[TH] Warnings

[TH] Warnings 1.1.7

No permission to download

Jon W

Well-known member
Waindigo submitted a new resource:

Warnings by Waindigo - Adds the ability to limit warning actions to specified warning definitions only.

This add-on adds the ability to limit warning actions to specified warning definitions only.

This means, for example, that you can have harsher actions for those who consistently get warned for doing the same thing. Or you could have certain warning definitions for certain parts of your site with warning actions to match....
Read more about this resource...

Jon W

Well-known member
Waindigo updated Warnings by Waindigo with a new update entry:

Version 1.0.2 released

Bug fixes:
  • Fixed duplicate entry error when warning actions applied user groups for a specified time period.
  • Fixes bug that user groups may not be added or removed correctly if applied for a specified time period and actions only apply to certain user groups.
  • Fixes bug that actions were not being applied if no warning definitions were selected, so were never being applied to custom warnings.
  • Adds workaround for...
Read the rest of this update entry...

Jon W

Well-known member
Waindigo updated Warnings by Waindigo with a new update entry:

Version 1.0.3 released

New features:
  • Added support for warning groups.
  • Added support for changing the display order of your warnings and warning groups.
  • Added the option for warning actions to apply only to certain warning groups.
Bug fixes:
  • Fixed bug that stopped user groups applied temporarily due to warning actions not being reversed after the specified time has elapsed.
Read the rest of this update entry...

Jon W

Well-known member
This is exactly the same as for normal warnings, so if you are unsure how this works you should post in the general support forums and someone will be able to explain how it works.


Well-known member
Having a problem installing this add-on - on both 1.2.3 and 1.3b4, I'm getting an error when I go to ACP > Users > Warnings:

Mysqli prepare error: Table 'addon-test.xf_warning_group' doesn't exist

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
XenForo_Model->fetchAllKeyed() in Waindigo/Warnings/Extend/XenForo/Model/Warning.php at line 410
Waindigo_Warnings_Extend_XenForo_Model_Warning->getAllWarningGroups() in Waindigo/Warnings/Extend/XenForo/ControllerAdmin/Warning.php at line 21
Waindigo_Warnings_Extend_XenForo_ControllerAdmin_Warning->actionIndex() in XenForo/FrontController.php at line 337
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /Volumes/Content/Web/addontest/admin.php at line 13
As the error message states, the xf_warning_group table does not exist in the database when inspected manually.

Stuart Wright

Well-known member
@Waindigo Hi Jon, getting server errors with 1.3 RC2 when giving a warning:
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Incorrect integer value: '' for column 'end_date' at row 1 - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Apsilon, Today at 9:46 AM

Stack Trace
#0 /home/sites/avforums/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/sites/avforums/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/sites/avforums/public_html/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /home/sites/avforums/public_html/library/Waindigo/Warnings/Extend/XenForo/Model/Warning.php(236): Zend_Db_Adapter_Abstract->insert('xf_warning_user...', Array)
#4 /home/sites/avforums/public_html/library/Waindigo/Warnings/Extend/XenForo/Model/Warning.php(97): Waindigo_Warnings_Extend_XenForo_Model_Warning->triggerWarningAction(644311, Array)
#5 /home/sites/avforums/public_html/library/XenForo/Model/Warning.php(213): Waindigo_Warnings_Extend_XenForo_Model_Warning->_userWarningPointsIncreased(644311, 60, 50)
#6 /home/sites/avforums/public_html/library/XenForo/DataWriter/User.php(987): XenForo_Model_Warning->userWarningPointsChanged(644311, 60, 50)
#7 /home/sites/avforums/public_html/library/XenForo/DataWriter.php(1409): XenForo_DataWriter_User->_postSave()
#8 /home/sites/avforums/public_html/library/DigitalPointSpy/DataWriter/User.php(7): XenForo_DataWriter->save()
#9 /home/sites/avforums/public_html/library/XenForo/DataWriter/Warning.php(110): DigitalPointSpy_DataWriter_User->save()
#10 /home/sites/avforums/public_html/library/Waindigo/Warnings/Extend/XenForo/DataWriter/Warning.php(18): XenForo_DataWriter_Warning->_postSave()
#11 /home/sites/avforums/public_html/library/ModEss/DataWriter/Warning.php(15): Waindigo_Warnings_Extend_XenForo_DataWriter_Warning->_postSave()
#12 /home/sites/avforums/public_html/library/XenForo/DataWriter.php(1409): ModEss_DataWriter_Warning->_postSave()
#13 /home/sites/avforums/public_html/library/XenForo/ControllerPublic/Member.php(860): XenForo_DataWriter->save()
#14 /home/sites/avforums/public_html/library/XenForo/FrontController.php(347): XenForo_ControllerPublic_Member->actionWarn()
#15 /home/sites/avforums/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#16 /home/sites/avforums/public_html/index.php(13): XenForo_FrontController->run()
#17 {main}

Request State
array(3) {
["url"] => string(57) "http://www.avforums.com/members/lightningslow.644311/warn"
["_GET"] => array(0) {
["_POST"] => array(14) {
["warning_definition_id"] => string(2) "17"
["points_enable"] => string(1) "1"
["points"] => string(2) "10"
["expiry_enable"] => string(1) "1"
["expiry_value"] => string(1) "1"
["expiry_unit"] => string(5) "years"
["notes"] => string(0) ""
["conversation_title"] => string(39) "Failing to honour commitments in a deal"
["conversation_message"] => string(376) "lightningslow,

Your message (UPS with USB port.) broke our trading rules.

Your ability to use our classified forums may be restricted based on these actions.
We recommend that you read our trading rules so you can better avoid breaking them in the future."
["content_action"] => string(0) ""
["content_type"] => string(4) "post"
["content_id"] => string(8) "20399689"
["redirect"] => string(58) "http://www.avforums.com/threads/ups-with-usb-port.1860889/"
["_xfToken"] => string(8) "********"

Stuart Wright

Well-known member
Tried to upgrade - got this:
Server Error
Mysqli statement execute error : Subquery returns more than 1 row

  1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
  2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
  3. Zend_Db_Adapter_Abstract->query() in Waindigo/Warnings/Install/Controller.php at line 40
  4. Waindigo_Warnings_Install_Controller->_preInstall() in Waindigo/Install/20140226.php at line 196
  5. Waindigo_Install->_install() in Waindigo/Install/20140226.php at line 88
  6. Waindigo_Install::install()
  7. call_user_func() in XenForo/Model/AddOn.php at line 215
  8. XenForo_Model_AddOn->installAddOnXml() in XenCentral/Framework/Model/AddOn.php at line 25
  9. XenCentral_Framework_Model_AddOn->installAddOnXml() in ConvEss/Model/AddOn.php at line 24
  10. ConvEss_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169
  11. XenForo_Model_AddOn->installAddOnXmlFromFile() in XenForo/ControllerAdmin/AddOn.php at line 236
  12. XenForo_ControllerAdmin_AddOn->actionUpgrade() in XenForo/FrontController.php at line 347
  13. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  14. XenForo_FrontController->run() in /home/sites/avforums/public_html/admin.php at line 13
AVForums is broken until this is resolved.