[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