DB Query error with Coppermine 1.3.1 and phpBB 2.0.11

[Vadim]

I've integrated coppermine 1.3.1 and php 2.0.11, everything was fine, but when I wanted to Batch add pictures clicking to the folder name I've got a following error

Code Select Expand

While executing query "SELECT aid, CONCAT('(', username, ') ', title) AS title FROM cpg11d_albums AS a INNER JOIN `karjamaa`.phpbb_users AS u ON category = (10000 + user_id) ORDER BY title" on 0

mySQL error: Column: 'aid' in field list is ambiguous

in include/functions.inc.php

I have tried to replace a functions file with the one from 1.3.2 but got the same result.
When I deintegrated, everything went fine again.

Any suggests?

[Nibbler]

Find the query in the bridge file and change aid to a.aid.

[Vadim]

Bingo, that worked!
Thanks!