News:

CPG Release 1.6.29
During HTML5 upload, keep pseudo blank code 200 messages from triggering error condition
added Russian language
correct failure to use theme menu icons in album manager
minor vulnerabilities mitigation

Main Menu

Database Confusion

Started by samin, November 18, 2003, 09:13:15 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

samin

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.