[ppa-help] [ phppgadmin-Bugs-2579270 ] confusion of comments in uploaded sql script

[SourceForge.net <no...@so...>]

Bugs item #2579270, was opened at 2009-02-08 04:08
Message generated for change (Settings changed) made by ioguix
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=2579270&group_id=37132

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Import/Export
>Group: GIT
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: woodz (woodz_)
>Assigned to: Guillaume `ioguix` de Rorthais (ioguix)
Summary: confusion of comments in uploaded sql script

Initial Comment:
Hi,
if I execute a sql script by attaching it's name from the file browser dialog to the upload box, I get a confusion with rows containig text fields like this '-----'. But in the iput area I get no confusion. Suppose the following two lines:
INSERT INTO positions VALUES (129, 'ICT Offline Vakuum Adapter UTCU2', '----', 2, true, false, '2009-02-27', false, 1, 1);
INSERT INTO positions VALUES (131, 'fahrbarer Schutzubehälter für Trafo', '----', 6, false, false, '2009-01-22', false, 4, 1);

The execution from upload script fails with "syntax error at or near 131, 'fahrbarer Schutzubehälter...
As mentioned, in the sql input area these two lines work.

If I correct the lines to:
INSERT INTO positions VALUES (129, 'ICT Offline Vakuum Adapter UTCU2', '', 2, true, false, '2009-02-27', false, 1, 1);
INSERT INTO positions VALUES (131, 'fahrbarer Schutzubehälter für Trafo', '', 6, false, false, '2009-01-22', false, 4, 1);

they also work in an uploaded sql script. It seems that ppa means there are suddently occuring comments in a row and then refuses with the mentioned error. An escaping of special characters problem?
Another question is, why doesn't ppa fail at the first line (if needs must fail), since the first line already contains a '-----' text field?

Something about my environment:
- FF 3.0.6 (tried on Win XP SP 3 and openSUSE 11)
- ppa 4.2.2 
- PostgreSQL 8.3.1 on openSUSE 11 (database with UTF-8 client encoding)

Thanks for consideration

WOODZ


----------------------------------------------------------------------

>Comment By: Guillaume `ioguix` de Rorthais (ioguix)
Date: 2010-08-26 23:29

Message:
Hey,

I have fixed this bug today in our current dev tree : 

 
http://github.com/xzilla/phppgadmin/commit/36c782e86a3a2b8d8b93932e30d23f4381a3ecfa

If you don't want to wait for the nextr beta release coming soon, you can
already download a snapshot of this version from the following page:

  http://github.com/xzilla/phppgadmin

Just click on "Download source".

Thank you for your report !

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=2579270&group_id=37132