Log in

View Full Version : Database error, help appreciated. :)


SHANE-D-PAIN
07-31-2008, 11:37 PM
So I uninstalled a few products, ones which had been disabled anyway, then a short while after, this error started to appear whilst posting new threads. it's also causing the Duplicate Post message to come up after every reply. Which is obviously annoying. :/

Anyway, yeah, it's this....


Database error in vBulletin 3.7.0:

Invalid SQL:
UPDATE user SET
posts = posts + 1,
usertitle = '<img src=\"http://www.teenageforums.com/images/user_admin.jpg\" alt=\"Administrator\" />',
lastpost = 1217550892,
lastpostid = 0
WHERE userid = 1;

MySQL Error : Unknown column 'lastpostid' in 'field list'
Error Number : 1054





The bits I picked up on were...

lastpostid = 0
Obviously not good, I'm sure this should be quite a high number.

MySQL Error : Unknown column 'lastpostid' in 'field list'
Isn't this a default vb table column, how can it be unkown? :/

--------------- Added 1217555021 at 1217555021 ---------------

Nevermind, i fixed it.

Thanks to anyone who took the time to look though. :)