[Gmod-help] Re: [gmod-cmap] Help: Duplicate Problem

[Ben Faga]

Hi Amy,

I'm sure you have this figured out already.  My gut reaction is that
Dave is right (although the query I would use to test it would be more
like "select * from cmap_map where map_acc='licy2001a1'".

Was this the problem?  Did removing the previously entered maps help?

Ben

On Thu, 2008-10-09 at 09:52 -0700, Dave Clements, GMOD Help Desk wrote:
> Hi Amy,
> 
> The code at line 3316 of Generic.pm is
> 
>  3316     $db->do(
>  3317         qq[
>  3318         insert into cmap_map
>  3319         (map_id,map_acc,map_set_id,map_name,display_order,map_start,map_stop
> )
>  3320          values ( ?,?,?,?,?,?,? )
>  3321         ],
>  3322         {},
>  3323         (@insert_args)
>  3324     );
> 
> I'm not familiar with CMap internals, but my guess is that the
> cmap_map table already has a 'licy2001a1' map defined in it from a
> previous (possibly abortive) run.  In MySQL try
> 
> select * from cmap_map;
> 
> I bet you'll see an entry for 'licy2001a1'.
> 
> Dave C.
> GMOD Help Desk
> 
> On Wed, Oct 8, 2008 at 9:58 PM, Lee Amy <openlinuxsource at gmail.com> wrote:
> > Hello,
> >
> > I encountered another duplicate poblem again, however it dosen't seem
> > normal. The attachment I provide is the partial data. And the error message
> > is by following words.
> >
> > Rice-Zejiang_IR64_Azu_DH_QTL_2001 error
> > DBD::mysql::db do failed: Duplicate entry 'licy2001a1' for key 2 at
> > /usr/lib/perl5/site_perl/5.8.8/Bio/GMOD/CMap/Data/Generic.pm line 3316,
> > <GEN5> line 335.
> > DBD::mysql::db do failed: Duplicate entry 'licy2001a1' for key 2 at
> > /usr/lib/perl5/site_perl/5.8.8/Bio/GMOD/CMap/Data/Generic.pm line 3316,
> > <GEN5> line 335.
> >
> > Thank you very much.
> >
> > Best Regards,
> >
> > Amy Lee
> >
> > -------------------------------------------------------------------------
> > 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
> > gmod-cmap at lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/gmod-cmap
> >
> >
> 
> 
>