Need assistance with a SPL server problem

dpogary

New Member
Messages
134
Reaction score
0
Points
0
Could not obtain post/user information.

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 'FROM nuke_bbposts p, nuke_users u, nuke_bbposts_text pt WHERE p.topic_id' at line 2

SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid, FROM nuke_bbposts p, nuke_users u, nuke_bbposts_text pt WHERE p.topic_id = '1' AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

I keep recieving this error whenever i try to view a post on my forum...its brand new so this is the first post. i can see it in the SQL server. but it wont show up. any one got some help?
 

Richard

Active Member
Messages
2,028
Reaction score
0
Points
36
Code:
pt.post_subject, pt.bbcode_uid[COLOR="Red"],[/COLOR] FROM nuke_bbposts p, nuke_users u
the comma before "FROM" needs to go. That should sort the problem out.
 
Top