#348 confusion of comments in uploaded sql script
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
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 !