[chris5000]

All of a sudden I am getting the following error. I did upgrade to 9.1.2.1. and I do have MySql 5 and PHP 5 which probably have something to do with it. Any ideas? TIA!

On /index.php?name=coppermine&file=upload
While executing query "SELECT aid, CONCAT('(', username, ') ', title) AS title FROM cms_cpg_albums AS a INNER JOIN cms_users AS u ON user_id = (category - 10000) ORDER BY title"

the following error occured: Column 'title' in field list is ambiguous

In: /home/xxxxxxx/public_html/xxxxxxxx/includes/coppermine/functions.inc on line: 355

[Phoenix]

That usually occurs if you have two tables with an identical column name, but 'title' is unique to cms_cpg_albums in this instance.

Would you be running MySQL STRICT by any chance?

That particular query is unchanged, even in current cvs.

Try modifying includes/coppermine/functions.inc lines 347 to 350 to

Code:

	if (GALLERY_ADMIN_MODE){
		$sql = "SELECT aid, CONCAT('(', username, ') ', a.title) AS title FROM {$CONFIG['TABLE_ALBUMS']} AS a "
			."INNER JOIN {$CONFIG['TABLE_USERS']} AS u ON user_id = (category - " . FIRST_USER_CAT . ') '
			.'ORDER BY title';

Note the , title) => , a.title) in the second line.

[chris5000]

Your solution saved the day, Phoenix! Thank you very much. I appreciate the expertise! Worked like a charm!