Tickets Not a Bug 1.5.8 Upgrade Error

[Fellowsfilm]

When trying to upgrade from 1.5.5 to 1.5.8:

Mysqli statement execute error : Unknown column 'execute_once' in 'xf_nixfifty_ticket_escalation'

Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in NixFifty/Tickets/Install.php at line 747
NixFifty_Tickets_Install::addColumn() in NixFifty/Tickets/Install.php at line 245
NixFifty_Tickets_Install::install()
call_user_func() in XenForo/Model/AddOn.php at line 215
XenForo_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169
XenForo_Model_AddOn->installAddOnXmlFromFile() in XenForo/ControllerAdmin/AddOn.php at line 237
XenForo_ControllerAdmin_AddOn->actionUpgrade() in XenForo/FrontController.php at line 351
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/afellows/public_html/admin.php at line 13

 

[Naz]

What version are you upgrading from?

 

[Fellowsfilm]

What version are you upgrading from?

1.5.5. Will I need to run the .6 and .7 upgrades first?

 

[Naz]

1.5.5. Will I need to run the .6 and .7 upgrades first?

No, the error suggests that you have a missing column from 1.5.0 for some reason.

To remedy this, run this sql query:

ALTER TABLE `xf_nixfifty_ticket_escalation` ADD COLUMN `execute_once` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `active`

Then this:

ALTER TABLE `xf_nixfifty_ticket_escalation` ADD COLUMN `execute_type` ENUM('always','per_ticket','per_message') NOT NULL DEFAULT 'always' AFTER `execute_once`

 

[Fellowsfilm]

To remedy this, run this sql query:

ALTER TABLE `xf_nixfifty_ticket_escalation` ADD COLUNN `execute_once` TINYINT(3) UNSIGNED NOT NULL DEFAU

That is showing up an SQL syntax error.

 

[Naz]

That is showing up an SQL syntax error.

I spelt column wrong. Try now.

 

[Fellowsfilm]

Haha, didn't notice that. All working and upgraded, cheers.