I am using testlink 1.7.4 for our project. Then i have upgraded to 1.8.Rc1, Login page is displayed with the following error message
[
ERROR ON exec_query() - database.class.php
1054 - Unknown column 'script_key' in 'field list' - SELECT id,login,password,first,last,email,role_id,locale, login AS fullname, active,default_testproject_id, script_key FROM users WHERE login = 'admin'
THE MESSAGE :: SQL [3] executed [took 0.3423 secs][all took 0.7221 secs]: SELECT id,login,password,first,last,email,role_id,locale, login AS fullname, active,default_testproject_id, script_key FROM users WHERE login = 'admin' Query failed: errorcode[1054] errormsg:Unknown column 'script_key' in 'field list'
ERROR ON exec_query() - database.class.php
1146 - Table 'testlink.events' doesn't exist - DELETE FROM events WHERE fired_at < 1230010681 ORDER BY transaction_id DESC,fired_at DESC
THE MESSAGE :: SQL [6] executed [took 0.0007 secs][all took 2.3773 secs]: DELETE FROM events WHERE fired_at < 1230010681 ORDER BY transaction_id DESC,fired_at DESC Query failed: errorcode[1146] errormsg:Table 'testlink.events' doesn't exist
ERROR ON exec_query() - database.class.php
1146 - Table 'testlink.transactions' doesn't exist - SELECT id FROM transactions t WHERE (SELECT COUNT(*) FROM events e WHERE e.transaction_id = t.id) = 0
THE MESSAGE :: SQL [7] executed [took 0.0507 secs][all took 2.4287 secs]: SELECT id FROM transactions t WHERE (SELECT COUNT(*) FROM events e WHERE e.transaction_id = t.id) = 0 Query failed: errorcode[1146] errormsg:Table 'testlink.transactions' doesn't exist
]
I couldn't login to Testlink, showing message "Wrong user name & password". I have done the following steps for upgrade
1. 1.7.4 testlink folder is deleted from Esay PHP www folder
2. Copied the 1.8 RC1 in to Esay PHP www folder
3. config_db.inc.php & custom_config.inc.php files were modified
4. Restart the PHP service
5. Entered in to Locale web
6. Getting the above Error message
Please help me on this......
Subha