Unknown Schema version DB 1.6, please upgrade your Testlink

[dbrossard]

All, I upgrade testlink today from 1.9.7 to 1.9.8. Untarred the files into a new directory and then copied over my working config.inc.php & config_db.inc.php from 1.9.7. According to the README the next steps are:
- Launch TestLink
- TestLink will check Database version, and if some upgrade/migration
is needed will launch automatically the installer.

However when I go to my web page I am unable to login and see an error that states:
"Unknown Schema version DB 1.6, please upgrade your Testlink".

Indeed if I look at my version in Postgres it does not have the new Schema:

Code: Select all

postgres@jira-test:~$ psql testlink
psql (8.4.17)
Type "help" for help.

testlink=# select * from db_version;
 version |        upgrade_ts         |     notes      
---------+---------------------------+----------------
 DB 1.6  | 2013-08-05 22:19:40.02702 | TestLink 1.9.6
(1 row)

I never had TestLink 1.9.6 installed so I assume 1.9.7 used the previous schema.
How do I upgrade the DB scheme. As mentioned I am on Postgres.

Thanks

[fman]

0. we are avoiding any kind of automatic processing of update on installer, may be wrong info is still insider README.

1. give a look to [TLINSTALLDIR]/install/sql/postgres/
there you are going to find the FRESH INSTALL scripts, and will find what is the DB version is expected to be on 1.9.8

2. you can also give a look to [TLINSTALLDIR]/install/sql/alter_tables/1.9.8/postgres
Do a backup of your 1.9.7 DB, and the apply manually these scripts.

3. give a look to other sections of this forum and also on http://mantis.testlink.org, searching for similar upgrade issues.

4. After succesful update, continue your upgrade to 1.9.9 with latest fixes.