Databasefeil ved søking

Diskuter MODer til phpBB 3.x her.
Svar
Brukeravatar
pippin
PhpBB-frelst
PhpBB-frelst
Innlegg: 383
Registrert: 9. mai 2006, 19:41

Databasefeil ved søking

Legg inn av pippin » 29. jan 2010, 15:26

Ikke alltid den kommer men noen ganger

Kode: Velg alt

General Error
SQL ERROR [ mysqli ]

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 'LEFT JOIN phpbb_topics t ON (p.topic_id = t.topic_id) LEFT JOIN phpbb_forum' at line 2 [1064]

SQL

SELECT p.*, f.forum_id, f.forum_name, f.forum_solve_text, f.forum_solve_color, t.*, u.username, u.username_clean, u.user_sig, u.user_sig_bbcode_uid, u.user_colour LEFT JOIN phpbb_topics t ON (p.topic_id = t.topic_id) LEFT JOIN phpbb_forums f ON (p.forum_id = f.forum_id) LEFT JOIN phpbb_users u ON (p.poster_id = u.user_id) WHERE p.post_id IN ('28657', '28653', '28611', '28463', '28066', '28065', '28062', '28061', '28001', '27974') ORDER BY p.post_time DESC

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: search.php
LINE: 716
CALL: dbal_mysqli->sql_query()

Svar