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.
Subscribe to news feed
November 30th, 2007 at 5:14 am
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
December 3rd, 2007 at 10:49 pm
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
December 25th, 2007 at 4:09 am
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) )
January 2nd, 2008 at 8:44 pm
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?
January 3rd, 2008 at 7:12 pm
Problem solved.
Thanks to James.
Just replace that you can find at
http://svn.wp-plugins.org/wordpress-petition-plugin/trunk/fcpetition.php
Bye
January 22nd, 2008 at 12:58 am
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
January 22nd, 2008 at 10:44 am
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/
January 24th, 2008 at 11:46 am
I just wanted to drop this note to thanks James for all his help!
Much appreciated James.
Regards
Leigh
January 30th, 2008 at 1:35 pm
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
February 2nd, 2008 at 6:54 pm
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
March 5th, 2008 at 12:52 am
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.)
April 17th, 2008 at 7:43 pm
Hi if others are interested in language variants may be we can help
April 18th, 2008 at 11:46 pm
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
April 18th, 2008 at 11:47 pm
also the ability to edit the comments made on the petition would be great, i.e. to take out swear words etc.
April 20th, 2008 at 12:04 am
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′;
April 20th, 2008 at 12:19 am
it works with the new file.
thanks. great scrript.
April 22nd, 2008 at 8:06 pm
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
May 25th, 2008 at 7:25 am
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′;
?
June 7th, 2008 at 1:26 am
im having similar problems to jason, not showing the characters correclty shows
June 9th, 2008 at 1:27 pm
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.
June 12th, 2008 at 1:35 pm
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.
June 26th, 2008 at 2:14 pm
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.
July 20th, 2008 at 5:16 pm
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!
July 20th, 2008 at 5:27 pm
Dave’s problem was fixed some time ago, you shouldn’t be seeing the same one. What version of the plugin have you downloaded?
July 24th, 2008 at 9:16 am
En Kaliteli Oyun Sitesi Bedava Oyunlar
July 24th, 2008 at 10:49 am
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….
July 25th, 2008 at 1:00 am
sinop,Sinop,Sinop Forum,Forum Sinop,Sinop Sitesi,Sinop Hakkında aradığınız herşey burada…
July 25th, 2008 at 1:15 am
host,hosting,irc,ircd,shell,resell,radio,unreal,cr
July 25th, 2008 at 1:46 am
sinop,Sinop