Page 1 of 1
[SOLVED] Migration from 1.9.6 to 1.9.7
Posted: Mon Aug 12, 2013 10:49 am
by VegaMan
I want to migrate from version 1.9.6 to 1.9.7. There were no alter tables in the install directory, so i thought that no changes in database are required. But when I start Testlink in the Browser, he shows the new version 1.9.7 but informs me that a change of database (manually) is required. Are there some Update-Scripst for MySql? I have also looked in the database version Table and the latest version is 1.9.6 so I Think, i have done all table updates in the past. Does anybody have the same probleme and can help me?
Re: Migration from 1.9.6 to 1.9.7
Posted: Mon Aug 12, 2013 1:13 pm
by fman
Just done following test
1. get 1.9.6 from sourceforge
2. get 1.9.7 from sourceforge
3. unpack 1.9.6 and run installer
4. login and create 1 test project
5. unpack 1.9.7 on a new different folder
6. copy config_db* file created by 1.9.6 installation on 1.9.7 installation folder
7. try to login to 1.9.7 => get no message regarding DB UPGRADE.
But anyway you have to follow instructions as described in 1.9.7 README
- Upgrade from 1.9.4/5 to 1.9.7
WARNING: if you are using a table prefix replace /*prefix*/ with your prefix
a) Execute install/sql/alter_tables/1.9.6/<your_db>/DB.1.6/step1/db_schema_update.sql
b) Execute install/sql/alter_tables/1.9.6/<your_db>/DB.1.6/stepZ/z_final_step.sql
on README file present on 1.9.7 DISTRIBUTION
- Upgrade from 1.9.4/5 to 1.9.7
WARNING: if you are using a table prefix replace /*prefix*/ with your prefix
a) Execute install/sql/alter_tables/1.9.6/<your_db>/DB.1.6/step1/db_schema_update.sql
b) Execute install/sql/alter_tables/1.9.6/<your_db>/DB.1.6/stepZ/z_final_step.sql
Re: Migration from 1.9.6 to 1.9.7
Posted: Mon Aug 12, 2013 1:15 pm
by fman
Please also give a look to 1.9.7 latest fixes, after you have installed it without issues, because there are some records to add on rights table.(details on mantis)
Re: Migration from 1.9.6 to 1.9.7
Posted: Tue Aug 13, 2013 4:55 pm
by fman
hi, do you have any news ?
Re: Migration from 1.9.6 to 1.9.7
Posted: Wed Aug 14, 2013 7:02 am
by VegaMan
Thanks for your help!
It seemed a problem with my config_db* file. After I copied the file again from my backup directory, it works fine.
I don't know what was wrong with the first copy of the file.
It works.....