coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 (BBS) Integration / Bridging => Topic started by: goyo on July 09, 2004, 02:50:29 PM

Title: mySQL error: Column: 'title' in field list is ambiguous
Post by: goyo on July 09, 2004, 02:50:29 PM
I have the same problem as this user had a while back:

http://forum.coppermine-gallery.net/index.php?topic=1714.msg8119

I have an (non-hacked) Invision Board 1.3 + CPG 1.3 bridged.

Most of the functions are working fine (CPG currently is the best photo script around)
but on some pages I have a similar mysql error messages.
When I click to admin utils (util.php) I have this mysql error in include/functions.inc.php at line 110

While executing query "SELECT aid, category, IF(name IS NOT NULL, CONCAT('(', name, ') ',title), CONCAT(' - ', title)) AS title FROM cpg130_albums AS a LEFT JOIN ibf_members AS u ON category = (10000 + id) ORDER BY category, title" on

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


I see the page but there's no submit buttons...

Any help realy appreciated!
Title: Re: mySQL error: Column: 'title' in field list is ambiguous
Post by: Joachim Müller on July 09, 2004, 11:31:45 PM
get the most recent stable version from webcvs, this has been posted before (please search before posting); or wait for cpg1.3.1 to get released.

GauGau
Title: Re: mySQL error: Column: 'title' in field list is ambiguous
Post by: goyo on July 11, 2004, 11:39:07 AM
Quote from: GauGau on July 09, 2004, 11:31:45 PM
get the most recent stable version from webcvs, this has been posted before (please search before posting); or wait for cpg1.3.1 to get released.

GauGau

Thanks for your help!

It (http://cvs.sourceforge.net/viewcvs.py/*checkout*/coppermine/devel/bridge/invisionboard.inc.php?rev=1.15) worked like a charm...

(Actually I did searched the forums but the only topic I've found is included in my first post).