[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