MyBB Community Forums

Full Version: [F] Showthread nextoldest SQL error
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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:
$query = $db->simple_select("posts", "pid", "tid='{$nextthread['tid']}", $options);
Replace with:
$query = $db->simple_select("posts", "pid", "tid='{$nextthread['tid']}'", $options);
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.