Hello everyone,

I am currently testing the dev-branch of FOG and have run into an issue when trying to create a new Multicast deployment task for a group of hosts.

Whenever I attempt to start the task, it fails immediately. The web UI shows a generic “Failed to create tasking” error, and the debug log reveals the following SQL integrity constraint violation:

The full query and parameters from the log show that the INSERT into the tasks table is trying to set taskPassreset to NULL, but the column definition in the database does not allow null values.

Additional context:

This issue occurs only on the dev-branch.
I have tested the exact same configuration (same server, same image, same host group) on the stable branch, and Multicast group tasks work perfectly fine there.

I have attached the error screenshot/print for reference.

Has anyone else encountered this specific issue on the dev-branch? Could it be a schema mismatch (e.g., missing default value for taskPassreset), or is this a known regression in the development code? Any pointers on how to fix or patch this temporarily would be greatly appreciated.

Thank you in advance for your help!

FOG Version: Dev-Branch (latest pull)
Init/Kernel: (Not relevant, happens in web UI before PXE boot)
Storage: NFS (working fine on stable)

####################

Tasking Failed
Failed to create tasking

```

teste Failed to start tasking type Multi-Cast
Failed to query: Error: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘taskPassreset’ cannot be null Error Message: Error Code: “23000”, Error Message: [“23000”,1048,“Column ‘taskPassreset’ cannot be null”], Debug: SQL: [1115] INSERT INTO tasks (taskName,taskCreateBy,taskHostID,taskForce,taskStateID,taskTypeID,taskNFSGroupID,taskNFSMemberID,taskWOL,taskImageID,taskShutdown,taskIsDebug,taskPassreset,taskLastMemberID) VALUES (:name_0,:createdBy_0,:hostID_0,:isForced_0,:stateID_0,:typeID_0,:storagegroupID_0,:storagenodeID_0,:wol_0,:imageID_0,:shutdown_0,:isDebug_0,:passreset_0,:NFSLastMemberID_0),(:name_1,:createdBy_1,:hostID_1,:isForced_1,:stateID_1,:typeID_1,:storagegroupID_1,:storagenodeID_1,:wol_1,:imageID_1,:shutdown_1,:isDebug_1,:passreset_1,:NFSLastMemberID_1) ON DUPLICATE KEY UPDATE taskName=VALUES(taskName),taskCreateBy=VALUES(taskCreateBy),taskHostID=VALUES(taskHostID),taskForce=VALUES(taskForce),taskStateID=VALUES(taskStateID),taskTypeID=VALUES(taskTypeID),taskNFSGroupID=VALUES(taskNFSGroupID),taskNFSMemberID=VALUES(taskNFSMemberID),taskWOL=VALUES(taskWOL),taskImageID=VALUES(taskImageID),taskShutdown=VALUES(taskShutdown),taskIsDebug=VALUES(taskIsDebug),taskPassreset=VALUES(taskPassreset),taskLastMemberID=VALUES(taskLastMemberID) Params: 28 Key: Name: [7] :name_0 paramno=0 name=[7] “:name_0” is_param=1 param_type=2 Key: Name: [12] :createdBy_0 paramno=1 name=[12] “:createdBy_0” is_param=1 param_type=2 Key: Name: [9] :hostID_0 paramno=2 name=[9] “:hostID_0” is_param=1 param_type=2 Key: Name: [11] :isForced_0 paramno=3 name=[11] “:isForced_0” is_param=1 param_type=2 Key: Name: [10] :stateID_0 paramno=4 name=[10] “:stateID_0” is_param=1 param_type=2 Key: Name: [9] :typeID_0 paramno=5 name=[9] “:typeID_0” is_param=1 param_type=2 Key: Name: [17] :storagegroupID_0 paramno=6 name=[17] “:storagegroupID_0” is_param=1 param_type=2 Key: Name: [16] :storagenodeID_0 paramno=7 name=[16] “:storagenodeID_0” is_param=1 param_type=2 Key: Name: [6] :wol_0 paramno=8 name=[6] “:wol_0” is_param=1 param_type=2 Key: Name: [10] :imageID_0 paramno=9 name=[10] “:imageID_0” is_param=1 param_type=2 Key: Name: [11] :shutdown_0 paramno=10 name=[11] “:shutdown_0” is_param=1 param_type=2 Key: Name: [10] :isDebug_0 paramno=11 name=[10] “:isDebug_0” is_param=1 param_type=2 Key: Name: [12] :passreset_0 paramno=12 name=[12] “:passreset_0” is_param=1 param_type=2 Key: Name: [18] :NFSLastMemberID_0 paramno=13 name=[18] “:NFSLastMemberID_0” is_param=1 param_type=2 Key: Name: [7] :name_1 paramno=14 name=[7] “:name_1” is_param=1 param_type=2 Key: Name: [12] :createdBy_1 paramno=15 name=[12] “:createdBy_1” is_param=1 param_type=2 Key: Name: [9] :hostID_1 paramno=16 name=[9] “:hostID_1” is_param=1 param_type=2 Key: Name: [11] :isForced_1 paramno=17 name=[11] “:isForced_1” is_param=1 param_type=2 Key: Name: [10] :stateID_1 paramno=18 name=[10] “:stateID_1” is_param=1 param_type=2 Key: Name: [9] :typeID_1 paramno=19 name=[9] “:typeID_1” is_param=1 param_type=2 Key: Name: [17] :storagegroupID_1 paramno=20 name=[17] “:storagegroupID_1” is_param=1 param_type=2 Key: Name: [16] :storagenodeID_1 paramno=21 name=[16] “:storagenodeID_1” is_param=1 param_type=2 Key: Name: [6] :wol_1 paramno=22 name=[6] “:wol_1” is_param=1 param_type=2 Key: Name: [10] :imageID_1 paramno=23 name=[10] “:imageID_1” is_param=1 param_type=2 Key: Name: [11] :shutdown_1 paramno=24 name=[11] “:shutdown_1” is_param=1 param_type=2 Key: Name: [10] :isDebug_1 paramno=25 name=[10] “:isDebug_1” is_param=1 param_type=2 Key: Name: [12] :passreset_1 paramno=26 name=[12] “:passreset_1” is_param=1 param_type=2 Key: Name: [18] :NFSLastMemberID_1 paramno=27 name=[18] “:NFSLastMemberID_1” is_param=1 param_type=2 SQL: INSERT INTO tasks (taskName,taskCreateBy,taskHostID,taskForce,taskStateID,taskTypeID,taskNFSGroupID,taskNFSMemberID,taskWOL,taskImageID,taskShutdown,taskIsDebug,taskPassreset,taskLastMemberID) VALUES (:name_0,:createdBy_0,:hostID_0,:isForced_0,:stateID_0,:typeID_0,:storagegroupID_0,:storagenodeID_0,:wol_0,:imageID_0,:shutdown_0,:isDebug_0,:passreset_0,:NFSLastMemberID_0),(:name_1,:createdBy_1,:hostID_1,:isForced_1,:stateID_1,:typeID_1,:storagegroupID_1,:storagenodeID_1,:wol_1,:imageID_1,:shutdown_1,:isDebug_1,:passreset_1,:NFSLastMemberID_1) ON DUPLICATE KEY UPDATE taskName=VALUES(taskName),taskCreateBy=VALUES(taskCreateBy),taskHostID=VALUES(taskHostID),taskForce=VALUES(taskForce),taskStateID=VALUES(taskStateID),taskTypeID=VALUES(taskTypeID),taskNFSGroupID=VALUES(taskNFSGroupID),taskNFSMemberID=VALUES(taskNFSMemberID),taskWOL=VALUES(taskWOL),taskImageID=VALUES(taskImageID),taskShutdown=VALUES(taskShutdown),taskIsDebug=VALUES(taskIsDebug),taskPassreset=VALUES(taskPassreset),taskLastMemberID=VALUES(taskLastMemberID) Params: Array ( [name_0] => Multi-Cast Task - teste [createdBy_0] => fog [hostID_0] => 2 [isForced_0] => 0 [stateID_0] => 1 [typeID_0] => 8 [storagegroupID_0] => 1 [storagenodeID_0] => 1 [wol_0] => 1 [imageID_0] => 1 [shutdown_0] => [isDebug_0] => [passreset_0] => [NFSLastMemberID_0] => 1 [name_1] => Multi-Cast Task - teste [createdBy_1] => fog [hostID_1] => 3 [isForced_1] => 0 [stateID_1] => 1 [typeID_1] => 8 [storagegroupID_1] => 1 [storagenodeID_1] => 1 [wol_1] => 1 [imageID_1] => 1 [shutdown_1] => [isDebug_1] => [passreset_1] => [NFSLastMemberID_1] => 1 ) ErrorInfo: Array ( [0] => 23000 [1] => 1048 [2] => Column ‘taskPassreset’ cannot be null ) Debug: SQL: [1115] INSERT INTO tasks (taskName,taskCreateBy,taskHostID,taskForce,taskStateID,taskTypeID,taskNFSGroupID,taskNFSMemberID,taskWOL,taskImageID,taskShutdown,taskIsDebug,taskPassreset,taskLastMemberID) VALUES (:name_0,:createdBy_0,:hostID_0,:isForced_0,:stateID_0,:typeID_0,:storagegroupID_0,:storagenodeID_0,:wol_0,:imageID_0,:shutdown_0,:isDebug_0,:passreset_0,:NFSLastMemberID_0),(:name_1,:createdBy_1,:hostID_1,:isForced_1,:stateID_1,:typeID_1,:storagegroupID_1,:storagenodeID_1,:wol_1,:imageID_1,:shutdown_1,:isDebug_1,:passreset_1,:NFSLastMemberID_1) ON DUPLICATE KEY UPDATE taskName=VALUES(taskName),taskCreateBy=VALUES(taskCreateBy),taskHostID=VALUES(taskHostID),taskForce=VALUES(taskForce),taskStateID=VALUES(taskStateID),taskTypeID=VALUES(taskTypeID),taskNFSGroupID=VALUES(taskNFSGroupID),taskNFSMemberID=VALUES(taskNFSMemberID),taskWOL=VALUES(taskWOL),taskImageID=VALUES(taskImageID),taskShutdown=VALUES(taskShutdown),taskIsDebug=VALUES(taskIsDebug),taskPassreset=VALUES(taskPassreset),taskLastMemberID=VALUES(taskLastMemberID) Params: 28 Key: Name: [7] :name_0 paramno=0 name=[7] “:name_0” is_param=1 param_type=2 Key: Name: [12] :createdBy_0 paramno=1 name=[12] “:createdBy_0” is_param=1 param_type=2 Key: Name: [9] :hostID_0 paramno=2 name=[9] “:hostID_0” is_param=1 param_type=2 Key: Name: [11] :isForced_0 paramno=3 name=[11] “:isForced_0” is_param=1 param_type=2 Key: Name: [10] :stateID_0 paramno=4 name=[10] “:stateID_0” is_param=1 param_type=2 Key: Name: [9] :typeID_0 paramno=5 name=[9] “:typeID_0” is_param=1 param_type=2 Key: Name: [17] :storagegroupID_0 paramno=6 name=[17] “:storagegroupID_0” is_param=1 param_type=2 Key: Name: [16] :storagenodeID_0 paramno=7 name=[16] “:storagenodeID_0” is_param=1 param_type=2 Key: Name: [6] :wol_0 paramno=8 name=[6] “:wol_0” is_param=1 param_type=2 Key: Name: [10] :imageID_0 paramno=9 name=[10] “:imageID_0” is_param=1 param_type=2 Key: Name: [11] :shutdown_0 paramno=10 name=[11] “:shutdown_0” is_param=1 param_type=2 Key: Name: [10] :isDebug_0 paramno=11 name=[10] “:isDebug_0” is_param=1 param_type=2 Key: Name: [12] :passreset_0 paramno=12 name=[12] “:passreset_0” is_param=1 param_type=2 Key: Name: [18] :NFSLastMemberID_0 paramno=13 name=[18] “:NFSLastMemberID_0” is_param=1 param_type=2 Key: Name: [7] :name_1 paramno=14 name=[7] “:name_1” is_param=1 param_type=2 Key: Name: [12] :createdBy_1 paramno=15 name=[12] “:createdBy_1” is_param=1 param_type=2 Key: Name: [9] :hostID_1 paramno=16 name=[9] “:hostID_1” is_param=1 param_type=2 Key: Name: [11] :isForced_1 paramno=17 name=[11] “:isForced_1” is_param=1 param_type=2 Key: Name: [10] :stateID_1 paramno=18 name=[10] “:stateID_1” is_param=1 param_type=2 Key: Name: [9] :typeID_1 paramno=19 name=[9] “:typeID_1” is_param=1 param_type=2 Key: Name: [17] :storagegroupID_1 paramno=20 name=[17] “:storagegroupID_1” is_param=1 param_type=2 Key: Name: [16] :storagenodeID_1 paramno=21 name=[16] “:storagenodeID_1” is_param=1 param_type=2 Key: Name: [6] :wol_1 paramno=22 name=[6] “:wol_1” is_param=1 param_type=2 Key: Name: [10] :imageID_1 paramno=23 name=[10] “:imageID_1” is_param=1 param_type=2 Key: Name: [11] :shutdown_1 paramno=24 name=[11] “:shutdown_1” is_param=1 param_type=2 Key: Name: [10] :isDebug_1 paramno=25 name=[10] “:isDebug_1” is_param=1 param_type=2 Key: Name: [12] :passreset_1 paramno=26 name=[12] “:passreset_1” is_param=1 param_type=2 Key: Name: [18] :NFSLastMemberID_1 paramno=27 name=[18] “:NFSLastMemberID_1” is_param=1 param_type=2

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

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
The fix worked perfectly! The menu issue is now resolved.

Thanks for the support!

Hi everyone,

I am encountering an issue with the PXE boot menu when booting clients in Legacy BIOS mode using the dev-branch version of FOG.

Instead of rendering the standard graphical interface (bg.png / iPXE theme), the menu loads as plain text on a black screen without any styling or background, as shown below:

Environment / Details:

FOG Version/Branch: dev-branch

Boot Mode: Legacy BIOS

iPXE File Used: undionly.kpxe

Has anyone else experienced this issue on the latest dev-branch, or is there a specific iPXE build/configuration option needed to restore the graphical menu for BIOS mode?

Thanks in advance!