PDA

View Full Version : Update Counters Problem

Kamui Shirou
03-05-2005, 04:57 PM
Hey, i hope u can help.
If i try to update the threads, this comes up


Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE thread SET lastpost=1110025646,replycount=2,postusername='Spr iggan', postuserid='18', lastposter='Crono',attach= WHERE threadid=854
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=854' at line 1

mysql error number: 1064



thx
Marco van Herwaarden
03-05-2005, 05:07 PM
Well i don't know what the reason is, probably some hack you installed, but the value for attach is missing.

Please check hacks you recently installed.
Kamui Shirou
03-05-2005, 06:36 PM
i didn't install hacks for a year XD, because I'm currently in the US a an exchange student. i just changed an username. just lately it worked fine.
Kamui Shirou
03-07-2005, 07:45 PM
anyone?
Kamui Shirou
03-12-2005, 09:42 PM
really nobody?
Kamui Shirou
04-03-2005, 03:17 PM
could anyone tell me what i have to change in the database?
Marco van Herwaarden
04-04-2005, 07:03 AM
Sorry but i have no knowledge of vB 2.3
manguish
04-04-2005, 08:35 AM
No idea of vb2 - BUT

if your 100% sure all you did was change a username - change it back and try again.

Doubt it'll work like, but - worth a shot
lasto
04-04-2005, 10:19 AM
not sure if this any good but read here m8

http://www.vbulletin.com/forum/showthread.php?t=107731