Demo Import 500 Error

Hi,

it looks like a PHP error occurs when the import is attempted, based on this screenshot: https://ibb.co/b3QSRMH

Please enable WP Debug logs and check what kind of error occurs when trying to import. More info on how to enable WP Debug Logs can be found here.

Let us know what the error is, so we can help you further.

Take care!

I have attached the debug logs in my reply. At the end I have attached my PHP Config Settings.

[28-Oct-2022 13:01:13 UTC] PHP Fatal error:  Allowed memory size of 367001600 bytes exhausted (tried to allocate 20480 bytes) in /home/example.com/test.example.com/wp-includes/wp-db.php on line 2135
[28-Oct-2022 13:01:13 UTC] PHP Fatal error:  Allowed memory size of 367001600 bytes exhausted (tried to allocate 32768 bytes) in /home/example.com/test.example.com/wp-content/plugins/woocommerce/includes/class-wc-log-levels.php on line 1
[28-Oct-2022 13:01:21 UTC] PHP Fatal error:  Allowed memory size of 367001600 bytes exhausted (tried to allocate 33554440 bytes) in /home/example.com/test.example.com/wp-includes/wp-db.php on line 2136
[28-Oct-2022 13:01:28 UTC] PHP Fatal error:  Allowed memory size of 367001600 bytes exhausted (tried to allocate 20480 bytes) in /home/example.com/test.example.com/wp-includes/wp-db.php on line 2135
[28-Oct-2022 13:01:28 UTC] PHP Fatal error:  Allowed memory size of 367001600 bytes exhausted (tried to allocate 32768 bytes) in /home/example.com/test.example.com/wp-content/plugins/woocommerce/includes/class-wc-log-levels.php on line 1
[28-Oct-2022 13:01:39 UTC] PHP Fatal error:  Allowed memory size of 367001600 bytes exhausted (tried to allocate 4096 bytes) in /home/example.com/test.example.com/wp-includes/wp-db.php on line 2135
[28-Oct-2022 13:01:50 UTC] PHP Fatal error:  Allowed memory size of 367001600 bytes exhausted (tried to allocate 20480 bytes) in /home/example.com/test.example.com/wp-includes/wp-db.php on line 2135
[28-Oct-2022 13:01:50 UTC] PHP Fatal error:  Allowed memory size of 367001600 bytes exhausted (tried to allocate 20480 bytes) in /home/example.com/test.example.com/wp-includes/class-wp-user.php on line 522

— PHP CONFIG —
memory_limit: 1024M
max_execution_time: 600
upload_max_filesize: 25M
post_max_size: 48M
max_input_time: 400

Hi @vlohar08,

It looks like a server issue.

Please contact your hosting company, they should be able to resolve your issue.

Take care!

I did all the server checks and there is no issue on the server side.
So, I reset my WordPress Installation using WP Reset Plugin and it worked.
Before resetting, I disabled every plugin except the 4 required plugins but it still failed.
I can’t understand what the problem is.

I have identified the Issue.
My store has over 1lakh+ orders and that is the problem. On deleting all of them the demo import worked without any error!

I want to know Why the woocommerce orders are causing issues in the demo import.

Hi @vlohar08,

Thank you for letting us know what resolved your issue.

Maybe just one of your WC orders was causing issues?
Maybe some server resources were exhausted (timeout or memory limit)?

Have a nice day!

Hi, i can’t install demo content, it’s doesn’t progress. i have the following them:

max_execution_time=900
memory_limit=250
post_max_size=100
upload_max_filesize=150
max_input_vars=9000

but “max_execution_time” does not change, always 300.

• This reply was modified 1 year, 8 months ago by aub88.

Hi @capuderg,

i can’t install demo content, it’s doesn’t progress. i have the following them:

max_execution_time=900
memory_limit=250
post_max_size=100
upload_max_filesize=150
max_input_vars=9000

but “max_execution_time” does not change, always 300.

Change the default time of one AJAX call

The default value is 25 seconds. Add this code at the end of your theme functions.php file:

function ocdi_change_time_of_single_ajax_call() {
    return 10;
}
add_filter( 'ocdi/time_for_one_ajax_call', 'ocdi_change_time_of_single_ajax_call' );

This will “slice” the requests to smaller chunks and it might bypass the low server settings (timeouts and memory per request).

If you see that the 500 server error shows up, when the new AJAX request is being requested, then you can change the above number to something higher, like?return 180;, to increase the single length of the AJAX request and that might resolve your issue.

Check your server settings

• upload_max_filesize (256M)
• max_input_time (300)
• memory_limit (256M)
• max_execution_time (300)
• post_max_size (512M)