Database Confusion Database Confusion
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

Database Confusion

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

Previous topic - Next topic

0 Members and 2 Guests 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.