forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: net4all on March 01, 2006, 04:34:50 pm

Title: Critical Error
Post by: net4all on March 01, 2006, 04:34:50 pm
Hi everybody!

Today a friend of mine uploaded some pictures into his gallery, and wanted to change the sort order of the pictures - but he got a critical error and since that the gallery doesnīt work - it only returns a critical error. Unfortunately he couldnīt explain exactly what he did  >:( - so Iīve just got this poor information.

Hereīs the message I got by using the debug mode:

USER:
------------------
Array
(
    [ID] => 2c68549e468721fd67ca35be598b88a7
    [am] => 1
    [liv] => Array
        (
            [user_id] => 1
    [user_group] => 1
    [user_active] => YES
    [user_name] => admin
    [user_password] => ********
    [user_lastvisit] => 2006-03-01 16:20:55
    [user_regdate] => 2005-05-18 10:35:36
    [user_group_list] =>
    [user_email] =>
    [user_website] =>
    [user_location] =>
    [user_interests] =>
    [user_occupation] =>
    [user_actkey] =>
    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 0
    [can_send_ecards] => 1
    [ufc_max] => 3
    [ufc_min] => 3
    [custom_user_upload] => 0
    [num_file_upload] => 9
    [num_URI_upload] => 3
    [can_post_comments] => 0
    [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
    [groups] => Array
        (
            [1] => 1
        )

)

==========================
Queries:
------------------
Array
(
   
Title: Re: Critical Error
Post by: Nibbler on March 01, 2006, 06:44:18 pm
Post the actual mysql error message you get.
Title: Re: Critical Error
Post by: net4all on March 01, 2006, 06:57:42 pm
Post the actual mysql error message you get.

Here it is:

While executing query "SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg133_pictures WHERE aid IN (40) AND approved = 'YES' GROUP BY aid" on 0

mySQL error: Got error 134 from table handler
Title: Re: Critical Error
Post by: Nibbler on March 01, 2006, 07:01:40 pm
It's a mysql issue, unrelated to Coppermine.

MySQL error code 134: Record was already deleted (or record file crashed)

Try running a REPAIR on the table using phpmyadmin.