Messages

1

Feng Office 2 / Re: FO 1.75 -> 2.3 Upgrade Instructions

« on: July 03, 2013, 10:22:20 am »

Yes I just did this last week, it is more work then what you would assume but I guess it is a major upgrade.

Did you review this: forums.fengoffice.com/index.php?topic=14906.0 and this fengoffice.com/web/wiki/doku.php/installation:migration#upgrading_from_1x_to_2x

I had to set MySQL to run as 4.0 to upgrade and restore once upgrade was complete:
Edit your my.ini file to be: sql-mode="MYSQL40"
Then restart your MySQL and then you can run the update.  I would also run it from the command line if possible as this seemed to work better:
C:\PHP\php.exe -f "C:\www\public\upgrade\console.php" 1.7.5 2.3

Once upgraded I was not able to see any Tasks and had to reassign all permissions to see them.

2

Feng Office 2 / Re: Error when changing the due date

« on: July 01, 2013, 12:13:43 pm »

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:

Code: [Select]

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:

Code: [Select]

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.