Table 'my_bd.xf_moderator_discussion' doesn't exist

[Alpha1]

Since upgrading to the latest ModEss, threads regularly fail and I am getting a lot of these:

Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Table 'my_bd.xf_moderator_discussion' doesn't exist - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Emilita, Today at 7:53 AM

Stack Trace
#0 /library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('Select * from x...')
#1 /library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'Select * from x...')
#2 /library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('Select * from x...')
#3 /library/Zend/Db/Adapter/Abstract.php(753): Zend_Db_Adapter_Abstract->query('Select * from x...', Array)
#4 /library/ModEss/Model/ModeratorDiscussion.php(22): Zend_Db_Adapter_Abstract->fetchRow('Select * from x...', Array)
#5 /library/ModEss/ControllerPublic/Thread.php(25): ModEss_Model_ModeratorDiscussion->getCreatedDiscussion(319724, '0')
#6 /library/XenForo/Controller.php(311): ModEss_ControllerPublic_Thread->_preDispatch('Index')
#7 /library/XenForo/FrontController.php(350): XenForo_Controller->preDispatch('Index', 'XenForo_Control...')
#8 /library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /index.php(13): XenForo_FrontController->run()
#10 {main}
Request State
array(3) {
["url"] => string(74) "https://site.com/threads/cut-off-subheading.319724/"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}

 

[Xon]

@Alfa1 I haven't updated moderator essentials much yet. Looking at the installer, it is something of a mess and really will need an overhaul to-do incremental schema changes properly:

Can you run the following SQL:

                            CREATE TABLE IF NOT EXISTS `xf_moderator_discussion` (
                            `discussion_id` INT(11) NOT NULL AUTO_INCREMENT,
                            `thread_id` INT(11) NOT NULL,
                            `forum_id` INT(11) NOT NULL,
                            `discussion_thread` INT(11) NOT NULL,
                            `user_id` INT(11) NOT NULL,
                            `content_user_id` INT(11) NOT NULL,
                            `content_username` VARCHAR(100) NOT NULL,
                            PRIMARY KEY (`discussion_id`)
                            ) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci

If this errors, please tell me what the error is.

if this errors witht eh column already exists that is ok;

ALTER TABLE `xf_moderator_log` ADD `modess_discussion_id` INT(11) NOT NULL DEFAULT '0' AFTER `ip_address`, ADD INDEX (`modess_discussion_id`) ;

 

[Alpha1]

The column was created by the query.

Looking at the installer, it is something of a mess and really will need an overhaul to-do incremental schema changes properly

Click to shrink...

Considering the background of this I am not surprised.