• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login

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

    Scheduled Pinned Locked Moved Unsolved FOG Problems
    1 Posts 1 Posters 3 Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • E
      edvandro
      last edited by

      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

      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!

      1 Reply Last reply Reply Quote 0
      • 1 / 1
      • First post
        Last post

      57

      Online

      12.7k

      Users

      17.6k

      Topics

      156.9k

      Posts
      Copyright © 2012-2026 FOG Project