pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Probleme with Postgresql and phpPgAdmin on a Debian Linux
5+ messages / 3 participants
[nested] [flat]

* Probleme with Postgresql and phpPgAdmin on a Debian Linux
@ 2003-01-27 13:29  Samuel Torton <samuel@ncslab.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Samuel Torton @ 2003-01-27 13:29 UTC (permalink / raw)
  To: pgsql-php

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 





^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Probleme with Postgresql and phpPgAdmin on a Debian Linux
@ 2003-01-27 13:42  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  parent: Samuel Torton <samuel@ncslab.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Christopher Kings-Lynne @ 2003-01-27 13:42 UTC (permalink / raw)
  To: Samuel Torton <samuel@ncslab.com>; +Cc: pgsql-php

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
>




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Probleme with Postgresql and phpPgAdmin on a Debian Linux
@ 2003-01-27 15:56  Andrei Verovski (aka MacGuru) <andreil1@mail.starlett.lv>
  parent: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  0 siblings, 1 reply; 5+ messages in thread

From: Andrei Verovski (aka MacGuru) @ 2003-01-27 15:56 UTC (permalink / raw)
  To: pgsql-php; +Cc: Christopher Kings-Lynne <chriskl@familyhealth.com.au>


On Monday, Jan 27, 2003, at 15:42 Europe/Helsinki, Christopher 
Kings-Lynne wrote:

> 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/
>

Dear Christofer,

Is option magic_quotes_gpc should be initialized in php.ini or somehwre 
else?

Thanks


*********************************************
*   Best Regards   ---   Andrei Verovski
*
*   Personal Home Page
*   http://snow.prohosting.com/guru4mac
*   Mac, Linux, DTP, Development, IT WEB Site
*********************************************




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Probleme with Postgresql and phpPgAdmin on a Debian Linux
@ 2003-01-28 01:11  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  parent: Andrei Verovski (aka MacGuru) <andreil1@mail.starlett.lv>
  0 siblings, 1 reply; 5+ messages in thread

From: Christopher Kings-Lynne @ 2003-01-28 01:11 UTC (permalink / raw)
  To: Andrei Verovski (aka MacGuru) <andreil1@mail.starlett.lv>; pgsql-php

> On Monday, Jan 27, 2003, at 15:42 Europe/Helsinki, Christopher
> Kings-Lynne wrote:
>
> > 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/
> >
>
> Dear Christofer,
>
> Is option magic_quotes_gpc should be initialized in php.ini or somehwre
> else?

Yes, but it's just a guess - I can't guarantee that it will fix the issue.
I really do suggest tracking the webdb CVS module which is to become
phpPgAdmin 3.

Chris




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Probleme with Postgresql and phpPgAdmin on a Debian Linux
@ 2003-01-28 11:02  Samuel Torton <samuel@ncslab.com>
  parent: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  0 siblings, 0 replies; 5+ messages in thread

From: Samuel Torton @ 2003-01-28 11:02 UTC (permalink / raw)
  To: 'Christopher Kings-Lynne' <chriskl@familyhealth.com.au>; 'Andrei Verovski (aka MacGuru)' <andreil1@mail.starlett.lv>; pgsql-php

Hi Chris and the list,

I checked the PHP.INI conf file and I could see that the
"magic_quote_gpc" is enabled.

So, phpPgAdmin 2.4.2 is bugged, but in the meanwhile it's possible to
avoid this bug by using the "psql" command line with "-f file" argument,
and then everything is ok to dump / restore tables.

Cheers,
--
Samuel Torton
http://www.ncslab.com 

> -----Original Message-----
> From: pgsql-php-owner@postgresql.org [mailto:pgsql-php-
> owner@postgresql.org] On Behalf Of Christopher Kings-Lynne
> Sent: mardi 28 janvier 2003 02:12
> To: Andrei Verovski (aka MacGuru); pgsql-php@postgresql.org
> Subject: Re: [PHP] Probleme with Postgresql and phpPgAdmin on a Debian
> Linux
> 
> > On Monday, Jan 27, 2003, at 15:42 Europe/Helsinki, Christopher
> > Kings-Lynne wrote:
> >
> > > 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/
> > >
> >
> > Dear Christofer,
> >
> > Is option magic_quotes_gpc should be initialized in php.ini or
somehwre
> > else?
> 
> Yes, but it's just a guess - I can't guarantee that it will fix the
issue.
> I really do suggest tracking the webdb CVS module which is to become
> phpPgAdmin 3.
> 
> Chris
> 
> 
> ---------------------------(end of
broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster




^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2003-01-28 11:02 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-01-27 13:29 Probleme with Postgresql and phpPgAdmin on a Debian Linux Samuel Torton <samuel@ncslab.com>
2003-01-27 13:42 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2003-01-27 15:56   ` Andrei Verovski (aka MacGuru) <andreil1@mail.starlett.lv>
2003-01-28 01:11     ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2003-01-28 11:02       ` Samuel Torton <samuel@ncslab.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox