Excel download link does not work

Hi @tsjippy,

This looks like strange error for the plugin. It looks to be mostly javascript errors, due to a thing in the (chrome- / firefox-)devtools. Do you get this error on every form, or on a specific one?

What version of PHP do you use, and is there an upload-field among the fields in your form?

I honestly doubt it’s a problem with the plugin, but if it is I’d like to help.

Oh, as a side question, have you tried disabling every other plugin, and then try again? If it works, it’s probably having issues with another plugin.

thank you so much!

I tested a copy of the site in another environment, with php 7 and it works.
My environment is on php 5.5.38
That should be enough right?

Apache 2.4.33
DirectAdmin 1.53.0
Exim 4.91
MySQL 5.6.38
Named 9.8.2rc1
sshd
dovecot 2.3.1 (8e2f634)
pure-ftpd 1.0.47
Php 5.5.38

Unfortunately you need add least php 5.6. As of version 1.2.4 (something went wrong with the versioning). I’ve updated the docs to reflect this change. But somehow wordpress hasn’t picked up on these.

I strongly suggest you update to at least 5.6. But 7.1 would be even better. Much faster and safer as 5.5 had no security patches anymore.

If that’s not an option fpr now. Try reverting to version 1.2.3. That should still work.

Sorry for the docs mix up. Hope that will be fixed soon.

Thanks, I updated to php 7.1 and it works!

Cool. Glad to hear it worked out. Have fun with the plugin.
If you have any other issues or requests just add another support ticket.

Also, if you’d like, I’d love for you to leave a quick review of the plugin. Helps me help others! But no pressure.

Thanks!

Hi, having similar issue and deactivate all plugins, changed theme, upgraded WordPress, tried previous version and new version of your Excel download plugin and still getting the following error(s):

This site can’t be reached
The webpage at https://am.csaci.ca/gf-entries-in-excel/bQhYyveFml3/VpXqnhdnQVHtpM7VZLNt/ZHKcaaGD1Q= might be temporarily down or it may have moved permanently to a new web address.
ERR_INVALID_RESPONSE

Any idea why it stopped working and anything else I can try? We are already on php7

Thanks

Hi @jrock88,

do you have this problem with every form? Or a specific one?
It probably is an error in the output, before the output of the file is rendered.

could you add something like error_reporting(E_ALL); to your functions.php and try again? With any luck you’ll get an error we can work with.

Let me know!

Happens on every form (just two forms exist right now)

Here is expanded errors;
[23-May-2018 19:14:33 UTC] PHP Fatal error: Uncaught Error: Class ‘ZipArchive’ not found in /home/csaci/am.csaci.ca/wp-content/plugins/gf-entries-in-excel/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx.php:210
Stack trace:
#0 /home/csaci/am.csaci.ca/wp-content/plugins/gf-entries-in-excel/src/Renderer/AbstractPHPExcelRenderer.php(38): PhpOffice\PhpSpreadsheet\Writer\Xlsx->save(‘/tmp/phpxltmpN9…’)
#1 /home/csaci/am.csaci.ca/wp-content/plugins/gf-entries-in-excel/src/Renderer/PHPExcelRenderer.php(43): GFExcel\Renderer\AbstractPHPExcelRenderer->renderOutput()
#2 /home/csaci/am.csaci.ca/wp-content/plugins/gf-entries-in-excel/src/GFExcelOutput.php(126): GFExcel\Renderer\PHPExcelRenderer->handle(Array, Array, Array)
#3 /home/csaci/am.csaci.ca/wp-content/plugins/gf-entries-in-excel/src/GFExcel.php(85): GFExcel\GFExcelOutput->render()
#4 /home/csaci/am.csaci.ca/wp-includes/class-wp-hook.php(286): GFExcel\GFExcel->request(Array)
#5 /home/csaci/am.csaci.ca/wp-includes/plugin.php(203): WP_Hook->apply_filters(Array, Array)
#6 /home/csaci/am.csaci. in /home/csaci/am.csaci.ca/wp-content/plugins/gf-entries-in-excel/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx.php on line 210

Thanks, J.

Hi @jrock88,

Thanks for sending the error message. This helps a lot. The plugin uses a library called phpoffice/phpspreadsheet. One of it’s dependencies is the php-zip library compiled into PHP.

To fix this issue you need to install php-zip onto your server. There are lots of resources online to help you with this. But something along the lines of this should work:

sudo apt-get install php-zip.

Hope this helps you out. At the least you’ve helped me, because this made me aware of some missing feedback in the plugin. I’ll make it so we can retrieve the errors more easily, and also give users some feedback if their missing some dependancies.

Thank you so much for your quick support, once we installed that on the server the download xls feature worked perfectly again!

Cool @jrock88, glad to hear!