Advanced search  

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]

Pages: [1]   Go Down

Author Topic: mySQL error: Column: 'title' in field list is ambiguous  (Read 3993 times)

0 Members and 1 Guest are viewing this topic.

goyo

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
mySQL error: Column: 'title' in field list is ambiguous
« 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

Code: [Select]
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!
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: mySQL error: Column: 'title' in field list is ambiguous
« Reply #1 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
Logged

goyo

  • Coppermine newbie
  • Offline Offline
  • Posts: 3
Re: mySQL error: Column: 'title' in field list is ambiguous
« Reply #2 on: July 11, 2004, 11:39:07 am »

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).
Logged
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 15 queries.