[sv1cec]

Originally Posted by Battle_Ring

the error i posted above

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'warning_options` SET version='3.1.8' WHERE oid='1'' at line 1

Check that you have a table called warning_options in your database.
Check that there is one row of data in that table.

If you do not have the table at all, create it using the following query:

PHP Code:

CREATE TABLE `".TABLE_PREFIX."warning_options` (
`oid` int(15) NOT NULL auto_increment, 
`version` char(10),
`hierarchical` char(3),
`automatic` char(3),
`automaticpm` char(3),
`autocomments` char(3),
`automatic_warner` int(10) unsigned,
`warner` int(10) unsigned, 
`collector` int(10) unsigned, 
`banned_limit` int(15) NOT NULL, 
`points_before_banned` int(5) NOT NULL default '0',
`warnings_before_banned` int(5) NOT NULL default '0',
`banned_usergroup_id` int(15) default '0',
`protected_usergroups` varchar(50),
`aprotected_usergroups` varchar(50),
`troll_usergroup_id` varchar(10),
`restore_groupid` smallint(5) unsigned,
`incr_ban_days` char(3),
`max_no_bans` int(5),
`bans_mature` int(10),
`viewoption` char(3),
`multiple_per_post` char(3),
`send_pm_warning` char(3),
`send_em_warning` char(3),
`email_on_ban` char(3),
`historical` char(3),
`allowoffpost` char(3),
`warnings_per_page` int(3),
`textbutoption` char(10),
`modoption` char(3),
`sig_thresshold` int(15),
`avatar_thresshold` int(15),
 PRIMARY KEY  (`oid`)
) 


If the table exists, but contains no data, run the following query:

PHP Code:

INSERT INTO `".TABLE_PREFIX."warning_options` values ('1','3.1.8', 'No', 'No','No','No','','','','7','10','10','8','','','8','','No','3','0','All','No','No','No','No','No','No','15','Text', 'All','3','6') 


Let me know