Still having trouble accessing private albums...

[iamcanadian]

I upgraded to 1.2, but the following problems still persist:

When accessing private albums...

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

Also get this error when trying to view users in admin:

There was an error while processing a database query.

In debug mode:

Code Select Expand

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



It's been several weeks now & no one seems to have a solution....

[DJMaze]

check in which tables the "username" field exists:
nuke_users
cpg_usergroups
cpg_albums
cpg_pictures

when it is in cpg_* then delete the field.

if not then change query into

Code Select Expand

"SELECT u.user_id,
        u.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 u.user_id ORDER BY u.username"

[iamcanadian]

THANK YOU SO MUCH!!! I deleted the username field from cpg_pictures and it works great now!