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:
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
==========================