DB error with "update thread info"

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Scarlet Witch
    New Member
    • Jan 2004
    • 5
    • 2.3.0

    DB error with "update thread info"

    I recently converted from XMB to VB and during the process of updating the counters I got the following error with the "update thread info" section only

    Thread ids:

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


    There seems to have been a slight problem with the Ultimate-Evolution - X-Men Forum 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=1075231952,replycount=0,postusername='Blaze', postuserid='4', lastposter='Blaze',attach= WHERE threadid=218
    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=218' at line 1
    mysql error number: 1064
    Date: Tuesday 27th of January 2004 12:06:20 PM
    Script: http://www.ultimate-evolution.net/fo...admin/misc.php
    Referer: http://www.thetale.lunarpages.com/fo...ction=chooser&

    I don't know what to do about this and I haven't been able to update the forum info since I installed VB and moved the XMB database information over.
  • assassingod
    Senior Member
    • Apr 2003
    • 559
    • 3.5.x

    #2
    This is because of MySQL 4.0.13

    To fix, open up admin/misc.php and find:
    PHP Code:
    attach=$attachsum 
    and replace with
    PHP Code:
    attach=" . intval($attachsum) . " 
    That should do it

    Comment

    • Scarlet Witch
      New Member
      • Jan 2004
      • 5
      • 2.3.0

      #3
      Thank you very much... works wonderfully now

      Comment

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