Quote:
Error getting user list for group
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax near 'ORDER BY u.username' at line 7
SELECT u.username, u.user_id, u.user_viewemail, u.user_posts, u.user_regdate, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_msnm, ug.user_pending FROM nuke_users u, nuke_bbuser_group ug WHERE ug.group_id = 3 AND u.user_id = ug.user_id AND ug.user_pending = 0 AND ug.user_id <> ORDER BY u.username
Line : 849
File : /home/virtual/site14/fst/var/www/html/modules/Forums/groupcp.php
|
I've just got this exact same error.
I did a clean install of Nuke 6.5 onto an empty site. Then upgraded to 6.8. There are virtually no users and no posts. The only template that I've altered is the header template to change the colour of the text and the background.
I was hoping for an error-free install before I move the site to another domain and set it live. No such luck I guess!!!!
Any ideas how the syntax in groupcp.php might be altered to get this working?
Cheers,
Chris