Announcement

Collapse
No announcement yet.

Postings.php SQL error

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

  • Postings.php SQL error

    Just got this error emailed to me, and I believe it was when a moderator was moving a thread:

    Database error in vBulletin 3.5.3:

    Invalid SQL:

    UPDATE post SET
    parentid = CASE WHEN parentid = 41836 THEN 41874 WHEN parentid = 41837 THEN 41875 WHEN parentid = 41840 THEN 41876 WHEN parentid = 41841 THEN 41877 WHEN parentid = 41847 THEN 41878 WHEN parentid = 41853 THEN 41879 WHEN parentid = 41856 THEN WHEN parentid = 41858 THEN 41880 WHEN parentid = 41859 THEN 41881 WHEN parentid = 41870 THEN 41882 ELSE parentid END
    WHERE threadid = 5403 AND parentid IN (0,41836,41837,41840,41841,41847,41853,41856,41858,41859,41870);

    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 'WHEN parentid = 41858 THEN 41880 WHEN parentid = 41859 THEN 418
    Error Number : 1064
    Date : Monday, January 30th 2006 @ 09:31:05 PM
    Script : http://www.website.com
    Referrer :
    http://www.website.com
    IP Address : XXX.XXX.XXX.XXX
    Username : XXXX
    Classname : vb_database

    Could this be a vBulletin bug or a problem with my installation? Things still seem to work fine and the thread moved over fine, but I'm just wondering why I got this error?

  • #2
    Maybe the file is incomplete on the server. Re-upload all the vbulletin files 100%, you can skip the install/ and images/ directory.

    Comment


    • #3
      Thanks for that. I wouldn't have thought the file would be incomplete though as I uploaded them as a .tar.gz file and extracted it on the server. I think I'll see if it happens again, and if it does then I'll follow your suggestion.

      Comment

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