Table 'gift_support.ost_ticket_lock' doesn't exist

nirmaljaysval · Oct 9, 2014

Hello Guys, I am using osticket 1.7, and i get this message in regular inverval of time, my front section is working properly, but in admin section when try to check open tickets, it doesn't open also closed tickets doesn't open. Following is the error that i got. Second thing yesterday, i upgraded the system from 1.7 to 1.9 but still having problem, open and closed tickets are not opening, please check them and tell me the issue.Site url- http://leadershipgift.com/supportTable 'gift_support.ost_ticket_lock' doesn't existThanks in advanceNirmal

ntozier · Oct 9, 2014

Sounds like you are missing a table: ost_ticket_lock.Here's the code to create it:CREATE TABLE `%TABLE_PREFIX%ticket_lock` ( `lock_id` int(11) unsigned NOT NULL auto_increment, `ticket_id` int(11) unsigned NOT NULL default '0', `staff_id` int(10) unsigned NOT NULL default '0', `expire` datetime default NULL, `created` datetime NOT NULL, PRIMARY KEY (`lock_id`), UNIQUE KEY `ticket_id` (`ticket_id`), KEY `staff_id` (`staff_id`)) DEFAULT CHARSET=utf8;Of course you would want to change %TABLE_PREFIX% to your table prefix, which appears to be ost_.