500 Error When Attempting CSV Download of Singature List

In case it is helpful to know:

I just tried clicking the “Download as CSV” button on a different petition and the same result happened. When I deleted the signatures in that petition and clicked the “Download as CSV” button again, I got an expected “No signatures found” message.

So This error only occurs when there is actual data in the wp_dk_speakout_signatures table for the given petition ID.

Hey, thanks for the report.

I can’t reproduce this in either my public site https://speakout.123host.net.au or my development site, which makes me wonder if it is a hosting configuration issue.

I suggest you contact your hosting provider and see if they can spot the issue. It might be something I can work around but if you can’t find an error it makes it tricky ??

Hi. Thank you for your reply!

I am the administrator of this machine. I do not see any issues on the server (though it is possible there is one that I am not aware of).

I have checked the Apache logs and have turned off SELinux and mod_security — the problem still appears when those things are off, and I see no other errors, apart from the 500 status code returned to the client.

Can you provide some hints as to what hosting configuration elements could be related to this CSV export problem? The server and site otherwise work great. ??

Thanks again for your help!

Sorry this got ignored ??

Can you increase the allocated memory and see if that helps? THough that usually throws a memory allocation error. But it might be worth a try.

Where would he go if used phpMyadmin or directly downloaded from the database via an export there?

What table and what parameters would we look for if we had to do it the hard way?

In the database look for the wp_dk_speakout_signatures table.

Note that a WordPress database might have table names that start with something random like wpug instead of just wp

We just hit 73,000 signatures and growing fast. Now when I hit the download CSV, it does nothing.

I have been going to phpMyAdmin and downloading the table wp_dk_speakout_signatures manually.

What is the number of signatures where I would have to worry about performance or start to break things?

Can it handle 100K signatures?

I have heard of this happening to others with a lot of signatures and haven’t discovered the cause. I think it is more a memory allocation issue than a plugin problem. Do you have access to the error_log file so you can check if there is some sort of error?

Where would I find the error_log? If I can get to it, I will let you know.

One thing seems odd. The petition CSV download is 15MB. The download from phpMyAdmin is only 7.7MB.

It looks like COMMA delimited files are smaller than TAB delimited files when downloaded.

• This reply was modified 4 years, 10 months ago by GideonLupine.

You’ll find error_log in the document root directory on the server. That is, the same directory where you find wp-config.php

On most servers it will be in /home/username/public_html. If you have a cpanel server you can access it via the file manager.

Hope that helps

As for file size, what you say is interesting. My test site has 250 signatures. The .csv is 3Kb, the .sql is 100Kb, the opposite way around to your results.

Not the .sql export, but the csv export from phpMyAdmin

csv export 85Kb

I did not find any related entries in the error log.

I suggest trying to increase the memory limit.

If you have a cpanel server go to multi-php ini editor find the memory_limit setting and increase it to 1024 and see if that helps.