Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Juhani

Pages: [1]
1
Installation problems / Upgrading successfully from 1.7.5 to 2.6.1
« on: June 21, 2014, 06:52:28 pm »
I recently upgarded from 1.7.5 to 2.6.1, and had many issues.  The operating system was Ubuntu 12.04 with PHP 5.3.10.  I followed the official migration guide, but it was a little bit faulty.  So, I would like to just share what issues I had and how I solved them, if it might help somebody ;)


  • I had my Feng Office 1.7.5 database tables without any prefix. The upgrade script begun working, when I first added prefix og_ to all the database table names.  This can be made with SQL or just easily with PhpMyAdmin.  If you've got some prefix, change it to og_.  Simultaneously I had prefix fo_ in config.php like told in the migration guide.

  • There was an issue in upgrading from 2.5.1.5 to 2.6.1, so I had to first upgrade from 1.7.5 to 2.5.1.5.  Then I gave the following two SQL commands:

    DELETE FROM fo_config_options WHERE fo_config_options.name = 'milestone_selector_filter';
    ALTER TABLE fo_application_logs DROP INDEX member;

    And after this upgrade from 2.5.1.5 to 2.6.1 was made without errors.

  • The database table og_custom_properties_by_co_type didn't get upgraded.  Solution was to copy it to a new table with name fo_custom_properties_by_co_type.  I'm not sure was this a necessary step.

  • I tried to run complete_migration.php, but database table fo_processed_objects and file /root/feng_upgrade_log.log remained empty. I couldn't see any tasks or other objects in the upgraded Feng Office, and additionally had errors like FATAL: exception 'Exception' with message 'You must choose at least one member of Workspaces, Tags.' in FENG_ROOT/cache/log.php.

    Solution was just to decrease number of processed objects from 2000 to 200, so that it became suitable for the capacity of a small server:

    */10 * * * * php FENG_ROOT/public/upgrade/complete_migration.php 200 >> /root/feng_upgrade_log.log

    If you can't schedule tasks as root, it's necessary change the path of log file.

  • I copied files between folders, so then it was necessary to change permissions of folders like told in Copy Installation wiki article


PS. If you had any errors during the procedure of running console.php script, you must start over from the very beginning. This means you must restore the files and database to the condition, where they were before running the migration script console.php. Otherwise you will see endless amount of errors (some of them mentioned earlier on this forum) that can't be fixed.

--------------------------------------

EDIT:

I forgot to update this post.  I found later, that error FATAL: exception 'Exception' with message 'You must choose at least one member of Workspaces, Tags.' that blocked the migration process, was caused by some objects, that didn't have any reference to any workspace.  I had to look for an object_id of some workspace from database table "workspaces", and then modify script FENG_ROOT/public/upgrade/complete_migration.php to use this id, when an object without id was met in the object processing loop.

This board doesn't allow me to post any code (with error message "Sorry, you are not allowed to post external links." altought I'm not having any links in the post), so I must put the code as the attachment.

2
Installation problems / Re: ugrading 2.5.1.2 to 2.6.1
« on: June 21, 2014, 05:43:10 pm »
I had to run first the following SQL commands in order to get the database schema upgrade to run without errors:

DELETE FROM fo_config_options WHERE fo_config_options.name = "milestone_selector_filter";
ALTER TABLE fo_application_logs DROP INDEX member;

They already exists in the database for some reason, but the upgrade script tries to add them.

3
Suomi / Translation version alpha 2 (for Feng Office 1.7.2)
« on: January 28, 2011, 03:15:11 am »
Some errors fixed, mainly with finnish inflection.  The source language doesn't make it easy, because finnish belongs to different language family than english & almost all the others, so structure of the language is sometimes really diverging.

4
Suomi / Re: Preparing for official finnish translation
« on: January 28, 2011, 03:03:33 am »
Moi, puhutaan inklantia, että ulkomaailmojen oliotkin ymmärtää  ;)

Sorry for a delay in a reply, Aslak.  If you could contribute by joining your translation with my version, might be nice.. if not, please post your translation here (or email me) so I can take a look.  My work results also would need a community evaluation, as I'm not a professional translator; if you are the one, perhaps you could then make some proof-reading :)

5
Suomi / Translation version alpha 1 (for Feng Office 1.7.2)
« on: January 11, 2011, 03:01:06 pm »
Almost completely translated, but for example admin areas still need some attention (you're welcome to contribute!).  This is now in use for one small finnish company, and we will post more versions when something to fix in testing phase will be found.

6
Suomi / Preparing for official finnish translation
« on: January 11, 2011, 02:54:42 pm »
So, let's go for it!  This thread is meant for preparing it.  Updates and corrections can be posted to this thread as attachments and comments. Anybody is welcome to contribute :)

Pages: [1]