coppermine-gallery.com/forum

......  mode :   QuoteWhile 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/ ......

...... , 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 error : Error : QuoteWhile executing query " ............  * 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/ ......

...... , 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  ......

...... , 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  ......

...... , 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:  ......

......  from: AVB on November 12, 2007, 08:35:49  ............ . Çàëåç â îòëàäêó  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 PMIt's an  ............  from MySQL, not Coppermine. Contact your host.  OS  ............  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 quizás  ............ .  Encontré un comentario con respecto a un error idéntico al tuyo pero en los foros de vBulletin™  ......

......  buenos días yo tengo el mismo problema de (Error crítico  Se produjo un error al procesar una  ............ )  hice lo de modo de depuración y me suelta este errorQuoteWhile 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  ......

...... .mx/galeria/  QuoteWhile 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  ......

......  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 QuotemySQL error: Got error 28 from  ............  enginewhen searching this board? That's funny. I get 11  ............  of search results when searching for "Got error 28 from storage engine", and all of those  ......

......  following message:  Code Select Expand 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  ............ ]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/ ......

......  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: ;  ......

......  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  ......

......  requête. 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  ......

......  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   QuoteWhile executing query "SELECT * FROM cpg14x_pictures WHERE approved = 'YES' ORDER BY  ............ () LIMIT 5" on 0  mySQL error: Got error 28 from storage engine http:// ......

......  your webhost that you're gettingQuote from: gisellebebegirl on July 03, 2008, 12:58:41  ............  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  QuoteWhile 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/ ......

......  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 PMNo need to  ............  then 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)  ......