vb.org Archive - Database error when saving a "User Infractions" setting.

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Database error when saving a "User Infractions" setting. (https://vborg.vbsupport.ru/showthread.php?t=142447)

Fungsten

03-18-2007 06:58 PM

Database error when saving a "User Infractions" setting.

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

Quote:

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

03-18-2007 07:20 PM

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

03-18-2007 07:31 PM

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.

Quote:

Originally Posted by Marco van Herwaarden (Post 1206740)

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';

All times are GMT. The time now is 02:19 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01090 seconds Memory Usage 1,714KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: