[DAS] LDAS fattribute error...
jfreeman
jfreeman@variagenics.com
Thu, 28 Feb 2002 13:43:16 -0500
Hi,
I have the following enclosed from a LDAS server (LDasServer-1.04) I
have set up, the request for the fattribute table seems to be in error.
When I built the dicty test database the tables are only as shown:
mysql> use dicty
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables from dicty
-> ;
+-----------------+
| Tables_in_dicty |
+-----------------+
| fdata |
| fdna |
| fgroup |
| fnote |
| ftype |
+-----------------+
5 rows in set (0.00 sec)
There isn't and fattributes table in dicty, nor in my test database,
does anyone know what I have done wrong?
Thanks,
Jim Freeman
Senior Scientist
Variagenics, Inc.
(From a cold and windy Massachusetts, not sunny south africa :()
--------------------------------------
------------- EXCEPTION -------------
MSG: Couldn't execute query SELECT fref,
IF(ISNULL(gclass),'Sequence',gclass),
min(fstart),
max(fstop),
fstrand,
gname
FROM fdata,fgroup,fattribute,fattribute_to_feature
WHERE fattribute_to_feature.fattribute_value=?
AND fgroup.gclass=?
AND fgroup.gid=fdata.gid
AND fattribute.fattribute_name='Alias'
AND
fattribute_to_feature.fattribute_id=fattribute.fattribute_id
AND fattribute_to_feature.fid=fdata.fid
GROUP BY fref,fstrand
:
Table 'testing.fattribute' doesn't exist
STACK
Bio::DB::GFF::Adaptor::dbi::caching_handle::do_query
/usr/lib/perl5/site_p
erl/5.6.0/Bio/DB/GFF/Adaptor/dbi/caching_handle.pm:129
STACK Bio::DB::GFF::Adaptor::dbi::mysql::get_abscoords
/usr/lib/perl5/site_perl/
5.6.0/Bio/DB/GFF/Adaptor/dbi/mysql.pm:349
STACK Bio::DB::GFF::abscoords
/usr/lib/perl5/site_perl/5.6.0/Bio/DB/GFF.pm:1708
STACK Bio::DB::GFF::RelSegment::new
/usr/lib/perl5/site_perl/5.6.0/Bio/DB/GFF/Re
lSegment.pm:241
STACK Bio::DB::GFF::segment
/usr/lib/perl5/site_perl/5.6.0/Bio/DB/GFF.pm:734
STACK main::get_segment_obj
/usr/local/apache/cgi-bin/das:741
STACK main::features /usr/local/apache/cgi-bin/das:225
STACK toplevel /usr/local/apache/cgi-bin/das:60