Help!! Critical error!! Help!! Critical error!!
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

Help!! Critical error!!

Started by YiLi, April 27, 2005, 03:19:08 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

YiLi

Help~!!
My CPG has "Critical error"...and shows...
"There was an error while processing a database query."

http://yili.no-ip.com/gallery/
I don't really know PHP and mySQL...but I do try to read some solutions...
however, not working at all.... :\'(

PLEASE HELP ME~~~~~~
Thanks
===========================================

While executing query "SELECT aid, category, IF(user_name IS NOT NULL, CONCAT('(', user_name, ') ',title), CONCAT(' - ', title)) AS title FROM cpg132_albums AS a LEFT JOIN cpg132_users AS u ON category = (10000 + user_id) ORDER BY category, title" on 0

mySQL error: Table 'gallery.cpg132_albums' doesn't exist

===========================================



USER:
------------------
Array
(
    [ID] => cf18029dd97944b07bea912a63645d86
    [am] => 1
    [liv] => Array
        (
           
  • => 1272
                [1] => 846
                [2] => 1292
                [3] => 1293
                [4] => 1290
            )

        [theme] => mac_ox_x
        [lang] => english
    )

    ==========================
    USER DATA:
    ------------------
    Array
    (
        [user_id] => 1
        [user_group] => 1
        [user_active] => YES
        [user_name] => yili
        [user_password] => ********
        [user_lastvisit] => 2005-04-25 17:10:20
        [user_regdate] => 2004-12-18 15:15:22
        [user_group_list] =>
        [user_email] =>
        [user_website] => http://yili.no-ip.com/gallery
        [user_location] => Taichung & HsinChu
        [user_interests] =>
        [user_occupation] => Engineer
        [user_actkey] =>
        [user_favpics] =>
        [disk_max] => 500000
        [disk_min] => 500000
        [can_rate_pictures] => 1
        [can_send_ecards] => 1
        [ufc_max] => 3
        [ufc_min] => 3
        [custom_user_upload] => 1
        [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] => 1
        [group_name] => Administrators
        [upload_form_config] => 3
        [group_quota] => 500000
        [can_see_all_albums] => 1
        [group_id] => 1
        [groups] => Array
            (
                [1] => 1
            )

    )

    ==========================
    Queries:
    ------------------
    Array
    (
       
  • => SELECT extension, mime, content FROM cpg132_filetypes;
        [1] => SELECT * FROM cpg132_users WHERE user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = 'ac10ec1ace51b2d973cd87973a98d3ab'
        [2] => 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 cpg132_usergroups WHERE group_id in (1)
        [3] => SELECT group_name FROM  cpg132_usergroups WHERE group_id= 1
        [4] => DELETE FROM cpg132_banned WHERE expiry < 1114564626
        [5] => SELECT * FROM cpg132_banned WHERE ip_addr='61.220.247.196' OR ip_addr='61.220.247.196' OR user_id=1
        [6] => SELECT aid, category, IF(user_name IS NOT NULL, CONCAT('(', user_name, ') ',title), CONCAT(' - ', title)) AS title FROM cpg132_albums AS a LEFT JOIN cpg132_users AS u ON category = (10000 + user_id) ORDER BY category, title
    )

    ==========================
    GET :
    ------------------
    Array
    (
        [lang] => english
    )

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

    ==========================
    VERSION INFO :
    ------------------
    PHP version: 4.2.3 - OK
    ------------------
    mySQL version: 3.23.52-max-nt
    ------------------
    Coppermine version: 1.3.2
    ==========================
    Module: gd
    ------------------
    module doesn't exist
    ==========================
    Module: mysql
    ------------------
    module doesn't exist
    ==========================
    Module: zlib
    ------------------
    module doesn't exist
    ==========================
    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 | no value | no value
    file_uploads | 1 | 1
    include_path | .;c:\php4\pear | .;c:\php4\pear
    open_basedir | no value | no value
    ==========================
    email
    ------------------
    Directive | Local Value | Master Value
    sendmail_from | me@localhost.com | me@localhost.com
    sendmail_path | no value | no value
    SMTP | localhost | localhost |  |
    ==========================
    Size and Time
    ------------------
    Directive | Local Value | Master Value
    max_execution_time | 30 | 30 |  |
    upload_max_filesize | 2M | 2M
    post_max_size | 8M | 8M
    ==========================
    Page generated in 2.566 seconds - 7 queries in 0.005 seconds - Album set :

CapriSkye

for some reason his cpg132_albums table got deleted. i created a new albums table and was able to get rid of that error.
but all his albums got wipe out so there's still a problem. all his pictures are still there, just without albums, and click on a picture would show no album for the picture can be found.
if he was to create new albums with the same names as before, i wonder if that would automatically put pictures into those albums....

Nibbler

They would have to have the same `aid` as previously.