Re: Probleme with Postgresql and phpPgAdmin on a Debian Linux

Yes, phpPgAdmin 2.4.2 is not quoting your strings properly. We're working
on phpPgAdmin 3.0, but inthe mean time, try making sure magic_quotes_gpc
is enabled for that directory.

Project page: http://phppgadmin.sourceforge.net/

Chris

On Mon, 27 Jan 2003, Samuel Torton wrote:

> Hi,
>
>
> I'm having problem with Postgresql and phpPgAdmin on my Debian Linux
> box:
> - Debian Woody 3.0
> - PostgreSQL 7.2.1
> - phpPgAdmin 2.4.1
>
> If I want to run a SQL from phpPgAdmin interface, such as:
>
> ------
> INSERT INTO content VALUES (1, '1 description', 'content_tpl1',
> 'content_tpl1.gif', 'Il s\'agit d\'une simple page avec du
> texte.<br>Vous n\'avez qu\'&agrave; rajouter la
> <b><i>description</i></b> dans l\'espace r&eacute;serv&eacute;
> &agrave; cet effet.');
> ------
>
> ... I get the following error message :
>
> ------
> Warning: PostgreSQL query failed: ERROR: parser: parse error at
> or near "agit" in /usr/share/phppgadmin/db_readdump.php on line
> 33
> Error - /usr/share/phppgadmin/db_readdump.php -- Line: 33
> PostgreSQL said: ERROR: parser: parse error at or near "agit"
> Your query:
> INSERT INTO content VALUES (1, '1 description', 'content_tpl1',
> 'content_tpl1.gif', 'Il s'agit d'une simple page avec du
> texte.<br>Vous n'avez qu'&agrave; rajouter la
> <b><i>description</i></b> dans l'espace r&eacute;
> ....
> ------
>
> This type of command lines (with "\'" strings) used to work successfully
> with previous versions of PostgreSQL 7.0.3
>
>
> Would anybody have any idea to debug ?
>
> Thank you,
> --
> Samuel Torton
> http://www.ncslab.com
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>