cpg 1.4.2 and phpbb 2.0.20 - MySQL problem

[dr.Kadzija]

Hi all,

I have the following issue when trying to bridge coppermine and phpBB:

I can log in without any problems, but receive a "There was an error while processing a database query." error when I click "User galleries". Here are the details:

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 `kadzija_phpb2`.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:

One note: the default language of the forum is Croatian, but I've set English as the language for user "test", so everything should be clear once you log in. I hope this is not a problem. The Coppermine default language is English.


Coppermine install: http://www.13gimnazija.com/fotke/
Forum install: http://www.13gimnazija.com/forum/
Coppermine version: cpg1.4.2
Forum version: phpBB v2.0.20
Test user account: test / test

BridgeManager settings:
Forum URL:  http://www.13gimnazija.com/forum
Relative path to your BBS's config file:  ../forum/ 
Use post-based groups?:  0

[Joachim Müller]

Don't use the outdated version cpg1.4.2, but the most recent one (currently cpg1.4.. There's a reason why we release new versions: bugs (that existed in previous versions) get fixed. You might be affected by one of them. Download the package (download link at the top of this page), then read the upgrade section of the documentation (link again at top of this page) and do as suggested there.

[dr.Kadzija]

Thanks. I'm using 1.4.2 because it's available in Fantastico on the server which is hosting my site. I'll try to get the administrator to offer 1.4.8 through Fantastico, and if that isn't possible, i'll upgrade it myself.
Either way, I'll let you know how that worked out.

Thanks again for the quick reply.

[Joachim Müller]

Fantastico doesn't come with cpg1.4.8 - they only have the outdated version, so asking your server admin doesn't make sense. Fantastico sucks anyway. Do as suggested and upgrade as I said. Never use Fantastico again. It's crap.

[dr.Kadzija]

Point taken. I'm new to both Fantastico and CPG, and obviously have a lot to learn. Thanks for the tip, I will upgrade "manually".