1,423
edits
Changes
Partial page redesign
{{header_en|title=VtigerCRM version upgrade| keyword={{Template:keyword_en_vtigercrm}}| description=A brief guide to upgrading VtigerCRM 5 version | link_page=vtigercrm_aggiornamento_di_versione}}
== 5.1.0 ⇒ 5.2.1 ==
== 5.1.0 ⇒ 5.2.1 ==
Below you'll find the procedure I followed to update '''VtigerCrm''' release 5.1.0 to more recent 5.2.1.
Below you'll find the procedure I followed to update '''VtigerCRM''' release 5.1.0 to more recent 5.2.1.
* Make a full back-up of release 5.1.0 database.
* Make a full back-up of release 5.1.0 database.
* Create a new empty database dedicated to release 5.2.1. Use standard SQL command '''"CREATE DATABASE''' ''<database_name>'' ''';"''' to perform the task. Please refer to the documentation for your installed '''MySql''' release for the correct syntax and a more detailed description of the command.
* Create a new empty database dedicated to release 5.2.1. Use standard SQL command '''"CREATE DATABASE''' ''<database_name>'' ''';"''' to perform the task. Please refer to the documentation for your installed '''MySql''' release for the correct syntax and a more detailed description of the command.
* Recover release 5.1.0 back-up on the 5.2.1 empty database overwriting it.
* Recover release 5.1.0 back-up on the 5.2.1 empty database overwriting it.
* Grant to release 5.1.0 '''admin''' user root access to the database for release 5.2.1. The user should be authorized to connect and perform administrative tasks on both databases.
* Grant to release 5.1.0 '''admin''' user root access to the database for release 5.2.1. The user should be authorized to connect and perform administrative tasks on both databases.
* Run the data conversion process through VtigerCrm 5.2.1 installer program.
* Run the data conversion process through VtigerCRM 5.2.1 installer program.
* '''MyIsam''' formatted tables will be translated into '''InnoDb''' format as part of the conversion. Some of the tables could trigger an installer error. In case of problems delete the error inducing tables and later import them directly from the back-up file. Use SQL command: '''"DROP TABLE''' ''<table_name>'' ''';"''' to remove tricky tables.
* '''MyIsam''' formatted tables will be translated into '''InnoDb''' format as part of the conversion. Some of the tables could trigger an installer error. In case of problems delete the error inducing tables and later import them directly from the back-up file. Use SQL command: '''"DROP TABLE''' ''<table_name>'' ''';"''' to remove tricky tables.
: ''vtiger_usermanualcontents''
: ''vtiger_usermanualcontents''
:: Disable the flag and the table should be converted smoothly. Flag can be disabled issuing a SQL command or through a graphical interface connected to release 5.2.1 database.
:: Disable the flag and the table should be converted smoothly. Flag can be disabled issuing a SQL command or through a graphical interface connected to release 5.2.1 database.
* Complete table conversion and the remaining part of the update process run by the 5.2.1 package installer.
* Complete table conversion and the remaining part of the update process run by the 5.2.1 package installer.
* Create eventually deleted tables and load data recurring to '''VtigerCrm''' release 5.1.0 back-up file as the data source.
* Create eventually deleted tables and load data recurring to '''VtigerCRM''' release 5.1.0 back-up file as the data source.
After update completion, point your Web Browser to the usual URL to access release 5.2.1 of the CRM.
After update completion, point your Web Browser to the usual URL to access release 5.2.1 of the CRM.
* [http://dev.mysql.com/doc/refman/5.1/en/create-database.html CREATE DATABASE command]
* [http://dev.mysql.com/doc/refman/5.1/en/create-database.html CREATE DATABASE command]
* [http://dev.mysql.com/doc/refman/5.1/en/drop-table.html DROP TABLE command]
* [http://dev.mysql.com/doc/refman/5.1/en/drop-table.html DROP TABLE command]
----
----
{{footer_en | link_page=vtigercrm_aggiornamento_di_versione}}