#4072 Export doesn't work on my server

[DisgruntledGoat]

This is a strange one. PMA has been working fine on localhost and one of my servers. But on another, I just upgraded PMA (from scratch - I deleted version 3 and added latest 4.0.5). Most things work OK but when I click the Export button, either on a database or table, it just hangs.

The yellow "Loading" box appears but nothing happens. I check in Dev Tools and there is an AJAX request for:
/db_export.php?db=phpmyadmin&token=5bacb1c66edff5ff7775087231f90e46&ajax_request=true&ajax_page_request=true&menuHashes=977d3860-dae0601e-7cdab78f-014d4bca&_nocache=1377602979563596588
The Response tab is just blank.

This server is running PHP 5.2.6-2ubuntu4 and MySQL Ver 14.12 Distrib 5.0.67 whereas the others are 5.3. Let me know if I can provide any more information.

[Marc Delisle]

Here is a fix I propose for the upcoming 4.0.6-rc2, please confirm:
https://github.com/phpmyadmin/phpmyadmin/commit/5298602f8edb4475fce5d299532c7780e0e314a5.patch

[Marc Delisle]

Any feedback?

[DisgruntledGoat]

Well this is strange. I just uploaded version 4.0.5 again from scratch and Export is now working. Not really sure how that happened, I have not updated any software on the server.

However, the one thing I have done is increase the memory_limit value in php.ini (from 12M to 36M). I had reverted to version 3 to make Export work and was getting memory errors. Perhaps the same error was occurring on 4.0.5 but it wasn't telling me that.

EDIT: OK double checked this by reducing the PHP memory back down again and it is indeed a memory error. The first time I clicked Export it actually showed a "Memory exhausted" error (in the tcpdf thing) but the second time it's doing what I described above and just hanging.

[DisgruntledGoat]

Also I just tried your patch with my memory on low and it did not fix the issue.

[Marc Delisle]

Thanks for the feedback; I'm closing this ticket (not much we can do for memory too low).

[DisgruntledGoat]

not much we can do for memory too low

You could maybe... not use so much memory? Why would you need to use more than 12 MB of memory for a single page?

The other issue is that PMA is just hanging. If the page comes back blank, shouldn't PMA show an error instead? And for some reason no PHP errors are output on the page itself, but they are shown in v3 of PMA so it's not a server setting or anything.