coppermine-gallery.com/forum

Hi we have problem with cpg at our site:
http://www.ladislavspilka-fanclub.eu/fotogalerie/

Kritická chyba
Vyskytla se chyba pi databázovém dotazu.

Translate:
Critical error
An error occured during database query


How do we fix it?

Please search the board before posting. Every post like yours gets the same reply.

Enable debug mode (http://coppermine-gallery.net/tutorial/debug_mode.php) and post the mysql error message (not the entire debug output) you get.

While executing query "SELECT count(*) FROM fotog_pictures as p, fotog_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000" on 0

mySQL error: Table './ladislavspilka-fanclub_eu/fotog_pictures' is marked as crashed and should be repaired


Debug info
USER:
------------------
Array
(
    [ID] => 11a1d230e0db2010503aa666ea98f044
    [am] => 1
    [lang] => czech
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 3
    [user_name] => Admin
    [groups] => Array
        (
           

• => 2
          )
  
      [disk_max] => 10024
      [disk_min] => 10024
      [can_rate_pictures] => 1
      [can_send_ecards] => 1
      [ufc_max] => 3
      [ufc_min] => 3
      [custom_user_upload] => 0
      [num_file_upload] => 10
      [num_URI_upload] => 3
      [can_post_comments] => 1
      [can_upload_pictures] => 1
      [can_create_albums] => 0
      [has_admin_access] => 0
      [pub_upl_need_approval] => 1
      [priv_upl_need_approval] => 0
      [group_name] => Registered
      [upload_form_config] => 3
      [group_quota] => 10024
      [can_see_all_albums] => 0
      [group_id] => 2
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content, player FROM fotog_filetypes; (0s)
      [1] => select * from fotog_plugins order by priority asc; (0.001s)
      [2] => delete from `ladislavspilka-fanclub_eu`.fotog_sessions where time<1247225092 and remember=0; (0.001s)
      [3] => delete from `ladislavspilka-fanclub_eu`.fotog_sessions where time<1246019092; (0s)
      [4] => select user_id from `ladislavspilka-fanclub_eu`.fotog_sessions where session_id = '17bc0385550304ce56b2ce20dcec5d60' (0s)
      [5] => select user_id as id, user_password as password from `ladislavspilka-fanclub_eu`.fotog_users where user_id=3 (0s)
      [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `ladislavspilka-fanclub_eu`.fotog_users AS u INNER JOIN `ladislavspilka-fanclub_eu`.fotog_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='3' (0s)
      [7] => SELECT user_group_list FROM `ladislavspilka-fanclub_eu`.fotog_users AS u WHERE user_id='3' and user_group_list <> ''; (0.001s)
      [8] => 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 fotog_usergroups WHERE group_id in (2) (0s)
      [9] => SELECT group_name FROM  fotog_usergroups WHERE group_id= 2 (0s)
      [10] => update `ladislavspilka-fanclub_eu`.fotog_sessions set time='1247228692' where session_id = '17bc0385550304ce56b2ce20dcec5d60' (0s)
      [11] => SELECT description from fotog_albums WHERE aid='' (0s)
      [12] => SELECT user_favpics FROM fotog_favpics WHERE user_id = 3 (0.001s)
      [13] => DELETE FROM fotog_banned WHERE expiry < '2009-07-10 12:24:52' (0.001s)
      [14] => SELECT * FROM fotog_banned WHERE (ip_addr='85.71.229.240' OR ip_addr='85.71.229.240' OR user_id=3) AND brute_force=0 (0s)
      [15] => SELECT aid FROM fotog_albums WHERE visibility != '0' AND visibility !='10003' AND visibility NOT IN (2) (0s)
      [16] => SELECT aid FROM fotog_albums (0s)
      [17] => SELECT cid, name, description, thumb FROM fotog_categories WHERE parent = ''  ORDER BY pos (0.001s)
      [18] => SELECT aid FROM fotog_albums as a WHERE category>=10000 (0s)
      [19] => SELECT count(*) FROM fotog_pictures as p, fotog_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0.001s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  Page generated in 0.164 seconds - 20 queries in 0.007 seconds - Album set : ; Meta set: AND aid IN (1,2,3,4,5,8,9,10,11,12,13,16) ;

The table is crashed. Repair it.

http://forum.coppermine-gallery.net/index.php/topic,10409.0.html

Thanks a lot.