phpPgAdmin / Bugs / #336 SQL Query truncated abnormally

#336 SQL Query truncated abnormally

Status: closed-fixed

Owner: Robert Treat

Labels: General (123)

Priority: 5

Updated: 2008-12-18

Created: 2008-04-16

Creator:

Private: No

Long SQL queries are truncated abnormally by PhpPgAdmin. Submitting long queries causes an application error displaying a blank page. Hint: the problem is related to the size limit of HTTP GET request, SQL query strings should be passed always via HTTP POST or manteined in a SESSION variable.

Discussion

Robert Treat - 2008-08-17

Logged In: YES
user_id=204589
Originator: NO

can you provide a little more detail on where you get this error? Is it in the sql pop-up window, or the sql page on the database page, or some place else?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Robert Treat - 2008-08-17

assigned_to: nobody --> xzilla
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Robert Treat - 2008-08-25

status: open --> pending-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Robert Treat - 2008-08-25

Logged In: YES
user_id=204589
Originator: NO

I believe I have a fix for this available in my git repo. You can grab a copy of the code from
http://github.com/xzilla/phppgadmin/tarball/28a749657ab3c92c6a59bf6171cc3e7b8b1c3c84.

I am marking this bug ticket as pending, please let us know if you have additional issues. Note, this fix will be backpatched to 4.2.x

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Anonymous - 2008-08-26

status: pending-fixed --> open-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Anonymous - 2008-08-26

Logged In: YES
user_id=2064472
Originator: YES

The problem is not present in the forms that send the query by HTTP POST (database sql, pop-up, save report). The problem occurs whenever you access the query contents via HTTP GET. For example in database sql and pop-up when you have executed the query for the first time and then you click on "Modify SQL". The same if you saved the query in a report: you will not be able to run it. The problem is due to a Internet Explorer feature, see http://support.microsoft.com/kb/208427 For an example query, see the attached file "long_query.txt", try to run/modify that query and then try to create/modify/run a report with that query.

File Added: long_query.txt

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Anonymous - 2008-08-26

status: open-fixed --> pending-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Anonymous - 2008-08-26

Logged In: YES
user_id=2064472
Originator: YES

File Added: long_query.txt

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Anonymous - 2008-08-26

status: pending-fixed --> open-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Anonymous - 2008-08-26

status: open-fixed --> pending-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Anonymous - 2008-08-26

status: pending-fixed --> open-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Anonymous - 2008-08-26

status: open-fixed --> pending-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Anonymous - 2008-08-26

Logged In: YES
user_id=2064472
Originator: YES

File Added: long_query.txt

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Anonymous - 2008-08-26

status: pending-fixed --> open-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Anonymous - 2008-08-26

Logged In: YES
user_id=2064472
Originator: YES

I have downloaded and installed http://github.com/xzilla/phppgadmin/tarball/28a749657ab3c92c6a59bf6171cc3e7b8b1c3c84
The problem is still present.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Robert Treat - 2008-08-26

status: open-fixed --> open-accepted
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Robert Treat - 2008-08-26

Logged In: YES
user_id=204589
Originator: NO

ah, ok, i thought there might be more to this. however, i get an error when trying to download your example (something about it being a binary file), can you re-upload? thanks!

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Anonymous - 2008-09-01

Logged In: YES
user_id=2064472
Originator: YES

File Added: long_query.zip

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Anonymous - 2008-09-01

Logged In: YES
user_id=2064472
Originator: YES

Ok, I have uploaded a zipped copy of the attached file.
File Added: long_query.txt

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Anonymous - 2008-09-01

Long Query Example Test

long_query.txt

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Anonymous - 2008-09-01

Logged In: YES
user_id=2064472
Originator: YES

File Added: long_query.txt

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Nobody/Anonymous - 2008-09-01

Long Query Example Test (Zipped)

long_query.zip

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Robert Treat - 2008-09-13

I've worked up some code to manage the sql query via a session var, I think you can grab it at
http://github.com/xzilla/phppgadmin/tarball/77fb4f46c675b23e189f06ead11d35d1921a3b64, lmk how it goes.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Robert Treat - 2008-12-18

This issue has been resolved and is currently fixed in CVS. If
you wish to acquire the fix, please download a nightly snapshot:

http://phppgadmin.sourceforge.net/

Note that you may have to wait up to 24 hours for the latest CVS
changes to appear in the snapshot.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Robert Treat - 2008-12-18

status: open-accepted --> closed-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.