Critical error: There was an error while processing a database query

[StevenR]

While executing query "SELECT * FROM cpg14x_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 8" on 0

mySQL error: Incorrect key file for table '/tmp/#sql_35e6_0.MYI'; try to repair it

File: /home/jcena/public_html/gallery/include/functions.inc.php - Line: 250 

Code Select Expand

USER:
------------------
Array
(
    [ID] => 8f2457809b7e00924a13a5b0550f60a2
    [am] => 1
    [lang] => english_gb
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => Steven
    [groups] => Array
        (
            [0] => 1
        )

    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 3
    [ufc_min] => 3
    [custom_user_upload] => 0
    [num_file_upload] => 10
    [num_URI_upload] => 3
    [can_post_comments] => 1
    [can_upload_pictures] => 1
    [can_create_albums] => 1
    [has_admin_access] => 1
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [group_name] => Administrators
    [upload_form_config] => 3
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg14x_filetypes; (0s)
    [1] => select * from cpg14x_plugins order by priority asc; (0s)
    [2] => delete from `jcena_Jcenadb`.cpg14x_sessions where time<1245355061 and remember=0; (0s)
    [3] => delete from `jcena_Jcenadb`.cpg14x_sessions where time<1244149061; (0s)
    [4] => select user_id from `jcena_Jcenadb`.cpg14x_sessions where session_id = '28ce9e682852be621aa7eae2e8f2e2fc' (0s)
    [5] => select user_id as id, user_password as password from `jcena_Jcenadb`.cpg14x_users where user_id=1 (0s)
    [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `jcena_Jcenadb`.cpg14x_users AS u INNER JOIN `jcena_Jcenadb`.cpg14x_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
    [7] => SELECT user_group_list FROM `jcena_Jcenadb`.cpg14x_users AS u WHERE user_id='1' and user_group_list <> ''; (0s)
    [8] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg14x_usergroups WHERE group_id in (1) (0s)
    [9] => SELECT group_name FROM  cpg14x_usergroups WHERE group_id= 1 (0s)
    [10] => update `jcena_Jcenadb`.cpg14x_sessions set time='1245358661' where session_id = '28ce9e682852be621aa7eae2e8f2e2fc' (0s)
    [11] => SELECT user_favpics FROM cpg14x_favpics WHERE user_id = 1 (0s)
    [12] => DELETE FROM cpg14x_banned WHERE expiry < '2009-06-18 16:57:41' (0s)
    [13] => SELECT * FROM cpg14x_banned WHERE (ip_addr='92.5.37.158' OR ip_addr='92.5.37.158' OR user_id=1) AND brute_force=0 (0s)
    [14] => SELECT cid, name, description, thumb FROM cpg14x_categories WHERE parent = ''  ORDER BY pos (0s)
    [15] => SELECT aid FROM cpg14x_albums WHERE category = 49 (0s)
    [16] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 49 (0s)
    [17] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '49' (0s)
    [18] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=49 ORDER BY a.pos LIMIT 0,1 (0s)
    [19] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (294)GROUP BY a.aid (0s)
    [20] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='19674' (0s)
    [21] => SELECT aid FROM cpg14x_albums WHERE category = 27 (0s)
    [22] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 27 (0s)
    [23] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '27' (0s)
    [24] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=27 ORDER BY a.pos LIMIT 0,3 (0s)
    [25] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (178, 299, 169)GROUP BY a.aid (0s)
    [26] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='20073' (0s)
    [27] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='20072' (0s)
    [28] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='12599' (0s)
    [29] => SELECT aid FROM cpg14x_albums WHERE category = 127 (0s)
    [30] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 127 (0s)
    [31] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '127' (0s)
    [32] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=127 ORDER BY a.pos LIMIT 0,3 (0s)
    [33] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (211, 322, 185)GROUP BY a.aid (0s)
    [34] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='13381' (0s)
    [35] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='21975' (0s)
    [36] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='12733' (0s)
    [37] => SELECT aid FROM cpg14x_albums WHERE category = 15 (0s)
    [38] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 15 (0s)
    [39] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '15' (0s)
    [40] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=15 ORDER BY a.pos LIMIT 0,1 (0s)
    [41] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (238)GROUP BY a.aid (0s)
    [42] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='13690' (0s)
    [43] => SELECT aid FROM cpg14x_albums WHERE category = 2 (0s)
    [44] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 2 (0s)
    [45] => SELECT aid FROM cpg14x_albums WHERE category = 16 (0s)
    [46] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 16 (0s)
    [47] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '16' (0s)
    [48] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=16 ORDER BY a.pos LIMIT 0,12 (0s)
    [49] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (208, 6, 249, 54, 296, 25, 121, 218, 331, 57, 309, 175)GROUP BY a.aid (0.001s)
    [50] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='13662' (0s)
    [51] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='14240' (0s)
    [52] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='19719' (0s)
    [53] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='10186' (0s)
    [54] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='13500' (0s)
    [55] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='22687' (0s)
    [56] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='4042' (0s)
    [57] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='21614' (0s)
    [58] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='12651' (0s)
    [59] => SELECT aid FROM cpg14x_albums as a WHERE category>=10000 (0s)
    [60] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0s)
    [61] => SELECT aid FROM cpg14x_albums as a WHERE category = '0' (0s)
    [62] => SELECT count(*) FROM cpg14x_albums as a WHERE 1 (0s)
    [63] => SELECT count(*) FROM cpg14x_pictures as p LEFT JOIN cpg14x_albums as a ON a.aid=p.aid WHERE 1 AND approved='YES' (0.015s)
    [64] => SELECT count(*) FROM cpg14x_comments as c LEFT JOIN cpg14x_pictures as p ON c.pid=p.pid LEFT JOIN cpg14x_albums as a ON a.aid=p.aid WHERE 1 (0.012s)
    [65] => SELECT count(*) FROM cpg14x_categories WHERE 1 (0s)
    [66] => SELECT sum(hits) FROM cpg14x_pictures as p LEFT JOIN cpg14x_albums as a ON p.aid=a.aid WHERE 1 (0.04s)
    [67] => SELECT COUNT(*) FROM cpg14x_pictures WHERE approved = 'NO' (0.014s)
    [68] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '0' (0s)
    [69] => SELECT COUNT(*) from cpg14x_pictures WHERE approved = 'YES'  (0.009s)
    [70] => SELECT * FROM cpg14x_pictures WHERE approved = 'YES'  ORDER BY pid DESC  LIMIT 0 ,8 (0s)
    [71] => SELECT * FROM cpg14x_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 8 (0.805s)
)

==========================
GET :
------------------
Array
(
)

==========================
POST :
------------------
Array
(
)

==========================
VERSION INFO :
------------------
PHP version: 5.2.9 - OK
------------------
mySQL version: 5.0.77-community
------------------
Coppermine version: 1.4.24(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.34 compatible)
FreeType Support: 1
FreeType Linkage: with freetype
T1Lib Support:
GIF Read Support: 1
GIF Create Support: 1
JPG Support: 1
PNG Support: 1
WBMP Support: 1
XPM Support: 1
XBM Support: 1
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 1
Client API version 5.0.77
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib64 -lmysqlclient 
==========================
Module: zlib
------------------
ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.1.2
Linked Version 1.2.3
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | no value | no value
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | no value | no value
sql.safe_mode | Off | Off
disable_functions | exec, shellexec, passthru, system, escapeshellcmd, escapeshellarg, allow_url_fopen | exec, shellexec, passthru, system, escapeshellcmd, escapeshellarg, allow_url_fopen
file_uploads | On | On
include_path | .:/usr/lib/php:/usr/local/lib/php | .:/usr/lib/php:/usr/local/lib/php
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 30 | 30
max_input_time | 60 | 60
upload_max_filesize | 2M | 2M
post_max_size | 8M | 8M
==========================
Page generated in 1.09 seconds - 72 queries in 0.896 seconds - Album set : ; Meta set: ;

The problem first started today. I proceeded to do an upgrade, hoping that it would indeed fix the error, it didn't. So now I'm here.

Any help would be greatly appreciated.

[Joachim Müller]

The error message doesn't come from coppermine, but from your mysql database - it just shines through in coppermine. As suggested in the error message's text, the mysql database is broken and needs to be repaired, which is something that is beyond the scope of what coppermine can do. Use a third party tool like phpMyAdmin to perform the repair command against the database. If you can't do that (for lack of permissions, skills or whatever), ask your webhost for support, telling them the text of the error message. Not very surprisingly: your question has been asked and answered before, so the reply I just made has been posted many times over. In the future, please search first before starting a thread. And please don't play with buttons that you have no idea of what they do: tagging your thread as "solved" instantly right after posting is not a bright idea if you are actually looking for answers.

[StevenR]

Apologies about that. I thought it was an edit button. I was looking to add more detail. It appears there is no edit button though.

Anyway; what do I run the repair in phpMyAdmin against? The pictures table?

[Nibbler]

You can't repair it in phpMyAdmin. You need to contact your host to get them to fix their MySQL setup. To get your main page back you can disable the 'random files' block in config ('content of the main page' setting).

[StevenR]

Thanks.

Its just the fact that there are no pictures (thumbnails) available until my host fixes it?

[Joe Carver]

Have you tried what was suggested before you posted again?

To get your main page back you can disable the 'random files' block in config ('content of the main page' setting).

By the way, if you post a link to your gallery you might be able to get more help and save people time too...........

[StevenR]

Its just what I posted already. However, as per request, here is the link:

http://j-cena.com/gallery/index.php

(I had to remove the random images)