vb.org Archive
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Advanced Warning System (AWS) (https://vborg.vbsupport.ru/forumdisplay.php?f=105)
-   -   Help (https://vborg.vbsupport.ru/showthread.php?t=76877)

Battle_Ring 02-23-2005 01:58 AM
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 02-23-2005 04:32 AM
Quote:
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 02-23-2005 10:39 AM
get the same error doing it withotu the tabel prefix cuz i dotn got a table prefix

sv1cec 02-23-2005 10:56 AM
Quote:
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 02-23-2005 07:45 PM
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 02-24-2005 04:35 AM
Quote:
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 02-24-2005 04:54 PM
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 02-24-2005 07:42 PM
Quote:
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 02-25-2005 07:32 PM
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 02-25-2005 07:36 PM
Quote:
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


All times are GMT. The time now is 10:41 PM.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01356 seconds
  • Memory Usage 1,765KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete