Help

[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

[sv1cec]

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]

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]

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]

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:


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:


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]

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

[Battle_Ring]

i have a warning options and it has these under it

oid int(15) No auto_increment
version varchar(10) Yes NULL
hierarchical char(3) Yes NULL
automatic char(3) Yes NULL
automaticpm char(3) Yes NULL
autocomments char(3) Yes NULL
automatic_warner int(10) UNSIGNED Yes NULL
warner int(10) UNSIGNED Yes NULL
collector int(10) UNSIGNED Yes NULL
banned_limit int(15) No 0
points_before_banned int(5) No 0
warnings_before_banned int(5) No 0
banned_usergroup_id int(15) Yes 0
protected_usergroups varchar(50) Yes NULL
aprotected_usergroups varchar(50) Yes NULL
troll_usergroup_id varchar(10) Yes NULL
restore_groupid smallint(5) UNSIGNED Yes NULL
incr_ban_days char(3) Yes NULL
max_no_bans int(5) Yes NULL
bans_mature int(10) Yes NULL
viewoption char(3) Yes NULL
multiple_per_post char(3) Yes NULL
send_pm_warning char(3) Yes NULL
send_em_warning char(3) Yes NULL
email_on_ban char(3) Yes NULL
historical char(3) Yes NULL
allowoffpost char(3) Yes NULL
warnings_per_page int(3) Yes NULL
textbutoption varchar(10) Yes NULL
modoption char(3) Yes NULL
sig_thresshold int(15) Yes NULL
avatar_thresshold int(15) Yes NULL

ok update i unsinstalled it liek 5 tiems and installed it 5 more times and its now workign right

Thanks

[sv1cec]

Glad you have it solved. I do not know what your problem was, though.