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 upgrade  (Read 7156 times)

0 Members and 1 Guest are viewing this topic.

flyingsparks

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
critical error after upgrade
« on: June 03, 2010, 07:42:54 am »

After upgrading from 1.4 to 1.5.4 I'm now getting this error and am unable to view anything from my gallery.  Thanks in advance for help.

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

While executing query 'SELECT COUNT(DISTINCT(p.aid)) AS alb_count, COUNT(*) AS pic_count
        FROM cpg130_albums AS a
        INNER JOIN cpg130_pictures AS p ON p.aid = a.aid
        WHERE a.category > 10000
        AND approved = 'YES'' in index.php on line 287

mySQL error: Incorrect key file for table 'cpg130_pictures'; try to repair it

Here's the debug output:

Code: [Select]
USER:
------------------
Array
(
    [ID] => b13cad6694ad8a54f63406e5c0276198
    [am] => 1
    [lang] => english
)

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

    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [can_post_comments] => 0
    [can_upload_pictures] => 1
    [can_create_albums] => 1
    [has_admin_access] => 1
    [access_level] => 3
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [group_name] => Administrators
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
    [allowed_albums] => Array
        (
        )

)

==========================
Queries:
------------------
Array
(
    [0] => SELECT name, value FROM cpg130_config [include/init.inc.php:178] (2 ms)
    [1] => SELECT * FROM cpg130_plugins ORDER BY priority [include/plugin_api.inc.php:54] (3 ms)
    [2] => SELECT user_id, time FROM `sonny_gallery`.cpg130_sessions WHERE session_id = '08a43d6bb0198dc2b405c457dd93eb5f' [bridge/coppermine.inc.php:264] (2 ms)
    [3] => SELECT user_id, user_password FROM `sonny_gallery`.cpg130_users WHERE user_id = 1 [bridge/coppermine.inc.php:276] (1 ms)
    [4] => SELECT u.user_id AS id, u.user_name AS username, user_password AS password, u.user_group AS group_id FROM `sonny_gallery`.cpg130_users AS u LEFT JOIN `sonny_gallery`.cpg130_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' [bridge/udb_base.inc.php:70] (0 ms)
    [5] => SELECT user_group_list FROM `sonny_gallery`.cpg130_users AS u WHERE user_id='1' AND user_group_list <> '' [bridge/coppermine.inc.php:202] (1 ms)
    [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(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, MAX(access_level) AS access_level, MIN(pub_upl_need_approval) AS pub_upl_need_approval, MIN( priv_upl_need_approval) AS  priv_upl_need_approval FROM cpg130_usergroups WHERE group_id in (1) [bridge/udb_base.inc.php:321] (1 ms)
    [7] => SELECT group_name FROM  cpg130_usergroups WHERE group_id= 1 [bridge/udb_base.inc.php:325] (1 ms)
    [8] => UPDATE `sonny_gallery`.cpg130_sessions SET time = UNIX_TIMESTAMP() WHERE session_id = '08a43d6bb0198dc2b405c457dd93eb5f' [bridge/coppermine.inc.php:321] (1 ms)
    [9] => SELECT lang_id FROM cpg130_languages WHERE enabled='YES' [include/init.inc.php:326] (1 ms)
    [10] => SELECT user_favpics FROM cpg130_favpics WHERE user_id = 1 [include/init.inc.php:384] (1 ms)
    [11] => SHOW TABLES LIKE 'cpg130_languages' [include/functions.inc.php:4123] (1 ms)
    [12] => SELECT * FROM cpg130_languages [include/functions.inc.php:4130] (0 ms)
    [13] => SHOW TABLES LIKE 'cpg130_languages' [include/functions.inc.php:4123] (1 ms)
    [14] => SELECT * FROM cpg130_languages [include/functions.inc.php:4130] (1 ms)
    [15] => DELETE FROM cpg130_banned WHERE expiry < '2010-06-02 22:39:32' [include/init.inc.php:440] (3 ms)
    [16] => SELECT null FROM cpg130_banned WHERE (user_id=1 OR '76.93.73.226' LIKE ip_addr ) AND brute_force=0 LIMIT 1 [include/init.inc.php:456] (0 ms)
    [17] => SELECT name, description, thumb FROM cpg130_categories WHERE cid = 1 [index.php:263] (0 ms)
    [18] => SELECT COUNT(DISTINCT(p.aid)) AS alb_count, COUNT(*) AS pic_count
        FROM cpg130_albums AS a
        INNER JOIN cpg130_pictures AS p ON p.aid = a.aid
        WHERE a.category > 10000
        AND approved = 'YES' [index.php:287] (1 ms)
    [19] => SELECT COUNT(*) FROM cpg130_pictures WHERE approved = 'NO' [include/functions.inc.php:2402] (1 ms)
    [20] => SELECT lang_id, abbr FROM cpg130_languages WHERE available='YES' AND enabled='YES' [include/themes.inc.php:2315] (0 ms)
    [21] => DELETE FROM cpg130_temp_messages WHERE time < 1275539972 [include/functions.inc.php:4903] (0 ms)
)

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

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

==========================
COOKIE :
------------------
Array
(
    [cpg_install_cookie_check] => passed
    [cpg15x_data] => YTozOntzOjI6IklEIjtzOjMyOiJjN2IwN2QyMDI4MTZlMTFhZTNjY2Y3ZWY4ZGE1YjM0YiI7czoyOiJhbSI7aToxO3M6NDoibGFuZyI7czo3OiJlbmdsaXNoIjt9
    [65f5bfe98264e3bd03370209269c6437] => 6533b31dfdeb54396320d87ad5a8ffce
    [cpg143_data] => YTozOntzOjI6IklEIjtzOjMyOiJiMTNjYWQ2Njk0YWQ4YTU0ZjYzNDA2ZTVjMDI3NjE5OCI7czoyOiJhbSI7aToxO3M6NDoibGFuZyI7czo3OiJlbmdsaXNoIjt9
    [3912b8ffa89ef3106aa4b20296e1ca89] => fc6106c2ca290a2ada5c45a8f5701f29
)

==========================
VERSION INFO :
------------------
PHP version        5.2.9      OK    
MySQL version      5.1.39-log OK    
Coppermine version 1.5.4      Stable

==========================
Module: GD
------------------
Exact version                    2.0.34                    
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                                                
XBM Support                      1                          
JIS-mapped Japanese Font Support                            

==========================
Key config settings
------------------
site_url             http://gallery.mauricebenard.tv/            
charset              utf-8                                      
allow_private_albums 0                                          
cookie_name          cpg143                                      
cookie_path          /                                          
impath               /usr/bin/                                  
lang                 english                                    
main_page_layout     breadcrumb/catlist/alblist/lasthits/lastup,2
silly_safe_mode      0                                          
smtp_host                                                        
theme                mbtv                                        
thumb_method         im                                          

==========================
Plugins
------------------

==========================
Server restrictions
------------------
safe_mode                                                            
safe_mode_exec_dir                                                  
safe_mode_gid                                                        
safe_mode_include_dir                                                
sql.safe_mode                                                        
disable_functions                                                    
file_uploads             1                                          
include_path             .:/usr/local/php5/lib/php:/usr/local/lib/php
open_basedir                                                        
allow_url_fopen          1                                          
max_execution_time       30                                          
max_input_time           60                                          
upload_max_filesize      500M                                        
post_max_size            500M                                        
memory_limit             90M                                        
suhosin.post.max_vars                                                
suhosin.request.max_vars                                            


==========================
Page (performance)
------------------
Parameter        Current  Peak    
Memory usage     4.44 MiB 6.41 MiB
Page generation  385 ms   385 ms  
Page query time  22 ms    22 ms  
Page query count 22       22      


==========================
                
« Last Edit: June 03, 2010, 07:50:40 am by François Keller »
Logged

François Keller

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9094
  • aka Frantz
    • Ma galerie
Re: critical error after upgrade
« Reply #1 on: June 03, 2010, 07:51:20 am »

error message is relativ clear, try to repair the table via a tool like phpmyadmin
Logged
Avez vous lu la DOC ? la FAQ ? et cherché sur le forum avant de poster ?
Did you read the DOC ? the FAQ ? and search the board before posting ?
Mon Blog

flyingsparks

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: critical error after upgrade
« Reply #2 on: June 03, 2010, 08:28:11 am »

error message is relativ clear, try to repair the table via a tool like phpmyadmin
i'm unable to repair it in phpmyadmin
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: critical error after upgrade
« Reply #3 on: June 03, 2010, 10:08:33 am »

If you can't repair that table, restore your 1.4.x gallery and perform the upgrade again.
Logged

flyingsparks

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: critical error after upgrade
« Reply #4 on: June 03, 2010, 04:55:05 pm »

thank you to everyone for your help. it appears this was due to a recent upgrade that my webhost completed for MySQL.
Logged
Pages: [1]   Go Up
 

Page created in 0.026 seconds with 19 queries.