Announcement

Collapse
No announcement yet.

Previous and Next Thread SQL Error Message when viewing only first thread in forum

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Previous and Next Thread SQL Error Message when viewing only first thread in forum

    Hi,
    When I go to a forum on my site, I can click the first thread in that forum and then after reading posts, etc. I see the "Previous thread | Next Thread" option after the last post. When I click on the previous thread link it works. But it does not work when I click the next thread link and it gives me the following SQL error message:

    Database error in vBulletin 4.0.0:

    Invalid SQL:

    SELECT thread.threadid, thread.title

    FROM thread AS thread

    WHERE forumid = 7
    AND visible = 1
    AND open <> 10


    AND lastpost >
    ORDER BY lastpost
    LIMIT 1;

    MySQL Error : 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 lastpost
    LIMIT 1' at line 11
    Error Number : 1064
    Request Date : Tuesday, December 29th 2009 @ 12:50:19 AM
    Error Date : Tuesday, December 29th 2009 @ 12:50:20 AM
    Script : http://www.raptureforums.com/forum/s...oto=nextnewest
    Referrer : http://www.raptureforums.com/forum/p...n-markell.html
    IP Address : removed by poster
    Username : Chris
    Classname : vB_Database
    MySQL Version : 5.0.68-log
    Any ideas as to why this might happen?

  • #2
    I am facing the same problem, can you tell me how you fixed it and what was the cause?

    Thank you

    Comment


    • #3
      anyone?

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X