critical error when selecting 'User Galleries'

[todd222222]

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
         (
             
• => 2
         )
  
  )
  
  ==========================
  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)

[jared]

I had the same problem - - apparently there is a bug that causes this to happen if you have hidden albums.  The problem went away for me once I deleted or "un-hid" the hidden albums. 

-jared

[wildflowerintn]

I have made sure there are no hidden galleries, still get the following error. I am running coppermine on a pcnuke system, but dont know if this is a coppermine issue or an issue with the pcnuke mod. Can you please help if its a coppermine problem?

While executing query "SELECT user_id, username, user_avatar as avatar, COUNT(DISTINCT a.aid) as alb_count, COUNT(DISTINCT pid) as pic_count, MAX(pid) as thumb_pid FROM cms_users AS u INNER JOIN cms_cpg_albums AS a ON (category = 10000 + user_id  AND visibility > -1)LEFT JOIN cms_cpg_pictures AS p ON (p.aid = a.aid AND approved = 'YES') GROUP BY user_id ORDER BY username" on 0

mySQL error: Column: 'visibility' in on clause is ambiguous

[Joachim Müller]

http://forum.coppermine-gallery.net/index.php?topic=17684.0

[wildflowerintn]

I apologize. The test user account is UN: coppermine  PW: coppermine

I havent changed any files at all. Site can be found at www.travelazine.com

If you need anything else, please let me know.

[Joachim Müller]

you're using a nuke port of coppermine, which goes unsupported. Read http://forum.coppermine-gallery.net/index.php?topic=13667.0

[wildflowerintn]

Yes, I know this. Is this a coppermine error or a nuke error is what I am trying to find out? the visibility thing in the sql is wrong it says, what do i do with the sql query being wrong?

[Nibbler]

No support. Locking thread.

[Joachim Müller]

Even though the thread was locked and wildflowerintn was told that there is no nuke support, he/she started a new thread that just shows he/she's too lazy to read before posting. I wonder why all those nuke users are so stubborn, they seem to think they have a right to be supported ...