Author Topic: Error in 1.7.5 to 2.0 upgrade  (Read 38195 times)

franponce87

  • Administrator
  • Hero Member
  • *****
  • Posts: 1819
    • View Profile
    • Email
Re: Error in 1.7.5 to 2.0 upgrade
« Reply #45 on: January 29, 2013, 10:09:59 AM »
Hello Barbara, welcome to our Forums!
That is because the upgrade procedure seems not to have finished yet.
Please have a look at this guide, and follow step by step, specially the "complete migration script" running:
http://www.fengoffice.com/web/wiki/doku.php/installation:migration#upgrading_from_1x_to_2x

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

veelineen

  • Newbie
  • *
  • Posts: 6
    • View Profile
Re: Error in 1.7.5 to 2.0 upgrade
« Reply #46 on: February 17, 2013, 12:03:18 PM »
hi all, having some problems upgrading from 1.7.5 to 2.2.3 myself. Everything seems to be ok, the numbers of entries in my new fo_ tables are all matching with the old go_ tables, BUT:
the field text in fo_project_tasks, which had to be filled with the content from the field title from go_project_tasks is empty, that's why I can't see any tasks.

Changing:
INSERT INTO `fo_project_tasks` (`object_id`, `text`, `parent_id`, `due_date`, `start_date`, `assigned_on`, `assigned_by_id`, `time_estimate`, `completed_on`, `completed_by_id`, `started_on`, `started_by_id`, `priority`, `state`, `order`, `milestone_id`, `is_template`, `from_template_id`, `repeat_end`, `repeat_forever`, `repeat_num`, `repeat_d`, `repeat_m`, `repeat_y`, `repeat_by`, `object_subtype`, `percent_completed`, `assigned_to_contact_id`)
 SELECT (SELECT `id` FROM `fo_objects` WHERE `f1_id` = `c`.`id` AND `object_type_id` = (SELECT `ot`.`id` FROM `fo_object_types` `ot` WHERE `ot`.`name`='task')), `c`.`text`, `c`.`parent_id`, `c`.`due_date`, `c`.`start_date`, `c`.`assigned_on`,
 IF(`c`.`assigned_by_id` > 0, (SELECT o.id FROM fo_objects o WHERE o.f1_id = c.assigned_by_id AND o.object_type_id = (SELECT `ot`.`id` FROM `fo_object_types` `ot` WHERE `ot`.`name`='contact')), 0),
 `c`.`time_estimate`, `c`.`completed_on`,
 IF(`c`.`completed_by_id` > 0, (SELECT o.id FROM fo_objects o WHERE o.f1_id = c.completed_by_id AND o.object_type_id = (SELECT `ot`.`id` FROM `fo_object_types` `ot` WHERE `ot`.`name`='contact')), 0),
 `c`.`started_on`,
 IF(`c`.`started_by_id` > 0, (SELECT o.id FROM fo_objects o WHERE o.f1_id = c.started_by_id AND o.object_type_id = (SELECT `ot`.`id` FROM `fo_object_types` `ot` WHERE `ot`.`name`='contact')), 0),
 `c`.`priority`, `c`.`state`, `c`.`order`,
 (SELECT `id` FROM `fo_objects` WHERE `f1_id` = `c`.`milestone_id` AND `object_type_id` = (SELECT `ot`.`id` FROM `fo_object_types` `ot` WHERE `ot`.`name`='milestone')),
 `c`.`is_template`, `c`.`from_template_id`, `c`.`repeat_end`, `c`.`repeat_forever`, `c`.`repeat_num`, `c`.`repeat_d`, `c`.`repeat_m`, `c`.`repeat_y`, `c`.`repeat_by`, `c`.`object_subtype`, 0,
 IF (`c`.`assigned_to_user_id`> 0,
   (SELECT o.id FROM fo_objects o WHERE o.f1_id = c.assigned_to_user_id AND o.object_type_id = (SELECT `ot`.`id` FROM `fo_object_types` `ot` WHERE `ot`.`name`='contact')),
   (SELECT o.id FROM fo_objects o WHERE o.f1_id = c.assigned_to_company_id AND o.object_type_id = (SELECT `ot`.`id` FROM `fo_object_types` `ot` WHERE `ot`.`name`='company'))
 )
 FROM `og_project_tasks` `c`;


to:
INSERT INTO `fo_project_tasks` (`object_id`, `text`, `parent_id`, `due_date`, `start_date`, `assigned_on`, `assigned_by_id`, `time_estimate`, `completed_on`, `completed_by_id`, `started_on`, `started_by_id`, `priority`, `state`, `order`, `milestone_id`, `is_template`, `from_template_id`, `repeat_end`, `repeat_forever`, `repeat_num`, `repeat_d`, `repeat_m`, `repeat_y`, `repeat_by`, `object_subtype`, `percent_completed`, `assigned_to_contact_id`)
 SELECT (SELECT `id` FROM `fo_objects` WHERE `f1_id` = `c`.`id` AND `object_type_id` = (SELECT `ot`.`id` FROM `fo_object_types` `ot` WHERE `ot`.`name`='task')), `c`.`title`, `c`.`parent_id`, `c`.`due_date`, `c`.`start_date`, `c`.`assigned_on`,
 IF(`c`.`assigned_by_id` > 0, (SELECT o.id FROM fo_objects o WHERE o.f1_id = c.assigned_by_id AND o.object_type_id = (SELECT `ot`.`id` FROM `fo_object_types` `ot` WHERE `ot`.`name`='contact')), 0),
 `c`.`time_estimate`, `c`.`completed_on`,
 IF(`c`.`completed_by_id` > 0, (SELECT o.id FROM fo_objects o WHERE o.f1_id = c.completed_by_id AND o.object_type_id = (SELECT `ot`.`id` FROM `fo_object_types` `ot` WHERE `ot`.`name`='contact')), 0),
 `c`.`started_on`,
 IF(`c`.`started_by_id` > 0, (SELECT o.id FROM fo_objects o WHERE o.f1_id = c.started_by_id AND o.object_type_id = (SELECT `ot`.`id` FROM `fo_object_types` `ot` WHERE `ot`.`name`='contact')), 0),
 `c`.`priority`, `c`.`state`, `c`.`order`,
 (SELECT `id` FROM `fo_objects` WHERE `f1_id` = `c`.`milestone_id` AND `object_type_id` = (SELECT `ot`.`id` FROM `fo_object_types` `ot` WHERE `ot`.`name`='milestone')),
 `c`.`is_template`, `c`.`from_template_id`, `c`.`repeat_end`, `c`.`repeat_forever`, `c`.`repeat_num`, `c`.`repeat_d`, `c`.`repeat_m`, `c`.`repeat_y`, `c`.`repeat_by`, `c`.`object_subtype`, 0,
 IF (`c`.`assigned_to_user_id`> 0,
   (SELECT o.id FROM fo_objects o WHERE o.f1_id = c.assigned_to_user_id AND o.object_type_id = (SELECT `ot`.`id` FROM `fo_object_types` `ot` WHERE `ot`.`name`='contact')),
   (SELECT o.id FROM fo_objects o WHERE o.f1_id = c.assigned_to_company_id AND o.object_type_id = (SELECT `ot`.`id` FROM `fo_object_types` `ot` WHERE `ot`.`name`='company'))
 )
 FROM `og_project_tasks` `c`;

in 2_0_asado.php did help, everyhing does look fine in the DB right now, but still, tasks aren't displayed within my fengoffice frontend.
Anyone knows where to look for a solution?

Patribus

  • Freshman
  • *
  • Posts: 41
    • View Profile
Re: Error in 1.7.5 to 2.0 upgrade
« Reply #47 on: March 13, 2013, 03:23:01 PM »
Hello.

I just (almost!) upgraded form 1.7.5. to 2.2.3.1, but I'm stucked at one point.

I followed the instructions step by step given at  fengoffice. com/ web/wiki/doku. php /installation:migration#upgrading_from_1x_to_2x.

My first problem was, that the prefix of my DB-tables already were "fo_".  This comes from some instalation of a 1.7.x version of FEngOffice, where I spontanously decided to name the prfix like this.

So, the solution was to rename the prefix first with MYphpAdmin.

So I renamed them to (let's say) "ofo_" (to start with).

With the update procedure new tables with the "fo_" prefix  were generated.

When I arrive to point Nr. 8 of the update instructions, (running complete_migration.php) I have the following problems.

My server provider does not allow "sh" crons. So I cannot carry out the proposed run_complete_migration.sh script.

I can only carry out http/:[something]/[filename].php crons.

So, just to check, I carried out complete_migration.php from my browser window.

I get the message:

Code: [Select]
You already have upgraded to the latest possible version: 2.2.3.1

    Execution of 'Fill searchable objects and sharing table' completed.

The thing now is, that at a DB level nothing changes. At least I do not detect any changes. Opening the new FengOffice, I just see a fresh installation.

So my questions are:
What do I have to do, to finish the migration process?
How does the complete_migration.php routine take care of the new prefix of the old tables (I did try to rename them to "og_", but no change in the behavior).

Can someone help me on this?

Thanks
Patrick
« Last Edit: March 13, 2013, 03:33:27 PM by abanabanana »

 

anything
anything