Help

im trying to install this i ran the installer and it says i have version 3.1.7

i tried to run this query
`".TABLE_PREFIX."warning_options` SET version='3.1.8' WHERE oid='1'

but got this

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

[sv1cec]

Originally Posted by Battle_Ring

im trying to install this i ran the installer and it says i have version 3.1.7

i tried to run this query
`".TABLE_PREFIX."warning_options` SET version='3.1.8' WHERE oid='1'

but got this


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

Are you using a table prefix for your tables? If not, then run the query without the "TABLE_PREFIX" part, just erase that and run the query again. If you are using a table prefix, then replace the part above, with your own prefix.

Rgds

[Battle_Ring]

get the same error doing it withotu the tabel prefix cuz i dotn got a table prefix

[sv1cec]

Originally Posted by Battle_Ring

im trying to install this i ran the installer and it says i have version 3.1.7

i tried to run this query
`".TABLE_PREFIX."warning_options` SET version='3.1.8' WHERE oid='1'

but got this


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

Maybe I am missing something here?

The queries are:

UPDATE `".TABLE_PREFIX."warning_options` SET version='3.1.8' WHERE oid='1'

ALTER TABLE `".TABLE_PREFIX."warning_options` ADD COLUMN sig_thresshold INT(15)

ALTER TABLE `".TABLE_PREFIX."warning_options` ADD COLUMN avatar_thresshold INT(15)

Remove the table prefix thing, if you have no prefix.

[Battle_Ring]

ALTER TABLE `".TABLE_PREFIX."warning_options` ADD COLUMN sig_thresshold INT(15)

ALTER TABLE `".TABLE_PREFIX."warning_options` ADD COLUMN avatar_thresshold INT(15)

them 2 worked the first time but now i get the error when i try doing them

[sv1cec]

Originally Posted by Battle_Ring

ALTER TABLE `".TABLE_PREFIX."warning_options` ADD COLUMN sig_thresshold INT(15)

ALTER TABLE `".TABLE_PREFIX."warning_options` ADD COLUMN avatar_thresshold INT(15)

them 2 worked the first time but now i get the error when i try doing them

What is the error? Please be more specific, in your posts, if you want me to help you.

Rgds

[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

[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

[Battle_Ring]

i ra nthat and got

An error occurred while attempting to execute your query. The following information was returned.
error number: 1062
error desc: Duplicate entry '1' for key 1

[sv1cec]

Originally Posted by Battle_Ring

i ra nthat and got

An error occurred while attempting to execute your query. The following information was returned.
error number: 1062
error desc: Duplicate entry '1' for key 1

I asked you a couple of questions, I didn't tell you to run the query, unless you didn't have an entry in that table.

If there is one, and it looks as if there is one, tell me what it contains.

Rgds