From: | Ron St-Pierre <rstpierre(at)syscor(dot)com> |
---|---|
To: | Daniel Secomb <dan(at)ds-d(dot)com>, pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: I NEED HELP!!! - (ERROR: parser: unterminated quoted |
Date: | 2004-09-08 15:11:56 |
Message-ID: | 413F213C.9020208@syscor.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Daniel Secomb wrote:
> Hi,
>
> I'm using PostgreSQL 7.3.4 on phpPgAdmin 2.4.2 and I'm getting the
> following error when I try and run a SQL query on a script:
>
> *Error -
> /usr/local/psa/admin/htdocs/domains/databases/phpPgAdmin/db_readdump.php
> -- Line: 33*
>
> PostgreSQL said: ERROR: parser: unterminated quoted string at or near
> "'*Black Tea <file://%22/html/tea_black_tea.html//%22>*\015\012Fresh
> range of leaf tea for drinking black or with milk,\015\012including
> Ceylons, Assams and favourites like Irish
> Breakfast.\015\012\015\012*Green Tea
> <file://%22/html/tea_green_tea.html//%22>*\015\012First quality
> Japanese & Chinese popular green teas, including Bancha, Genmaicha &
> flavoured green teas.\015\012\015\012*Flavoured Tea
> <file://%22/html/tea_flavoured_black_tea.html//%22>*\015\012Exotic and
> delicious, favourites are Vanilla, Arctic Fire & Lady
> Grey.\015\012\015\012*Herbal Infusions
> <file://%22/html/tea_herbal_infusions.html//%22>*\015\012Pure flowers
> and whole leaves of calming herbs, & a\015\012delightful range of
> specially blended herbal infusions Fruit Melanges;" at character 566
>
>
>
If this is part of a SQL statement, the final quote should be before the
semicolon. If not check on the previous string to see that it is
properly quoted/terminated.
Ron
From | Date | Subject | |
---|---|---|---|
Next Message | Eduardo Vázquez Rodríguez | 2004-09-08 21:29:26 | Cast |
Previous Message | paul | 2004-09-08 14:16:46 | Re: Why am I getting the error: "Cannot insert a duplicate key into unique index"? |