[Babase] Re: weird error

Karl O. Pinc kop at meme.com
Fri Oct 30 14:03:30 EDT 2009


On 10/30/2009 12:50:39 PM, Lacey Roerish wrote:
> ok, very weird!  No idea how that happened!    So did you upload the
> file
> once it was fixed, or shall I Go in and do that now?

You do it.  I didn't want to change anything.

> Thanks!
> L
> 
> On Fri, Oct 30, 2009 at 1:47 PM, Karl O. Pinc <kop at meme.com> wrote:
> 
> > On 10/30/2009 12:00:04 PM, Lacey Roerish wrote:
> > > File supplied: *NC0209A.txt*
> > >
> > > Line 2: *ERROR: unterminated quoted identifier at or near ""ÿþd"
> at
> > > character 27*
> >
> > Well, that was curious.  The first 3 bytes of the file are
> > not regular (ASCII) characters.  The bit patterns in hexadecimal
> > are:
> >
> > ef bb bf
> >
> > These don't print, or come out strange like ""ÿþd".
> >
> > So, you got an error on every line because the first column
> > name 'date' wasn't really the column name you thought
> > you had.  Which is why every row got an error.
> >
> > The obscure clue in the error message is the word
> > 'identifier', which is an indication that the problem
> > is not in the data but is in the SQL that's putting
> > the data into the database.  The only part of the
> > SQL that ever changes are the column names so if you
> > get an error about an identifier then it's either about
> > a column name or somehow an extra quote character got
> > put somewhere and some data escaped from inside it's
> > quotes.  IIRC the upload program is not supposed to allow
> > the latter to happen.
> >
> >
> >
> > Karl <kop at meme.com>
> > Free Software:  "You don't pay back, you pay forward."
> >                 -- Robert A. Heinlein
> >
> >
> 
> 
> -- 
> - -
> Lacey K. Maryott Roerish
> Alberts Lab
> Department of Biology
> Duke University
> ph: 919-660-7306
> fax: 919-660-7293
> Lacey.Maryott at duke.edu
> 




Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein




More information about the Babase mailing list