[F] Showthread nextoldest SQL error

[Dennis Tsang]

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 ''29834 ORDER BY dateline DESC LIMIT 0, 1' at line 1
Query:
SELECT pid FROM posts WHERE tid='29834 ORDER BY dateline DESC LIMIT 0, 1

In showthread.php, find:

PHP Code:

$query = $db->simple_select("posts", "pid", "tid='{$nextthread['tid']}", $options); 


Replace with:

PHP Code:

$query = $db->simple_select("posts", "pid", "tid='{$nextthread['tid']}'", $options); 


[Yumi]

Thank you for your bug report.

This bug has been fixed in our internal code repository. Please note that the problem will not be fixed here until these forums are updated.