Error 'Uncaught Exception AutoExecute Query: AutoExecute Query: INSERT swchatobjects' When Initiating a Live Chat Session

Overview

After a database update, users might see the error 'Uncaught Exception AutoExecute Query: AutoExecute Query: INSERT swchatobjects' when trying to initiate a live chat session. This article provides information on how to fix the issue.

Information

The database update may have turned the default MySQL Strict Mode to the enabled state. When strict mode is enabled, invalid or missing data may cause warnings or errors when attempting to process the query. The preferred state for strict mode when using Kayako Classic should be disabled. So to resolve this issue, strict mode should be disabled.

For more information about disabling strict mode, refer to the Disabling MySQL Strict Mode on the Server article.