Unable to Export Store List

We have an issue on our site where we are unable to export the store listings within the admin area. We have not modified the server settings or any plugins in several months ( 6+ months)

I was able to grab an export in February 2019 but as of today I’m able to grab an export from the site. The number of locations is around 5,101 stores in the system so I believe the number of locations is not the issue.

here is a screenshot of our error in the WP logs
https://imgur.com/dUuHtO7

PHP message: PHP Fatal error: Uncaught PHPExcel_Writer_Exception: Could not close zip file /var/www/DOMAINNAME_pub/wp-content/plugins/codecanyon-16973546-agile-store-locator-google-maps-for-wordpress/public/export/store.xlsx. in /var/www/DOMAINNAME_pub/wp-content/plugins/codecanyon-16973546-agile-store-locator-google-maps-for-wordpress/PHPExcel/Classes/PHPExcel/Writer/Excel2007.php:389
Stack trace:
#0 /var/www/DOMAINNAME_pub/wp-content/plugins/codecanyon-16973546-agile-store-locator-google-maps-for-wordpress/admin/class-agile-store-locator-admin.php(2338): PHPExcel_Writer_Excel2007->save(‘/var/www/funkaw…’)
#1 /var/www/DOMAINNAME_pub/wp-includes/class-wp-hook.php(286): AgileStoreLocator_Admin->export_store(”)
#2 /var/www/DOMAINNAME_pub/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters(”, Array)
#3 /var/www/DOMAINNAME_pub/wp-includes/plugin.php(453): WP_Hook->do_action(Array)
#4 /var/www/DOMAINNAME_pub/wp-admin/admin-ajax.php(97): do_action(‘wp_ajax_asl_exp…’)
#5 {main}
thrown in /var/www/DOMAINNAME_pub/” while reading response header from upstream, client: xxx.xxx.xx.xx(REDACTED IP ADDRESS HERE), server: , request: “POST /wp-admin/admin-ajax.php?action=asl_export_file HTTP/1.1”, upstream: “fastcgi://unix:/run/php/php7.0-fpm.sock:”, host: “DOMAINNAME.com”

I also noticed on the ASL import/export page there is an error

/var/www/DOMAIN_pub/wp-content/plugins/codecanyon-16973546-agile-store-locator-google-maps-for-wordpress/public/import <= Directory is not writable, Excel Import will Fail, Make directory writable.

I confirmed with our sys admins that that directory is in fact Writeable but the error message is mainly around import but the export functionality is not working either.

• This topic was modified 5 years, 7 months ago by JT83.