Quote:

error getting total topics.

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 'AND (p.post_time + 86400 + 3600) > 1235952000 AND (p.post_time + 3600) < 1235952' at line 3

SELECT count(DISTINCT(t.topic_id)) AS total_topics FROM phpbb_topics t, phpbb_posts p WHERE t.forum_id NOT IN (11,12,19,20,23,31,38) AND AND (p.post_time + 86400 + 3600) > 1235952000 AND (p.post_time + 3600) < 1235952000 AND p.post_id = t.topic_last_post_id

Line : 438
File : recent.php

Quote:

error getting total topics.

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 'AND (p.post_time + 3600) > 1235952000 AND p.post_id = t.topic_last_post_id' at line 3

SELECT count(DISTINCT(t.topic_id)) AS total_topics FROM phpbb_topics t, phpbb_posts p WHERE t.forum_id NOT IN (11,12,19,20,23,31,38) AND AND (p.post_time + 3600) > 1235952000 AND p.post_id = t.topic_last_post_id

Line : 438
File : recent.php