phpbb2 даване на статус точки проблем

R

ReD_z0n3

Registered
Следвах всичко по урокът http://web-tourist.net/login/login/view.php?st=1351 Създавам тема и като се пробвам да вляза в нея ми излиза това

Код: 
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 '.user_allow_viewonline, u.user_session_time, p.*, pt.post_text, pt.post_subject' 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, u.karma_plus, u.karma_minus, u.karma_time u.user_allow_viewonline, u.user_session_time, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb2posts p, phpbb2users u, phpbb2posts_text pt WHERE p.topic_id = 10 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

Line : 448
File : viewtopic.php
 
На пръв поглед личи ,че си изпуснал една запетая
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.karma_plus, u.karma_minus, u.karma_time,u.user_allow_viewonline, u.user_session_time, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb2posts p, phpbb2users u, phpbb2posts_text pt WHERE p.topic_id = 10 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15
Увеличете...
намери заявката и добави запетайката ,пък да видим нататък.
 
добавих но пак същото
Код: 
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 phpbb2posts p, phpbb2users u, phpbb2posts_text pt WHERE p.topic_id = 4 ' 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, u.karma_plus, u.karma_minus, u.karma_time, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid, FROM phpbb2posts p, phpbb2users u, phpbb2posts_text pt WHERE p.topic_id = 4 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

Line : 401
File : viewtopic.php
А на Line: 401 ми е ето този код
Код: 
 message_die(GENERAL_ERROR, "Could not obtain post/user information.", '', __LINE__, __FILE__, $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.karma_plus, u.karma_minus, u.karma_time, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid, FROM phpbb2posts p, phpbb2users u, phpbb2posts_text pt WHERE p.topic_id = 4 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15
Увеличете...
 
Е щом пак е същото ,няма смисъл да налучквам.

П.П. Има разлика между първата и втората грешка ,която даде. Възможно ли е да не виждаш ралзика и в 3-тата? :idea:
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе