February 21st, 2005, 05:30 AM
|
|
Registered User
|
|
Join Date: Feb 2005
Posts: 2
Time spent in forums: 37 m 40 sec
Reputation Power: 0
|
|
|
Mysql error 1064
Hi, hope someone can help me.
I get this error when I try to get user list for a group:
Quote: 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 ' u.user_allow_viewonline, u.user_session_time ug.user_pending
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,, u.user_allow_viewonline, u.user_session_time ug.user_pending FROM phpbb_users u, phpbb_user_group ug WHERE ug.group_id = 7 AND u.user_id = ug.user_id AND ug.user_pending = 0 AND ug.user_id <> 2 ORDER BY u.username
Line : 786
File : /home/mind/public_html/forum/groupcp.php |
What should I do to correct this?
Edit: Please delete this...problem is solved. Sorry for trouble.
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
