ERR_EMPTY_RESPONSE when Exporting to Excel

Hi wmvidal,

The “ERR_EMPTY_RESPONSE” could be due to unstable network connection, it could be from your computer or from the server’s end. There are a few troubleshooting steps that you could do. Firstly, could you try switching to a different browser and see if you still get the same error.
As mentioned above it could be due to bad network at your computer’s end, to reset your network connections you could enter the following commands one by one in command prompt and see if this fixes the issue:

ipconfig /release
ipconfig /flushdns
ipconfig /renew
netsh winsock reset

You could also contact your website’s hosting provider and ask them to look in the server logs to see if there’s anything there that can answer this.

Hello!

I have tried using Chrome and Firefox in two computers, the problem continues happening.
We have about 2400 rows in the database, I belive this error is related to the rows number in the orders table.

I made a test modifing the query that loads orders data in the EWD_OTP_Export_To_Excel.php file. After ajusting the query to load less rows from the table, I was able to “solve” the problem. (I know Its a workaround).

There are any adjustment that could be made on the server to solve this problem?

Thank you!

Wallace

Hi wmvidal,

That seems like the memory allocated to WordPress, PHP server or the SQL database is getting exhausting which results in no response being sent from the server(as evident from getting a response if you choose to reduce the SQL queries). You could start by looking at the server logs to check if that’s the issue. If this is due to the memory exhaustion issue, you could increase the memory allocated to PHP and to the SQL database. You may contact your website host to set the max memory for the PHP/SQL server,and for the WordPress memory, you could edit the wp-config.php file and change the amount of memory allocated to WordPress:

define( 'WP_MAX_MEMORY_LIMIT', '256M' );