[SOLVED] Migration from 1.9.6 to 1.9.7

LATEST Official version.
Questions and discussions - NO ISSUES
FOR ISSUES => http://mantis.testlink.org

Moderators: Amaradana, TurboPT, TL Developers

Locked
VegaMan
TestLink user
Posts: 5
Joined: Mon Aug 12, 2013 10:34 am

[SOLVED] Migration from 1.9.6 to 1.9.7

Post 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?
fman
Member of TestLink Community
Posts: 3123
Joined: Tue Nov 15, 2005 7:19 am

Re: Migration from 1.9.6 to 1.9.7

Post 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
fman
Member of TestLink Community
Posts: 3123
Joined: Tue Nov 15, 2005 7:19 am

Re: Migration from 1.9.6 to 1.9.7

Post 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)
fman
Member of TestLink Community
Posts: 3123
Joined: Tue Nov 15, 2005 7:19 am

Re: Migration from 1.9.6 to 1.9.7

Post by fman »

hi, do you have any news ?
VegaMan
TestLink user
Posts: 5
Joined: Mon Aug 12, 2013 10:34 am

Re: Migration from 1.9.6 to 1.9.7

Post 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.....
Locked