An Error - Some help please!

[Leo Wyatt]

When updating counters [Thread Info], I get the following error. If you could help me fix it, I'd greatly appreciate it. Thanks in advance.



Thread ids:

Processing thread 439



There seems to have been a slight problem with the Reality Boards 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=1058311447,replycount=0,postusername='Gan dalf', postuserid='3', lastposter='Gandalf',attach= WHERE threadid=439
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=439' at line 1

mysql error number: 1064

Date: Tuesday 15th of July 2003 07:27:52 PM
Script: http://www.reality-boards.net/forum/...admin/misc.php
Referer: http://www.reality-boards.net/forum/admin/misc.php?

[Erwin]

Go to this thread:

http://www.reality-boards.net/forum/...p?threadid=439

And delete it since it has something that is causing an error (if you can afford to). That is the easiest shortcut solution.

Then run update threads again.

[Erwin]

Mmm... that thread looks innocent enough... can't imagine why... usually it's a bad attachment that causes this error...

[Leo Wyatt]

I figured as much the first time the error was made. [It was a different thread ID]. But after I deleted it, it said there was something wrong with the thread AFTER IT. Any ideas? Any other way around it?

OK - I deleted it to see if it would work this time and I got the same error with:

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE thread SET lastpost=1058337516,replycount=0,postusername='Pho ebe', postuserid='72', lastposter='Phoebe',attach= WHERE threadid=446
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=446' at line 1

mysql error number: 1064

Date: Wednesday 16th of July 2003 06:48:58 AM
Script: http://www.reality-boards.net/forum/...admin/misc.php
Referer: http://www.reality-boards.net/forum/admin/misc.php?

[Leo Wyatt]

*bump* I neeeeeeeeeeeeeeeeeed to update counters o.O

[squawell]

do u have problem with update thread info??

if yes...this already fiexd in vbulletin.com...

check this

http://www.vbulletin.com/forum/showp...48&postcount=2

[Leo Wyatt]

Thanks! I hope that fixes it. Thanks loaaaaads.

Yep - worked thank you!

[squawell]

Today at 03:48 AM Leo Wyatt said this in Post #7
Thanks! I hope that fixes it. Thanks loaaaaads.

Yep - worked thank you!

ur welcome~