Announcement

Collapse
No announcement yet.

mysql error number: 1064

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

  • revisedcode
    replied
    Be nice if ver 2.31 was available in members area

    Be nice if ver 2.31 was available in members area


    Revisedcode

    Leave a comment:


  • revisedcode
    replied
    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]

    Leave a comment:


  • Steve Machol
    replied
    http://www.vbulletin.com/forum/showt...546#post463546

    Leave a comment:


  • Cary
    replied
    This is a bug, and has been fixed for version 2.3.1

    Leave a comment:


  • revisedcode
    started a topic mysql error number: 1064

    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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X