Feng Forum
Support => Feng Office 2 => : blatour January 11, 2013, 06:21:09 AM
-
Hello all,
We have installed version 2.2.1 of Fengoffice community and we get an error when we want to change the due date of an existing task.
Here is the error message: Query failed with message 'Column 'date' cannot be null'
Anyone have a solution to this problem?
Thank you in advance.
B. Latour
-
Hello,
Nobody to help me to solve this problem?
Regards
-
i saw this issue as well.. i did skip all the v2 updates until 2.2.2 as i was migrating from 1.7.5 and had some issues with previous versions...
did you upgrade or are you on a fresh install? have you tried to go to version 2.2.2 and has this resolved the issue?
when i had this problem, i believe it was a permissions issue with the way the task/milestone was setup.. i would change the date and i would then not have the correct perms to view that task anymore, giving me a similar error.
-
Chances are the installation/upgrade was corrupt or not completely finished.
By following this guide, you should have no problem when upgrading - we do not have them at least -:
http://www.fengoffice.com/web/wiki/doku.php/installation:migration#upgrading_from_1x_to_2x
Best regards,
Francisco
-
I have the same problem as blatour. But I upgraded from 1.7.5 to 2.2.3.1. I followed the update script to the letter.
Also log.php gets filled up with this error because of it:
ERROR: Error: Undefined index: multi_assignment in 'C:\Apache\htdocs\fengoffice\application\models\project_tasks\ProjectTasks.class.php' on line 430 (error code: 8)
-
I solved my problem with the due date by adding the column "is_required" to the table "fo_dimensions". Apparantly it wasn't created when upgrading from 1.7.5 to 2.2.3.1.
-
This is still a problem on a fresh install of either 2.2.4.1 or 2.3RC2. I'm unable to set a due date unless I do it when creating the task, I can't edit a task to add it...
Why is this? Have you tested fresh installs properly?
-
This is still a problem on a fresh install of either 2.2.4.1 or 2.3RC2. I'm unable to set a due date unless I do it when creating the task, I can't edit a task to add it...
Why is this? Have you tested fresh installs properly?
Do you mean in Chrome but not when using other browsers?
If so that is because of an upgrade in Chrome, but that has already been fixed long ago for the Professional Edition, as well as within later versions (2.3beta onwards).
Best regards,
Francisco
-
There is a bad hard coded query that needs to be updated:
FENG\application\models\project_tasks\ProjectTask.class.php around line 1219:
It looks something like this:
if ($due_date_changed) {
$id = $this->getId();
$sql = "UPDATE `".TABLE_PREFIX."object_reminders` SET
`date` = date_sub((SELECT `due_date` FROM `".TABLE_PREFIX."project_tasks` WHERE `id` = $id),
interval `minutes_before` minute) WHERE `object_id` = $id;";
DB::execute($sql);
}
And it needs to be this:
if ($due_date_changed) {
$id = $this->getId();
$sql = "UPDATE `".TABLE_PREFIX."object_reminders` SET
`date` = date_sub((SELECT `due_date` FROM `".TABLE_PREFIX."project_tasks` WHERE `object_id` = $id),
interval `minutes_before` minute) WHERE `object_id` = $id;";
DB::execute($sql);
}
Basically just add in object_ in the nested select WHERE clause.
-
There is a bad hard coded query that needs to be updated:
FENG\application\models\project_tasks\ProjectTask.class.php around line 1219:
It looks something like this:
if ($due_date_changed) {
$id = $this->getId();
$sql = "UPDATE `".TABLE_PREFIX."object_reminders` SET
`date` = date_sub((SELECT `due_date` FROM `".TABLE_PREFIX."project_tasks` WHERE `id` = $id),
interval `minutes_before` minute) WHERE `object_id` = $id;";
DB::execute($sql);
}
And it needs to be this:
if ($due_date_changed) {
$id = $this->getId();
$sql = "UPDATE `".TABLE_PREFIX."object_reminders` SET
`date` = date_sub((SELECT `due_date` FROM `".TABLE_PREFIX."project_tasks` WHERE `object_id` = $id),
interval `minutes_before` minute) WHERE `object_id` = $id;";
DB::execute($sql);
}
Basically just add in object_ in the nested select WHERE clause.
Thank you for your conrtibution! This has been added to the 2.3.1-beta onwards.
Keep up the good work!
Best regards,
Francisco
-
cialis for daily use (https://ccialiss.icu) These data demonstrate the differences between the treatment groups, as well as the effect of time