dbTalk Databases Forums  

I NEED HELP!!! - (ERROR: parser: unterminated quoted string)

comp.databases.postgresql.novice comp.databases.postgresql.novice


Discuss I NEED HELP!!! - (ERROR: parser: unterminated quoted string) in the comp.databases.postgresql.novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Daniel Secomb
 
Posts: n/a

Default I NEED HELP!!! - (ERROR: parser: unterminated quoted string) - 09-08-2004 , 08:33 AM






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\015\012Fresh range of leaf tea for drinking black or with
milk,\015\012including Ceylons, Assams and favourites like Irish
Breakfast.\015\012\015\012Green Tea\015\012First quality Japanese & Chinese
popular green teas, including Bancha, Genmaicha & flavoured green
teas.\015\012\015\012Flavoured Tea\015\012Exotic and delicious, favourites
are Vanilla, Arctic Fire & Lady Grey.\015\012\015\012Herbal
Infusions\015\012Pure flowers and whole leaves of calming herbs, &
a\015\012delightful range of specially blended herbal infusions Fruit
Melanges;" at character 566



Any idea as to why this is doing this?

Thank you for your help.

Dan


Reply With Quote
  #2  
Old   
Ron St-Pierre
 
Posts: n/a

Default Re: I NEED HELP!!! - (ERROR: parser: unterminated quoted - 09-08-2004 , 10:11 AM






Daniel Secomb wrote:

Quote:
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


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.