2.0.1 to 2.5 Upgrade Issues

[clint]

From the support inbox. --Clint

-----Original Message-----
Sent: Friday, January 21, 2005 4:29 PM
To: support@sugarcrm.com
Subject: Possible BUG in Open 2.5 or its upgrade

Good Morning
I had a fully working 2.0.1 package.

I have taken the following steps ...

1.upgrade sql with 2.0.x-2.5_open_db_upgrade.sql using phpMyAdmin receiving a successful message 2. unzipped 2.5 into sugar root replacing existing files 3. ran install.php receiving the "green light" all the way ... no errors in other words 4. went to access sugarcrm either with known user or admin user and receive the following error in my browser

Error retrieving Task list: Query Failed:SELECT tasks.id, tasks.assigned_user_id, tasks.status, tasks.name, tasks.parent_type, tasks.parent_id, tasks.contact_id, tasks.date_due, tasks.time_due, tasks.priority, contacts.first_name, contacts.last_name, users.user_name as assigned_user_name FROM tasks LEFT JOIN contacts ON tasks.contact_id=contacts.id LEFT JOIN users ON tasks.assigned_user_id=users.id where tasks.assigned_user_id='1' and (tasks.status is NULL or (tasks.status!='Completed' and

tasks.status!='Deferred')) and (tasks.date_start is NULL or tasks.date_start <= '2005-01-22') AND tasks.deleted=0 AND ( contacts.deleted IS NULL OR contacts.deleted=0) GROUP BY tasks.id ORDER BY date_due,priority desc::MySQL error 1054: Unknown column 'tasks.date_start' in 'where clause'

What can I do to over come this?

Thanks in advance.

[clint]

Hi there -

A few issues with the 2.0.x to 2.5 upgrade scripts have been fixed today. We have posted both a new version of the 2.0.x-2.5_open_db_upgrade.sql file as well as a new upgrade patch file called 2.0.x-2.5_open_repairsf_db_upgrade.sql that will help people like you who used the earlier upgrade script that had issues.

You will find all of the necessary files at http://sourceforge.net/project/showf...kage_id=116411.

Please let us know if this solves your issues.

Regards,