1

cpg1.2 Standalone Support / Error 127 from MySQL after registered new user

« by lamme on October 21, 2003, 08:37:59 am »

......  I got a problem with MySQL. After the first user  ............  it comes with this error: While executing query "SELECT aid, CONCAT('(',  ............ , ') ', title) AS title FROM cpg11d_albums AS a INNER JOIN cpg11d_users AS u  ............  = (10000 + user_id) ORDER BY title" on 0 mySQL error: Got error 127 from table handler  ......

2

cpg1.2 Standalone Support / database crash - critical error 127

« by jmc on March 08, 2004, 01:36:47 am »

...... , max(pid) as last_pid, max(ctime) as last_upload FROM cpg11d_pictures WHERE aid IN (1, 4, 5, 6) AND  ............  = 'YES' GROUP BY aid" on 0 mySQL error: Got error 127 from table handler File: C:\ ............  - Line: 105 ( Line 105 says: cpg_die(CRITICAL_ERROR, $out, __FILE__, __LINE__); ) DEBUG INFO: USER:  ............  and 60+ photos, it's not a major task to start from scratch, but I'm interested for catastrophic  ............  EDIT: Obviously, I know how to create an sql file from the db... just not sure whether I would be re- ......

3

cpg1.3 Miscellaneous / There was an error while processing a database query

« by pimkoorn on January 05, 2005, 12:14:07 am »

......  was an error while processing a database query.  While  ............ (msg_date) as msg_date, msg_body, aid FROM cpg1321_comments as c, cpg1321_pictures as p  ............  = p.pid ORDER by msg_id DESC LIMIT 0 ,8" on 0  mySQL error: Got error 127 from table handler   it  ......

4

cpg1.4 miscellaneous / database query

« by Master D on March 18, 2006, 03:58:27 am »

...... 't know what to do to fix this problem.  "Critical error There was an error while processing a database  ............ , max( p.ctime ) AS last_upload, a.keyword FROM cpg143_albums AS a LEFT JOIN cpg143_pictures AS  ............  = 'YES' WHERE a.aid IN (11)GROUP BY a.aid" on 0  mySQL error: Got error 127 from table handler Please  ......

5

cpg1.4 miscellaneous / Re: My site is down - Critical error

« by Joachim Müller on September 20, 2006, 07:04:24 am »

......  requested, it only clutters the thread.  Quote from: CD69 on September 20, 2006, 03:19:25 am  mySQL  ............ : Got error 127 from table handler  http://forum. ............ -gallery.net/index.php?topic=23411.0  Quote from: CD69 on September 20, 2006, 04:00:13 am  While  ............  query "DELETE FROM cpg11d_mod_online WHERE last_action < NOW() -  ......

6

cpg1.3.x Support / Critical error

« by heyyoukidd on November 07, 2005, 01:59:14 pm »

......  to my gallery because now all I see is "Critical error" where the album list should be. I read in  ............  post to put it on debug mode and I got this message:  There was an error while  ............ , max(pid) as last_pid, max(ctime) as last_upload FROM cpg135_pictures WHERE aid IN (23) AND approved = ' ............ ' GROUP BY aid" on 0  mySQL error: Got error 127 from table handler  And then  ............ -- Array (  => SELECT extension, mime, content FROM cpg135_filetypes; [1] => SELECT * FROM  ............ ) as priv_upl_need_approval FROM cpg135_usergroups WHERE group_id in (1)  [3] => ............  SELECT group_name FROM cpg135_usergroups WHERE group_id= 1  [4] =>  ............  FROM cpg135_banned WHERE expiry < '2005-11-07 07:47:30' ............   [5] => SELECT * FROM cpg135_banned WHERE ip_addr='66.69.107.71' OR  ............ =1  [6] => SELECT cid, name, description, thumb FROM cpg135_categories WHERE parent = '' ORDER BY pos  ............  [7] => SELECT aid FROM cpg135_albums as a WHERE category>=10000  [8] = ............ > SELECT count(*) FROM cpg135_pictures as p, cpg135_albums as a WHERE p. ............   [9] => SELECT cid, name, description, thumb FROM cpg135_categories WHERE parent = '1' ORDER BY  ............   [10] => SELECT aid FROM cpg135_albums WHERE category = 2  [11] =>  ............  count(*) FROM cpg135_pictures as p, cpg135_albums as a WHERE p. ............ .aid AND category = 2  [12] => SELECT count(*) FROM cpg135_albums as a WHERE category = '2'  [13] = ............ , filepath, filename, url_prefix, pwidth, pheight FROM cpg135_albums as a LEFT JOIN cpg135_pictures as p  ............ , max(pid) as last_pid, max(ctime) as last_upload FROM cpg135_pictures WHERE aid IN (3, 24, 4, 9, 11, 20, ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='225'  [16] =>  ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='224'  [17] =>  ............  cid, name, description, thumb FROM cpg135_categories WHERE parent = '2' ORDER BY  ............   [18] => SELECT aid FROM cpg135_albums WHERE category = 3  [19] =>  ............  count(*) FROM cpg135_pictures as p, cpg135_albums as a WHERE p. ............ .aid AND category = 3  [20] => SELECT count(*) FROM cpg135_albums as a WHERE category = '3'  [21] = ............ , filepath, filename, url_prefix, pwidth, pheight FROM cpg135_albums as a LEFT JOIN cpg135_pictures as p  ............ , max(pid) as last_pid, max(ctime) as last_upload FROM cpg135_pictures WHERE aid IN (1, 2) AND approved = ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='2'  [24] => SELECT  ............ , name, description, thumb FROM cpg135_categories WHERE parent = '3' ORDER BY  ............   [25] => SELECT aid FROM cpg135_albums WHERE category = 4  [26] =>  ............  count(*) FROM cpg135_pictures as p, cpg135_albums as a WHERE p. ............ .aid AND category = 4  [27] => SELECT count(*) FROM cpg135_albums as a WHERE category = '4'  [28] = ............ , filepath, filename, url_prefix, pwidth, pheight FROM cpg135_albums as a LEFT JOIN cpg135_pictures as p  ............ , max(pid) as last_pid, max(ctime) as last_upload FROM cpg135_pictures WHERE aid IN (21, 22, 18, 19) AND  ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='155'  [31] =>  ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='159'  [32] =>  ............  cid, name, description, thumb FROM cpg135_categories WHERE parent = '4' ORDER BY  ............   [33] => SELECT aid FROM cpg135_albums WHERE category = 5  [34] =>  ............  count(*) FROM cpg135_pictures as p, cpg135_albums as a WHERE p. ............ .aid AND category = 5  [35] => SELECT count(*) FROM cpg135_albums as a WHERE category = '5'  [36] = ............ , filepath, filename, url_prefix, pwidth, pheight FROM cpg135_albums as a LEFT JOIN cpg135_pictures as p  ............ , max(pid) as last_pid, max(ctime) as last_upload FROM cpg135_pictures WHERE aid IN (26, 12, 8, 13, 15,  ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='231'  [39] =>  ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='235'  [40] =>  ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='233'  [41] =>  ............  filepath, filename, url_prefix, pwidth, pheight FROM cpg135_pictures WHERE pid='133'  [42] =>  ............  cid, name, description, thumb FROM cpg135_categories WHERE parent = '5' ORDER BY  ............   [43] => SELECT aid FROM cpg135_albums WHERE category = 6  [44] =>  ............  count(*) FROM cpg135_pictures as p, cpg135_albums as a WHERE p. ............   [45] => SELECT cid, name, description, thumb FROM cpg135_categories WHERE parent = '6' ORDER BY  ............   [46] => SELECT aid FROM cpg135_albums WHERE category = 7  [47] =>  ............  count(*) FROM cpg135_pictures as p, cpg135_albums as a WHERE p. ............ .aid AND category = 7  [48] => SELECT count(*) FROM cpg135_albums as a WHERE category = '7'  [49] = ............ , filepath, filename, url_prefix, pwidth, pheight FROM cpg135_albums as a LEFT JOIN cpg135_pictures as p  ............ , max(pid) as last_pid, max(ctime) as last_upload FROM cpg135_pictures WHERE aid IN (23) AND approved = ' ............ ------- PHP version: 4.4.0 - OK ------------------ mySQL version: 4.0.25-standard-log ------------------  ............  enabled  ========================== Module: mysql ------------------ Active Persistent Links 0   ............  Links 1  Client API version 4.0.25  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/ ......

7

cpg1.3.x Support / There was an error while processing a database query.

« by unbeliever on November 05, 2005, 12:57:20 pm »

......  executing query "SELECT sum(hits) FROM copper_pictures as p LEFT JOIN copper_albums as a  ............  p.aid=a.aid WHERE 1" on 0  mySQL error: Got error 127 from table handler   what  ......

8

cpg1.4 miscellaneous / Critical Error after server goes down...

« by unquiet_void on August 03, 2006, 06:01:11 pm »

......  this morning. As a result, There is apparently an error in the database stopping visitors from viewing my  ............  to be in, even when in Debug Mode. Here is the error message. I can supply Debug Information if needed. ............   Thanks. ^_^   CRITICAL ERROR: While executing query "SELECT a.aid, count( p. ............ , max( p.ctime ) AS last_upload, a.keyword FROM cpg148_albums AS a LEFT JOIN cpg148_pictures AS  ............ , 23, 15, 16, 17, 18, 19, 20)GROUP BY a.aid" on 0  mySQL error: Got error 127 from table handler  ......

9

cpg1.2 Standalone Support / Critical Error: mySQL error 127

« by Tamir on February 24, 2004, 06:06:30 pm »

......  comment that didn't appear) wouldn't get deleted from the database! it gives the error: Quote   While  ............  query "DELETE FROM defaultcomments WHERE pid='46'" on 0 mySQL error: ............  Got error 127 from table handler File: /home/virtual/ ......

10

cpg1.4 upload / Home page error

« by wfs on June 26, 2006, 03:55:06 pm »

......  done something to the codes of my index page.  I got this msg when I tried to refresh the index page:  ............   "Critical error:  "There was an error while processing a database  ............  is:   "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 table handler"  and  ............ .inc.php - Line: 249   How do I correct this error?  The other pages seems OK.  pse help.  thanks.  ......

11

cpg1.4 upgrading / Re: Critical Error with DB Query

« by cessam on August 13, 2007, 11:45:23 am »

......  did the repair on the table however now still getting the same error. It  ............  on their end.  While executing query "delete from `userID_coppermine`.copperminesessions where time< ............  and remember=0;" on Resource id #6  mySQL error: Got error 127 from table handler  ......