On 13 Feb 2007, at 18:18, seth redmond wrote:
Sorry if this is something obvious, but I keep running into a 'no
usable tables' error when I'm trying to do a naive build. I've pared
the database back to just two tables but still can't get a naive build
started.
Is there any way to, eg, get the DB calls back from marteditor so I
can see what's going on? Or is there a verbose mode I've missed?
-s
P.S. I've tried this with a number of tables, BTW but for an example
of one which doesn't work, the following are the ones I'm using now:
snr02[vbmart_01_3]> show create table vb__reporter__main\G show create
table vb__reporter_meta__dm \G
*************************** 1. row ***************************
Table: vb__reporter__main
Create Table: CREATE TABLE `vb__reporter__main` (
`reporter_id_key` varchar(40) NOT NULL,
`reporter_type_list` varchar(50) default NULL,
PRIMARY KEY (`reporter_id_key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
1 row in set (0.00 sec)
*************************** 1. row ***************************
Table: vb__reporter_meta__dm
Create Table: CREATE TABLE `vb__reporter_meta__dm` (
`reporter_id_key` varchar(40) NOT NULL,
`mapping_bool` tinyint(1) default '0',
`transcript_bool` tinyint(1) default '0',
`unique_transcript_bool` tinyint(1) default '0',
`experiment_bool` tinyint(1) default '0',
KEY `reporter_id_key` (`reporter_id_key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
1 row in set (0.00 sec)
Hi Seth,
this is because you need to have at least one record in your main table.
Try something like this for example:
mysql> insert into vb__reporter__main values ('blue', 'blue');
It should work now. I agree that the error message there is not very
informative
a.
------------------------------------------------------------------------
-------
Arek Kasprzyk
EMBL-European Bioinformatics Institute.
Wellcome Trust Genome Campus, Hinxton,
Cambridge CB10 1SD, UK.
Tel: +44-(0)1223-494606
Fax: +44-(0)1223-494468
------------------------------------------------------------------------
-------
