help with critical error please

[pi6l3t]

hi, I successfully dl coppermine and integraded it with my website and thought everything was working great till i tried to use it as a 'user' so I could post a users guide for my members.

pictures uploaded fine but when I try and and open the user gallery i get this critical error

There was an error while processing a database query.

heres the complete error

While executing query "SELECT ID_MEMBER as user_id,memberName as user_name,COUNT(DISTINCT a.aid) as alb_count,COUNT(DISTINCT pid) as pic_count,MAX(pid) as thumb_pid, MAX(galleryicon) as gallery_pid FROM cpg_albums AS a INNER JOIN `aunty_smf1`.smf_members as u on u.ID_MEMBER+10000=a.category LEFT JOIN cpg_pictures AS p ON p.aid = a.aid WHERE ((isnull(approved) or approved='YES') AND category > 10000)  GROUP BY category ORDER BY category LIMIT 0, 12 " on 0

mySQL error:

File: /home/users/aunty/public_html/gallery/include/functions.inc.php - Line: 248

I'd appreciate some help figuring out what it means so i can fix it

thank you

heres a link to my site;
http://aunty.vintagehoster.com/gallery/index.php

user/pw test/test

[Joachim Müller]

Test user account doesn't work for me.

[pi6l3t]

sorry...after i posted i was reading another thread and realized i didnt have cpg146, i was using 142 so I was in the process of uploading the new version when you tried logging in...anywho, now that i have cpg146 installed its working fine (knock on wood)

thanks for being so quick to respond though, i appreciate it 

[Joachim Müller]

Everything works as expected for me (see http://aunty.vintagehoster.com/gallery/displayimage.php?pos=-11). Issue solved?

[pi6l3t]

yes, its solved..thank you so much