mimo wykonania porad z topica:
http://phpbb2.pl/forum/viewtopic.php?t=370
Nadal otrzymuje podobny błąd
Kod:
Błąd Ogólny
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 'phpbb_posts p, (phpbb_users u LEFT JOIN phpbb_banlist b ON u.u
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, u.user_plusp, u.user_minusp, u.user_disallowed_write, b.ban_id, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FORM phpbb_posts p, (phpbb_users u LEFT JOIN phpbb_banlist b ON u.user_id=b.ban_userid),phpbb_posts_text pt WHERE p.topic_id = 14 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15
Line : 408
File : viewtopic.php
Mój plik viewtopic.php i okolice 408 lini:
[php]
//
// Go ahead and pull all data for this topic
//
$sql = "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, u.user_plusp, u.user_minusp, u.user_disallowed_write, b.ban_id, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid
FORM " . POSTS_TABLE . " p, (" . USERS_TABLE . " u LEFT JOIN ".BANLIST_TABLE." b ON u.user_id=b.ban_userid)," . POSTS_TEXT_TABLE . " pt
WHERE p.topic_id = $topic_id
$limit_posts_time
AND pt.post_id = p.post_id
AND u.user_id = p.poster_id
ORDER BY p.post_time $post_time_order
LIMIT $start, ".$board_config['posts_per_page'];
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, "Could not obtain post/user information.", '', __LINE__, __FILE__, $sql); // linia 408!
}
[/php]
Co jest do cholery nietak :[
Life is brutal and full of zasadzkas and sometimes kopas w dupas.