Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

 Search results for: mySQL error: Got error 28 from storage engine

Pages: [1]

......  mode :   Quote  While executing query "SELECT * FROM xam_pictures WHERE approved = 'YES' ORDER BY  ............ () LIMIT 12" on 0  mySQL error: Got error 28 from storage engine   Debug  ............  [0] => SELECT extension, mime, content, player FROM xam_filetypes; (0s)  [1] => select * from  ............  order by priority asc; (0s)  [2] => delete from `tattoo_hinhxamdep`.xam_sessions where time< ............  and remember=0; (0.001s)  [3] => delete from `tattoo_hinhxamdep`.xam_sessions where time< ............ ; (0.001s)  [4] => select user_id from `tattoo_hinhxamdep`.xam_sessions where session_id  ............ => select user_id as id, user_password as password from `tattoo_hinhxamdep`.xam_users where user_id=1 (0s) ............  AS password, u.user_group+100 AS group_id FROM `tattoo_hinhxamdep`.xam_users AS u INNER JOIN ` ............ ='1' (0s)  [7] => SELECT user_group_list FROM `tattoo_hinhxamdep`.xam_users AS u WHERE user_id=' ............ ) as priv_upl_need_approval FROM xam_usergroups WHERE group_id in (1) (0s)  [9]  ............ => SELECT group_name FROM xam_usergroups WHERE group_id= 1 (0s)  [10] => ............ ' (0s)  [11] => SELECT user_favpics FROM xam_favpics WHERE user_id = 1 (0s)  [12] =>  ............  FROM xam_banned WHERE expiry < '2012-05-17 08:07:11' ( ............ )  [13] => SELECT * FROM xam_banned WHERE (ip_addr='58.187.119.70' OR  ............ )  [14] => SELECT cid, name, description, thumb FROM xam_categories WHERE parent = '' ORDER BY pos (0. ............ )  [15] => SELECT aid FROM xam_albums WHERE category = 25 (0s)  [16] =>  ............  count(*) FROM xam_pictures as p, xam_albums as a WHERE p.aid =  ............  filepath, filename, url_prefix, pwidth, pheight FROM xam_pictures WHERE pid='15848' (0s)  [18] =>  ............  count(*) FROM xam_albums as a WHERE category = '25' (0s)  [ ............ , filepath, filename, url_prefix, pwidth, pheight FROM xam_albums as a LEFT JOIN xam_pictures as p ON a. ............ , max( p.ctime ) AS last_upload, a.keyword FROM xam_albums AS a LEFT JOIN xam_pictures AS p ON a. ............  filepath, filename, url_prefix, pwidth, pheight FROM xam_pictures WHERE pid='15870' (0s)  [22] =>  ............  aid FROM xam_albums WHERE category = 22 (0.001s)  [23] = ............ > SELECT count(*) FROM xam_pictures as p, xam_albums as a WHERE p.aid =  ............  filepath, filename, url_prefix, pwidth, pheight FROM xam_pictures WHERE pid='12941' (0s)  [25] =>  ............  count(*) FROM xam_albums as a WHERE category = '22' (0s)  [ ............ , filepath, filename, url_prefix, pwidth, pheight FROM xam_albums as a LEFT JOIN xam_pictures as p ON a. ............ , max( p.ctime ) AS last_upload, a.keyword FROM xam_albums AS a LEFT JOIN xam_pictures AS p ON a. ............ ' WHERE a.aid IN (231, 552, 551, 553, 17, 265, 9, 288, 4, 6, 5, 7, 10, 11, 12, 14, 15, 16, 18, 13, 21,  ............ , 24, 8, 20, 19, 300)GROUP BY a.aid (0.096s)  [28] => SELECT filepath, filename, url_prefix, pwidth, ............  pheight FROM xam_pictures WHERE pid='15743' (0s)  [29] =>  ............  filepath, filename, url_prefix, pwidth, pheight FROM xam_pictures WHERE pid='15100' (0s)  [30] =>  ............  filepath, filename, url_prefix, pwidth, pheight FROM xam_pictures WHERE pid='15344' (0s)  [31] =>  ............  filepath, filename, url_prefix, pwidth, pheight FROM xam_pictures WHERE pid='14031' (0s)  [32] =>  ............  filepath, filename, url_prefix, pwidth, pheight FROM xam_pictures WHERE pid='14104' (0s)  [33] =>  ............  filepath, filename, url_prefix, pwidth, pheight FROM xam_pictures WHERE pid='14174' (0.002s)  [34] = ............ > SELECT aid FROM xam_albums as a WHERE category>=10000 (0.001s)   ............  [35] => SELECT count(*) FROM xam_pictures as p, xam_albums as a WHERE p.aid =  ............  category >= 10000 (0.015s)  [36] => SELECT aid FROM xam_albums WHERE category = 28 (0s)  [37] =>  ............  count(*) FROM xam_pictures as p, xam_albums as a WHERE p.aid =  ............ .aid AND approved='YES' AND category = 28 (0.001s)  [38] => SELECT count(*) FROM  ............  as a WHERE category = '28' (0s)  [39] => SELECT a.aid, a.title, a. ............ , filepath, filename, url_prefix, pwidth, pheight FROM xam_albums as a LEFT JOIN xam_pictures as p ON a. ............ =p.pid WHERE category=28 ORDER BY a.pos LIMIT 0,7 (0.001s)  [40] =>  ............ , max( p.ctime ) AS last_upload, a.keyword FROM xam_albums AS a LEFT JOIN xam_pictures AS p ON a. ............ )GROUP BY a.aid (0.002s)  [41] => SELECT aid FROM xam_albums as a WHERE category = '0' (0.001s)   ............ [42] => SELECT count(*) FROM xam_albums as a WHERE 1 (0s)  [43] => SELECT  ............ (*) FROM xam_pictures as p LEFT JOIN xam_albums as a ON a. ............ ='YES' (0.016s)  [44] => SELECT count(*) FROM xam_comments as c LEFT JOIN xam_pictures as p ON  ............ .aid WHERE 1 (0.049s)  [45] => SELECT count(*) FROM xam_categories WHERE 1 (0s)  [46] => SELECT  ............ (hits) FROM xam_pictures as p LEFT JOIN xam_albums as a ON p. ............ .aid WHERE 1 (0.033s)  [47] => SELECT COUNT(*) FROM xam_pictures WHERE approved = 'NO' (0.009s)  [ ............ ] => SELECT count(*) FROM xam_albums as a WHERE category = '0' (0.001s)   ............ [49] => SELECT * FROM xam_pictures WHERE approved = 'YES' ORDER BY  ............ ------ PHP version: 5.3.10 - OK ------------------ mySQL version: 5.5.22-cll ------------------ Coppermine  ............  Support:   ========================== Module: mysql ------------------ MySQL Supportenabled Active  ............  0  Active Links 1  Client API version 5.5.22  MYSQL_MODULE_TYPE external  MYSQL_SOCKET /var/lib/mysql............ .sock  MYSQL_INCLUDE -I/usr/include/mysql  MYSQL_LIBS -L/usr/ ............  -lmysqlclient  ========================== Module: zlib -- ............ -- Directive | Local Value | Master Value sendmail_from | no value | no value sendmail_path | /usr/sbin/ ......
2
cpg1.4 miscellaneous / Re: Critical Error?
« by Joachim Mller on February 28, 2010, 08:20:02 pm »

...... , what kept you from searching the board for "mySQL error: Got error  ............  from storage engine"? The resultsRe: Help help - Error: ............  There was an error while processing a database query. Fatal Error...  ............ 't know what to do...  Re: Help: New Error: There was an error while processing a database  ............ . [Solved]: There was an error while processing a database query  Re: error  ............  database Re: There was an error while processing a database query - inactive  ......

......  that no one 've seen it on 1.4.x section.  My cpg got this errorError : Quote  While executing query  ............ "SELECT * FROM xam_pictures WHERE approved = 'YES' ORDER BY  ............ () LIMIT 12" on 0  mySQL error: Got error 28 from storage engine   Debug  ............  [0] => SELECT extension, mime, content, player FROM xam_filetypes; (0s)  [1] => select * from  ............  order by priority asc; (0s)  [2] => delete from `tattoo_hinhxamdep`.xam_sessions where time< ............  and remember=0; (0.001s)  [3] => delete from `tattoo_hinhxamdep`.xam_sessions where time< ............ ; (0.001s)  [4] => select user_id from `tattoo_hinhxamdep`.xam_sessions where session_id  ............ => select user_id as id, user_password as password from `tattoo_hinhxamdep`.xam_users where user_id=1 (0s) ............  AS password, u.user_group+100 AS group_id FROM `tattoo_hinhxamdep`.xam_users AS u INNER JOIN ` ............ ='1' (0s)  [7] => SELECT user_group_list FROM `tattoo_hinhxamdep`.xam_users AS u WHERE user_id=' ............ ) as priv_upl_need_approval FROM xam_usergroups WHERE group_id in (1) (0s)  [9]  ............ => SELECT group_name FROM xam_usergroups WHERE group_id= 1 (0s)  [10] => ............ ' (0s)  [11] => SELECT user_favpics FROM xam_favpics WHERE user_id = 1 (0s)  [12] =>  ............  FROM xam_banned WHERE expiry < '2012-05-17 08:07:11' ( ............ )  [13] => SELECT * FROM xam_banned WHERE (ip_addr='58.187.119.70' OR  ............ )  [14] => SELECT cid, name, description, thumb FROM xam_categories WHERE parent = '' ORDER BY pos (0. ............ )  [15] => SELECT aid FROM xam_albums WHERE category = 25 (0s)  [16] =>  ............  count(*) FROM xam_pictures as p, xam_albums as a WHERE p.aid =  ............  filepath, filename, url_prefix, pwidth, pheight FROM xam_pictures WHERE pid='15848' (0s)  [18] =>  ............  count(*) FROM xam_albums as a WHERE category = '25' (0s)  [ ............ , filepath, filename, url_prefix, pwidth, pheight FROM xam_albums as a LEFT JOIN xam_pictures as p ON a. ............ , max( p.ctime ) AS last_upload, a.keyword FROM xam_albums AS a LEFT JOIN xam_pictures AS p ON a. ............  filepath, filename, url_prefix, pwidth, pheight FROM xam_pictures WHERE pid='15870' (0s)  [22] =>  ............  aid FROM xam_albums WHERE category = 22 (0.001s)  [23] = ............ > SELECT count(*) FROM xam_pictures as p, xam_albums as a WHERE p.aid =  ............  filepath, filename, url_prefix, pwidth, pheight FROM xam_pictures WHERE pid='12941' (0s)  [25] =>  ............  count(*) FROM xam_albums as a WHERE category = '22' (0s)  [ ............ , filepath, filename, url_prefix, pwidth, pheight FROM xam_albums as a LEFT JOIN xam_pictures as p ON a. ............ , max( p.ctime ) AS last_upload, a.keyword FROM xam_albums AS a LEFT JOIN xam_pictures AS p ON a. ............ ' WHERE a.aid IN (231, 552, 551, 553, 17, 265, 9, 288, 4, 6, 5, 7, 10, 11, 12, 14, 15, 16, 18, 13, 21,  ............ , 24, 8, 20, 19, 300)GROUP BY a.aid (0.096s)  [28] => SELECT filepath, filename, url_prefix, pwidth, ............  pheight FROM xam_pictures WHERE pid='15743' (0s)  [29] =>  ............  filepath, filename, url_prefix, pwidth, pheight FROM xam_pictures WHERE pid='15100' (0s)  [30] =>  ............  filepath, filename, url_prefix, pwidth, pheight FROM xam_pictures WHERE pid='15344' (0s)  [31] =>  ............  filepath, filename, url_prefix, pwidth, pheight FROM xam_pictures WHERE pid='14031' (0s)  [32] =>  ............  filepath, filename, url_prefix, pwidth, pheight FROM xam_pictures WHERE pid='14104' (0s)  [33] =>  ............  filepath, filename, url_prefix, pwidth, pheight FROM xam_pictures WHERE pid='14174' (0.002s)  [34] = ............ > SELECT aid FROM xam_albums as a WHERE category>=10000 (0.001s)   ............  [35] => SELECT count(*) FROM xam_pictures as p, xam_albums as a WHERE p.aid =  ............  category >= 10000 (0.015s)  [36] => SELECT aid FROM xam_albums WHERE category = 28 (0s)  [37] =>  ............  count(*) FROM xam_pictures as p, xam_albums as a WHERE p.aid =  ............ .aid AND approved='YES' AND category = 28 (0.001s)  [38] => SELECT count(*) FROM  ............  as a WHERE category = '28' (0s)  [39] => SELECT a.aid, a.title, a. ............ , filepath, filename, url_prefix, pwidth, pheight FROM xam_albums as a LEFT JOIN xam_pictures as p ON a. ............ =p.pid WHERE category=28 ORDER BY a.pos LIMIT 0,7 (0.001s)  [40] =>  ............ , max( p.ctime ) AS last_upload, a.keyword FROM xam_albums AS a LEFT JOIN xam_pictures AS p ON a. ............ )GROUP BY a.aid (0.002s)  [41] => SELECT aid FROM xam_albums as a WHERE category = '0' (0.001s)   ............ [42] => SELECT count(*) FROM xam_albums as a WHERE 1 (0s)  [43] => SELECT  ............ (*) FROM xam_pictures as p LEFT JOIN xam_albums as a ON a. ............ ='YES' (0.016s)  [44] => SELECT count(*) FROM xam_comments as c LEFT JOIN xam_pictures as p ON  ............ .aid WHERE 1 (0.049s)  [45] => SELECT count(*) FROM xam_categories WHERE 1 (0s)  [46] => SELECT  ............ (hits) FROM xam_pictures as p LEFT JOIN xam_albums as a ON p. ............ .aid WHERE 1 (0.033s)  [47] => SELECT COUNT(*) FROM xam_pictures WHERE approved = 'NO' (0.009s)  [ ............ ] => SELECT count(*) FROM xam_albums as a WHERE category = '0' (0.001s)   ............ [49] => SELECT * FROM xam_pictures WHERE approved = 'YES' ORDER BY  ............ ------ PHP version: 5.3.10 - OK ------------------ mySQL version: 5.5.22-cll ------------------ Coppermine  ............  Support:   ========================== Module: mysql ------------------ MySQL Supportenabled Active  ............  0  Active Links 1  Client API version 5.5.22  MYSQL_MODULE_TYPE external  MYSQL_SOCKET /var/lib/mysql............ .sock  MYSQL_INCLUDE -I/usr/include/mysql  MYSQL_LIBS -L/usr/ ............  -lmysqlclient  ========================== Module: zlib -- ............ -- Directive | Local Value | Master Value sendmail_from | no value | no value sendmail_path | /usr/sbin/ ......
4
cpg1.5 miscellaneous / Critical Error..
« by mr.bena on March 08, 2012, 11:57:58 pm »

...... , after trying to upload a picture, I suddenly got the message "There was an error while processing  ............ , alb_hits, visibility, r.thumb, r.owner  FROM album_categories AS c  INNER JOIN  ............  ORDER BY r.pos, r.aid' in index.php on line 379  mySQL error: Got error 28 from storage engine ********** ......

...... 've been getting this error on one of my Coppermines lately, and I don't have  ............  experience with this error at all. I've googled a bit, and I have enabled  ............ .owner_id, pic_raw_ip, pic_hdr_ip  FROM cpg15x_pictures AS r  INNER JOIN  ............  0 ,8' in include/functions.inc.php on line 1504  mySQL error: Got error 28 from storage engine    What  ......
6
cpg1.5 upgrading / Error while executing Query
« by strokesfan on January 18, 2011, 10:16:18 pm »

...... , I am getting an error in lautnerfan.com/gallery. It says:  While  ............ , alb_hits, visibility, r.thumb, r.owner  FROM cpg14x_categories AS c  INNER JOIN  ............  ORDER BY r.pos, r.aid' in index.php on line 379  mySQL error: Got error 28 from storage engine   ---  I  ......
7
cpg1.5.x Espaol (Spanish) / Error 28 en mysql
« by ChicaJaner on July 27, 2011, 03:13:27 am »

...... , alb_hits, visibility, r.thumb, r.owner  FROM categories AS c  INNER JOIN albums AS r ON  ............  ORDER BY r.pos, r.aid' in index.php on line 379  mySQL error: Got error 28 from storage engine  Fichero:  ......
8
cpg1.4.x Русский (Russian) / Re: ?
« by Makc666 on November 14, 2007, 06:32:32 pm »

......  from: AVB on November 12, 2007, 08:35:49 pm   ............ .    While executing query "SELECT * FROM cpg1410_pictures WHERE approved = 'YES' ORDER BY  ............ () LIMIT 8" on 0  mySQL error: Got error 28 from storage engine     / ......

......  debug_output unless requested in the future.  The error message "mySQL error: Got error 28 from storage  ............  simple and always shows the same answer:Quote from: Nibbler on October 29, 2005, 08:07:28 pm  It's  ............  error from MySQL, not Coppermine. Contact your host.   ............  error code 28: No space left on device     ......

......  De todos modos, aparece esta linea en tu reporte "mySQL error: Got error 28 from storage engine" y quizs  ............ .  Encontr un comentario con respecto a un error idntico al tuyo pero en los foros de vBulletin  ......
11
cpg1.5.x Espaol (Spanish) / Re: Pregunta sobre los bridge
« by sergin104 on June 02, 2013, 12:02:30 pm »

......  buenos das yo tengo el mismo problema de (Error crtico  Se produjo un error al procesar una  ............ )  hice lo de modo de depuracin y me suelta este errorQuote  While executing query 'SELECT title, r. ............ , alb_hits, visibility, r.thumb, r.owner  FROM cpg_categories AS c  INNER JOIN cpg_albums  ............  ORDER BY r.pos, r.aid' in index.php on line 379  mySQL error: Got error 28 from storage engine  Fichero:  ......

......  /functions.inc.php - Line: 250    There was an error while processing a database query. While  ............  query "SELECT * FROM cpg14x_pictures WHERE approved = 'YES' ORDER BY  ............ () LIMIT 8" on 0  mySQL error: Got error 28 from storage engine   i have  ............  mode for all users so if you need to go see the error report your self you can.  Thanks for anyhelp in  ......
13
cpg1.4 miscellaneous / Fatal Error... Don't know what to do...
« by Andrik3 on January 11, 2009, 06:51:28 am »

...... /galeria/  Quote  While executing query "SELECT * FROM cpg14x_pictures WHERE approved = 'YES' ORDER BY  ............ () LIMIT 8" on 0  mySQL error: Got error 28 from storage engine   I also  ......
14
cpg1.4.x Italian (Italiano) / Errore Query Database
« by stex on November 23, 2009, 12:47:48 pm »

......  in debug mode:  While executing query "SELECT * FROM cpg_pictures WHERE approved = 'YES' ORDER BY  ............ () LIMIT 8" on 0  mySQL error: Got error 28 from storage engine   Sapete  ......

......  haven't see the error message Quote  mySQL error: Got error 28 from  ............  engine  when searching this board? That's funny. I get  ............  threads of search results when searching for "Got error 28 from storage engine", and all of those  ......
16
cpg1.3 Installation & Setup / Database error
« by angeljs on October 29, 2005, 07:58:47 pm »

......  the following message:  Code: [Select] Critical error   There was an error while processing a database  ............  aid, CONCAT('(', username, ') ', title) AS title FROM cpg135_albums AS a INNER JOIN `******_phpb1`. ............  = (10000 + user_id) ORDER BY title" on 0  mySQL error: Got error 28 from storage engine    I've  ......

......  ~10-20 more Images into an album, the following error appears:  In German: Kritischer Fehler  Beim Ausf ............ ]Debugmessage:[/b] While executing query "SELECT * FROM cpg1410_pictures WHERE approved = 'YES' ORDER BY  ............ () LIMIT 8" on 0  mySQL error: Got error -1 from storage engine   [b] ............  [0] => SELECT extension, mime, content, player FROM cpg1410_filetypes; (0s)  [1] => select * from  ............  order by priority asc; (0s)  [2] => delete from `siedlungsshow`.cpg1410_sessions where time< ............  and remember=0; (0.001s)  [3] => delete from `siedlungsshow`.cpg1410_sessions where time< ............ ; (0s)  [4] => select user_id from `siedlungsshow`.cpg1410_sessions where session_id= ............ => select user_id as id, user_password as password from `siedlungsshow`.cpg1410_users where user_id=1 (0s) ............  AS password, u.user_group+100 AS group_id FROM `siedlungsshow`.cpg1410_users AS u INNER JOIN ` ............ ='1' (0s)  [7] => SELECT user_group_list FROM `siedlungsshow`.cpg1410_users AS u WHERE user_id=' ............ ) as priv_upl_need_approval FROM cpg1410_usergroups WHERE group_id in (1) (0s)   ............ [9] => SELECT group_name FROM cpg1410_usergroups WHERE group_id= 1 (0s)  [ ............ '); (0s)  [11] => SELECT user_favpics FROM cpg1410_favpics WHERE user_id = 1 (0.001s)  [ ............ ] => DELETE FROM cpg1410_banned WHERE expiry < '2007-05-16 14:34: ............ ' (0s)  [13] => SELECT * FROM cpg1410_banned WHERE (ip_addr='217.225.131.67' OR  ............ )  [14] => SELECT cid, name, description, thumb FROM cpg1410_categories WHERE parent = '' ORDER BY  ............  (0.001s)  [15] => SELECT aid FROM cpg1410_albums as a WHERE category>=10000 (0s)   ............  [16] => SELECT count(*) FROM cpg1410_pictures as p, cpg1410_albums as a WHERE  ............ )  [17] => SELECT cid, name, description, thumb FROM cpg1410_categories WHERE parent = '1' ORDER BY  ............  (0s)  [18] => SELECT aid FROM cpg1410_albums WHERE category = 6 (0s)  [19] => ............  SELECT count(*) FROM cpg1410_pictures as p, cpg1410_albums as a WHERE  ............  category = 6 (0.001s)  [20] => SELECT count(*) FROM cpg1410_albums as a WHERE category = '6' (0s)   ............ , filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_albums as a LEFT JOIN cpg1410_pictures as  ............ , max( p.ctime ) AS last_upload, a.keyword FROM cpg1410_albums AS a LEFT JOIN cpg1410_pictures  ............  = p.aid AND p.approved = 'YES' WHERE a.aid IN (28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 43, 44,  ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='2969' (0.001s)  [ ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='3198' (0s)  [25] => ............  SELECT cid, name, description, thumb FROM cpg1410_categories WHERE parent = '6' ORDER BY  ............  (0s)  [26] => SELECT aid FROM cpg1410_albums WHERE category = 5 (0s)  [27] => ............  SELECT count(*) FROM cpg1410_pictures as p, cpg1410_albums as a WHERE  ............  AND approved='YES' AND category = 5 (0.002s)  [28] => SELECT count(*) FROM cpg1410_albums as a  ............ , filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_albums as a LEFT JOIN cpg1410_pictures as  ............ , max( p.ctime ) AS last_upload, a.keyword FROM cpg1410_albums AS a LEFT JOIN cpg1410_pictures  ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='4947' (0.001s)  [ ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='5003' (0s)  [33] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='5071' (0s)  [34] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='5242' (0s)  [35] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='7731' (0s)  [36] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='8142' (0s)  [37] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='8118' (0s)  [38] => ............  SELECT cid, name, description, thumb FROM cpg1410_categories WHERE parent = '5' ORDER BY  ............  (0.001s)  [39] => SELECT aid FROM cpg1410_albums WHERE category = 4 (0s)  [40] => ............  SELECT count(*) FROM cpg1410_pictures as p, cpg1410_albums as a WHERE  ............  category = 4 (0.002s)  [41] => SELECT count(*) FROM cpg1410_albums as a WHERE category = '4' (0s)   ............ , filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_albums as a LEFT JOIN cpg1410_pictures as  ............ , max( p.ctime ) AS last_upload, a.keyword FROM cpg1410_albums AS a LEFT JOIN cpg1410_pictures  ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='5776' (0s)  [45] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='6411' (0s)  [46] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='6415' (0s)  [47] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='6648' (0s)  [48] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='6741' (0s)  [49] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='7049' (0s)  [50] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='7210' (0s)  [51] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='7534' (0s)  [52] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='7556' (0s)  [53] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='7660' (0s)  [54] => ............  SELECT cid, name, description, thumb FROM cpg1410_categories WHERE parent = '4' ORDER BY  ............  (0s)  [55] => SELECT aid FROM cpg1410_albums WHERE category = 3 (0s)  [56] => ............  SELECT count(*) FROM cpg1410_pictures as p, cpg1410_albums as a WHERE  ............  category = 3 (0.002s)  [57] => SELECT count(*) FROM cpg1410_albums as a WHERE category = '3' (0s)   ............ , filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_albums as a LEFT JOIN cpg1410_pictures as  ............ , max( p.ctime ) AS last_upload, a.keyword FROM cpg1410_albums AS a LEFT JOIN cpg1410_pictures  ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='170' (0s)  [61] =>  ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='207' (0s)  [62] =>  ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='440' (0s)  [63] =>  ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='538' (0s)  [64] =>  ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='660' (0s)  [65] =>  ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='684' (0s)  [66] =>  ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='778' (0s)  [67] =>  ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='852' (0s)  [68] =>  ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='913' (0s)  [69] =>  ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='957' (0s)  [70] =>  ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='1053' (0s)  [71] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='1226' (0s)  [72] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='1265' (0s)  [73] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='1382' (0s)  [74] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='1469' (0s)  [75] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='1517' (0s)  [76] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='1582' (0s)  [77] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='1597' (0s)  [78] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='1678' (0s)  [79] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='1783' (0s)  [80] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='1808' (0s)  [81] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='1881' (0s)  [82] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='2067' (0s)  [83] => ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_pictures WHERE pid='2093' (0s)  [84] => ............  SELECT cid, name, description, thumb FROM cpg1410_categories WHERE parent = '3' ORDER BY  ............  (0s)  [85] => SELECT aid FROM cpg1410_albums WHERE category = 2 (0s)  [86] => ............  SELECT count(*) FROM cpg1410_pictures as p, cpg1410_albums as a WHERE  ............  category = 2 (0.001s)  [87] => SELECT count(*) FROM cpg1410_albums as a WHERE category = '2' (0s)   ............ , filepath, filename, url_prefix, pwidth, pheight FROM cpg1410_albums as a LEFT JOIN cpg1410_pictures as  ............ , max( p.ctime ) AS last_upload, a.keyword FROM cpg1410_albums AS a LEFT JOIN cpg1410_pictures  ............ )  [90] => SELECT cid, name, description, thumb FROM cpg1410_categories WHERE parent = '2' ORDER BY  ............  (0s)  [91] => SELECT aid FROM cpg1410_albums as a WHERE category = '0' (0s)   ............ [92] => SELECT count(*) FROM cpg1410_albums as a WHERE 1 (0s)  [93] =>  ............  count(*) FROM cpg1410_pictures as p LEFT JOIN cpg1410_albums as  ............ ='YES' (0.008s)  [94] => SELECT count(*) FROM cpg1410_comments as c LEFT JOIN cpg1410_pictures  ............ =p.aid WHERE 1 (0s)  [95] => SELECT count(*) FROM cpg1410_categories WHERE 1 (0s)  [96] =>  ............  sum(hits) FROM cpg1410_pictures as p LEFT JOIN cpg1410_albums as  ............ .aid WHERE 1 (0.016s)  [97] => SELECT COUNT(*) FROM cpg1410_pictures WHERE approved = 'NO' (0.004s)   ............  [98] => SELECT count(*) FROM cpg1410_albums as a WHERE category = '0' (0s)   ............ [99] => SELECT COUNT(*) from cpg1410_pictures WHERE approved = 'YES' (0.005s)  ............  [100] => SELECT * FROM cpg1410_pictures WHERE approved = 'YES' ORDER BY  ............  version: 4.4.4-8+etch2 - OK ------------------ mySQL version: 5.0.32-Debian_7etch1-log ---------------- ............  doesn't exist ========================== Module: mysql ------------------ MySQL Supportenabled Active  ............  0  Active Links 1  Client API version 5.0.32  MYSQL_MODULE_TYPE external  MYSQL_SOCKET /var/run/ ............ /mysqld.sock  MYSQL_INCLUDE -I/usr/include/mysql   ............  -L/usr/lib -lmysqlclient  ========================== Module: zlib -- ............ -- Directive | Local Value | Master Value sendmail_from | no value | no value sendmail_path | /usr/sbin/ ......
18
cpg1.4 upload / Critical error (28?) - help
« by MsVixen on July 12, 2008, 02:59:46 am »

......  error 12/07/08 - all has been working fine up until now. ............  the file details it wouldn't work & now I get an error message just trying to navigate about.  Thank you  ............  advance.    While executing query "SELECT * FROM cpg149_pictures WHERE approved = 'YES' ORDER BY  ............ () LIMIT 8" on 0  mySQL error: Got error 28 from storage engine    USER:   ............ ] => Array  (  => 3044 [1] => 2816  )   [lap] => 2  [search] => Array  ............  (  => SELECT extension, mime, content, player FROM cpg149_filetypes; (0s) [1] => select * from  ............  order by priority asc; (0s)  [2] => delete from `********data`.cpg149_sessions where time< ............  and remember=0; (0.001s)  [3] => delete from `********data`.cpg149_sessions where time< ............ ; (0.001s)  [4] => select user_id from `********data`.cpg149_sessions where session_id= ............ => select user_id as id, user_password as password from `********data`.cpg149_users where user_id=1 (0s)   ............  AS password, u.user_group+100 AS group_id FROM `********data`.cpg149_users AS u INNER JOIN `***** ............ ='1' (0s)  [7] => SELECT user_group_list FROM `********data`.cpg149_users AS u WHERE user_id='1' ............ ) as priv_upl_need_approval FROM cpg149_usergroups WHERE group_id in (1) (0s)  [ ............ ] => SELECT group_name FROM cpg149_usergroups WHERE group_id= 1 (0s)  [10] ............ '); (0.001s)  [11] => SELECT user_favpics FROM cpg149_favpics WHERE user_id = 1 (0.001s)  [12] ............  => DELETE FROM cpg149_banned WHERE expiry < '2008-07-12 00:39:47' ............  (0s)  [13] => SELECT * FROM cpg149_banned WHERE (ip_addr='86.163.174.81' OR  ............ )  [14] => SELECT cid, name, description, thumb FROM cpg149_categories WHERE parent = '' ORDER BY  ............  (0.001s)  [15] => SELECT aid FROM cpg149_albums WHERE category = 3 (0s)  [16] =>  ............  count(*) FROM cpg149_pictures as p, cpg149_albums as a WHERE p. ............ )  [17] => SELECT cid, name, description, thumb FROM cpg149_categories WHERE parent = '3' ORDER BY  ............  (0s)  [18] => SELECT aid FROM cpg149_albums WHERE category = 11 (0s)  [19] => ............  SELECT count(*) FROM cpg149_pictures as p, cpg149_albums as a WHERE p. ............ ' AND category = 11 (0s)  [20] => SELECT aid FROM cpg149_albums WHERE category = 9 (0s)  [21] =>  ............  count(*) FROM cpg149_pictures as p, cpg149_albums as a WHERE p. ............ 'YES' AND category = 9 (0s)  [22] => SELECT aid FROM cpg149_albums WHERE category = 10 (0s)  [23] => ............  SELECT count(*) FROM cpg149_pictures as p, cpg149_albums as a WHERE p. ............ ' AND category = 10 (0s)  [24] => SELECT aid FROM cpg149_albums WHERE category = 5 (0s)  [25] =>  ............  count(*) FROM cpg149_pictures as p, cpg149_albums as a WHERE p. ............ 'YES' AND category = 5 (0s)  [26] => SELECT aid FROM cpg149_albums WHERE category = 46 (0s)  [27] => ............  SELECT count(*) FROM cpg149_pictures as p, cpg149_albums as a WHERE p. ............  AND approved='YES' AND category = 46 (0s)  [28] => SELECT aid FROM cpg149_albums WHERE category = ............  2 (0s)  [29] => SELECT count(*) FROM cpg149_pictures as p, cpg149_albums as a WHERE p. ............ 'YES' AND category = 2 (0s)  [30] => SELECT aid FROM cpg149_albums as a WHERE category>=10000 (0s)   ............ [31] => SELECT count(*) FROM cpg149_pictures as p, cpg149_albums as a WHERE p. ............ )  [32] => SELECT cid, name, description, thumb FROM cpg149_categories WHERE parent = '1' ORDER BY  ............  (0s)  [33] => SELECT aid FROM cpg149_albums WHERE category = 4 (0s)  [34] =>  ............  count(*) FROM cpg149_pictures as p, cpg149_albums as a WHERE p. ............ )  [35] => SELECT cid, name, description, thumb FROM cpg149_categories WHERE parent = '4' ORDER BY  ............  (0.119s)  [36] => SELECT aid FROM cpg149_albums WHERE category = 12 (0s)  [37] => ............  SELECT count(*) FROM cpg149_pictures as p, cpg149_albums as a WHERE p. ............ ' AND category = 12 (0s)  [38] => SELECT aid FROM cpg149_albums WHERE category = 8 (0s)  [39] =>  ............  count(*) FROM cpg149_pictures as p, cpg149_albums as a WHERE p. ............ 'YES' AND category = 8 (0s)  [40] => SELECT aid FROM cpg149_albums WHERE category = 7 (0s)  [41] =>  ............  count(*) FROM cpg149_pictures as p, cpg149_albums as a WHERE p. ............ 'YES' AND category = 7 (0s)  [42] => SELECT aid FROM cpg149_albums WHERE category = 44 (0s)  [43] => ............  SELECT count(*) FROM cpg149_pictures as p, cpg149_albums as a WHERE p. ............ ' AND category = 44 (0s)  [44] => SELECT aid FROM cpg149_albums WHERE category = 6 (0s)  [45] =>  ............  count(*) FROM cpg149_pictures as p, cpg149_albums as a WHERE p. ............ 'YES' AND category = 6 (0s)  [46] => SELECT aid FROM cpg149_albums as a WHERE category = '0' (0s)  [ ............ ] => SELECT count(*) FROM cpg149_albums as a WHERE 1 (0s)  [48] =>  ............  count(*) FROM cpg149_pictures as p LEFT JOIN cpg149_albums as a  ............  approved='YES' (0s)  [49] => SELECT count(*) FROM cpg149_comments as c LEFT JOIN cpg149_pictures as  ............ =p.aid WHERE 1 (0s)  [50] => SELECT count(*) FROM cpg149_categories WHERE 1 (0s)  [51] => SELECT  ............ (hits) FROM cpg149_pictures as p LEFT JOIN cpg149_albums as a  ............ =a.aid WHERE 1 (0s)  [52] => SELECT COUNT(*) FROM cpg149_pictures WHERE approved = 'NO' (0s)  [ ............ ] => SELECT count(*) FROM cpg149_albums as a WHERE category = '0' (0s)  [ ............ ] => SELECT COUNT(*) from cpg149_pictures WHERE approved = 'YES' (0s)  [ ............ ] => SELECT * FROM cpg149_pictures WHERE approved = 'YES' ORDER BY  ............ ------- PHP version: 4.4.7 - OK ------------------ mySQL version: 4.1.20-standard ------------------  ............ : GD ------------------ GD Version: bundled (2.0.28 compatible) FreeType Support: 1 FreeType Linkage:  ............  Support:   ========================== Module: mysql ------------------ MySQL Supportenabled Active  ............  0  Active Links 1  Client API version 4.1.20  MYSQL_MODULE_TYPE external  MYSQL_SOCKET /var/lib/mysql............ .sock  MYSQL_INCLUDE -I/usr/include/mysql  MYSQL_LIBS -L/usr/ ............  -lmysqlclient  ========================== Module: zlib -- ............ -- Directive | Local Value | Master Value sendmail_from | no value | no value sendmail_path | /usr/sbin/ ............  generated in 0.256 seconds - 56 queries in 0.128 seconds - Album set : ; Meta set: ;  ......
19
cpg1.3.x Support / Admin tools problem CPG 1.3
« by lucabart74 on December 27, 2004, 05:12:29 pm »

......  guys, im write from italy and sorry for my english. I ave one problem  ............  the problem. in admin tools i ave one critical error:  There was an error while processing a database  ............   ok the error is in database.  this is the debug: While  ............ , ') ',title), CONCAT(' - ', title)) AS title FROM cpg132_albums AS a LEFT JOIN cpg132_users AS u ON  ............  (10000 + user_id) ORDER BY category, title" on 0  mySQL error: Got error 28 from storage engine  thi is  ............ ] => 262  [2] => 347  [3] => 28  [4] => 29  )   [sort] => na  ............ -- Array (  => SELECT extension, mime, content FROM cpg132_filetypes; [1] => SELECT * FROM  ............ ) as priv_upl_need_approval FROM cpg132_usergroups WHERE group_id in (1)  [3] => ............  SELECT group_name FROM cpg132_usergroups WHERE group_id= 1  [4] =>  ............  FROM cpg132_banned WHERE expiry < 1104163087  [5] => ............  SELECT * FROM cpg132_banned WHERE ip_addr='192.168.0.29' OR  ............ , ') ',title), CONCAT(' - ', title)) AS title FROM cpg132_albums AS a LEFT JOIN cpg132_users AS u ON  ............ ------- PHP version: 4.2.2 - OK ------------------ mySQL version: 4.1.8-standard ------------------  ............  doesn't exist ========================== Module: mysql ------------------ module doesn't exist ========== ............ -- Directive | Local Value | Master Value sendmail_from | me@localhost.com | me@localhost.com  ......
20
cpg1.4.x Franais (French) / Erreur critique (rparer Tables MySQL)
« by zettili on September 22, 2006, 05:14:54 pm »

......  requte. While executing query "SELECT sum(hits) FROM cpg148_pictures as p LEFT JOIN cpg148_albums as a  ............  p.aid=a.aid WHERE 1" on 0 mySQL error: Got error 127 from storage engine Fichier:  ............  [0] => SELECT extension, mime, content, player FROM cpg148_filetypes; (0.001s)  [1] => select *  ............  order by priority asc; (0.001s)  [2] => delete from `photos`.cpg148_sessions where time<1158933633  ............  remember=0; (0.003s)  [3] => delete from `photos`.cpg148_sessions where time<1157727633; ( ............ .001s)  [4] => select user_id from `photos`.cpg148_sessions where session_id=md5(" ............ => select user_id as id, user_password as password from `photos`.cpg148_users where user_id=1 (0.001s)   ............  AS password, u.user_group+100 AS group_id FROM `photos`.cpg148_users AS u INNER JOIN `photos`. ............ ='1' (0.001s)  [7] => SELECT user_group_list FROM `photos`.cpg148_users AS u WHERE user_id='1' and  ............ ) as priv_upl_need_approval FROM cpg148_usergroups WHERE group_id in (1) (0.001s)   ............  [9] => SELECT group_name FROM cpg148_usergroups WHERE group_id= 1 (0.001s)   ............ '); (0.002s)  [11] => SELECT user_favpics FROM cpg148_favpics WHERE user_id = 1 (0.001s)  [12] ............  => DELETE FROM cpg148_banned WHERE expiry < '2006-09-22 15:00:33' ............  (0.002s)  [13] => SELECT * FROM cpg148_banned WHERE (ip_addr='81.52.163.8' OR  ............ )  [14] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '' ORDER BY pos  ............ (0.004s)  [15] => SELECT aid FROM cpg148_albums as a WHERE category>=10000 (0.006s)  ............  [16] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p. ............ )  [17] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '1' ORDER BY  ............  (0.002s)  [18] => SELECT aid FROM cpg148_albums WHERE category = 5 (0.001s)  [19] ............  => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p. ............ )  [20] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '5' ORDER BY  ............  (0.002s)  [21] => SELECT aid FROM cpg148_albums WHERE category = 8 (0.003s)  [22] ............  => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p. ............ ' AND category = 8 (0.002s)  [23] => SELECT aid FROM cpg148_albums WHERE category = 3 (0.001s)  [24] ............  => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p. ............ ' AND category = 3 (0.002s)  [25] => SELECT aid FROM cpg148_albums WHERE category = 9 (0s)  [26] =>  ............  count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p. ............ ' AND category = 9 (0.001s)  [27] => SELECT aid FROM cpg148_albums WHERE category = 11 (0.001s)  [ ............ ] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p. ............ )  [29] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '11' ORDER BY  ............  (0.001s)  [30] => SELECT aid FROM cpg148_albums WHERE category = 13 (0.001s)  [ ............ ] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p. ............  AND category = 13 (0.007s)  [32] => SELECT aid FROM cpg148_albums WHERE category = 14 (0.002s)  [ ............ ] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p. ............  AND category = 14 (0.001s)  [34] => SELECT aid FROM cpg148_albums WHERE category = 15 (0.001s)  [ ............ ] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p. ............  AND category = 15 (0.001s)  [36] => SELECT aid FROM cpg148_albums WHERE category = 10 (0.002s)  [ ............ ] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p. ............ )  [38] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '10' ORDER BY  ............  (0.001s)  [39] => SELECT aid FROM cpg148_albums WHERE category = 12 (0s)  [40] => ............  SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p. ............  AND category = 12 (0.002s)  [41] => SELECT aid FROM cpg148_albums WHERE category = 16 (0.001s)  [ ............ ] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p. ............ )  [43] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '16' ORDER BY  ............  (0.001s)  [44] => SELECT aid FROM cpg148_albums WHERE category = 18 (0.001s)  [ ............ ] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p. ............  AND category = 18 (0.001s)  [46] => SELECT aid FROM cpg148_albums WHERE category = 19 (0.001s)  [ ............ ] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p. ............  AND category = 19 (0.009s)  [48] => SELECT aid FROM cpg148_albums WHERE category = 20 (0.02s)  [49] ............  => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p. ............  AND category = 20 (0.002s)  [50] => SELECT aid FROM cpg148_albums WHERE category = 21 (0s)  [51] => ............  SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p. ............  AND category = 21 (0.001s)  [52] => SELECT aid FROM cpg148_albums WHERE category = 29 (0.001s)  [ ............ ] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p. ............  AND category = 29 (0.001s)  [54] => SELECT aid FROM cpg148_albums WHERE category = 17 (0.001s)  [ ............ ] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p. ............ )  [56] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '17' ORDER BY  ............  (0.001s)  [57] => SELECT aid FROM cpg148_albums WHERE category = 22 (0.001s)  [ ............ ] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p. ............  AND category = 22 (0.001s)  [59] => SELECT aid FROM cpg148_albums WHERE category = 23 (0.065s)  [ ............ ] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p. ............ )  [61] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '23' ORDER BY  ............  (0.001s)  [62] => SELECT aid FROM cpg148_albums WHERE category = 24 (0.001s)  [ ............ ] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p. ............ ' AND category = 24 (0.14s)  [64] => SELECT aid FROM cpg148_albums WHERE category = 25 (0s)  [65] => ............  SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p. ............  AND category = 25 (0.001s)  [66] => SELECT aid FROM cpg148_albums WHERE category = 26 (0.001s)  [ ............ ] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p. ............  AND category = 26 (0.001s)  [68] => SELECT aid FROM cpg148_albums WHERE category = 27 (0.001s)  [ ............ ] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p. ............  AND category = 27 (0.001s)  [70] => SELECT aid FROM cpg148_albums WHERE category = 28 (0.001s)  [ ............ ] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p. ............  = a.aid AND approved='YES' AND category = 28 (0.001s)  [72] => SELECT count(*) FROM  ............  as a WHERE category = '28' (0.001s)  [73] => SELECT a.aid, a.title, a. ............ , filepath, filename, url_prefix, pwidth, pheight FROM cpg148_albums as a LEFT JOIN cpg148_pictures as p  ............  a.thumb=p.pid WHERE category=28 ORDER BY a.pos LIMIT 0,1 (0.002s)  [74] =>  ............ , max( p.ctime ) AS last_upload, a.keyword FROM cpg148_albums AS a LEFT JOIN cpg148_pictures AS  ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg148_pictures WHERE pid='1141' (0.007s)  [76] ............  => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = '28' ORDER BY  ............  (0.001s)  [77] => SELECT aid FROM cpg148_albums as a WHERE category = '0' (0.001s)   ............  [78] => SELECT count(*) FROM cpg148_albums as a WHERE 1 (0.001s)  [79] =>  ............  count(*) FROM cpg148_pictures as p LEFT JOIN cpg148_albums as a  ............ ='YES' (0.004s)  [80] => SELECT count(*) FROM cpg148_comments as c LEFT JOIN cpg148_pictures as  ............ .aid WHERE 1 (0.005s)  [81] => SELECT count(*) FROM cpg148_categories WHERE 1 (0.001s)  [82] =>  ............  sum(hits) FROM cpg148_pictures as p LEFT JOIN cpg148_albums as a  ............ .aid WHERE 1 (0.065s)  [83] => SELECT COUNT(*) FROM cpg148_pictures WHERE approved = 'NO' (0.004s) )   ............ ------ PHP version: 4.3.11 - OK ------------------ mySQL version: 4.1.14 ------------------ Coppermine  ............ : GD ------------------ GD Version: bundled (2.0.28 compatible) FreeType Support: 1 FreeType Linkage:  ............  Support:   ========================== Module: mysql ------------------ MySQL Supportenabled Active  ............  0  Active Links 1  Client API version 3.23.49  MYSQL_MODULE_TYPE builtin  MYSQL_SOCKET /tmp/mysql.sock  ............  MYSQL_INCLUDE no value  MYSQL_LIBS no value  =========== ............ -- Directive | Local Value | Master Value sendmail_from | no value | no value sendmail_path | /usr/sbin/ ............  /include/functions.inc.php Warning line 211: mysql_query(): Unable to save result  ......
21
cpg1.4.x Franais (French) / Galerie bloque
« by cometyounha on June 07, 2008, 12:00:46 pm »

......  l'erreur sont :  "While executing query "SELECT * FROM cpg149_pictures WHERE approved = 'YES' ORDER BY  ............ () LIMIT 8" on 0  mySQL error: Got error 28 from storage engine  Fichier:  ......

......  an error. not sure how this happened. last night it was  ............  fine   Quote  While executing query "SELECT * FROM cpg14x_pictures WHERE approved = 'YES' ORDER BY  ............ () LIMIT 5" on 0  mySQL error: Got error 28 from storage engine   http:// ......
23
cpg1.4 permissions / Re: error processing database
« by Joachim Mller on July 03, 2008, 08:34:07 am »

......  your webhost that you're gettingQuote from: gisellebebegirl on July 03, 2008, 12:58:41 am   ............  executing query "SELECT * FROM cpg_pictures WHERE approved = 'YES' ORDER BY  ............ () LIMIT 8" on 0  mySQL error: Got error 28 from storage engine   This  ......

...... ! The error is still showing up. I enabled debug mode and  ............  showed up  Quote  While executing query "SELECT * FROM cpg135_pictures WHERE approved = 'YES' ORDER BY  ............ () LIMIT 8" on 0  mySQL error: Got error 28 from storage engine     File:  ............  (  => SELECT extension, mime, content, player FROM cpg135_filetypes; (0s) [1] => select * from  ............  order by priority asc; (0s)  [2] => delete from `farley2_avril`.cpg135_sessions where time< ............  and remember=0; (0.001s)  [3] => delete from `farley2_avril`.cpg135_sessions where time< ............ ; (0s)  [4] => select user_id from `farley2_avril`.cpg135_sessions where session_id= ............ => select user_id as id, user_password as password from `farley2_avril`.cpg135_users where user_id=1 (0s)  ............  AS password, u.user_group+100 AS group_id FROM `farley2_avril`.cpg135_users AS u INNER JOIN ` ............ ='1' (0s)  [7] => SELECT user_group_list FROM `farley2_avril`.cpg135_users AS u WHERE user_id=' ............ ) as priv_upl_need_approval FROM cpg135_usergroups WHERE group_id in (1) (0s)  [ ............ ] => SELECT group_name FROM cpg135_usergroups WHERE group_id= 1 (0s)  [10] ............ '); (0s)  [11] => SELECT user_favpics FROM cpg135_favpics WHERE user_id = 1 (0s)  [12] =>  ............  FROM cpg135_banned WHERE expiry < '2006-04-23 18:25:59' ............  (0s)  [13] => SELECT * FROM cpg135_banned WHERE (ip_addr='124.106.190.101' OR  ............ )  [14] => SELECT cid, name, description, thumb FROM cpg135_categories WHERE parent = '' ORDER BY pos  ............ (0s)  [15] => SELECT aid FROM cpg135_albums as a WHERE category>=10000 (0s)   ............ [16] => SELECT count(*) FROM cpg135_pictures as p, cpg135_albums as a WHERE p. ............  AND category >= 10000 (0s)  [17] => SELECT aid FROM cpg135_albums WHERE category = 2 (0s)  [18] =>  ............  count(*) FROM cpg135_pictures as p, cpg135_albums as a WHERE p. ............ .aid AND category = 2 (0s)  [19] => SELECT aid FROM cpg135_albums WHERE category = 12 (0s)  [20] => ............  SELECT count(*) FROM cpg135_pictures as p, cpg135_albums as a WHERE p. ............ .aid AND category = 12 (0s)  [21] => SELECT aid FROM cpg135_albums WHERE category = 3 (0s)  [22] =>  ............  count(*) FROM cpg135_pictures as p, cpg135_albums as a WHERE p. ............ .aid AND category = 3 (0s)  [23] => SELECT aid FROM cpg135_albums WHERE category = 4 (0s)  [24] =>  ............  count(*) FROM cpg135_pictures as p, cpg135_albums as a WHERE p. ............  AND category = 4 (0s)  [25] => SELECT count(*) FROM cpg135_albums as a WHERE category = '4' (0s)  [ ............ , filepath, filename, url_prefix, pwidth, pheight FROM cpg135_albums as a LEFT JOIN cpg135_pictures as p  ............ , max( p.ctime ) AS last_upload, a.keyword FROM cpg135_albums AS a LEFT JOIN cpg135_pictures AS  ............  a.aid IN (141, 190, 157)GROUP BY a.aid (0s)  [28] => SELECT aid FROM cpg135_albums WHERE category = ............  6 (0s)  [29] => SELECT count(*) FROM cpg135_pictures as p, cpg135_albums as a WHERE p. ............  AND category = 6 (0s)  [30] => SELECT count(*) FROM cpg135_albums as a WHERE category = '6' (0s)  [ ............ , filepath, filename, url_prefix, pwidth, pheight FROM cpg135_albums as a LEFT JOIN cpg135_pictures as p  ............ , max( p.ctime ) AS last_upload, a.keyword FROM cpg135_albums AS a LEFT JOIN cpg135_pictures AS  ............  IN (17)GROUP BY a.aid (0s)  [33] => SELECT aid FROM cpg135_albums WHERE category = 7 (0s)  [34] =>  ............  count(*) FROM cpg135_pictures as p, cpg135_albums as a WHERE p. ............  AND category = 7 (0s)  [35] => SELECT count(*) FROM cpg135_albums as a WHERE category = '7' (0s)  [ ............ , filepath, filename, url_prefix, pwidth, pheight FROM cpg135_albums as a LEFT JOIN cpg135_pictures as p  ............ , max( p.ctime ) AS last_upload, a.keyword FROM cpg135_albums AS a LEFT JOIN cpg135_pictures AS  ............ , 352)GROUP BY a.aid (0s)  [38] => SELECT aid FROM cpg135_albums WHERE category = 5 (0s)  [39] =>  ............  count(*) FROM cpg135_pictures as p, cpg135_albums as a WHERE p. ............  AND category = 5 (0s)  [40] => SELECT count(*) FROM cpg135_albums as a WHERE category = '5' (0s)  [ ............ , filepath, filename, url_prefix, pwidth, pheight FROM cpg135_albums as a LEFT JOIN cpg135_pictures as p  ............ , max( p.ctime ) AS last_upload, a.keyword FROM cpg135_albums AS a LEFT JOIN cpg135_pictures AS  ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='5732' (0s)  [44] =>  ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='957' (0s)  [45] =>  ............  aid FROM cpg135_albums as a WHERE category = '0' (0s)  [ ............ ] => SELECT count(*) FROM cpg135_albums as a WHERE 1 (0s)  [47] =>  ............  count(*) FROM cpg135_pictures as p LEFT JOIN cpg135_albums as a  ............ =p.aid WHERE 1 (0s)  [48] => SELECT count(*) FROM cpg135_comments as c LEFT JOIN cpg135_pictures as  ............ =p.aid WHERE 1 (0s)  [49] => SELECT count(*) FROM cpg135_categories WHERE 1 (0s)  [50] => SELECT  ............ (hits) FROM cpg135_pictures as p LEFT JOIN cpg135_albums as a  ............ =a.aid WHERE 1 (0s)  [51] => SELECT COUNT(*) FROM cpg135_pictures WHERE approved = 'NO' (0s)  [ ............ ] => SELECT count(*) FROM cpg135_albums as a WHERE category = '0' (0s)  [ ............ ] => SELECT COUNT(*) from cpg135_pictures WHERE approved = 'YES' (0s)  [ ............ ] => SELECT * FROM cpg135_pictures WHERE approved = 'YES' ORDER BY  ............ ------- PHP version: 4.4.1 - OK ------------------ mySQL version: 4.1.18-standard-log ------------------  ............ : GD ------------------ GD Version: bundled (2.0.28 compatible) FreeType Support: 1 FreeType Linkage:  ............  Support:   ========================== Module: mysql ------------------ MySQL Supportenabled Active  ............  0  Active Links 1  Client API version 4.1.18  MYSQL_MODULE_TYPE external  MYSQL_SOCKET /var/lib/mysql............ .sock  MYSQL_INCLUDE -I/usr/include/mysql  MYSQL_LIBS -L/usr/ ............  -lmysqlclient  ========================== Module: zlib -- ............ -- Directive | Local Value | Master Value sendmail_from | no value | no value sendmail_path | /usr/sbin/ ......

......  error for me, I didnt want to open a new topic for it  ............  i will i use this one...  here is the error message:  While executing query "SELECT pid,  ............ , filesize, pwidth, pheight, ctime, aid, aid FROM cpg134_pictures WHERE approved = 'YES' ORDER BY  ............ () LIMIT 10" on 0  mySQL error: Got error 12 from storage engine  File: / ............ :  ------------------ Array (  [ID] => 3d9ad670f28b7d0b80d0e63c2554b9ff  [am] => 1  [liv] =>  ............ -- Array (  => SELECT extension, mime, content FROM cpg134_filetypes; [1] => SELECT * FROM  ............ ) as priv_upl_need_approval FROM cpg134_usergroups WHERE group_id in (1)  [3] => ............  SELECT group_name FROM cpg134_usergroups WHERE group_id= 1  [4] =>  ............  FROM cpg134_banned WHERE expiry < '2005-10-08 17:39:14' ............   [5] => SELECT * FROM cpg134_banned WHERE ip_addr='********** OR  ............ *******' OR user_id=1  [6] => SELECT aid, title FROM cpg134_albums WHERE 1 )  ========================= ............ ] => i0026  [27] => i0027  [28] => i0028  [29] => i0029  [ ............ =  [album_lb_id_i0028] => d0000  [picfile_i0028] =>  ............ ------- PHP version: 5.0.4 - OK ------------------ mySQL version: 4.1.13-standard ------------------  ............ ------ GD Support enabled  GD Version bundled (2.0.28 compatible)  FreeType Support enabled  FreeType  ............  enabled  ========================== Module: mysql ------------------ Active Persistent Links 0   ............  Links 1  Client API version 4.1.13  MYSQL_MODULE_TYPE external  MYSQL_SOCKET /var/lib/mysql............ .sock  MYSQL_INCLUDE -I/usr/include/mysql  MYSQL_LIBS -L/usr/ ............  -lmysqlclient  ========================== Module: zlib -- ............ -- Directive | Local Value | Master Value sendmail_from | no value | no value sendmail_path | /usr/sbin/ ......
26
cpg1.4 upgrading / Re: Upgrade problem from 1.4.14 to 1.4.16: error message
« by Xil on February 08, 2008, 11:31:41 pm »

......  better to post this debug outpout   I have this error message:  While executing query "SELECT * FROM  ............  approved = 'YES' ORDER BY RAND() LIMIT 8" on 0  mySQL error: Got error 28 from storage engine   Link:  ......

......  from: Nibbler on May 31, 2006, 02:22:21 pm  No need to  ............  you will find out exaclty why.    There was an error while processing a database query.  While  ............  query "SELECT * FROM cpg_pictures WHERE approved = 'YES' ORDER BY  ............ () LIMIT 12" on 0  mySQL error: Got error 28 from storage engine  File: / ............ .php - Line: 249   Line [248] => SELECT count(*) FROM cpg_albums as a WHERE category = '24' (0s)  ......
Pages: [1]

 

Page created in 0.541 seconds with 30 queries.