Text only | Text with Images

coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 (BBS) Integration / Bridging => Topic started by: Vadim on December 06, 2004, 01:30:07 PM

Title: DB Query error with Coppermine 1.3.1 and phpBB 2.0.11
Post by: Vadim on December 06, 2004, 01:30:07 PM
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
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?
Title: Re: DB Query error with Coppermine 1.3.1 and phpBB 2.0.11
Post by: Nibbler on December 06, 2004, 07:17:12 PM
Find the query in the bridge file and change aid to a.aid.
Title: Re: DB Query error with Coppermine 1.3.1 and phpBB 2.0.11
Post by: Vadim on December 06, 2004, 07:58:28 PM
Bingo, that worked!
Thanks!
;D
Text only | Text with Images