#1 viewtopic.php Error with MySQL 5+

[Aaru Bui]

With MySQL 5+, viewtopic.php will return an error. This
fix will fix the error but would remove the tracker
stats of the users from being displayed next to their post.

Could not obtain post/user information.

DEBUG MODE

SQL Error : 1054 Unknown column 'p.poster_id' in 'on
clause'

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_real_name, u.user_company, u.user_designation,
u.user_country, u.user_company_address,
u.user_company_logo, 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, u.user_warnings, u.user_level,
u.user_birthday, u.user_next_birthday_greeting, p.*,
pt.post_text, pt.post_subject, pt.bbcode_uid,
bt.u_up_total, bt.u_down_total, u.reputation,
u.warnings, u.user_level FROM phpbb_posts p,
phpbb_users u, phpbb_posts_text pt LEFT JOIN
phpbb_bt_users bt ON p.poster_id = bt.user_id WHERE
p.topic_id = 39 AND pt.post_id = p.post_id AND
u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT
0, 15

Line : 402
File : viewtopic.php

[Aaru Bui]

viewtopic.php Error with MySQL 5+ Fix

[Sergey Gurov]

Logged In: YES
user_id=1854138
Originator: NO

#
#-----[ OPEN ]---------------------------------------------
#
viewtopic.php

#
#-----[ FIND ]---------------------------------------------
#
FROM " . POSTS_TABLE . " p, " . USERS_TABLE . " u, " . POSTS_TEXT_TABLE . " pt

#
#-----[ REPLACE WITH ]---------------------------------------------
#
FROM " . USERS_TABLE . " u, " . POSTS_TEXT_TABLE . " pt," . POSTS_TABLE . " p

#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM