swchathits table doesn't exisit

[johntk]

We just upgraded to SupportSuite version 3.3, we were previously running version 3.1

Now whenever a new chat request comes in our clients see the following error:


"Invalid SQL: INSERT INTO `swchathits` (`staffid`, `dateline`, `fullname`, `email`, `chatobjectid`) VALUES ('3', '1220452769', 'john', 'john@utechsoft.com', '777'); (Table 'kayako_suite.swchathits' doesn't exist) "

The chat alert shows up but obviously no one ever answers because they only see the error.

Can anyone help?
Thanks!
John

[Jamie Edwards]

Did you run the upgrade script?

[johntk]

After I uploaded the new version,
then I edited the config.php then using my web browser I went to http://mysupportsite/setup and selected upgrade from the menu.

is this the upgrade script? or did I miss something?

John

[johntk]

I took a look at the code in setup directory, and I found the code that must get executed when you upgrade from 3.1 to 3.11. There I found the SQL syntax to create the missing table:

CREATE TABLE swchathits (chathitid INT UNSIGNED NOT NULL AUTO_INCREMENT, staffid INT UNSIGNED NOT NULL DEFAULT '0', chatobjectid INT UNSIGNED NOT NULL DEFAULT '0', dateline INT UNSIGNED NOT NULL DEFAULT '0', fullname VARCHAR(255) NOT NULL DEFAULT '', email VARCHAR(255) NOT NULL DEFAULT '', isaccepted SMALLINT(1) UNSIGNED NOT NULL DEFAULT '1', PRIMARY KEY (chathitid), KEY chathitid (chatobjectid, staffid));

The chats started working after after I added the table. It looks like the upgrade script between 3.1 and 3.11 never got executed. Is there something else I should be doing?

John

[ozgurerdogan]

I have the same issue, any solution for that?