Upgrade v5.5 to v6.1

[caffeineborg]

Good Day,

Working on a new customer's SugarCRM installation to perform some enhancements.

Task #1 was to upgrade to v6.1 (stopping there now as some reporting model version requirements ...).

This post is being made as I encountered an error


Query Failed:ALTER TABLE project_task modify column id char(36) NOT NULL , modify column date_entered datetime NULL , modify column date_modified datetime NULL , modify column project_task_id int(11) NULL , modify column name varchar(50) NULL , add column status varchar(255) NULL , modify column time_start int(11) NULL , modify column duration int(11) NULL , modify column duration_unit text NULL , modify column assigned_user_id char(36) NULL , modify column modified_user_id char(36) NULL , modify column created_by char(36) NULL , add column order_number int(11) DEFAULT '1' NULL , add column task_number int(11) NULL , add column estimated_effort int(11) NULL , modify column deleted bool DEFAULT '0' NULL , add column utilization int(11) DEFAULT '100' NULL ::MySQL error 1265: Data truncated for column 'time_start' at row 1


## I updated to:

ALTER TABLE project_task modify column id char(36) NOT NULL , modify column date_entered datetime NULL , modify column date_modified datetime NULL , modify column project_task_id int(11) NULL , modify column name varchar(50) NULL , add column status varchar(255) NULL , modify column duration int(11) NULL , modify column duration_unit text NULL , modify column assigned_user_id char(36) NULL , modify column modified_user_id char(36) NULL , modify column created_by char(36) NULL , add column order_number int(11) DEFAULT '1' NULL , add column task_number int(11) NULL , add column estimated_effort int(11) NULL , modify column deleted bool DEFAULT '0' NULL , add column utilization int(11) DEFAULT '100' NULL

This runs.

I had an issue after the upgrade. Before and after I ran the updated SQL into the project task table:

I am getting an error when I try to create or update a Task with dates. Here is an example:

Start Date(01-20-2012 02.15am) is not before 01-22-2012 10.15pm

Now I believe that 01-20-2012 02.15am is before 01-22-2012 10.15pm

My thought is that some thing in the upgrade when wrong. I am digging in the forums.

Any help will be appreciated.

[caffeineborg]

new entry below for improved readability

[caffeineborg]

UPDATE from my work yesterday ...

It seems to be some form of a race condition on the SugarCRM software versions and versions of PHP.

The upgrade v5.2.0c to v5.5.1 went smooth (it did thefirst time as well).

The change this time was to upgrade the PHP from the initial v5.2.n to v5.3.9 after the SugarCRM upgrade to v5.5.1.

Then the upgrade of SugarCRM to v6.1 succeeded.

I hope this helps. (now am on to search enhancements). Let me know if I need to add more details or if this helps.

Thanks

Not sure if this is due to the client being on a windows platform. I mention that here, in part, to add additional details to the thread.


Another piece of information: The v5.2.0c was an upgrade from 4.x versions.