Upgrade from 1.8 to 1.9 Table does not exist

[fyl]

I am attempting to upgrade from 1.8 to 1.9.
Databse: Mysql 5.1
System requirements
Server Operating System (no constrains) Linux
PHP version OK ( 5.2.0 [minimum version] <= 5.3.0 [your version] )
Web and PHP configuration
Maximum Session Idle Time before Timeout 240 minutes and 0 seconds - (OK)
Checking max. execution time (Parameter max_execution_time) OK (120 seconds)
Checking maximal allowed memory (Parameter memory_limit) OK (128 MegaBytes)
Checking if Register Globals is disabled OK
Checking MySQL Database OK
Checking Postgres Database Failed! Postgres Database cannot be used.
Checking GD Graphic library OK
Checking LDAP library Failed! LDAP library not enabled. LDAP authentication cannot be used. (default internal authentication will works).
Checking JSON library OK
Read/write permissions
Checking if /usr/local/httpd/htdocs/testlink/gui/templates_c directory exists OK
Checking if /usr/local/httpd/htdocs/testlink/gui/templates_c directory is writable OK
Checking if /usr/local/httpd/htdocs/testlink/logs directory exists OK
Checking if /usr/local/httpd/htdocs/testlink/logs directory is writable OK
Checking if /usr/local/httpd/htdocs/testlink/upload_area directory exists OK
Checking if /usr/local/httpd/htdocs/testlink/upload_area directory is writable OK


Your system is prepared for TestLink configuration (no fatal problem found).

TestLink setup will now attempt to setup the database:

Creating connection to Database Server: OK!


Connecting to database `testlink`: OK!

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

DB Access Error - debug_print_backtrace() OUTPUT START

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

#0 database->exec_query(SELECT * FROM DB_TABLE_PREFIXdb_version ORDER BY upgrade_ts DESC) called at [/usr/local/httpd/htdocs/testlink/install/installNewDB.php:305]

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

Database ERROR:Table 'testlink.DB_TABLE_PREFIXdb_version' doesn't exist

I can not proceed and have been stuck at this point for almost two months.

[fman]

details here data you have provided when system has requested DB configuration, ALL fields please

[fyl]

I attached the actual error message above. Here are all of the tables in the database.
TABLE_NAME
assignment_status
assignment_types
attachments
builds
cfield_design_values
cfield_execution_values
cfield_node_types
cfield_testplan_design_values
cfield_testprojects
custom_fields
db_version
events
execution_bugs
executions
keywords
milestones
node_types
nodes_hierarchy
object_keywords
req_coverage
req_specs
requirements
rights
risk_assignments
role_rights
roles
tcversions
testcase_keywords
testplan_tcversions
testplans
testprojects
testsuites
text_templates
transactions
user_assignments
user_group
user_group_assign
user_testplan_roles
user_testproject_roles
users

When you are asking for "All fields please" what do you mean by this? SOrry...

[fman]

what you have entered on screen used to do upgrade

[fyl]

Is there a way to attach screen shots?

[fyl]

Screen: Testlink 1.9 (Prague) Installation
- Upgrade from 1.8.x version to 1.9.x
Screen: Testlink 1.9 (Prague) - Upgrade
- Acceptance of LIcense
-- "I agree to the terms set out in this license"
-Verification of System and configuration requirements (Results posted above)
-Definition of DB access
--Database Type : MySQL (5.0 and later)
--Database Host: localhost:3306
--Database name: testlink
--Table prefix: (blank)
--Database admin login: root
--Database admin password: the root password
--Testlink DB login: _admin
--Testlink DB password: _admin password


Results----
TestLink setup will now attempt to setup the database:

Creating connection to Database Server: OK!


Connecting to database `testlink`: OK!

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

DB Access Error - debug_print_backtrace() OUTPUT START

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

#0 database->exec_query(SELECT * FROM DB_TABLE_PREFIXdb_version ORDER BY upgrade_ts DESC) called at [/usr/local/httpd/htdocs/testlink/install/installNewDB.php:305]

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

Database ERROR:Table 'testlink.DB_TABLE_PREFIXdb_version' doesn't exist

[fman]

very strange
Please do the following or check if you have done this

1. create A NEW directory for 1.9
2. clean up cookies and cache of your browser
3. uncompress teslink 1.9.0 on new created folder
4. run upgrade

[fyl]

Ok. I have done this.

I now get:
TestLink setup will now attempt to setup the database:

Creating connection to Database Server: OK!


Connecting to database `testlink`: OK!
Creating Testlink DB user `_admin`: OK! (ok - user_exists ok - grant assignment)
Processing:sql/alter_tables/1.9/mysql/DB.1.3/step1/db_schema_update.sql
migrate_testcases


I am assuming this will take some time.

[fyl]

Here are the privileges for "_admin"

mysql> show privileges;
+-------------------------+---------------------------------------+-------------------------------------------------------+
| Privilege | Context | Comment |
+-------------------------+---------------------------------------+-------------------------------------------------------+
| Alter | Tables | To alter the table |
| Alter routine | Functions,Procedures | To alter or drop stored functions/procedures |
| Create | Databases,Tables,Indexes | To create new databases and tables |
| Create routine | Functions,Procedures | To use CREATE FUNCTION/PROCEDURE |
| Create temporary tables | Databases | To use CREATE TEMPORARY TABLE |
| Create view | Tables | To create new views |
| Create user | Server Admin | To create new users |
| Delete | Tables | To delete existing rows |
| Drop | Databases,Tables | To drop databases, tables, and views |
| Event | Server Admin | To create, alter, drop and execute events |
| Execute | Functions,Procedures | To execute stored routines |
| File | File access on server | To read and write files on the server |
| Grant option | Databases,Tables,Functions,Procedures | To give to other users those privileges you possess |
| Index | Tables | To create or drop indexes |
| Insert | Tables | To insert data into tables |
| Lock tables | Databases | To use LOCK TABLES (together with SELECT privilege) |
| Process | Server Admin | To view the plain text of currently executing queries |
| References | Databases,Tables | To have references on tables |
| Reload | Server Admin | To reload or refresh tables, logs and privileges |
| Replication client | Server Admin | To ask where the slave or master servers are |
| Replication slave | Server Admin | To read binary log events from the master |
| Select | Tables | To retrieve rows from table |
| Show databases | Server Admin | To see all databases with SHOW DATABASES |
| Show view | Tables | To see views with SHOW CREATE VIEW |
| Shutdown | Server Admin | To shut down the server |
| Super | Server Admin | To use KILL thread, SET GLOBAL, CHANGE MASTER, etc. |
| Trigger | Tables | To use triggers |
| Update | Tables | To update existing rows |
| Usage | Server Admin | No privileges - allow connect only |
+-------------------------+---------------------------------------+-------------------------------------------------------+
29 rows in set (0.00 sec)

[fyl]

Further information: I can do a standalone installation with out any error. The issue lies with upgrading.

[mrkazgan]

I am having the same issue myself...

[fyl]

Version 1.9.1 does a better job of upgrading from 1.8. I would recommend that you use that build instead.