Author Topic: Has anyone successfully upgraded from 1.7.5 to 2.1?  (Read 2484 times)

shodgman

  • Freshman
  • *
  • Posts: 27
    • View Profile
Has anyone successfully upgraded from 1.7.5 to 2.1?
« on: July 19, 2012, 08:19:38 pm »
Recently I tried to upgrade from 1.7.5 to 2.1.  However, after the conversion to 2.0.1 there was an error getting to 2.1.

A number of us have posted and confirmed a bug in this stage of the upgrade process. see www <dot> fengoffice <dot> com and add /web/bugs/view.php?id=3960 as the detail on the URL.

I just wondered if we were alone or just special :-)

Clean installs of 2.1 work fine and I would like to be using it with the better permissions setup and Google calendar sync etc.  However, all my data is in 1.7.5 as I am worried that the 2.0.1 data might have been bad.

Can anyone help with suggestions on how to get around this issue please?
Thanks
SteveH

conrado

  • Administrator
  • Hero Member
  • *****
  • Posts: 998
  • Conrado
    • View Profile
    • Feng Office
    • Email
Re: Has anyone successfully upgraded from 1.7.5 to 2.1?
« Reply #1 on: July 24, 2012, 03:46:31 pm »
Have you finally been able to do a successful upgrade?

Here is a link to detailed instructions to upgrades and migrations:
http://www.fengoffice.com/web/wiki/doku.php/migration
Get Official Support for your Feng Office. Support the development team. Sign up for a Free Trial here.

franponce87

  • Administrator
  • Hero Member
  • *****
  • Posts: 1819
    • View Profile
    • Email
Re: Has anyone successfully upgraded from 1.7.5 to 2.1?
« Reply #2 on: July 27, 2012, 07:39:16 pm »
Hello everyone,
We have found out what the issue is, and its solution, which will be published for next release, and then yes, NO MORE problems when upgrading from 1.7.5 to 2.X IF you follow the instructions of course. Eventually it will become more user friendly though :)

Here is the fix:
Change all of the content of the file at FENG_ROOT/public/upgrade/templates/db_migration/2_1_molleja.php for the following one:

Code: [Select]
-- <?php echo $table_prefix ?> fo_
-- <?php echo $default_charset ?> DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
-- <?php echo $default_collation ?> collate utf8_unicode_ci
-- <?php echo $engine ?> InnoDB

INSERT INTO `<?php echo $table_prefix ?>file_types` (`id` ,`extension` ,`icon` ,`is_searchable` ,`is_image`) VALUES
 ('34', 'odt', 'doc.png', '1', '0'), ('35', 'fodt', 'doc.png', '1', '0')
ON DUPLICATE KEY UPDATE id=id;
UPDATE `<?php echo $table_prefix ?>permission_groups` SET `type` = 'roles' WHERE `id` <= 13;
UPDATE `<?php echo $table_prefix ?>permission_groups` SET `type` = 'permission_groups' WHERE `contact_id` > 0;
UPDATE `<?php echo $table_prefix ?>permission_groups` SET `type` = 'user_groups' WHERE `type` = '' OR `type` IS NULL;


The difference here is that there no longer are ALTER statements, which were actually already ran in the first process so as to keep your archived items.

Once you make this change, go to your browser and then:
FENG_ROOT/public/upgrade
Select the 2.1 version and voilá!!

We are sorry for this issue, and we thank you for patience and comprehension.

Should anyone find any further problem, please let us know about it so that we can solve it for the 2.1.1 beta version.

Best regards,
Francisco
Would you like to install Feng Office Professional or Enterprise Edition in your servers? No problem! Read this article!