viewtopic, SQL Error : 1064, przeniesienie forum

[piwko28]

Przenioslem forum na inny serwer, niestety pojawia mi sie taki blad przy podgladzie tematu:

Kod: Zaznacz cały

Could not obtain post/user information.

DEBUG MODE

SQL Error : 1064 Something is wrong in your syntax obok '(phpbb_users u LEFT JOIN phpbb_banlist b ON u.user_id=b.ban_user' w linii 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, u.user_ipreg, u.user_plusp, u.user_minusp, u.user_disallowed_write, b.ban_id, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM 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 = 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 : 398
File : viewtopic.php

Co mam zrobic? Plz, pomozcie.

[Balcar88]

Skasuj z tego kawalka

Kod: Zaznacz cały

(phpbb_users u LEFT JOIN phpbb_banlist b ON u.user_id=b.ban_userid)

Nie wiem po co on tam :]

[piwko28]

Po skasowaniu tego fragmentu pojawia się błąd:

Kod: Zaznacz cały

Could not obtain post/user information.

DEBUG MODE

SQL Error : 1109 Unknown table 'u' in field list

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_ipreg, u.user_plusp, u.user_minusp, u.user_disallowed_write, b.ban_id, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb_posts p, phpbb_posts_text pt WHERE p.topic_id = 18 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

Line : 398
File : viewtopic.php

Skasowany fragment to:

Kod: Zaznacz cały

(" . USERS_TABLE . " u LEFT JOIN ".BANLIST_TABLE." b ON u.user_id=b.ban_userid), 

// dopisano:
Juz mam. Dziekuje wszystkim, ktorzy probowali mi pomoc. Wystarczylo usunac nawiasy ze skladni LEFT JOIN (co dziwne, na poprzednim serwerze dzialalo z nawiasami). Pozdrawiam!