Re: [gmod-cmap] Help: Duplicate entry problem

[Ben F. <fag...@gm...>]

Hi Amy,

My guess is that there is already a map in a different map set with the
accession "bgi2005-1".

That's the only thing that makes sense because if you were importing the
data into the same map set as the previous bgi2005-1, it would just add
the features to it.

Try the following sql query:

select map_set_name 
from cmap_map m, cmap_map_set ms
where m.map_acc="bgi2005-1" and m.map_set_id = ms.map_set_id

And see if that is the same map set as the one you are importing into.

Ben

On Fri, 2008-09-12 at 15:01 +0800, Lee Amy wrote:
> Hello,
> 
> It seems that I encounter this problem again though I have change the
> attributes and enlarge the values by using MySQL. I have enlarged
> every possible vaules as I think, but when I import data errors are
> showing by following words.
> 
> DBD::mysql::db do failed: Duplicate entry 'bgi2005-1' for key 2
> at /usr/lib/perl5/site_perl/5.8.8/Bio/GMOD/CMap/Data/Generic.pm line
> 3316, <GEN5> line 2904351.
> DBD::mysql::db do failed: Duplicate entry 'bgi2005-1' for key 2
> at /usr/lib/perl5/site_perl/5.8.8/Bio/GMOD/CMap/Data/Generic.pm line
> 3316, <GEN5> line 2904351.
> 
> There's a demo data I will paste here. The attachment I also provide
> the configuration file.
> 
> Could you tell me how to fix that?
> 
> Thanks in advance.
> 
> Regards,
> 
> Amy
> 
> 
> 
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________ gmod-cmap mailing list gmo...@li... https://lists.sourceforge.net/lists/listinfo/gmod-cmap