Tickets Not a Bug Unknown column 'execute_once'

Dadparvar

Member
When I want to add Escalation:
Code:
The following error occurred:

Mysqli prepare error: Unknown column 'execute_once' in 'field list'
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 Zend/Db/Adapter/Abstract.php at line 574
Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1638
XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1627
XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1419
XenForo_DataWriter->save() in NixFifty/Tickets/ControllerAdmin/Escalation.php at line 152
NixFifty_Tickets_ControllerAdmin_Escalation->actionSave() in XenForo/FrontController.php at line 351
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/ius/domains/site.com/public_html/fa/admin.php at line 13
 
This is related to the same issue as before.
Code:
ALTER TABLE xf_nixfifty_ticket_escalation ADD COLUMN `execute_once` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `active`;

You may also need to run this one:
Code:
CREATE TABLE `xf_nixfifty_ticket_escalation_trigger_log` (
                        `trigger_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
                        `ticket_id` INT(10) UNSIGNED NOT NULL,
                        `escalation_id` INT(10) UNSIGNED NOT NULL,
                        `trigger_date` INT(10) UNSIGNED NOT NULL,
                        PRIMARY KEY (`trigger_id`),
                        INDEX `trigger_date` (`trigger_date`)
                    ) COLLATE='utf8_general_ci' ENGINE=InnoDB;
 
Back
Top