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
Test user account doesn't work for me.
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 :)
Everything works as expected for me (see http://aunty.vintagehoster.com/gallery/displayimage.php?pos=-11). Issue solved?
yes, its solved..thank you so much