Codezwiz >> Forums >> General PHP Nuke Help >> Problem with phpnuke 7.9

Okay have this problem (at least I think its one) this is a fresh install of phpnuke 7.9 I havent touched a thing when I click on user groups its fine, when I click on user information(moderators are already there, I get this

Error getting user list for group

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use 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 : 797
File : groupcp.php

I plan on upgrading the forum, I have reintstalled a fresh copy of this nuke and get this message everytime, it also remains when I have upgraded the forums. And I got this phpnuke from phpnuke.org.. anyone know of a solution? do I need to fix it?

Telli is currently out of town but am sure he will get to your post soon as he returns. Thanks for your patience

ok thank you for letting me know. I have installed a patched 7.9 and still get the same error, I'm guessing there is an issue with the groupcp.php file.. But I am good at breaking site's when I mess with stuff I don't know anything about..

Your missing some of the query:

AND ug.user_id <>

Ok, thank you very much