Upgrade

[gaboudiwan]

Dear, how can I upgrade from 1 version to a newer one?

[madhusanka]

For 2.7 an upgrader will be released.

[pickseed]

I just tried running the built in upgrader to upgrade from 2.5.6 to 2.7 and the process fails immediately with the following error:


2012-May-01 19:35:24 : MySQL Error: Error on rename of '.\ohrm_upgrade\hs_hr_emp_basicsalary' to '.\ohrm_upgrade\#sql2-e4c-47' (errno: 152).
Query: ALTER TABLE `hs_hr_emp_basicsalary`
DROP FOREIGN KEY `hs_hr_emp_basicsalary_ibfk_2`
2012-May-01 19:35:25 : MySQL Error: Error on rename of '.\ohrm_upgrade\hs_pr_salary_currency_detail' to '.\ohrm_upgrade\#sql2-e4c-47' (errno: 152).
Query: ALTER TABLE `hs_pr_salary_currency_detail`
DROP FOREIGN KEY `hs_pr_salary_currency_detail_ibfk_1`

My environment is:
Apache 2.2.6
PHP 5.2.5
MySQL 5.0.45

Any help would be much appreciated.

[Gayanath]

Hi, 2.7 built-in upgrader only support versions up to 2.6.5. In the upgrader, it's clearly mentioned that you have to select a version from the available list and else there will be an error.

[pickseed]

Hi, 2.7 built-in upgrader only support versions up to 2.6.5. In the upgrader, it's clearly mentioned that you have to select a version from the available list and else there will be an error.

Sorry, that was a typo on my part. We are running 2.6.5.

[Gayanath]

At which step do you get the error? Did you provide a copy of your current database properly as mentioned in first step? Can you post the full error log?