Table does not exist

[erobledo]

We have version 3.11 installed. After a power outtage over the weekend, the ticketing system has not been able to fetch any new tickets coming in. The cron jobs are working and so is everything else. However, on MySQL we get table 'kayako_suite.swticketpostlocksold' does not exist. Any suggestions?

Thanks,
Eliud

[supportskins]

Check your database and see if the table "swticketpostlocksold" exists. If it does then you might want to try and repair and optimize your database.

[craigbrass]

Yes, use phpMyAdmin to do so. If it is listed there, go into it and run the repair. If not, just run the following SQL on the table :-

CREATE TABLE `swticketlocks` (
  `ticketid` int(10) unsigned NOT NULL default '0',
  `lockstaffid` int(10) unsigned NOT NULL default '0',
  `lockdateline` int(10) unsigned NOT NULL default '0',
  UNIQUE KEY `ticketlocks1` (`ticketid`)
) ENGINE=HEAP DEFAULT CHARSET=latin1;