exporting submissions error 500

Hi ash3347,

I came across your query regarding the issue with exporting over 17,000 submissions in Forminator Forms. I completely understand how frustrating this can be, especially when time-out errors occur despite increasing the execution time and memory limits. Here are some suggestions that might help you resolve this issue:1. Optimize PHP Settings

Ensure your server’s PHP configuration is capable of handling large processes:

• max_execution_time = 300 or more.
• memory_limit = 512M or higher (1GB if possible).
• Check post_max_size and upload_max_filesize for any restrictions.

If you’re on shared hosting, consider asking your hosting provider to increase these limits.2. Use Filters to Export in Batches

The plugin allows you to filter submissions by date or other criteria. Try splitting the export into smaller batches instead of exporting everything at once. This reduces server load and prevents timeouts.3. Verify Scheduled Exports

Scheduled exports rely on WordPress’s cron jobs. If you’re not receiving scheduled exports:

• Use a plugin like WP Crontrol to check if cron jobs are running correctly.
• Ensure your hosting supports WordPress cron or switch to a server-side cron job for reliability.

4. Enable Debugging for More Insights

To identify specific issues, enable debugging by adding the following to your wp-config.php:

php

Copy code

define('WP_DEBUG', true); define('WP_DEBUG_LOG', true); define('WP_DEBUG_DISPLAY', false);

After triggering the export, check the log file (wp-content/debug.log) for any errors or warnings.5. Direct Database Export

If the plugin’s export functionality isn’t working, you can manually export data directly from the database. Use tools like phpMyAdmin or Adminer to access the table where submissions are stored (usually wp_frmt_form_entries). From there, you can export the data as a CSV file.6. Consider Alternate Tools

If the above solutions don’t work, you can use third-party plugins or tools like WP All Export to handle large data exports more efficiently.

If you still face issues, it might be worth reaching out to the Forminator Forms support team for further assistance. However, I hope these steps provide you with some quick wins to get your submissions exported successfully.

Best regards,
Md. Salim Shaikh
Freelance WordPress Developer
https://wpsmartsolutions.com/

hi @ash3347 ,

I hope you’re doing well and I’m sorry to see that you are facing this issue.

Also, thanks @wpsmartsolutions for sharing those steps which helps, anyways, I would not suggest 1GB of memory limit unless the site is too big with many plugins and the sever has enough resources.

Usually using 256MB is okay for “standard sites” and 512MB should work for e-commerce or complex sites.

@ash3347 , I understand that you have already increased the limits, in case max_execution_time is not 300 yet, could you give that a try?

In case that doesn’t work, could you please try to find a line that look like this on your wp-config.php?

define('WP_DEBUG', true);

And replace it with:

// Enable WP_DEBUG mode
define('WP_DEBUG', true);
// Enable Debug logging to the /wp-content/debug.log file
define('WP_DEBUG_LOG', true);
@ini_set( 'log_errors', 1 );
// Disable display of errors and warnings
define('WP_DEBUG_DISPLAY', false);
@ini_set('display_errors', 0);

Then, please try to export the form again and check the wp-content folder for a debug.log file, you can share it using a service like Google Drive or Dropbox, it should have a “Fatal Error” as it’s returning an error 500, please find that line and you can share it with us or share the complete debug.log if possible and if it doesn’t have any sensitive info.

I hope to hear back from you soon.

Best regards,
Williams Valerio