Just installed 2.0.2 and got an error when viewing a topic.
SQL Error : 1064 You have an error in your SQL syntax near ' u.user_allow_viewonline, u.user_session_time, u.user_gender, p.*, pt.post_text' at line 1
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, user_crystal, , u.user_allow_viewonline, u.user_session_time, u.user_gender, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM gbabb_posts p, gbabb_users u, gbabb_posts_text pt WHERE p.topic_id = 234 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15
Line : 414
File : /home/melon/phpBB/viewtopic.php
I've to replace the backup file for viewtopic.php. Other than that,
everything works fine. Any idea what went wrong?
---Edit---
It works now. I put the $cash_field after u.user_allowsmile
with a
coma since it is not the end of the line. Removing the coma fixed the problem.
