Tickets Fixed xf_nixfifty_ticket_redirect doesn't exist

From time to time I get this error:
Code:
Server Error Log
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Table 'my_db.xf_nixfifty_ticket_redirect' doesn't exist - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, Today at 5:54 AM
Stack Trace
#0 /home/ius/domains/site.com/public_html/en/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\r\n\t\t\tSELECT *\r\n...')
#1 /home/ius/domains/site.com/public_html/en/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\r\n\t\t\tSELECT *\r\n...')
#2 /home/ius/domains/site.com/public_html/en/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\r\n\t\t\tSELECT *\r\n...')
#3 /home/ius/domains/site.com/public_html/en/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('\r\n\t\t\tSELECT *\r\n...', Array, 2)
#4 /home/ius/domains/site.com/public_html/en/library/NixFifty/Tickets/Model/TicketRedirect.php(34): XenForo_Model->fetchAllKeyed('\r\n\t\t\tSELECT *\r\n...', 'ticket_id', 1504328084)
#5 /home/ius/domains/site.com/public_html/en/library/NixFifty/Tickets/CronEntry/CleanUp.php(9): NixFifty_Tickets_Model_TicketRedirect->getExpiredTicketRedirects(1504328084)
#6 /home/ius/domains/site.com/public_html/en/library/XenForo/Model/Cron.php(356): NixFifty_Tickets_CronEntry_CleanUp::runHourlyCleanUp(Array)
#7 /home/ius/domains/site.com/public_html/en/library/XenForo/Deferred/Cron.php(24): XenForo_Model_Cron->runEntry(Array)
#8 /home/ius/domains/site.com/public_html/en/library/XenForo/Model/Deferred.php(295): XenForo_Deferred_Cron->execute(Array, Array, 7.9652960300446, 'Rebuilding... S...')
#9 /home/ius/domains/site.com/public_html/en/library/XenForo/Model/Deferred.php(429): XenForo_Model_Deferred->runDeferred(Array, 7.9652960300446, 'Rebuilding... S...', false)
#10 /home/ius/domains/site.com/public_html/en/library/XenForo/Model/Deferred.php(374): XenForo_Model_Deferred->_runInternal(Array, 8, 'Rebuilding... S...', false)
#11 /home/ius/domains/site.com/public_html/en/deferred.php(23): XenForo_Model_Deferred->run(false)
#12 {main}
Request State
array(3) {
  ["url"] => string(34) "https://site.com/en/deferred.php"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(3) {
    ["_xfRequestUri"] => string(33) "/en/reviews/4/field?field=contact"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}
 
See this:

Run this:

Code:
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
;
 
Back
Top