[Babase] Re: weird error
Lacey Roerish
lroerish4 at gmail.com
Fri Oct 30 13:50:39 EDT 2009
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?
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://eeblistserv.Princeton.EDU/pipermail/babase/attachments/20091030/0da906a2/attachment.html
More information about the Babase
mailing list