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