[XenConcept] Advanced Forum Rules

[XenConcept] Advanced Forum Rules [Paid] 2.0.6 Patch 3

No permission to buy ($15.00)
Error: A server error occurred. Please try again later.
XF\Db\Exception: MySQL query error [1146]: Table 'edewan_db.xc_advanced_forum_rules_dismissed' doesn't exist in src/XF/Db/AbstractStatement.php at line 228

  1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
  2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 77
  3. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
  4. XF\Db\AbstractAdapter->query() in src/addons/XenConcept/AdvancedForumRules/Repository/AdvancedForumRules.php at line 148
  5. XenConcept\AdvancedForumRules\Repository\AdvancedForumRules->forceUserRule() in src/addons/XenConcept/AdvancedForumRules/Option/Rule.php at line 23
  6. XenConcept\AdvancedForumRules\Option\Rule::verifyOption()
  7. call_user_func_array() in src/XF/Entity/Option.php at line 206
  8. XF\Entity\Option->verifyOptionValue() in src/XF/Mvc/Entity/Entity.php at line 787
  9. XF\Mvc\Entity\Entity->_verifyValueCustom() in src/XF/Mvc/Entity/Entity.php at line 632
  10. XF\Mvc\Entity\Entity->set() in src/XF/Mvc/Entity/Entity.php at line 567
  11. XF\Mvc\Entity\Entity->__set() in src/XF/Repository/Option.php at line 114
  12. XF\Repository\Option->updateOptions() in src/XF/Admin/Controller/Option.php at line 82
  13. XF\Admin\Controller\Option->actionUpdate() in src/XF/Mvc/Dispatcher.php at line 350
  14. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
  15. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
  16. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
  17. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2344
  18. XF\App->run() in src/XF.php at line 512
  19. XF::runApp() in admin.php at line 13
 
I'm trying to buy this addon but yoursite is not sending out account confirmation emails, therefore I cannot proceed to purchase.
 
We're getting the following errors:

Code:
INSERT  INTO `xf_xc_advanced_forum_rules_dismissed` (`rule_id`, `user_id`, `dismiss_date`) VALUES (?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL query err...', 1062, '23000')
#1 src/XF/Db/Mysqli/Statement.php(83): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1062, '23000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(219): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#4 src/addons/XenConcept/AdvancedForumRules/Repository/ForumRules.php(178): XF\Db\AbstractAdapter->insert('xf_xc_advanced_...', Array)
#5 src/addons/XenConcept/AdvancedForumRules/Pub/Controller/Rules.php(76): XenConcept\AdvancedForumRules\Repository\ForumRules->addDismissRules(2, 105227)
#6 src/XF/Mvc/Dispatcher.php(362): XenConcept\AdvancedForumRules\Pub\Controller\Rules->actionConfirm(Object(XF\Mvc\ParameterBag))
#7 src/XF/Mvc/Dispatcher.php(264): XF\Mvc\Dispatcher->dispatchClass('XenConcept\\Adva...', 'Confirm', Object(XF\Mvc\RouteMatch), Object(XenConcept\AdvancedForumRules\Pub\Controller\Rules), NULL)
#8 src/XF/Mvc/Dispatcher.php(121): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XenConcept\AdvancedForumRules\Pub\Controller\Rules), NULL)
#9 src/XF/Mvc/Dispatcher.php(63): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#10 src/XF/App.php(2826): XF\Mvc\Dispatcher->run()
#11 src/XF.php(806): XF\App->run()
#12 index.php(23): XF::runApp('XF\\Pub\\App')
#13 {main}

Code:
Stack trace
INSERT  INTO `xf_xc_advanced_forum_rules_dismissed` (`rule_id`, `user_id`, `dismiss_date`) VALUES (?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL query err...', 1062, '23000')
#1 src/XF/Db/Mysqli/Statement.php(83): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1062, '23000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(219): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#4 src/addons/XenConcept/AdvancedForumRules/Repository/ForumRules.php(178): XF\Db\AbstractAdapter->insert('xf_xc_advanced_...', Array)
#5 src/addons/XenConcept/AdvancedForumRules/Pub/Controller/Rules.php(76): XenConcept\AdvancedForumRules\Repository\ForumRules->addDismissRules(2, 109673)
#6 src/XF/Mvc/Dispatcher.php(362): XenConcept\AdvancedForumRules\Pub\Controller\Rules->actionConfirm(Object(XF\Mvc\ParameterBag))
#7 src/XF/Mvc/Dispatcher.php(264): XF\Mvc\Dispatcher->dispatchClass('XenConcept\\Adva...', 'Confirm', Object(XF\Mvc\RouteMatch), Object(XenConcept\AdvancedForumRules\Pub\Controller\Rules), NULL)
#8 src/XF/Mvc/Dispatcher.php(121): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XenConcept\AdvancedForumRules\Pub\Controller\Rules), NULL)
#9 src/XF/Mvc/Dispatcher.php(63): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#10 src/XF/App.php(2826): XF\Mvc\Dispatcher->run()
#11 src/XF.php(806): XF\App->run()
#12 index.php(23): XF::runApp('XF\\Pub\\App')
#13 {main}
 
We're getting the following errors:

Code:
INSERT  INTO `xf_xc_advanced_forum_rules_dismissed` (`rule_id`, `user_id`, `dismiss_date`) VALUES (?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL query err...', 1062, '23000')
#1 src/XF/Db/Mysqli/Statement.php(83): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1062, '23000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(219): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#4 src/addons/XenConcept/AdvancedForumRules/Repository/ForumRules.php(178): XF\Db\AbstractAdapter->insert('xf_xc_advanced_...', Array)
#5 src/addons/XenConcept/AdvancedForumRules/Pub/Controller/Rules.php(76): XenConcept\AdvancedForumRules\Repository\ForumRules->addDismissRules(2, 105227)
#6 src/XF/Mvc/Dispatcher.php(362): XenConcept\AdvancedForumRules\Pub\Controller\Rules->actionConfirm(Object(XF\Mvc\ParameterBag))
#7 src/XF/Mvc/Dispatcher.php(264): XF\Mvc\Dispatcher->dispatchClass('XenConcept\\Adva...', 'Confirm', Object(XF\Mvc\RouteMatch), Object(XenConcept\AdvancedForumRules\Pub\Controller\Rules), NULL)
#8 src/XF/Mvc/Dispatcher.php(121): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XenConcept\AdvancedForumRules\Pub\Controller\Rules), NULL)
#9 src/XF/Mvc/Dispatcher.php(63): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#10 src/XF/App.php(2826): XF\Mvc\Dispatcher->run()
#11 src/XF.php(806): XF\App->run()
#12 index.php(23): XF::runApp('XF\\Pub\\App')
#13 {main}

Code:
Stack trace
INSERT  INTO `xf_xc_advanced_forum_rules_dismissed` (`rule_id`, `user_id`, `dismiss_date`) VALUES (?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL query err...', 1062, '23000')
#1 src/XF/Db/Mysqli/Statement.php(83): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1062, '23000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(219): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#4 src/addons/XenConcept/AdvancedForumRules/Repository/ForumRules.php(178): XF\Db\AbstractAdapter->insert('xf_xc_advanced_...', Array)
#5 src/addons/XenConcept/AdvancedForumRules/Pub/Controller/Rules.php(76): XenConcept\AdvancedForumRules\Repository\ForumRules->addDismissRules(2, 109673)
#6 src/XF/Mvc/Dispatcher.php(362): XenConcept\AdvancedForumRules\Pub\Controller\Rules->actionConfirm(Object(XF\Mvc\ParameterBag))
#7 src/XF/Mvc/Dispatcher.php(264): XF\Mvc\Dispatcher->dispatchClass('XenConcept\\Adva...', 'Confirm', Object(XF\Mvc\RouteMatch), Object(XenConcept\AdvancedForumRules\Pub\Controller\Rules), NULL)
#8 src/XF/Mvc/Dispatcher.php(121): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XenConcept\AdvancedForumRules\Pub\Controller\Rules), NULL)
#9 src/XF/Mvc/Dispatcher.php(63): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#10 src/XF/App.php(2826): XF\Mvc\Dispatcher->run()
#11 src/XF.php(806): XF\App->run()
#12 index.php(23): XF::runApp('XF\\Pub\\App')
#13 {main}
Hello,

Can you send the full error please ?
 
The request state?

Code:
array(4) {
  ["url"] => string(23) "/forums/rules/2/confirm"
  ["referrer"] => string(46) "https://***myurl***.com/forums/rules/2/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(4) {
    ["_xfToken"] => string(8) "********"
    ["accept"] => string(1) "1"
    ["redirect"] => string(64) "https://***myurl***.com/forums/general-satellite-talk.29/"
    ["action"] => string(0) ""
  }
}
 
Same error again today:

  • XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry '2-85869' for key 'rule_user'
  • src/XF/Db/AbstractStatement.php:230
Code:
Stack trace
INSERT  INTO `xf_xc_advanced_forum_rules_dismissed` (`rule_id`, `user_id`, `dismiss_date`) VALUES (?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL query err...', 1062, '23000')
#1 src/XF/Db/Mysqli/Statement.php(83): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1062, '23000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(219): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#4 src/addons/XenConcept/AdvancedForumRules/Repository/ForumRules.php(178): XF\Db\AbstractAdapter->insert('xf_xc_advanced_...', Array)
#5 src/addons/XenConcept/AdvancedForumRules/Pub/Controller/Rules.php(76): XenConcept\AdvancedForumRules\Repository\ForumRules->addDismissRules(2, 85869)
#6 src/XF/Mvc/Dispatcher.php(362): XenConcept\AdvancedForumRules\Pub\Controller\Rules->actionConfirm(Object(XF\Mvc\ParameterBag))
#7 src/XF/Mvc/Dispatcher.php(264): XF\Mvc\Dispatcher->dispatchClass('XenConcept\\Adva...', 'Confirm', Object(XF\Mvc\RouteMatch), Object(XenConcept\AdvancedForumRules\Pub\Controller\Rules), NULL)
#8 src/XF/Mvc/Dispatcher.php(121): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XenConcept\AdvancedForumRules\Pub\Controller\Rules), NULL)
#9 src/XF/Mvc/Dispatcher.php(63): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#10 src/XF/App.php(2826): XF\Mvc\Dispatcher->run()
#11 src/XF.php(806): XF\App->run()
#12 index.php(23): XF::runApp('XF\\Pub\\App')
#13 {main}

Code:
Request state
array(4) {
  ["url"] => string(23) "/forums/rules/2/confirm"
  ["referrer"] => string(46) "https://XXXXXXXX.com/forums/rules/2/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(4) {
    ["_xfToken"] => string(8) "********"
    ["accept"] => string(1) "1"
    ["redirect"] => string(64) "https://XXXXXXX.com/forums/general-satellite-talk.29/"
    ["action"] => string(0) ""
  }
}
 
Back
Top Bottom