Announcement

Collapse
No announcement yet.

mysql error number: 1064

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

  • mysql error number: 1064

    Just trying to update THREADS I get this error.

    mysql error number: 1064

    Database error in vBulletin Control Panel 2.3.0:

    Invalid SQL: UPDATE thread SET lastpost=1047164520,replycount=0,postusername='KPAH', postuserid='1091', lastposter='KPAH',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 20th of June 2003 08:38:32 PM
    Script: http://www.fantasticforum.com/1res/1res/admin/misc.php
    Referer: http://www.fantasticforum.com/1res/a...ion=chooser&s=


    I see an ERROR in the call to script 1res directory is REPEATED
    so I have a serious problem could use your help.

    Did a search, have not found a reference to any FIX

    Thanks for your time in advance...

    Revisedcode
    ___________
    Edited to add

    Seems this THREAD was posted a few days ago
    I did a search on the subject line oh well

    HELP

  • #2
    This is a bug, and has been fixed for version 2.3.1

    Comment


    • #3
      http://www.vbulletin.com/forum/showt...546#post463546
      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
      Change CKEditor Colors to Match Style (for 4.1.4 and above)

      Steve Machol Photography


      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


      Comment


      • #4
        Thanks for this fast support ticket

        Hello,
        MySQL 4.0.13 appears to have introduced a new problem when returning the sum of a column not always returning an integer value.

        open up your admin/misc.php
        on line 276
        replace:

        attach=$attachsum

        with

        attach=" . intval($attachsum) . "
        ---

        I don't know if the line number will be the same in your version of vB, but it should be close

        Please let me know if you require any further assistance.

        All the best,
        Martin Erwin
        Support Team, vBulletin

        http://www.vbulletin.com/
        mailto:[email protected]

        Comment


        • #5
          Be nice if ver 2.31 was available in members area

          Be nice if ver 2.31 was available in members area


          Revisedcode

          Comment

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