user galleries link not working after upgrade....

[willemt]

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):

Code Select Expand

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....

[Nibbler]

What version did you update to?

[willemt]

version 1.4.2

[Nibbler]

Why?

Update to the latest stable version, 1.4.8. No reason to suffer from bugs fixed months ago.

[willemt]

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!