ozzyozzyozzy wrote:I dont know if you're aware of this or not but there's a problem with the usergroups. For some reason when I click the usergroups button I get a SQL error. Could be just a problem with my own forum though. Anyone else try the conversion and get this problem?
can you post the error?
The error is as follows
"Error getting user list for group
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 phpbb_users u, phpbb_user_group ug WHERE ug.group_id = 74 AND u.user_id = ug.user_id AND ug.user_pending = 0 AND ug.user_id <> ORDER BY u.username
Line : 786
File : groupcp.php"