critical error after upgrade

[flyingsparks]

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 Expand

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      


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

[François Keller]

error message is relativ clear, try to repair the table via a tool like phpmyadmin

[flyingsparks]

error message is relativ clear, try to repair the table via a tool like phpmyadmin

i'm unable to repair it in phpmyadmin

[Αndré]

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

[flyingsparks]

thank you to everyone for your help. it appears this was due to a recent upgrade that my webhost completed for MySQL.