SQL Error : 1064

[ema2412]

wenn ein Beitrag/Thema erstellt funktioniert zwar die erstellung bevor man aber zur themenansicht kommt kommt dieser fehler.

Could not obtain topic 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 'BY p.post_id ASC' at line 5

SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments, f.auth_download, t.topic_attachment, f.min_posts_to_view, f.max_posts_to_view, COUNT(p2.post_id) AS prev_posts FROM phpbb_topics t, phpbb_forums f, phpbb_posts p, phpbb_posts p2 WHERE p.post_id = 97828 AND t.topic_id = p.topic_id AND p2.topic_id = p.topic_id AND p2.post_id <= 97828 AND f.forum_id = t.forum_id GROUP BY p.post_id, t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments, f.auth_download, t.topic_attachment , f.min_posts_to_view, f.max_posts_to_viewORDER BY p.post_id ASC

Line : 159
File : viewtopic.php

hab mir die viewtopic schon angeschaut find aber nichts, kann mir bitte wer helfen??

[Jan500]

verlink mal die datei
KB:datei

aber

f.max_posts_to_viewORDER BY p.post_id ASC

sollte wohl

f.max_posts_to_view ORDER BY p.post_id ASC

sein

Jan

[ema2412]

hallo, hier die datei:


www.angelforum.at/viewtopic1.txt

[Dr.Death]

Wie Jan schon sagte, da fehlt ein Leerzeichen.

SUCHE:

Code: Alles auswählen

$order_sql = (!$post_id) ? '' : "GROUP BY p.post_id, t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments , f.min_posts_to_view, f.max_posts_to_viewORDER BY p.post_id ASC";

ERSETZE MIT:

Code: Alles auswählen

$order_sql = (!$post_id) ? '' : "GROUP BY p.post_id, t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments , f.min_posts_to_view, f.max_posts_to_view ORDER BY p.post_id ASC";