Database error when saving a "User Infractions" setting.

[Fungsten]

Here's the error message when clicking on "Save".

Database error in vBulletin 3.6.5:
Invalid SQL:
UPDATE infractionlevel
SET points = 1,
expires = 10,
period = 'D',
warning = 1,
extend = 0
WHERE infractionlevelid = 2;
MySQL Error : Unknown column 'extend' in 'field list'
Error Number : 1054
Date : Sunday, March 18th 2007 @ 12:48:50 PM
Script : http://www.Blah blah=updatelevel
Referrer : http://www.Blahblah.com/forum/adminc...ctionlevelid=2
IP Address : xxx.xxx.xx.xx
Username : XXXXX
Classname : vb_database

Thank you in advance.

[Marco van Herwaarden]

Seems you have missed an upgrade step.Run the following query to fix this:

[sql]ALTER TABLE infractionlevel ADD COLUMN `extend` smallint(5) unsigned NOT NULL default '0';[/sql]

[Fungsten]

On Edit: It worked!! Thanks!!

BTW, though I did not see any missed steps or errors during the upgrade I'm am having some occasional trouble, such as this, with the forum.

Originally Posted by Marco van Herwaarden

Seems you have missed an upgrade step.Run the following query to fix this:


SQL Query: (how to run queries)
ALTER TABLE infractionlevel ADD COLUMN `extend` smallint(5) unsigned NOT NULL default '0';