[sv1cec]

Originally Posted by TosaInu

Thanks MarcoH64

lol stupid me.

A field is missing:

Invalid SQL: update vb_warning_options set
hierarchical='Yes',
automatic='No',
automaticpm='No',
autocomments='No',
warner='0',
automatic_warner='',
collector='',
banned_limit='2',
points_before_banned='5',
warnings_before_banned='0',
banned_usergroup_id='4',
troll_usergroup_id='8',
protected_usergroups='6',
aprotected_usergroups='',
restore_groupid='0',
incr_ban_days='Yes',
max_no_bans='2',
bans_mature='300',
viewoption='Mgm',
multiple_per_post='No',
send_pm_warning='Yes',
send_em_warning='Yes',
email_on_ban='No',
historical='Yes',
allowoffpost='Yes',
warnings_per_page='20',
textbutoption='Text'
where oid='1'
mysql error: Unknown column 'textbutoption' in 'field list'

Also Invalid SQL: insert into vb_warnings (wid, warned_user, warned_by, warned_time, warned_reason, warned_post, warned_warning_id, caused_ban, warned_status, removed_by, removed_date) values('','4','1','1107975903','test','44','4','N' ,'A','','')
mysql error: Unknown column 'caused_ban' in 'field list'

and

Database error in vBulletin 3.0.3:

Invalid SQL: update vb_post set warn_flag=warn_flag+1 where postid='44'
mysql error: Unknown column 'warn_flag' in 'field list'


When a moderator issues a warning which hits Warning Points Limit, reason:
Invalid SQL:
INSERT INTO vb_userban
(userid, usergroupid, displaygroupid, customtitle, usertitle, adminid, bandate, liftdate, reason)
VALUES
(4, 4, 0, 0, 'test', 1, 1107979673, 1108152473, 'User exceeded the Warning Limit and was banned.')
mysql error: Unknown column 'reason' in 'field list'

It's possible to warn again for the same post even when this is set to no.

Run the following queries to add the missing fields in your table (remember to change them to use your prefix):

ALTER TABLE `warning_options` ADD COLUMN textbutoption char(10)

ALTER TABLE `warnings` ADD COLUMN caused_ban char(1)

ALTER TABLE `post` ADD COLUMN warn_flag int(5) default 0

ALTER TABLE `userban` ADD COLUMN reason mediumtext


Run these and see if everything goes OK. I'll be uploading a new upgrade_warn.php script in a while.

Rgds