Upgrade Problem

[erobledo]

I was doing an upgrade and I got an error message and the upgrade didn't finished. Now when ever I click on the post reply tab of a ticket I get this:

Invalid SQL: SELECT * FROM `swticketpostlocks` WHERE `ticketid` = '1878' AND `staffid` = '4' ORDER BY `dateline` DESC LIMIT 1; (Table 'kayako_suite.swticketpostlocks' doesn't exist)Invalid SQL: INSERT INTO `swticketpostlocks` (`ticketid`, `staffid`, `dateline`, `contents`) VALUES ('1878', '4', '1176233346', ''); (Table 'kayako_suite.swticketpostlocks' doesn't exist)Invalid SQL: SELECT * FROM `swticketpostlocks` WHERE `ticketid` = '1878' AND `staffid` != '4' ORDER BY `dateline` DESC LIMIT 1; (Table 'kayako_suite.swticketpostlocks' doesn't exist)

Reading the forum I got the impression to run the MYSQL scripts manually. Where are the scripts located to do this? If I try to run the upgrade again the it finish half way. Any ideas?

Thank You,
Eliud

[Jamie Edwards]

Hi Eliud,

Please submit a ticket to the support department detailing your issue (and that you require the scripts to run manually).

[supportskins]

You can find the MySQL queries within the setup directory