[Biopython-dev] [Bug 1816] New: Error when importing GenBank file into BioSQL database

[bugzilla-daemon at portal.open-bio.org]

http://bugzilla.open-bio.org/show_bug.cgi?id=1816

           Summary: Error when importing GenBank file into BioSQL database
           Product: Biopython
           Version: Not Applicable
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: normal
          Priority: P2
         Component: BioSQL
        AssignedTo: biopython-dev at biopython.org
        ReportedBy: scresawn at ufl.edu


When importing a GenBank file with accession number AY243312 into a BioSQL
database, I get an error.  (See below.)  Importing the file was done according
to the documentation at http://biopython.org/docs/biosql/python_biosql_basic.html
I'm using python-2.3.4 and biopython-1.40b.  The biosql-schema was checked out
today (6/13/05) from cvs.
The error follows:

>>> db.load(iterator)
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
  File "BioSQL/BioSeqDatabase.py", line 414, in load
    db_loader.load_seqrecord(cur_record)
  File "BioSQL/Loader.py", line 43, in load_seqrecord
    self._load_reference(reference, rank, bioentry_id)
  File "BioSQL/Loader.py", line 324, in _load_reference
    (reference.pubmed_id,))
  File "BioSQL/BioSeqDatabase.py", line 287, in execute_and_fetch_col0
    self.cursor.execute(sql, args or ())
  File "/usr/lib/python2.3/site-packages/MySQLdb/cursors.py", line 95, in execute
    return self._execute(query, args)
  File "/usr/lib/python2.3/site-packages/MySQLdb/cursors.py", line 114, in _execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.3/site-packages/MySQLdb/connections.py", line 33, in
defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax
near 'USING (dbxref_id) WHERE dbname = 'PUBMED' AND accession = '7060133'' at
line 1")



------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.