Uncaught exception received when searching
When performing search in GFI HelpDesk, the following exception can be received sometimes:
INSERT swsearchstores
(array
(
'sessionid' => 'gM7CPU9K09lWAIB1ydsF1d2d25e4faeaffe89849e1912350626bd7a1a147RKFwmO8TT6Dtt',
'storetype' => 5, 'dateline' => 1557820459, 'lastupdate' => 1557820459, 'staffid' => '112', 'userid' => false,
)
)
in ./__swift/library/Database/class.SWIFT_Database.php:603
This is because MySQL Strict Mode is enabled by default and should be disabled to use GFI HelpDesk.
The recommended resolution for this is to Disable MySQL Strict Mode at the server level.
Alternatively, you can disable MySQL Strict Mode at the session level.
- This configuration ensures that every time GFI HelpDesk wants to connect to the MySQL Database, Strict Mode is disabled at the session level.
- The user must have the necessary permissions on the database to disable Strict Mode.
Follow the below steps to disable MySQL Strict Mode at the session level:
- Launch a text editor.
- Open the file:
__swift/library/Database/class.SWIFT_Database.php - Find the method
__construct() - At the end of that method, just before the line:
return parent::__construct(), add the following line of code:$this->Execute("SET SESSION sql_mode=''"); - At the end of that method, just after the line: return parent::__construct(), add the following code:
if(defined('DISABLE_MYSQL_STRICT_SESSION') && DISABLE_MYSQL_STRICT_SESSION) {$result = $this->Execute("SET SESSION sql_mode=''");} - Restart the MySQL services.
It should look like this in a code enabled text editor
Perform the search action again to confirm the exception is no longer received.