Error I am receiving when I try to access user albums...

[iamcanadian]

There was an error while processing a database query.


In debug mode ::

Code Select Expand

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....

[gtroll]

Did you install For phpnuke 6.5 version in 6.0 or less.... if not try this in index.php line 252 replace:

Code Select Expand

ORDER BY username


Code Select Expand

ORDER BY a.username

[edited to the correct value sorry]

[iamcanadian]

Just installed CPG 1.2 for nuke (I'm using nuke 6.7) & same error.....

[gtroll]

Canuck(iamcanadian)-did the fix I suggest work?

[iamcanadian]

Unfortunately no...

[gtroll]

a.username didn't work? what error message?

[iamcanadian]

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 ::

Code Select Expand

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

[iamcanadian]

Anyone?? My site is live....

Thanks

[iamcanadian]

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?

[SoulThief]

I have similar problem.

In /include/init.inc.php there is a line that says:

$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

[iamcanadian]

Are you using the standard nuke prefix or another?

I am using the standard prefix... nuke_users