Announcement

Collapse
No announcement yet.

Error updating threads

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

  • Error updating threads

    Hi

    Looking to get my board pruned posts and usernames so I can update my software to version 3

    I get this error when trying to run this

    Thread ids:

    Processing thread 1999
    P,BODY{FONT-FAMILY:tahoma,arial,sans-serif;FONT-SIZE:11px;}


    There seems to have been a slight problem with the Kansas F-Body Association database.
    Please try again by pressing the refresh button in your browser.

    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

    We apologise for any inconvenience.

    Database error in vBulletin Control Panel 2.3.0:
    Invalid SQL: UPDATE thread SET lastpost=1044641993,replycount=0,postusername='KsKid', postuserid='303', lastposter='KsKid',attach= WHERE threadid=1999
    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 'WHERE threadid=1999' at line 1
    mysql error number: 1064
    Date: Friday 06th of August 2004 08:29:26 AM
    Script: http://www.ksfba.org/forums/forums/admin/misc.php
    Referer: http://www.ksfba.org/forums/admin/misc.php?


    Is this something updating to the newest version will fix ?

  • #2
    Try uploading the original 2.3.0 admin/misc.php file in ascii transfer mode again.

    Do you have any hacks installed that made changes to the thread table?

    Comment


    • #3
      Nope, not really only changes made to the board is the skin/template and I remove user post counts, except to be viewd only in their profile. Not sure if I had the old Vb laying around anymore

      Comment


      • #4
        Just reminded me of something to

        Invalid SQL: UPDATE thread SET lastpost=1044641993,replycount=0,postusername='KsK id', postuserid='303', lastposter='KsKid',attach= WHERE threadid=1999

        If that user doesnt exist, it would error out I guess ? I deleted about 300 users on the board

        Comment


        • #5
          Its a mysql bug that you can fix by upgrading to v2.3.5

          Comment

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