phpBB • Free and Open Source Forum Software

I suspect this has already been submitted and fixed in the CVS, but during my brief search I could find it (might I suggest a Search function for this to avoid so many duplicate submissions)

Anyway, clicking on any of the search links on the homepage a "General Error" comes up.

For "View unanswered posts", "View active topics", and "View new posts" the following error comes up:

SQL ERROR [ mysql4 ]

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 ')) ORDER BY t.topic_last_post_time DESC LIMIT 1001' [1064]

SQL

SELECT DISTINCT t.topic_last_post_time, t.topic_id FROM phpbb_posts p, phpbb_topics t WHERE p.post_time > 1153670815 AND t.topic_approved = 1 AND p.topic_id = t.topic_id AND (p.post_approved = 1 OR p.forum_id NOT IN ()) ORDER BY t.topic_last_post_time DESC LIMIT 1001

BACKTRACE


FILE: includes/db/mysql4.php
LINE: 106
CALL: dbal_mysql4->sql_error()

FILE: includes/db/mysql4.php
LINE: 155
CALL: dbal_mysql4->sql_query()

FILE: search.php
LINE: 378
CALL: dbal_mysql4->sql_query_limit()


And for "View your posts" the following comes up:

SQL ERROR [ mysql4 ]

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 ')) ORDER BY t.topic_last_post_time DESC' at line 6 [1064]

SQL

SELECT t.*, f.forum_id, f.forum_name, tp.topic_posted FROM phpbb_topics t LEFT JOIN phpbb_forums f ON (f.forum_id = t.forum_id) LEFT JOIN phpbb_topics_posted tp ON (tp.user_id = 2 AND t.topic_id = tp.topic_id) WHERE t.topic_id IN (15, 18, 14, 10, 3, 16, 13, 12, 5, 4, 2, 8, 7, 6, 1) AND (t.topic_approved = 1 OR t.forum_id NOT IN ()) ORDER BY t.topic_last_post_time DESC

BACKTRACE


FILE: includes/db/mysql4.php
LINE: 106
CALL: dbal_mysql4->sql_error()

FILE: search.php
LINE: 547
CALL: dbal_mysql4->sql_query()



Again, I suspect this has already been deleted but here it is anyway.