The strangest thing happened after upgrading to 1.4.x. Everything went smooth: upgrade, bridging, changing the default theme, etc. The only one thing that gives me trouble is going to the user galleries (http://.../coppermine/index.php/?cat=1.
Error I get is "There was an error while processing a database query".
In debug I get the following (notice the big blank after MySQL error):
While executing query "SELECT user_id as user_id,username 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 `gunsmoke_phpbb2`.phpbb_users as u on u.user_id+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:
Going straight to a user gallery (eg http://.../coppermine/index.php/?cat=10015) works like it used to do....
What version did you update to?
version 1.4.2
Why?
Update to the latest stable version, 1.4.8. No reason to suffer from bugs fixed months ago.
yeah.... just noticed that I accidently picked the wrong version....
Works now! Still a couple of weird things though. I might post some later in case I can not find it myself or on the forum.
Thanks!