Search Engine: Elastic

Article ID: 117851, created on Oct 10, 2013, last review on May 10, 2014

  • Applies to:
  • Business Automation


The Provider configured integration between PBA and Kayako Fusion. The Kayako Fusion server uses the MySQL 5.5 database server.

When a customer tries to access the 'Support Tickets' section in the PBA Customer Control Panel the following error message is displayed:

Session cannot be inited because user was not found


During the PBA and Kayako integration, the special table must be created in the Kayako database. Syntax of the table creation is not supported in the MySQL 5.5.


The problem is resolved in PBA 5.5.2 in scope of the request PBA-51793.

If upgarde is not possible at the moment, correct the kayakofusion.php file located on the Kayako server:

  • Find the following SQL query to create the hspcomplete table in the script:

        CREATE TABLE `hspcomplete` (
        `hspcomplete` INT(10) UNSIGNED NOT NULL,
        `supportsuite` INT(10) UNSIGNED NOT NULL,
        `email_confirmed` INT(1) UNSIGNED NOT NULL,
        PRIMARY KEY (`hspcomplete`)
        ) TYPE=MyISAM

  • Save changes in the script.

198398b282069eaf2d94a6af87dcb3ff caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF