I have Coppermine setup to work with vbulletin 3.0.0.
When I login with the admin account it works fine.
When I login with a non admin account I get the Critical Error.
I'll post all the details of the error below.
Can someone help me. If I'm breaking any rules please let me know, I'm correct my ways.
Thanks,
Todd
While executing query "SELECT count(*) FROM cpg130_albums as a WHERE category = '1' and AND a.aid NOT IN (3) " on 0
mySQL error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND a.aid NOT IN (3)' at line 1
File: /home/u4/todd222222/lewisvillemoms.com/html/pictures/include/functions.inc.php - Line: 110
Notice: Undefined index: offline in /home/u4/todd222222/lewisvillemoms.com/html/pictures/include/init.inc.php on line 380
USER:
------------------
Array
(
[ID] => f6dcf70c0523d7e604af636b1004a0ec
[am] => 1
[liv] => Array
(
- => 2
[1] => 1
)
)
==========================
USER DATA:
------------------
Array
(
- => 24
[user_id] => 24
[1] => test3
[user_name] => test3
[2] => 2
[mgroup] => 2
[3] => 2
[group_id] => 2
[4] => Registered Users
[group_name] => Registered Users
[5] => 0
[group_quota] => 0
[6] => 0
[has_admin_access] =>
[7] => 1
[can_rate_pictures] => 1
[8] => 1
[can_send_ecards] => 1
[9] => 1
[can_post_comments] => 1
[10] => 1
[can_upload_pictures] => 1
[11] => 1
[can_create_albums] => 1
[12] => 0
[pub_upl_need_approval] => 0
[13] => 0
[priv_upl_need_approval] => 0
[14] => 3
[upload_form_config] => 3
[15] => 0
[custom_user_upload] => 0
[16] => 5
[num_file_upload] => 5
[17] => 3
[num_URI_upload] => 3
[can_see_all_albums] =>
[groups] => Array
(
)
)
==========================
Queries:
------------------
Array
(
- => SELECT extension, mime, content FROM cpg130_filetypes;
[1] => SELECT sessionhash,userid,host,useragent,styleid FROM `todd222222`.vb3session WHERE sessionhash='d3d23929b136a1fb6a2cc638b4706944' AND host='4.7.46.93' AND idhash='5f100c402674095ee00445233d0653fa'
[2] => SELECT userid as user_id, username as user_name, usergroupid as mgroup FROM `todd222222`.vb3user WHERE userid='24'
[3] => SELECT * FROM cpg130_usergroups WHERE group_id = '2'
[4] => DELETE FROM cpg130_banned WHERE expiry < 1087525154
[5] => SELECT * FROM cpg130_banned WHERE ip_addr='4.7.46.93' OR ip_addr='4.7.46.93' OR user_id=24
[6] => SELECT aid FROM cpg130_albums WHERE visibility != '0' AND visibility !='10024' AND visibility NOT IN (2)
[7] => SELECT name, parent FROM cpg130_categories WHERE cid = '1'
[8] => SELECT cid, name, description, thumb FROM cpg130_categories WHERE parent = '1' ORDER BY pos
[9] => SELECT aid FROM cpg130_albums as a WHERE category >= 10000 and a.aid NOT IN (3)
[10] => SELECT (category - 10000) as user_id, '???' as user_name, COUNT(DISTINCT a.aid) as alb_count, COUNT(DISTINCT pid) as pic_count, MAX(pid) as thumb_pid FROM cpg130_albums AS a INNER JOIN cpg130_pictures AS p ON p.aid = a.aid WHERE approved = 'YES' AND category > 10000 AND p.aid NOT IN (3) GROUP BY category ORDER BY category
[11] => SELECT userid as user_id, username as user_name FROM `todd222222`.vb3user WHERE userid IN (23)
[12] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg130_pictures WHERE pid='2'
[13] => SELECT count(*) FROM cpg130_albums as a WHERE category = '1' and AND a.aid NOT IN (3)
)
==========================
GET :
------------------
Array
(
[cat] => 1
)
==========================
POST :
------------------
Array
(
)
==========================
Page generated in 0.042 seconds - 14 queries in 0.02 seconds - Album set : AND aid NOT IN (3) AND aid IN (2)
Author
Topic: critical error when selecting 'User Galleries' (Read 4816 times)