forum.coppermine-gallery.net
Support => Older/other versions => cpg1.1.X Support (standalone) => Topic started by: schlicht on January 21, 2004, 04:00:14 pm
-
Hi there,
I'am running copermine 1.1 together with phpbb 2.0.6.
Everything works fine...
Users can create their own albums, upload pictures, but it is not possible to view pictures by clicking "user galleries". Pictures are visible in "last additions" and "random pictures".
Error Message:
"There was an error while processing a database query"
It seems that I have the same problem if I would do that here http://coppermine.sourceforge.net/demo/ .
Detailed Errormessage:
While executing query "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 cpg11d_albums AS a INNER JOIN cpg11d_pictures AS p ON p.aid = a.aid WHERE approved = 'YES' AND category > 10000 AND GROUP BY category ORDER BY category " 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 'GROUP BY category ORDER BY category' at line 1
Site: http://www.cameleonline.ch/gallery
Do you have any idea, what this could be?
Regards,
Michel