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: Critial error - An error occurred on a query to database  (Read 4092 times)

0 Members and 1 Guest are viewing this topic.

LukeK

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Critial error - An error occurred on a query to database
« on: July 10, 2009, 02:15:58 pm »

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?
Logged

Nibbler

  • Guest
Re: Critial error - An error occurred on a query to database
« Reply #1 on: July 10, 2009, 02:18:04 pm »

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.
Logged

LukeK

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Critial error - An error occurred on a query to database
« Reply #2 on: July 10, 2009, 02:27:07 pm »

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) ;
Logged

Nibbler

  • Guest
Logged

LukeK

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Critial error - An error occurred on a query to database
« Reply #4 on: July 10, 2009, 03:12:53 pm »

Thanks a lot.
Logged
Pages: [1]   Go Up
 

Page created in 0.028 seconds with 20 queries.