There was an error while processing a database query.
In debug mode ::
While executing query "SELECT user_id,
username,
COUNT(DISTINCT a.aid) as alb_count,
COUNT(DISTINCT pid) as pic_count,
MAX(pid) as thumb_pid
FROM nuke_users AS u
INNER JOIN cpg_usergroups AS g ON user_group_cp = group_id
INNER JOIN cpg_albums AS a ON category = 10000 + user_id
INNER JOIN cpg_pictures AS p ON p.aid = a.aid
WHERE approved = 'YES' GROUP BY user_id ORDER BY username "
mySQL error: Column: 'username' in field list is ambiguous
Can somone help with this....
Did you install For phpnuke 6.5 version in 6.0 or less.... if not try this in index.php line 252 replace:
ORDER BY username
ORDER BY a.username
[edited to the correct value sorry]
Just installed CPG 1.2 for nuke (I'm using nuke 6.7) & same error.....
Canuck(iamcanadian)-did the fix I suggest work?
Unfortunately no...
a.username didn't work? what error message?
No it didn't work for the error (posted above) when I try to view the user galleries. I also get this error when trying to view Users in admin ::
Critical error
There was an error while processing a database query.
While executing query "SELECT user_id, username, user_email, UNIX_TIMESTAMP(user_regdate) as user_regdate_cp, group_name, user_active_cp, COUNT(pid) as pic_count, ROUND(SUM(total_filesize)/1024) as disk_usage, group_quota FROM nuke_users AS u INNER JOIN cpg_usergroups AS g ON user_group_cp = group_id LEFT JOIN cpg_albums AS a ON category = 10000 + user_id LEFT JOIN cpg_pictures AS p ON p.aid = a.aid GROUP BY user_id ORDER BY user_regdate_cp DESC LIMIT 0, 25" on 0
mySQL error: Column: 'username' in field list is ambiguous
Anyone?? My site is live....
Thanks
I have a 'username' field in table cpg_users and a 'username' field in table nuke_users. Obviously the program doesn't know which to use! Can someone please help me???? I don't understand how I can be the only one to have this problem when I installed the same files as everyone else????
I have similar problem.
In /include/init.inc.php there is a line that says:
Quote$CONFIG['TABLE_USERS'] = "nuke_users";
In my own case I was not using the edfault nuke_users, I was using a different prefix (hence war_users). Are you using the standard nuke prefix or another?
ST
Quote from: "SoulThief"Are you using the standard nuke prefix or another?
I am using the standard prefix... nuke_users