Support » Plugin: SpeakOut! Email Petitions » 500 Error When Attempting CSV Download of Singature List

  • Resolved michelamarie

    (@michelamarie)


    I have just created a test petition with SpeakOut, and am having trouble with the CSV export feature.

    Everything with the plug-in looks good, apart from CSV export of the list of signatures.

    When I visit the page, /wp-admin/admin.php?page=dk_speakout_signatures&action=petition&pid=1 in the WordPress / SpeakOut admin panel (the page listing signatures for the test petition), and then click “Download as CSV,” The browser throws an error:

    might be temporarily down or it may have moved permanently to a new web address.
    ERR_INVALID_RESPONSE

    I see no errors in the Apache error logs, though I do see a 500 response from the server in Apache’s access log:

    "GET /wp-admin/admin.php?page=dk_speakout_signatures&action=petition&pid=1&csv=signatures&_wpnonce=c1fa5df806 HTTP/1.1" 500 1192

    I have checked the settings and tried this export several different times. I have also searched the web and this forum for hints as to what the problem could be, all to no avail.

    Might any of you friendly folks have an idea on why this error might be happening?

    Thank you!

    The page I need help with: [log in to see the link]

Viewing 14 replies - 1 through 14 (of 14 total)
  • 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.

    Plugin Author 123host

    (@123host)

    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!

    Plugin Author 123host

    (@123host)

    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?

    Plugin Author 123host

    (@123host)

    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?

    Plugin Author 123host

    (@123host)

    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 6 months, 2 weeks ago by GideonLupine.
    Plugin Author 123host

    (@123host)

    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

    Plugin Author 123host

    (@123host)

    csv export 85Kb

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

    Plugin Author 123host

    (@123host)

    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.

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘500 Error When Attempting CSV Download of Singature List’ is closed to new replies.