I can replicate the following error:
A one-time task is assigned to a user with the Auditee role.
The user completes this task.
When the administrator or a user with the User role attempts to accept this task, the following SQL error occurs:
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'plan_date' cannot be null (Connection: mysql, SQL: insert into controls (name, objective, input, model, indicator, action_plan, periodicity, plan_date, realisation_date, observations, score, note, next_id, standard, attributes, scope, status, updated_at, created_at) values (Planning, Implement actions to address risks and opportunities - Define information security objectives and plans to achieve them - Plan changes to the ISMS, - Risk assessment - Risk register - Risk treatment plan - Information security objectives, Control the actions implemented in the face of risks and opportunities - Information security objectives - ISMS modification plan, - Green: compliant - Red: non-compliant, Implement actions to address risks and opportunities, information security objectives and an ISMS modification plan., 0, ?, ?, ?, ?, ?, ?, ?, ?, ?, 0, 2026-03-01 18:23:05, 2026-03-01 18:23:05))
app/Http/Controllers/ControlController.php :1718
$new_control->note = null;
$new_control->score = null;
$new_control->plan_date = request('next_date');
// Save new control
$new_control->save();
// Clone measures
$new_control->measures()->sync($control->measures()->pluck('id')->toArray());
// Set owners
$new_control->users()->sync($control->users()->pluck('id')->toArray());
$new_control->groups()->sync($control->groups()->pluck('id')->toArray());
// make link
$control->next_id = $new_control->id;
I can replicate the following error:
A one-time task is assigned to a user with the Auditee role.
The user completes this task.
When the administrator or a user with the User role attempts to accept this task, the following SQL error occurs:
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'plan_date' cannot be null (Connection: mysql, SQL: insert into
controls(name,objective,input,model,indicator,action_plan,periodicity,plan_date,realisation_date,observations,score,note,next_id,standard,attributes,scope,status,updated_at,created_at) values (Planning, Implement actions to address risks and opportunities - Define information security objectives and plans to achieve them - Plan changes to the ISMS, - Risk assessment - Risk register - Risk treatment plan - Information security objectives, Control the actions implemented in the face of risks and opportunities - Information security objectives - ISMS modification plan, - Green: compliant - Red: non-compliant, Implement actions to address risks and opportunities, information security objectives and an ISMS modification plan., 0, ?, ?, ?, ?, ?, ?, ?, ?, ?, 0, 2026-03-01 18:23:05, 2026-03-01 18:23:05))app/Http/Controllers/ControlController.php :1718
$new_control->note = null;
$new_control->score = null;
$new_control->plan_date = request('next_date');