mysql error number: 1064

[revisedcode]

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

[Cary]

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

[Steve Machol]

http://www.vbulletin.com/forum/showthread.php?postid=463546#post463546

[revisedcode]

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]

[revisedcode]

Be nice if ver 2.31 was available in members area

Be nice if ver 2.31 was available in members area


Revisedcode