Hi,
revision 9989 (in trunk) contains a fix (with a hardcoded limit) for a problem I have: when uploading a 700 Kio file into a BLOB, I get a white page.
I think we had a limit on the number of queries displayed but not on the size of them.
Tell me what you think of this, as I would like to backport to QA_2_10.
Marc
Marc Delisle wrote:
Hi,
revision 9989 (in trunk) contains a fix (with a hardcoded limit) for a problem I have: when uploading a 700 Kio file into a BLOB, I get a white page.
I think we had a limit on the number of queries displayed but not on the size of them.
the size of the SQL should be limited as well (only?) in this case: SQL query: INSERT INTO `blobSizeTest` (`what`, `blob`) VALUES ('140k bz2', 0x425a683931415926535990ece2fe00cc03ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffe8c9c3efb1eecfabdee35f7db5e
IMO it makes no sense to display the whole blob again
greetings Juergen
Jürgen Wind a écrit :
Marc Delisle wrote:
Hi,
revision 9989 (in trunk) contains a fix (with a hardcoded limit) for a problem I have: when uploading a 700 Kio file into a BLOB, I get a white page.
I think we had a limit on the number of queries displayed but not on the size of them.
the size of the SQL should be limited as well (only?) in this case: SQL query: INSERT INTO `blobSizeTest` (`what`, `blob`) VALUES ('140k bz2', 0x425a683931415926535990ece2fe00cc03ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffe8c9c3efb1eecfabdee35f7db5e
IMO it makes no sense to display the whole blob again
greetings Juergen
Juergen, that's what revision 9989 does (not testing what the query contains, just its size).
Marc
Marc Delisle wrote:
Jürgen Wind a écrit :
Marc Delisle wrote:
Hi,
revision 9989 (in trunk) contains a fix (with a hardcoded limit) for a problem I have: when uploading a 700 Kio file into a BLOB, I get a white page.
I think we had a limit on the number of queries displayed but not on the size of them.
the size of the SQL should be limited as well (only?) in this case: SQL query: INSERT INTO `blobSizeTest` (`what`, `blob`) VALUES ('140k bz2', 0x425a683931415926535990ece2fe00cc03ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffe8c9c3efb1eecfabdee35f7db5e
IMO it makes no sense to display the whole blob again
greetings Juergen
Juergen, that's what revision 9989 does (not testing what the query contains, just its size).
Marc
sorry, i didn't study the source yet, at the moment (on demo, test.blobSizeTest) i get: Inserted rows: 1 Warning (1265): Data truncated for column 'blob' at row 1
Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 1692108 bytes) in /srv/http/pma.cihar.com/trunk-config/libraries/common.lib.php on line 1508
trying to upload only 900KB ---- for a smaller file (140KB) i still get a page >1.6MB with the blog data displayed
well, the redisplayed SQL is limited to 1000 chars now, but when i inspected the page source i still saw a huge textarea containing all the blob data.
-
Jürgen Wind -
Marc Delisle