Feng Forum

Support => Feng Office 2 => : shodgman July 19, 2012, 08:19:38 PM

: Has anyone successfully upgraded from 1.7.5 to 2.1?
: shodgman 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

: Re: Has anyone successfully upgraded from 1.7.5 to 2.1?
: conrado 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

: Re: Has anyone successfully upgraded from 1.7.5 to 2.1?
: franponce87 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:

:

-- <?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