Tickets Fixed Cron Job MySQL Error

[Freelancer]

Error Info
Mysqli prepare error: Table 'mydatabasename.xf_nixfifty_ticket_redirect' doesn't exist - library/Zend/Db/Statement/Mysqli.php:77

Stack Trace
#0 /var/www/clients/client180/web812/web/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\n\t\t\tSELECT *\n\t\t...')
#1 /var/www/clients/client180/web812/web/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\n\t\t\tSELECT *\n\t\t...')
#2 /var/www/clients/client180/web812/web/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\n\t\t\tSELECT *\n\t\t...')
#3 /var/www/clients/client180/web812/web/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('\n\t\t\tSELECT *\n\t\t...', Array, 2)
#4 /var/www/clients/client180/web812/web/library/NixFifty/Tickets/Model/TicketRedirect.php(34): XenForo_Model->fetchAllKeyed('\n\t\t\tSELECT *\n\t\t...', 'ticket_id', 1502868243)
#5 /var/www/clients/client180/web812/web/library/NixFifty/Tickets/CronEntry/CleanUp.php(9): NixFifty_Tickets_Model_TicketRedirect->getExpiredTicketRedirects(1502868243)
#6 /var/www/clients/client180/web812/web/library/XenForo/Model/Cron.php(356): NixFifty_Tickets_CronEntry_CleanUp::runHourlyCleanUp(Array)
#7 /var/www/clients/client180/web812/web/library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
#8 /var/www/clients/client180/web812/web/library/XenForo/Model/Deferred.php(295): XenForo_Deferred_Cron->execute(Array, Array, 8, '')
#9 /var/www/clients/client180/web812/web/library/XenForo/Model/Deferred.php(429): XenForo_Model_Deferred->runDeferred(Array, 8, '', false)
#10 /var/www/clients/client180/web812/web/library/XenForo/Model/Deferred.php(374): XenForo_Model_Deferred->_runInternal(Array, 8, '', false)
#11 /var/www/clients/client180/web812/web/deferred.php(23): XenForo_Model_Deferred->run(false)
#12 {main}

Request State
Array
(
    [url] => https://www.mywebsite.com/deferred.php
    [_GET] => Array
        (
        )

    [_POST] => Array
        (
            [_xfRequestUri] => /admin.php?add-ons/
            [_xfNoRedirect] => 1
            [_xfToken] => ********
            [_xfResponseType] => json
        )

)

 

[Naz]

Run this:

CREATE TABLE `xf_nixfifty_ticket_redirect` (
   `ticket_id` INT(10) UNSIGNED NOT NULL,
   `target_url` TEXT NOT NULL,
   `redirect_key` VARCHAR(50) NOT NULL DEFAULT '',
   `expiry_date` INT(10) UNSIGNED NOT NULL DEFAULT '0',
   PRIMARY KEY (`ticket_id`),
   INDEX `redirect_key_expiry_date` (`redirect_key`, `expiry_date`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;

 

[Freelancer]

Okay... done.

 

[Alpha1]

Done as well.

 

[Naz]

Missed it out in the installer.

 

[Naz]

Fixed.