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/admincp/admininfraction.php?do=editlevel&infractionlevelid=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:

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

[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.

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


SQL Query: (how to run queries (http://en.wikipedia.org/wiki/Wikipedia:Database_queries#Quick_instructions_for_ running_your_own__MySQL_queries))
ALTER TABLE infractionlevel ADD COLUMN `extend` smallint(5) unsigned NOT NULL default '0';