Here’s a quick way to run a petition in WordPress

I’ve written a short and simple plugin that embeds a web based petition into your WordPress page or post. Signatures are confirmed by e-mail and the administrative interface allows for customization along with deletion and exporting of signatures. Learn more now.

29 Responses to “Here’s a quick way to run a petition in WordPress”

  1. Bob Davidow Says:

    Great software! Simple and easy to install. Thanks! Two questions:

    How can I format my text in the petition? Bold, underline, paragraphs, indent?

    In the export file I do not get written comments? They are extremely important. How can I retrieve them.

    Thanks again…great that you contribute this to everyone! Bravo!

    b

  2. William Kasel Says:

    I tried installing it, and initially ran into some difficulties. I received a sql error saying comment was too large, (300). I changed fcpetition.php where the sql lines are from 300 to 255 and everything worked great! Might want to make the change to the textarea so nothing gets cut off. Thanks for the plugin.

    P.S. I used it here http://blog.johnebradle.com/petition

  3. Steve Says:

    Hi!

    I’m sorry if this is a newbie thing but I’m getting this error and I don’t know what to do about it. I’m just setting up wordpress for the first time because I want to use your petition.

    Any help is appreciated.

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), time DATETIME, UNIQUE KEY email (email) )' at line 5]
    CREATE TABLE wp_petition ( email VARCHAR(100), name VARCHAR(100), confirm VARCHAR(100), comment VARCHAR(), time DATETIME, UNIQUE KEY email (email) )

  4. Fabrizio Azzali Says:

    Same problem of steve.

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), time DATETIME, UNIQUE KEY email (email) )' at line 5]
    CREATE TABLE wp_petition ( email VARCHAR(100), name VARCHAR(100), confirm VARCHAR(100), comment VARCHAR(), time DATETIME, UNIQUE KEY email (email) )

    NO ANSWER?

  5. Fabrizio Azzali Says:

    Problem solved.
    Thanks to James.

    Just replace that you can find at
    http://svn.wp-plugins.org/wordpress-petition-plugin/trunk/fcpetition.php
    Bye

  6. Matthew Miller Says:

    Hi

    Trying to use Petition plug-in. The confirmation email is not showing the name of the petition or the confirmation email.

    What could I be doing wrong?

    I have inserted the placeholder [[petition-1]] into my page. Is this the right way to do it?

    Cheers
    Matthew

  7. James Davis Says:

    Matthew, sorry about this. It appears that due to issues beyond my control, my development code is being distributed as the stable version by wp-plugins.org.

    The stable version is available at http://svn.wp-plugins.org/wordpress-petition-plugin/tags/1.0.1/

  8. Leigh Says:

    I just wanted to drop this note to thanks James for all his help!

    Much appreciated James.

    Regards
    Leigh

  9. Pete Says:

    Hi James,

    Thanks for the work on the plugin - it looks like just what I’m after but I’m having a bit of trouble getting the plugin to work.

    I am developing a WordPress 2.3.1 blog on a Windows server :( with IIS, MySQL & PHP.

    I have modified my ABSPATH definition in the config file to cope with the Windows server.

    When I add the latest files within the plugins folder and within a folder called wordpress-petition-plugin, activation in the admin is fine, but when I go to Options > Petition, check Enable Petition, I get the following error message:

    Fatal error: Cannot redeclare fcpetition_upgrade() (previously declared in D:\Websites\HolidayTravelWatch\Website\wp-content\plugins\wordpress-petition-plugin\fcpetition.php:38) in D:\Websites\HolidayTravelWatch\Website\wp-content\plugins\wordpress-petition-plugin\fcpetition.php on line 49

    I guess that tells me that that the page is running twice but I cannot find out why? I don’t suppose you have any ideas?

    Thanks in advance,

    Pete

  10. Eoin Dubsky Says:

    This is a great little plugin, and freecharity is a great initiative too! You should get in touch with the good folks at MySociety.org (the people behind sites like PledgeBank.com) for ideas and tools that could come in handy for cash-strapped UK charities.

    Best wishes,
    Eoin

  11. David Says:

    Wordpress 2.3.3, Keep getting “Sorry, someone has already attempted to sign the petition using this e-mail address” even though there are no successful petition submissions yet.

    Using the petition page as the home page - is that effecting this? I’ve tried multiple permutations of URLs, to no avail.

    (Incidentally, even though the readme file says version 1.0.1, WP plugin page insists it is 1.0 and prompts to download the new one again.)

  12. Shawn Says:

    Hi if others are interested in language variants may be we can help

  13. jason Says:

    Hi, whenever anybody types the following: ‘
    it shows up as a: \
    not sure why.

    so ‘hello dolly’ shows up as \hello dolly\ for some reason. any help would be much appreciated.

    jason

  14. jason Says:

    also the ability to edit the comments made on the petition would be great, i.e. to take out swear words etc.

  15. revolution Says:

    I’m getting an error

    mysqldb.wp_petition_signatures’ doesn’t exist]
    select petition_confirmation,petition_from,petition_title,confirm from wp_petition_signatures,wp_petitions where wp_petitions.petition = wp_petition_signatures.petition and email = ’spacemanmkd@gmail.com’ and wp_petitions.petition = ‘2′;

  16. revolution Says:

    it works with the new file.

    thanks. great scrript.

  17. evowebber Says:

    im having similar problems to jason, not showing the characters correclty shows ‘/////’ instead of quotes.

    also when results are exported to csv, can the results be ordered into columns for excel, i.e. one column for emails relieved, one for names, it all seems to throw it all in together in one big line of info. Which means you have to manually sort through the results to arrange i.e. all the emails addresses together etc. I want to just be able to see a column of emails and names in excel but it doesnt arrange it like this when I click export to csv.

    thanks, brilliant script.

    TG

  18. chat Says:

    I’m getting an error

    mysqldb.wp_petition_signatures’ doesn’t exist]
    select petition_confirmation,petition_from,petition_title,confirm from wp_petition_signatures,wp_petitions where wp_petitions.petition = wp_petition_signatures.petition and email = ’spacemanmkd@gmail.com’ and wp_petitions.petition = ‘2′;

    ?

  19. Video Watch Says:

    im having similar problems to jason, not showing the characters correclty shows

  20. Mark Ði ßiasio Says:

    Nicely implemented plugin. It works great - thankyou.

    I do have a suggestion, add a postal code entry or perhaps a city and state/province field.

  21. James Davis Says:

    The database error probably indicates that you’re running an older version of the plugin. Please download the latest version and let me know if you still have the same problem.

    As for post code/city/state/province fields, this is something I’ve been thinking of adding but I’m waiting until I can come up with a solution to fit all locacles before releasing any changes.

  22. majkelx Says:

    Great plugin! Clear code.

    One thing: There should be created an index in petition_signatures table on filed time, there is a lot of sorting on it.

  23. Oscar Hayward Says:

    I ran into some problems during installation, namely the signatures weren’t being registered at all. Basically what Dave ran into.

    The reason was that in the SQL syntax, ‘confirm’ and ‘fields’ are MySQL keywords, and weren’t being treated as strings. Therefore the solution was to wrap them with quotes (`). Now it works like a charm!

    James, I suggest you implement this into the next release, as it could affect quite a few users.

    Many thanks for the plugin!

  24. James Davis Says:

    Dave’s problem was fixed some time ago, you shouldn’t be seeing the same one. What version of the plugin have you downloaded?

  25. Mete Says:

    En Kaliteli Oyun Sitesi Bedava Oyunlar

  26. Sohbet Says:

    animation,chat, funny videos,astronomy,stories, games,the best love poems, scripts, biographies,
    news, interpretation of dreams, woman,music,hygiene

    http://www.tamdost.com

    thank you site admin….

  27. CoLiN Says:

    sinop,Sinop,Sinop Forum,Forum Sinop,Sinop Sitesi,Sinop Hakkında aradığınız herşey burada…

  28. OzgurHosting Says:

    host,hosting,irc,ircd,shell,resell,radio,unreal,cr

  29. Sinop Says:

    sinop,Sinop

Leave a Reply