[Phpmyadmin-devel] recent fix for white page and field uploads
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 -- View this message in context: http://www.nabble.com/recent-fix-for-white-page-and-field-uploads-tf3227876.... Sent from the phpmyadmin-devel mailing list archive at Nabble.com.
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 -- View this message in context: http://www.nabble.com/recent-fix-for-white-page-and-field-uploads-tf3227876.... Sent from the phpmyadmin-devel mailing list archive at Nabble.com.
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. -- View this message in context: http://www.nabble.com/recent-fix-for-white-page-and-field-uploads-tf3227876.... Sent from the phpmyadmin-devel mailing list archive at Nabble.com.
participants (2)
-
Jürgen Wind -
Marc Delisle