warning_options errors, request table

[rh2004]

Just upgrading to the latest release and had a problem with warn options not existing, I looked and there was non. So I have used my old ones.



-- Table structure for table `warning_options`
--
DROP TABLE IF EXISTS `warning_options` ;# MySQL returned an empty result set (i.e. zero rows).
CREATE TABLE `warning_options` (
`oid` int( 15 ) NOT NULL AUTO_INCREMENT ,
`hierarchical` char( 3 ) default NULL ,
`automatic` char( 3 ) default NULL ,
`automaticpm` char( 3 ) default NULL ,
`automatic_warner` int( 10 ) unsigned default NULL ,
`warner` int( 10 ) unsigned default NULL ,
`banned_limit` int( 15 ) NOT NULL default '0',
`points_before_banned` int( 15 ) NOT NULL default '0',
`banned_usergroup_id` int( 15 ) default '0',
`protected_usergroups` varchar( 50 ) default NULL ,
`aprotected_usergroups` varchar( 50 ) default NULL ,
`troll_usergroup_id` varchar( 10 ) default NULL ,
`restore_groupid` smallint( 5 ) unsigned default NULL ,
`incr_ban_days` char( 3 ) default NULL ,
`max_no_bans` int( 5 ) default NULL ,
`viewoption` char( 3 ) default NULL ,
`multiple_per_post` char( 3 ) default NULL ,
`send_pm_warning` char( 3 ) default NULL ,
`send_em_warning` char( 3 ) default NULL ,
`historical` char( 3 ) default NULL ,
`allowoffpost` char( 3 ) default NULL ,
`warnings_per_page` int( 3 ) default NULL ,
PRIMARY KEY ( `oid` )
) TYPE = MYISAM AUTO_INCREMENT =2;# MySQL returned an empty result set (i.e. zero rows).
--
-- Dumping data for table `warning_options`
--
INSERT INTO `warning_options` ( `oid` , `hierarchical` , `automatic` , `automaticpm` , `automatic_warner` , `warner` , `banned_limit` , `points_before_banned` , `banned_usergroup_id` , `protected_usergroups` , `aprotected_usergroups` , `troll_usergroup_id` , `restore_groupid` , `incr_ban_days` , `max_no_bans` , `viewoption` , `multiple_per_post` , `send_pm_warning` , `send_em_warning` , `historical` , `allowoffpost` , `warnings_per_page` )
VALUES ( 1, 'No', 'No', 'No', 0, 7, 7, 10, 11, '5|6|7|6', '6', '8', 0, 'Yes', 3, 'All', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 15 ) ;# Affected rows:1




Now there is one or two errors, so has anyone got the latest warning_options table they could export and provide me with so I can run it.

Got this error when clicking: View Warned Users, Statistics - Warnings per User & Statistics - Bans per User


Warning: Division by zero in /admincp/admin_warn.php on line 704


error in vBulletin 3.0.7:

Invalid SQL: select * from
user u where warnings>0 ORDER BY userid ASC LIMIT 0,
mysql error: 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 '' at line 2

mysql error number: 1064

Date: Monday 28th of March 2005 07:53:44 PM
Script: http://www./admincp/admin_warn.php?act=viewwarnedusers
Referer: http://www./admincp/index.php?do=nav
Username:
IP Address:

[sv1cec]

You do not have to restore your table, all you have to do is to make sure that your warning options are saved. The error you get is because you have not entered how many lines you want to see in reports. This has been fixed in the latest zip file, but somehow I think that your warning options are not saved.

Have you run the script warn_install_settings.php?

Rgds

[rh2004]

Yeah, what I am going to do is install it on a brand new vB board and export the options and run the SQL in my site, I think that should work - I used the latest zip and it never added them, also can I ask I read in an email a few days ago the new PM banning, can you specify how many PM's they can send per day before there PM'in is disabled?

[sv1cec]

This is an additional restriction. Like the signature and avatar cut-off, there is a PM cut-off. If you set that to 5 (for example) and a member reaches 6 warning points, then he can not send or receive PMs.

Rgds