PDA

View Full Version : An Error - Some help please!


Leo Wyatt
07-15-2003, 10:33 PM
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/forum/admin/misc.php
Referer: http://www.reality-boards.net/forum/admin/misc.php?

Erwin
07-15-2003, 10:50 PM
Go to this thread:

http://www.reality-boards.net/forum/showthread.php?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
07-15-2003, 10:52 PM
Mmm... that thread looks innocent enough... can't imagine why... usually it's a bad attachment that causes this error...

Leo Wyatt
07-16-2003, 09:34 AM
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/forum/admin/misc.php
Referer: http://www.reality-boards.net/forum/admin/misc.php?

Leo Wyatt
07-17-2003, 03:26 PM
*bump* I neeeeeeeeeeeeeeeeeed to update counters o.O

squawell
07-17-2003, 03:30 PM
do u have problem with update thread info??

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

check this

http://www.vbulletin.com/forum/showpost.php?p=463548&postcount=2

Leo Wyatt
07-17-2003, 06:48 PM
Thanks! I hope that fixes it. Thanks loaaaaads.

Yep - worked thank you!

squawell
07-17-2003, 07:56 PM
Today at 03:48 AM Leo Wyatt said this in Post #7 (https://vborg.vbsupport.ru/showthread.php?postid=418529#post418529)
Thanks! I hope that fixes it. Thanks loaaaaads.

Yep - worked thank you!
ur welcome~ :)