Settings Update Fail: SQLSTATE[HY000]: 1364 Field 'settingDesc' doesn't have a default value (dev-branch)

[edvandro]

Environment:

FOG Version: 1.5.10.2328

Branch: dev-branch

Issue 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!

[Tom Elliott]

@edvandro Thanks for letting me know. I have found and fixed this in the latest if you don’t mind pulling/installing again?

Thank you!

[edvandro]

Resolved. I’m sharing FOG with as many people as I can. Love this project!