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

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

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

Started by goyo, July 09, 2004, 02:50:29 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

goyo

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!

Joachim Müller

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

goyo

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 worked like a charm...

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