Page 1 of 1

It shows error message in login page after I migrated ver.

PostPosted: Wed Apr 01, 2009 7:57 am
by tina
ERROR ON exec_query() - database.class.php
1146 - Table 'testlink.events' doesn't exist - DELETE FROM events WHERE fired_at < 1235979673

THE MESSAGE :: SQL [9] executed [took 0.0006 secs][all took 0.0148 secs]: DELETE FROM events WHERE fired_at < 1235979673 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 [10] executed [took 0.0005 secs][all took 0.0159 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


And when I try to login testlink, it enters an empty page.
-----------------------------------------------------------------------
What should I do now?
Please help.

PostPosted: Wed Apr 01, 2009 12:27 pm
by Amaradana
Can you please give few more details. is this meesage occured while installing test link? if so please give the requiresd steps what you had done.

PostPosted: Thu Apr 02, 2009 1:34 am
by tina
Hi,
These message were not shown in migrating process.
I upgraded database then did the migration.

PostPosted: Thu Apr 02, 2009 11:16 am
by havlatm
Your migration seems wrong. Did you migrate from 1.7.x to 1.8.0?
Verify why the table events is missing in your DB. You should deliver more information if you expect a help.

PostPosted: Fri Apr 03, 2009 6:03 am
by tina
Hi,
I copy the error code from upgrade database as below:
-------------------------------------------------------------------
TestLink setup will now attempt to setup the database:

Creating connection to Database Server: OK!

Checking MySQL version: OK! (5.0.41 >= 4.1.0)


Connecting to database `testlink`: OK!
Creating Testlink DB user `root`: OK! (ok - user_exists ok - grant assignment)
Processing:sql/alter_tables/1.8/mysql/DB.1.2/db_schema_update.sqlERROR ON exec_query() - database.class.php
1005 - Can't create table '.\testlink\events.frm' (errno: 121) - /* Step 2 - new tables */ CREATE TABLE `events` ( `id` int(10) unsigned NOT NULL auto_increment, `transaction_id` int(10) unsigned NOT NULL default '0', `log_level` smallint(5) unsigned NOT NULL default '0', `source` varchar(45) default NULL, `description` text NOT NULL, `fired_at` int(10) unsigned NOT NULL default '0', `activity` varchar(45) default NULL, `object_id` int(10) unsigned default NULL, `object_type` varchar(45) default NULL, PRIMARY KEY (`id`), KEY `transaction_id` (`transaction_id`), KEY `fired_at` (`fired_at`) ) DEFAULT CHARSET=utf8

THE MESSAGE :: SQL [9] executed [took 0.0894 secs][all took 0.1482 secs]: /* Step 2 - new tables */ CREATE TABLE `events` ( `id` int(10) unsigned NOT NULL auto_increment, `transaction_id` int(10) unsigned NOT NULL default '0', `log_level` smallint(5) unsigned NOT NULL default '0', `source` varchar(45) default NULL, `description` text NOT NULL, `fired_at` int(10) unsigned NOT NULL default '0', `activity` varchar(45) default NULL, `object_id` int(10) unsigned default NULL, `object_type` varchar(45) default NULL, PRIMARY KEY (`id`), KEY `transaction_id` (`transaction_id`), KEY `fired_at` (`fired_at`) ) DEFAULT CHARSET=utf8 Query failed: errorcode[1005] errormsg:Can't create table '.\testlink\events.frm' (errno: 121)
ERROR ON exec_query() - database.class.php
1005 - Can't create table '.\testlink\transactions.frm' (errno: 121) - CREATE TABLE transactions ( id int(10) unsigned NOT NULL auto_increment, entry_point varchar(45) NOT NULL default '', start_time int(10) unsigned NOT NULL default '0', end_time int(10) unsigned NOT NULL default '0', user_id int(10) unsigned NOT NULL default '0', session_id varchar(45) default NULL, PRIMARY KEY (id) ) DEFAULT CHARSET=utf8

THE MESSAGE :: SQL [10] executed [took 0.0455 secs][all took 0.2831 secs]: CREATE TABLE transactions ( id int(10) unsigned NOT NULL auto_increment, entry_point varchar(45) NOT NULL default '', start_time int(10) unsigned NOT NULL default '0', end_time int(10) unsigned NOT NULL default '0', user_id int(10) unsigned NOT NULL default '0', session_id varchar(45) default NULL, PRIMARY KEY (id) ) DEFAULT CHARSET=utf8 Query failed: errorcode[1005] errormsg:Can't create table '.\testlink\transactions.frm' (errno: 121)
ERROR ON exec_query() - database.class.php
1005 - Can't create table '.\testlink\text_templates.frm' (errno: 121) - CREATE TABLE text_templates ( id int(10) unsigned NOT NULL, tpl_type smallint(5) unsigned NOT NULL, title varchar(100) NOT NULL, template_data text, author_id int(10) unsigned default NULL, creation_ts datetime NOT NULL default '1900-00-00 01:00:00', is_public tinyint(1) NOT NULL default '0', UNIQUE KEY idx_text_templates (tpl_type,title) ) DEFAULT CHARSET=utf8 COMMENT='Global Project Templates'

THE MESSAGE :: SQL [11] executed [took 0.0310 secs][all took 0.3596 secs]: CREATE TABLE text_templates ( id int(10) unsigned NOT NULL, tpl_type smallint(5) unsigned NOT NULL, title varchar(100) NOT NULL, template_data text, author_id int(10) unsigned default NULL, creation_ts datetime NOT NULL default '1900-00-00 01:00:00', is_public tinyint(1) NOT NULL default '0', UNIQUE KEY idx_text_templates (tpl_type,title) ) DEFAULT CHARSET=utf8 COMMENT='Global Project Templates' Query failed: errorcode[1005] errormsg:Can't create table '.\testlink\text_templates.frm' (errno: 121)
ERROR ON exec_query() - database.class.php
1005 - Can't create table '.\testlink\user_group.frm' (errno: 121) - CREATE TABLE user_group ( id int(10) unsigned NOT NULL, title varchar(100) NOT NULL, description text, owner_id int(10) unsigned NOT NULL, testproject_id int(10) unsigned NOT NULL, UNIQUE KEY (title) ) DEFAULT CHARSET=utf8

THE MESSAGE :: SQL [12] executed [took 0.0375 secs][all took 0.4281 secs]: CREATE TABLE user_group ( id int(10) unsigned NOT NULL, title varchar(100) NOT NULL, description text, owner_id int(10) unsigned NOT NULL, testproject_id int(10) unsigned NOT NULL, UNIQUE KEY (title) ) DEFAULT CHARSET=utf8 Query failed: errorcode[1005] errormsg:Can't create table '.\testlink\user_group.frm' (errno: 121)
ERROR ON exec_query() - database.class.php
1005 - Can't create table '.\testlink\cfield_testplan_design_values.frm' (errno: 121) - CREATE TABLE `cfield_testplan_design_values` ( field_id int(10) NOT NULL default '0', link_id int(10) NOT NULL default '0' COMMENT 'point to testplan_tcversion id', value varchar(255) NOT NULL default '', PRIMARY KEY (`field_id`,`link_id`), KEY `idx_cfield_tplan_design_val` (`link_id`) ) DEFAULT CHARSET=utf8

THE MESSAGE :: SQL [14] executed [took 0.0345 secs][all took 0.5803 secs]: CREATE TABLE `cfield_testplan_design_values` ( field_id int(10) NOT NULL default '0', link_id int(10) NOT NULL default '0' COMMENT 'point to testplan_tcversion id', value varchar(255) NOT NULL default '', PRIMARY KEY (`field_id`,`link_id`), KEY `idx_cfield_tplan_design_val` (`link_id`) ) DEFAULT CHARSET=utf8 Query failed: errorcode[1005] errormsg:Can't create table '.\testlink\cfield_testplan_design_values.frm' (errno: 121)

Processing:sql/alter_tables/1.8/mysql/DB.1.2/z_final_step.sql
Failed! - Upgrade failed!

TestLink setup couldn't install the default site into the selected database. The last error to occur was Can't create table '.\testlink\cfield_testplan_design_values.frm' (errno: 121) during the execution of SQL statement CREATE TABLE `cfield_testplan_design_values` ( field_id int(10) NOT NULL default '0', link_id int(10) NOT NULL default '0' COMMENT 'point to testplan_tcversion id', value varchar(255) NOT NULL default '', PRIMARY KEY (`field_id`,`link_id`), KEY `idx_cfield_tplan_design_val` (`link_id`) ) DEFAULT CHARSET=utf8
---------------------------------------------------------------------------
Please help~~
Thanks you so much!!!