Error 'Uncaught Exception Invalid Data Provided in ./__swift/Apps/Base/Models/Staff/Class.swift_staff.Php:149' After an Upgrade

Overview

After upgrading Kayako Classic, users might see the following error:

Uncaught Exception
Invalid data provided in ./__swift/apps/base/models/Staff/class.SWIFT_Staff.php:149

They might also experience a problem not seeing any users from the staff control panel. This article provides information on how to fix the issue.

Information

The problem stated above may be experienced if the MySQL Strict Mode is enabled, which is the default 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.