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
665bfecd-2057-498b-a944-100c24b921a4-image.png
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!