Advanced search  

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

Pages: [1]   Go Down

Author Topic: Critical error after update  (Read 2514 times)

0 Members and 1 Guest are viewing this topic.

iakito

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Critical error after update
« on: January 01, 2010, 10:49:51 pm »

Hello,

Today, I have upgraded 2 galleries from 1.4.10 to 1.4.25
The first gallery: no problem
The seccond gallery, I obtain messa
I am having a problem with my gallery after update from 1.4.10 to 1.4.25
Logged

iakito

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: Critical error after update
« Reply #1 on: January 01, 2010, 11:01:39 pm »

oupsss!! finger too wide on the keys!  ::) the message has been posted without my consent

I continue
The second gallery, I obtain an Critical error and this message:

There was an error while processing a database query.

While executing query "SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg148_albums AS a  LEFT JOIN cpg148_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN ()GROUP BY a.aid" on 0

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')GROUP BY a.aid' at line 1

The debug info are:

USER:
------------------
Array
(
    [ID] => 89443aba9b6b321d48f8de617f72e95f
    [am] => 1
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 0
    [user_name] => Guest
    [groups] => Array
        (
           
  • => 3

        )

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

==========================
Queries:
------------------
Array
(
   
  • => SELECT extension, mime, content, player FROM cpg148_filetypes; (0s)
  • [1] => select * from cpg148_plugins order by priority asc; (0s)
        [2] => delete from `ppphotos`.cpg148_sessions where time<1262375656 and remember=0; (0s)
        [3] => delete from `ppphotos`.cpg148_sessions where time<1261169656; (0s)
        [4] => select user_id from `ppphotos`.cpg148_sessions where session_id = 'cb2ccb54f500096d1ccff73f899c4e3f' (0s)
        [5] => select user_id as id, user_password as password from `ppphotos`.cpg148_users where user_id=0 (0s)
        [6] => 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 cpg148_usergroups WHERE group_id in (3) (0s)
        [7] => SELECT group_name FROM  cpg148_usergroups WHERE group_id= 3 (0s)
        [8] => update `ppphotos`.cpg148_sessions set time='1262379256' where session_id = 'cb2ccb54f500096d1ccff73f899c4e3f' (0s)
        [9] => SHOW TABLES LIKE 'cpg148_cms_config' (0s)
        [10] => SELECT * FROM cpg148_cms_config (0s)
        [11] => DELETE FROM cpg148_banned WHERE expiry < '2010-01-01 21:54:16' (0s)
        [12] => SELECT * FROM cpg148_banned WHERE (ip_addr='89.90.180.68' OR ip_addr='89.90.180.68' OR user_id=0) AND brute_force=0 (0s)
        [13] => SELECT aid FROM cpg148_albums (0.001s)
        [14] => SELECT cid, name, description, thumb FROM cpg148_categories WHERE parent = ''  ORDER BY pos (0s)
        [15] => SELECT aid FROM cpg148_albums WHERE category = 13 (0s)
        [16] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 13 (0s)
        [17] => SELECT aid FROM cpg148_albums WHERE category = 10 (0s)
        [18] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 10 (0s)
        [19] => SELECT aid FROM cpg148_albums WHERE category = 6 (0s)
        [20] => SELECT count(*) FROM cpg148_pictures as p, cpg148_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 6 (0s)
        [21] => SELECT count(*) FROM cpg148_albums as a WHERE category = '6' (0s)
        [22] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg148_albums as a LEFT JOIN cpg148_pictures as p ON a.thumb=p.pid WHERE category=6 ORDER BY a.pos LIMIT 0,0 (0s)
        [23] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg148_albums AS a  LEFT JOIN cpg148_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN ()GROUP BY a.aid (0s)
    )

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

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

    ==========================
    Page generated in 0.048 seconds - 24 queries in 0.001 seconds - Album set : ; Meta set: AND aid IN (1,3,4,5,6,7,10,11,12,13,14,16,17,18,19,20,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,96,97,98,99,100,101,102,107,108,109,110,111,112,113,114,115,116,117,119,120,121,122,123,124,125,126,127,128) ;

    I have tried:
    Repairing MYSQL tables - Did not work
    Upgrading again - Did not work

    I can not logged me and access to the configuration.

    The gallery is here:
http://www.polynesiepassion.net/album/index.php
Thank you for your help
Logged

iakito

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: Critical error after update
« Reply #2 on: January 02, 2010, 11:35:08 am »

Hello,

Is repaired  :D

I installed the backup on a blank database and I run again update.php after changing include/config.inc.php with the new values of connection.
Always make backups...

I wish you a happy new year
Logged
Pages: [1]   Go Up
 

Page created in 0.021 seconds with 20 queries.