[SOLVED] problems to upgrade from version 1.9.3 to 1.9.8

[arielgott]

Hi,
First I want to thanks all the developers and testers that are contributes this phenomenal Test link open source project.
I have problems to upgrade from version 1.9.3 to version 1.9.8.
My Testlink is running on a VM running CentOS 6.2, PHP 5.3.3 , MYSQL 5.1.61 (my db name is testlink), Apache/2.2.15.
The steps I did for the upgrade after I backup all were:
1. download 1.9.8, uncompressed and rename the directory to tesetlink
2. copy old config_db.inc.php, config.inc.php and custom_config.inc.php to testlink directory
3. running the mysql script
[root@testLink html]# mysql -uroot -pXXX /var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql
ERROR 1102 (42000): Incorrect database name '/var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql'

I get this error no matter what i did.

can't find what my problem is.
please help,

[arielgott]

I've also try this way:
[root@testLink html]# mysql -uroot -pXXXX testlink < /var/www/html/testlink/install/sql/alter_tables/1.9.4/mysql/DB.1.5/step1/db_schema_update.sql
ERROR 1050 (42S01) at line 30: Table 'req_specs_revisions' already exists

and got another error

[arielgott]

ok,
I restart all the process:
1. load the VM from snapshot
2. download 1.9.8, uncompressed and rename the directory to tesetlink
3. copy old config_db.inc.php, config.inc.php and custom_config.inc.php to testlink directory
4. chomd -R for all the testlink directory
5. running the mysql scripts 1.9.3->1.9.4->1.9.7->1.9.8 ( mow it worked perfect for me. thanks)
6. delete cookies
now I get the following error in testlink login page:
==============================================================================

DB Access Error - debug_print_backtrace() OUTPUT START

==============================================================================

if you can help please do.
thanks

[arielgott]

BTW when I'm looking on the db_version table in MySQL I see that it is still display DB version 1.4 and not 1.9.8 as expected.

mysql> select * from db_version;
+---------+---------------------+-------------------+
| version | upgrade_ts | notes |
+---------+---------------------+-------------------+
| DB 1.4 | 2012-04-22 | TestLink 1.9.1 |
| | 13:59:41 | |
+---------+---------------------+-------------------+

[fman]

Right migration process is always the same

take your 1.9.3 , get 1.9.4 => upgrade and test
now start with your 1.9.4, get 1.9.5 => upgrade and test
now start with your 1.9.5, get 1.9.6 => upgrade and test
now start with your 1.9.6, get 1.9.7 => upgrade and test
now start with your 1.9.7, get 1.9.8 => upgrade and test

slow and long (not so long) but the safer path.
I've done an upgrade starting on 1.9.5 following this method without any issue
start with your 1.9.5, get 1.9.6 => upgrade and test
now start with your 1.9.6, get 1.9.7 => upgrade and test
now start with your 1.9.7, get 1.9.8 => upgrade and test

[arielgott]

I have problems to upgrade from 1.9.3 to 1.9.4 so I first delete a bunch of Builds and then I try again to upgrade from 1.9.3 to 1.9.8.
This time it was very fast and my DB seems to be upgraded to 1.9.8.
mysql> select * from db_version;
+----------+---------------------+----------------+
| version | upgrade_ts | notes |
+----------+---------------------+----------------+
| DB 1.4 | 2012-04-22 13:59:41 | TestLink 1.9.1 |
| DB 1.5 | 2013-11-13 11:03:51 | TestLink 1.9.4 |
| DB 1.9.8 | 2013-11-13 11:04:59 | TestLink 1.9.8 |
+----------+---------------------+----------------+

Unfortunately I can't login now to the Testlink from the login.php page I see only the message "Please log in..." .
I try to connect using the linkto.php instead of login.php and I'm in !!! I can do everything in Testlink, I'm with the right user name and can see all the history. I have only one problem, The Desktop link return me back to index.php and I have to reconnect again using linkto.php
So what is wrong with my login screen and how can I fix it.
One thing is different, I left the installation directory name testlink-1.9.8 and didn't change it to testlink.

Thanks

[arielgott]

can anyone help?
Thanks

[arielgott]

solved.
I followed fman suggestion to migrate version after version.
In the first shot it didn't work, we got the same errors on DB. Then we disabled the SE Linux and we did the whole process again successfully.