Ajax exporting not working

(@lapsrj)

Yesterday I noticed that the ajax export stoped working (both Express export and Export buttons). When I click in export it shows the progress bar in 0% and 2 seconds later it show an empty alert. In the browser console it shows:

load-scripts.php?c=1&load[]=jquery-core,jquery-migrate,utils&ver=4.6.1:4 
POST https://----.com/wp-admin/admin-ajax.php 500 (Internal Server Error)

I activated WP’s errors log and this shows up there:

[06-Dec-2016 12:30:19 UTC] PHP Fatal error:  Uncaught exception 'PHPExcel_Exception' with message 'No cells exist within the specified range' in /data/21/4/79/78/4568567/user/5412736/htdocs/wp-content/plugins/woo-order-export-lite/classes/PHPExcel/Worksheet/RowCellIterator.php:214
Stack trace:
#0 /data/21/4/79/78/4568567/user/5412736/htdocs/wp-content/plugins/woo-order-export-lite/classes/PHPExcel/Worksheet/CellIterator.php(86): PHPExcel_Worksheet_RowCellIterator->adjustForExistingOnlyRange()
#1 /data/21/4/79/78/4568567/user/5412736/htdocs/wp-content/plugins/woo-order-export-lite/classes/formats/class-woe-formatter-xls.php(116): PHPExcel_Worksheet_CellIterator->setIterateOnlyExistingCells(true)
#2 /data/21/4/79/78/4568567/user/5412736/htdocs/wp-content/plugins/woo-order-export-lite/classes/class-wc-order-export-engine.php(324): WOE_Formatter_Xls->finish()
#3 /data/21/4/79/78/4568567/user/5412736/htdocs/wp-content/plugins/woo-order-export-lite/classes/class-wc-order-export-admin.php(892): WC_Order_Export_Engine::build_file(Array, 'partial', 'file', 0, 30 in /data/21/4/79/78/4568567/user/5412736/htdocs/wp-content/plugins/woo-order-export-lite/classes/PHPExcel/Worksheet/RowCellIterator.php on line 214

If I use the Export [w/o progressbar] button it exports.

Do you have an idea about what is the problem?

Thank you!

Viewing 7 replies - 1 through 7 (of 7 total)

Plugin Author algol.plus
(@algolplus)

9 years, 6 months ago

hi

version? 1.2.4?

is option “Output column titles as first line” checked?

thanks, alex

Thread Starter Leandro Amorim
(@lapsrj)

9 years, 6 months ago

The version is 1.2.4. WordPress and all plugins are up to date.

The “Output column titles as first line” is checked.

Plugin Author algol.plus
(@algolplus)

9 years, 6 months ago

Could you uncheck “Auto column width” and press “Export” ?

Will you get XLS file ? Can you review it ? Will you see something strange in top rows?

Thread Starter Leandro Amorim
(@lapsrj)

9 years, 6 months ago

I unchecked the “Auto column width” and it generated an invalid xlsx file (0KB). Tried generating a csv but it also comes empty.

In the browser console it shows the right number of orders that should come in the file.

Plugin Author algol.plus
(@algolplus)

9 years, 6 months ago

Could you change date range? Will it change something ?

Or is it possible clone website to test subdomain using plugin “Duplicator”?

Thread Starter Leandro Amorim
(@lapsrj)

9 years, 6 months ago

The problem continues independent of date range.

I used Duplicator but installed in another server (because it was easier for me) and it worked (using the same settings). So, the problem is with the hosting? It’s strange that it only doesn’t work when using ajax.

Thanks.

Plugin Author algol.plus
(@algolplus)

9 years, 6 months ago

Do you use load balancer with multiple backend servers ?

So different servers reply to front-end requests.
it was a reason why I added “export w/o progressbar” more here

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Ajax exporting not working’ is closed to new replies.