#1 CMap error reloading corresp. Matrix

closed-fixed
None
5
2003-01-30
2002-10-04
Anonymous
No

Hello Friends,

This BUG/Suggestion is for CMAP 0.03

Had a problem using cmap_admin.pl.
The message error pointed to file:
<PerlPATH>/lib/Bio/GMOD/CMap/Admin.pm
at line 269

The use of 'truncate table cmap_correspondence_matrix'
can be bothersome for some versions of MySQL (mine
is 3.23.32 linux). It does not like the 'table' keyword

However if the line is changed to 'truncate
cmap_correspondence_matrix' it works. This will also
work in newer versions of MySQL (tested on 3.23.41 on
NT), but I don't know if this will break in Oracle.

-Mauricio La Rota <cml22@cornell.edu>

Discussion

  • Scott Cain
    Scott Cain
    2002-10-24

    • labels: --> 470585
    • assigned_to: nobody --> kycl4rk
     
  • Scott Cain
    Scott Cain
    2002-10-24

    • assigned_to: kycl4rk --> nobody
    • labels: 470585 -->
     
    • assigned_to: nobody --> kycl4rk
     
  • Logged In: YES
    user_id=469773

    No longer using "truncate table" -- switched to just "delete from" in order to get around this issue and ownership issues with PostgreSQL.

     
    • status: open --> closed-fixed