Author Topic: Upgrade from 1.7.5 to 3.1 ?  (Read 2848 times)

Fred91

  • Freshman
  • *
  • Posts: 14
    • View Profile
Upgrade from 1.7.5 to 3.1 ?
« on: April 13, 2015, 10:34:25 am »
Hi,

Can I upgrade directly to FengOffice 3.1 from an old 1.7.5 or do I have to upgrade to 2.x first ?

Thanks for your help,

Fred

steveg

  • Full Member
  • ***
  • Posts: 167
    • View Profile
Re: Upgrade from 1.7.5 to 3.1 ?
« Reply #1 on: April 13, 2015, 11:18:12 am »
Hi,

Can I upgrade directly to FengOffice 3.1 from an old 1.7.5 or do I have to upgrade to 2.x first ?

Thanks for your help,

Fred

You should be able to do an upgrade right to 3.1.3, but I'm not 100% sure on that.  There have been some reports of broken upgrade paths from 1.x to 3.x, but based on the readme file, these appear to have been fixed.  Worst case, just do a 1.x to 2.x, and then a 2.x to 3.x upgrade. 

Fred91

  • Freshman
  • *
  • Posts: 14
    • View Profile
Re: Upgrade from 1.7.5 to 3.1 ?
« Reply #2 on: April 14, 2015, 03:05:46 am »
Hi,

Thank you for your answer.

I tried to upgrade directly to 3.1 on a test server.
The upgrade worked fine at the begining, upgrading versions sucessfully until 2.4.1 where I got the following message :

...
Feng Office has been upgraded. You are now running Feng Office 2.1 Enjoy!
...
Feng Office has been upgraded. You are now running Feng Office 2.3.2.1 Enjoy!
2015-04-13 17:09:24 - Finished upgrade to 2.3.2.1
2015-04-13 17:09:24 - Starting upgrade to 2.4.1
Upgrade script has connected to the database.
Error: Failed to execute DB schema transformations. MySQL said: Column count doesn't match value count at row 1
Error upgrading to version 2.4.1
2015-04-13 17:09:28 - Updating plugins...
2015-04-13 17:10:19 - Finished plugins update.



What's strange is that version 2.4.1 doesn't seem to be available on Sourceforge.

I'm going to try to upgrade to last 2.x first and then upgrade to 3.x

Regards,

Fred

Fred91

  • Freshman
  • *
  • Posts: 14
    • View Profile
Re: Upgrade from 1.7.5 to 3.1 ?
« Reply #3 on: April 15, 2015, 11:44:40 am »
I tried to upgrade by installing 2.7.1.6 and after almost 24h, I have the following error :

PHP Fatal error:  Call to a member function getId() on a non-object in /var/www/FengOffice/releases/2.7.1.6/public/upgrade/complete_migration.php on line 128

It just remains less that 900 objects on a total of almost 120.000 items and I can't finish the migration.

Afterinvestigating in the code and the database, it seems that there is no corresponding record on fo_project_tasks on the following request (called from $cobj = Objects::findObject($obj);) :

SELECT `id`, `object_type_id`, `name`, `created_on`, `created_by_id`, `updated_on`, `updated_by_id`, `trashed_on`, `trashed_by_id`, `archived_on`, `archived_by_id`, `object_id`, `parent_id`, `text`, `assigned_to_contact_id`, `completed_on`, `due_date`, `start_date`, `completed_by_id`, `order`, `milestone_id`, `started_on`, `priority`, `state`, `started_by_id`, `assigned_on`, `assigned_by_id`, `time_estimate`, `is_template`, `from_template_id`, `from_template_object_id`, `repeat_forever`,
`repeat_end`, `repeat_num`, `repeat_d`, `repeat_m`, `repeat_y`, `repeat_by`, `object_subtype`, `percent_completed`, `use_due_time`, `use_start_time`, `original_task_id`, `type_content`
                FROM `fo_project_tasks` INNER JOIN `fo_objects` o
                ON o.id = `fo_project_tasks`.object_id
                WHERE `object_id` = '1446'


Do you have any idea on how to correct this ?

Thank you for your help,

fred