Settings Update Fail: SQLSTATE[HY000]: 1364 Field 'settingDesc' doesn't have a default value (dev-branch)
-
Environment:
FOG Version: 1.5.10.2328 Branch: dev-branchIssue Description:
Hi everyone,I am running FOG Project on the dev-branch (version 1.5.10.2328) and encountering a database error whenever I try to update or save any option under FOG Settings.
A pop-up modal appears with the message “Settings Update Fail” containing the following SQL query error:v

It seems the SQL statement performs an INSERT INTO globalSettings specifying only settingID, settingKey, and settingValue, but the settingDesc column in the database schema does not allow NULL values and lacks a default value defined in MySQL/MariaDB.
Is this a known bug in the current dev-branch build, or is there a recommended database scheme fix/workaround for this table?
Thanks for your help!