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: Database Confusion  (Read 3083 times)

0 Members and 1 Guest are viewing this topic.

samin

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Database Confusion
« on: November 18, 2003, 09:13:15 pm »

Hello everyone,
I got the latest release and most of my problems are solved.
However, now I have a new one.

Trying to integrate the users table with my existing database, and almost everything is working fine.

The problem I am now having is this:
I have a filed named "title" in my existing users table, so when I try to use the batch processing to add images, it gives me this error:


While executing query "SELECT aid, CONCAT('(', user_name, ') ', title) AS title FROM galalbums AS a INNER JOIN galusers AS u ON category = (10000 + user_id) ORDER BY title" on 0

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


I don't want to spend days modifying my existing program to change the name of the filed so they don't confuse each other.
Is there a way around this?

And will this problem hunt me some other place as well (If you know of any)?

Thanks so much.
Logged
Pages: [1]   Go Up
 

Page created in 0.014 seconds with 18 queries.