Changed ticket status from "New" to "Fix in progress"
Action performed by Kellanved (Former Team Member) on Nov 5th 2007, 23:53
-----------------
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 \'AND topic_moved_id = 0\n AND topic_last_post_time < \n AND topic_approved = \' at line 4 [1064]
SQL
SELECT topic_id, forum_id\n FROM phpbb_topics\n WHERE forum_id = \n AND topic_moved_id = 0\n AND topic_last_post_time < \n AND topic_approved = 1\n ORDER BY topic_last_post_time DESC\n LIMIT 1
BACKTRACE
FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()
FILE: includes/db/mysql.php
LINE: 205
CALL: dbal_mysql->sql_query()
FILE: includes/db/dbal.php
LINE: 153
CALL: dbal_mysql->_sql_query_limit()
FILE: viewtopic.php
LINE: 134
CALL: dbal->sql_query_limit()
------------------------------------------
The call error happens when someone calls view next or prev when $row['topic_last_post_time'] is empty...
I added in front of that sql the following code that fixes it
if (!$row['topic_last_post_time'])
{
$user->setup('viewtopic');
trigger_error(($view == 'next') ? 'NO_NEWER_TOPICS' : 'NO_OLDER_TOPICS');
}