Ok. I fixed the above by running the following:
Quote:
ALTER TABLE `user` ADD COLUMN `warnings` int(5) AFTER salt
|
I looked @ the table structure and the new column should be inserted between `salt` and `warning_level`. I took a peek @ the ALTER TABLE documentation and didn't see a BEFORE parameter, but did see an AFTER parameter, so decided to try that.
http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html
Quote:
Still getting this error, though when trying to warn a user:
Database error in vBulletin 3.0.3:
Invalid SQL: insert into vb3warnings values('','11','1','1101613183','spam 1.3.1','470','1','A','','')
mysql error: Column count doesn't match value count at row 1
mysql error number: 1136
|