[TosaInu]

Originally Posted by MarcoH64

in the upgrade script, change the [sql]delete from template where [/sql] into [sql]delete from vb_template where [/sql]

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.