Critical Error

[Adiago]

I'm having issues with my gallery, they started yesterday, I keep getting 'Critical Error' when I'm signed in (FireFox) and with IE I can't even view the gallery but I get a blank page with another error message.

(My Version: Coppermine Photo Gallery 1.4.13 (stable))

FireFox - Signed in error

Code Select Expand

Critical error
There was an error while processing a database query

IE - Error Message

Code Select Expand

Template error
Failed to find block 'log_ecards'(#(<!-- BEGIN log_ecards -->)(.*?)(<!-- END log_ecards -->)#s) in :

                <div align="center">
                <table cellpadding="0" cellspacing="1">
                        <tr>

                                <td class="admin_menu"><a href="admin.php" title="{ADMIN_TITLE}">{ADMIN_LNK}</a></td>
                                <td class="admin_menu"><a href="catmgr.php" title="{CATEGORIES_TITLE}">{CATEGORIES_LNK}</a></td>
                                <td class="admin_menu"><a href="albmgr.php{CATL}" title="{ALBUMS_TITLE}">{ALBUMS_LNK}</a></td>
                                <td class="admin_menu"><a href="groupmgr.php" title="{GROUPS_TITLE}">{GROUPS_LNK}</a></td>
                                <td class="admin_menu"><a href="usermgr.php" title="{USERS_TITLE}">{USERS_LNK}</a></td>
                                <td class="admin_menu"><a href="banning.php" title="{BAN_TITLE}">{BAN_LNK}</a></td>
                                <td class="admin_menu"><a href="reviewcom.php" title="{COMMENTS_TITLE}">{COMMENTS_LNK}</a></td>

                                <td class="admin_menu"><a href="picmgr.php" title="{PICTURES_TITLE}">{PICTURES_LNK}</a></td>
                                <td class="admin_menu"><a href="searchnew.php" title="{SEARCHNEW_TITLE}">{SEARCHNEW_LNK}</a></td>
                                <td class="admin_menu"><a href="util.php" title="{UTIL_TITLE}">{UTIL_LNK}</a></td>
                                <td class="admin_menu"><a href="profile.php?op=edit_profile" title="{MY_PROF_TITLE}">{MY_PROF_LNK}</a></td>
<!-- BEGIN documentation -->
                                <td class="admin_menu"><a href="{DOCUMENTATION_HREF}" title="{DOCUMENTATION_TITLE}" target="cpg_documentation">{DOCUMENTATION_LNK}</a></td>
<!-- END documentation -->
                        </tr>
                </table>
                </div>



Yesterday this error appeared and somehow went away after an hour or so and everything was working as it should, and today the error is back again, how come and how can I fix this?

I really appriciate any help, thanks.

[Joachim Müller]

Enable debug_mode (as suggested in http://coppermine-gallery.net/tutorial/debug_mode.php) and post the actual error message (not the debug_output). Posting a link to your gallery might help as well.

[Adiago]

Code Select Expand

USER:
------------------
Array
(
    [ID] => (removed)
    [am] => 1
    [liv] => Array
        (
            [0] => 118125
            [1] => 118124
            [2] => 118123
            [3] => 118122
            [4] => 118131
        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => (removed)
    [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] => 10
    [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 cpg11d_filetypes; (0s)
    [1] => select * from cpg11d_plugins order by priority asc; (0s)
    [2] => delete from `smallvil_gallery`.cpg11d_sessions where time<1194542062 and remember=0; (0.001s)
    [3] => delete from `smallvil_gallery`.cpg11d_sessions where time<1193336062; (0s)
    [4] => select user_id from `smallvil_gallery`.cpg11d_sessions where session_id=md5("90dd717b2390b4be16de9d6bc3b703521974237653ab1ab080aa7e5dcc87bc7d"); (0s)
    [5] => select user_id as id, user_password as password from `smallvil_gallery`.cpg11d_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 `smallvil_gallery`.cpg11d_users AS u INNER JOIN `smallvil_gallery`.cpg11d_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
    [7] => SELECT user_group_list FROM `smallvil_gallery`.cpg11d_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 cpg11d_usergroups WHERE group_id in (1) (0s)
    [9] => SELECT group_name FROM  cpg11d_usergroups WHERE group_id= 1 (0s)
    [10] => update `smallvil_gallery`.cpg11d_sessions set time='1194545662' where session_id=md5('90dd717b2390b4be16de9d6bc3b703521974237653ab1ab080aa7e5dcc87bc7d'); (0s)
    [11] => SELECT user_favpics FROM cpg11d_favpics WHERE user_id = 1 (0s)
    [12] => DELETE FROM cpg11d_banned WHERE expiry < '2007-11-08 18:14:22' (0s)
    [13] => SELECT * FROM cpg11d_banned WHERE (ip_addr='85.227.237.14' OR ip_addr='85.227.237.14' OR user_id=1) AND brute_force=0 (0s)
    [14] => SELECT cid, name, description, thumb FROM cpg11d_categories WHERE parent = ''  ORDER BY pos (0s)
    [15] => SELECT aid FROM cpg11d_albums WHERE category = 8 (0s)
    [16] => SELECT count(*) FROM cpg11d_pictures as p, cpg11d_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 8 (0s)
    [17] => SELECT aid FROM cpg11d_albums WHERE category = 2 (0s)
    [18] => SELECT count(*) FROM cpg11d_pictures as p, cpg11d_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 2 (0s)
    [19] => SELECT aid FROM cpg11d_albums as a WHERE category>=10000 (0s)
    [20] => SELECT count(*) FROM cpg11d_pictures as p, cpg11d_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0s)
    [21] => SELECT aid FROM cpg11d_albums WHERE category = 7 (0s)
    [22] => SELECT count(*) FROM cpg11d_pictures as p, cpg11d_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 7 (0s)
    [23] => SELECT count(*) FROM cpg11d_albums as a WHERE category = '7' (0s)
    [24] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_albums as a LEFT JOIN cpg11d_pictures as p ON a.thumb=p.pid WHERE category=7 ORDER BY a.pos LIMIT 0,14 (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 cpg11d_albums AS a  LEFT JOIN cpg11d_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (65, 66, 67, 68, 69, 70, 71, 72, 74, 73, 283, 284, 285, 286)GROUP BY a.aid (0.001s)
    [26] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='4745' (0s)
    [27] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='4746' (0s)
    [28] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='4747' (0s)
    [29] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='4744' (0s)
    [30] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='4748' (0s)
    [31] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='4709' (0s)
    [32] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='4721' (0s)
    [33] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='4698' (0s)
    [34] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='4716' (0s)
    [35] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='4743' (0s)
    [36] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='77832' (0s)
    [37] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='77836' (0s)
    [38] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='77826' (0s)
    [39] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='77837' (0s)
    [40] => SELECT aid FROM cpg11d_albums WHERE category = 25 (0s)
    [41] => SELECT count(*) FROM cpg11d_pictures as p, cpg11d_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 25 (0s)
    [42] => SELECT count(*) FROM cpg11d_albums as a WHERE category = '25' (0s)
    [43] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_albums as a LEFT JOIN cpg11d_pictures as p ON a.thumb=p.pid WHERE category=25 ORDER BY a.pos LIMIT 0,8 (0s)
    [44] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg11d_albums AS a  LEFT JOIN cpg11d_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (97, 98, 99, 100, 101, 230, 303, 277)GROUP BY a.aid (0.002s)
    [45] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='76078' (0s)
    [46] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='5830' (0s)
    [47] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='5832' (0s)
    [48] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='5632' (0s)
    [49] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='21811' (0s)
    [50] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='77820' (0s)
    [51] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='77773' (0s)
    [52] => SELECT aid FROM cpg11d_albums WHERE category = 44 (0s)
    [53] => SELECT count(*) FROM cpg11d_pictures as p, cpg11d_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 44 (0s)
    [54] => SELECT count(*) FROM cpg11d_albums as a WHERE category = '44' (0s)
    [55] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_albums as a LEFT JOIN cpg11d_pictures as p ON a.thumb=p.pid WHERE category=44 ORDER BY a.pos LIMIT 0,13 (0s)
    [56] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg11d_albums AS a  LEFT JOIN cpg11d_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 152)GROUP BY a.aid (0.001s)
    [57] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='116660' (0s)
    [58] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='5892' (0s)
    [59] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='5890' (0s)
    [60] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='76076' (0s)
    [61] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='81587' (0s)
    [62] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='5880' (0s)
    [63] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='81586' (0s)
    [64] => SELECT aid FROM cpg11d_albums as a WHERE category = '0' (0s)
    [65] => SELECT count(*) FROM cpg11d_albums as a WHERE 1 (0s)
    [66] => SELECT count(*) FROM cpg11d_pictures as p LEFT JOIN cpg11d_albums as a ON a.aid=p.aid WHERE 1 AND approved='YES' (0.103s)
    [67] => SELECT count(*) FROM cpg11d_comments as c LEFT JOIN cpg11d_pictures as p ON c.pid=p.pid LEFT JOIN cpg11d_albums as a ON a.aid=p.aid WHERE 1 (0s)
    [68] => SELECT count(*) FROM cpg11d_categories WHERE 1 (0s)
    [69] => SELECT sum(hits) FROM cpg11d_pictures as p LEFT JOIN cpg11d_albums as a ON p.aid=a.aid WHERE 1 (0.653s)
    [70] => SELECT COUNT(*) FROM cpg11d_pictures WHERE approved = 'NO' (0.06s)
    [71] => SELECT count(*) FROM cpg11d_albums as a WHERE category = '0' (0s)
    [72] => SELECT COUNT(*) from cpg11d_pictures WHERE approved = 'YES'  (0.059s)
    [73] => SELECT * FROM cpg11d_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 6 (2.445s)
)

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

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

==========================
VERSION INFO :
------------------
PHP version: 5.2.1 - OK
------------------
mySQL version: 5.0.27-standard
------------------
Coppermine version: 1.4.13(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.28 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.24
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -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, shell_exec, system, passthru, shell_exec, | exec, shell_exec, system, passthru, shell_exec,
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 3.482 seconds - 74 queries in 3.325 seconds - Album set : ; Meta set: ;

[Joachim Müller]

I told you to post the error message and not to post the debug_output. You did the opposite of what I proposed and posted the debug_output, but failed to post the error message.
Additionally you didn't do as I suggested: you haven't posted a link to your gallery.

Failing to do as supporters suggest usually leads to your support requests getting ignored, or at least supporters getting reluctant to look into your issues.

[Adiago]

I'm sorry, I misread your previous post which led me to post the "debug_output" instead of the error message, it wasn't intentional. As to posting a link to the gallery I did so intentionally, it won't show anything more than the error messages I'm posting here.

And as much as I appreciate you taking your time to help me out I don't see why the attitude (& - karma) is necessary, we all make mistakes, a simple "the other error message" would of have worked just as well.

Code Select Expand

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

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

Now if I'm not ignored due to speaking my mind I'd still appreciate your help!

Thanks,

[Joachim Müller]

And as much as I appreciate you taking your time to help me out I don't see why the attitude (& - karma) is necessary

Starting a meta discussion about karma won't help.

As to posting a link to the gallery I did so intentionally, it won't show anything more than the error messages I'm posting here.

The page might not show more for you, but might show more for us. We understand the application we designed better than you and have other methods that you're not aware of. That's why I told you to post the link to your gallery not matter what. I don't have to justify this nor am I willing to argue with you about it. Do as I suggested!

Code Select Expand

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

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

The error mesage means that one (or more) of your tables is broken and must be repaired using the repair command. If you have shell access, you can perform it there. Otherwise, you'll need to perform the repair command using a tool like phpMyAdmin. Maybe your webhost is providing a control panel application as well that enables you to run the repair command. Alternatively, you can ask your webhost to perform this for you.
To find more about the repair command, search this board or look it up in the mysql documentation.

[Lahori_Munda]

Where is my problem 

[Stramm]

I don't know... but you have been told already what to do to solve them.

[Joachim Müller]

Where is my problem 

Between your keyboard and your chair apparently
I told you what you need to do. If you don't, then nobody will be able to help you.