error while processing a database query error while processing a database query
 

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

Main Menu

error while processing a database query

Started by MastiMasti, September 14, 2007, 02:02:37 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

MastiMasti

Dear Members and DEV team

I am having a problem
I am getting error

Critical error There was an error while processing a database query

it were working fine today until 11 AM than I went back to site about 4 PM
I were getting error

than I can over here and search for help

I read from one post which says
Quoteenable debug mode
[/b]
I went to PHPMYADMIn and did switch CONFIG debug mode from 0 to 1

so here is now ERROR
While executing query "SELECT count(*) FROM cpg1410_pictures as p, cpg1410_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 and a.aid NOT IN (93) " on 0

mySQL error:



Debug Info
USER:
------------------
Array
(
    [ID] => fb269c2d37ca843cdc4cfc2b08459e7c
    [am] => 1
    [lang] => english
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 0
    [user_name] => Guest
    [groups] => Array
        (
            [0] => 3
        )

    [group_quota] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [can_post_comments] => 1
    [can_upload_pictures] => 1
    [can_create_albums] => 0
    [pub_upl_need_approval] => 1
    [priv_upl_need_approval] => 1
    [upload_form_config] => 3
    [num_file_upload] => 5
    [num_URI_upload] => 3
    [custom_user_upload] => 0
    [disk_max] => 0
    [disk_min] => 0
    [ufc_max] => 3
    [ufc_min] => 3
    [has_admin_access] => 0
    [group_name] => Guests
    [can_see_all_albums] => 0
    [group_id] => 3
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg1410_filetypes; (0.002s)
    [1] => select * from cpg1410_plugins order by priority asc; (0s)
    [2] => SELECT * FROM cpg1410_bridge (0.001s)
    [3] => SELECT u.user_id AS id, u.username AS username, u.user_password AS password, ug.group_id AS group_id FROM `wafakad_bfforum`.phpbb2users AS u, `wafakad_bfforum`.phpbb2user_group AS ug WHERE u.user_id=ug.user_id AND u.user_id='4' (0.31s)
    [4] => 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 cpg1410_usergroups WHERE group_id in (3) (0.002s)
    [5] => SELECT group_name FROM  cpg1410_usergroups WHERE group_id= 3 (0.004s)
    [6] => DELETE FROM cpg1410_banned WHERE expiry < '2007-09-13 23:53:54' (0.013s)
    [7] => SELECT * FROM cpg1410_banned WHERE (ip_addr='71.191.158.215' OR ip_addr='71.191.158.215' OR user_id=0) AND brute_force=0 (0.001s)
    [8] => SELECT aid FROM cpg1410_albums WHERE visibility != '0' AND visibility !='10000' AND visibility NOT IN (3) (0s)
    [9] => SELECT aid FROM cpg1410_albums (0s)
    [10] => SELECT cid, name, description, thumb FROM cpg1410_categories WHERE parent = ''  ORDER BY pos (0.009s)
    [11] => SELECT aid FROM cpg1410_albums as a WHERE category>=10000 and a.aid NOT IN (93)  (0.002s)
    [12] => SELECT count(*) FROM cpg1410_pictures as p, cpg1410_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 and a.aid NOT IN (93)  (0.002s)
)

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

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

==========================
Page generated in 0.477 seconds - 13 queries in 0.346 seconds - Album set : AND aid NOT IN (93) ; Meta set: AND aid IN (1,2,3,4,7,8,9,10,11,12,13,14,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,69,70,71,72,73,74,76,77,78,79,80,81,82,83,84,85,86,91,94,96,97,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,120,121) ;




I will be happy if someone help me to show way how I can fix it :) thanks

MastiMasti

I am pretty sorry I haven't give a link of site
here is site link

www.bollywoodfunda.com