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

1.8 related questions and discussions.
Please upgrade to LATEST 1.9.x.
No more fixes for 1.8.

Moderators: Amaradana, TurboPT, TL Developers

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

Postby tina » Wed Apr 01, 2009 7:57 am

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.
tina
TestLink user
 
Posts: 3
Joined: Wed Apr 01, 2009 7:54 am

Postby Amaradana » Wed Apr 01, 2009 12:27 pm

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.
Amaradana
Member of TestLink Community
 
Posts: 398
Joined: Mon Feb 16, 2009 11:19 am

Postby tina » Thu Apr 02, 2009 1:34 am

Hi,
These message were not shown in migrating process.
I upgraded database then did the migration.
tina
TestLink user
 
Posts: 3
Joined: Wed Apr 01, 2009 7:54 am

Postby havlatm » Thu Apr 02, 2009 11:16 am

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.
havlatm
Member of TestLink Community
 
Posts: 940
Joined: Mon Oct 31, 2005 1:24 am
Location: Czech

Postby tina » Fri Apr 03, 2009 6:03 am

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!!!
tina
TestLink user
 
Posts: 3
Joined: Wed Apr 01, 2009 7:54 am


Return to TestLink 1.8 (OBSOLETE => EOL)[LOCKED]



Who is online

Users browsing this forum: No registered users and 2 guests