Extremely Important:
This page is for Democracy 1.2 and has been preserved for archival reasons. Democracy 2.x has been released and fixes security problems, allows in-post polling, and a much better interface.
I’m announcing my second ever WordPress plugin, Democracy. Democracy adds polling functionality to your WordPress blog. It grew out of frustration with the only other WordPress polling option, WP-poll. It didn’t have valid markup, it was clunky, and it required one heck of an installation process. So I decided to create my own, using WP-poll as a reference. This plugin uses AJAX for quick sending and loading of poll data, although it doesn’t depend on javascript to function, like my other plugin. It is fully functional in non-javascript environments, meaning it will work in ALL browsers. The AJAX part is tested to work in Safari, Opera, Firefox, and IE6/Win. The poll is in my sidebar, so go ahead and see for yourself.
It also has a full-featured admin panel, which allows one to manage their polls. You can activate, edit, delete, and add new polls from the admin panel. It is also harder to ballot-stuff than WP-poll. It uses cookies as well as IP logging to prevent users from working spamming the ballot box.
And Installation is a piece of cake. Just upload it to your server, activate it, and place a template tag in your theme where you want the poll to appear.
Download: Version 1.2. It is released under the CC GPL 2.0. If you are upgrading, read the upgrade instructions in readme.txt
NOTICE: Democracy 2.0 is in development. It is being rebuilt from scratch to be more flexible. Make your feature suggestions on my democracy 2.0 post.
ESPAÑOL: Download version 1.0 RC 2. Many thanks to Javier Albert for providing a translation
Features:
- Uses AJAX for sending and loading the results, but is fully accessible in non-js environments
- Complete admin panel
- When someone votes, they receive a cookie with what poll they voted in and what their vote was. It also logs their IP, so the same person can’t vote twice even if they delete the cookie
- Allows users to see current results without voting. Also, detects if there are no votes and announces it…
- After voting, the choice you made is highlighted.
- Automatic database table installation.
- Displays winners of each poll in the admin panel.
- Delete old polls in the admin panel.
- Edit existing polls.
- Graphs the results of the poll beautifully and without images.
- AJAX is compatible with IE 6, Safari, Firefox, and Opera. All the other browsers, and those with javascript turned off, are supported as well.
- Select an active poll.
- jal_democracy() takes poll ID arguments. Use < ?php jal_democracy(10); ?> to display poll 10. However, I recommend you use the ‘activate’ feature instead.
- Allow your users to add their own choices.
- Uses the date format you set in the Options panel for the Date Added column.
- Support for rich HTML. Make your polling options be images!
Please report any errors you encounter with it in the comments below. If you like it, saying thank you is all I ask.
Update July 11
Just updated to Alpha3. It’s lot more robust, and there are plenty of new features. Check out the democracy.php Diff and the js.php Diff. The javascript file no longer conflicts with my other plugin, WordSpew. It also allows you to allow users to add their own answers if they don’t like yours.
New in Democracy Alpha 4 (plugin diff):
- Added a few options to the head of the plugin file.
- Added CSS file and
id / classhooks that allow for easy manipulation of the design. At the top of the plugin file, you can set the HTML that the question will be wrappd in. - New graphing feature makes everything look much nicer when viewing results
- Fixed HTML validity bug.
- Cleaned up the checkIP() function for better performance.
- Cleaned up some
if...elsestatements to use ternary operators - Added deactivation feature, so if you want no poll to display, you may. Also, the default poll is no longer active.
- Archiving function to view past polls.
Update: Releasing Beta 1, very small update. Allows users to set if they want to order the results by votes or by id. Gets rid of big bug that creates errors in wordpress if javascript is off/not running. It should work with and without javascript now. Also tweaked the CSS for Explorer.
Update August 2: Version RC 1 is here. I believe this one to be stable and ready for consumption. Here are some notes:
- Fixed glaring bug that made IP checking completely not work.
- Added a field for ‘added by user’, for answers added by users. This helps differentiate any ‘silly’ answers from your ‘official’ answers.
- Bugfixes and code cleanups everywhere
- Support for Blix theme. The Blix CSS is poorly written to make all inputs and labels be for table-like forms.
- Got rid of a couple of IE Bugs that gave console errors.
- Fixed or improved the flash between voting and receiving new poll data.
- More FAQs and readme goodness.
Update August 15: Releasing RC 2. Bugfix release
- HTML validity fixed
- Rich (HTML) poll answers and questions re-allowed
- i18n improvements.
- Cookies now operate on local level instead of domain level. Useful if you have more than one blog in a domain.
- More code beautification
If you’re updating from a version before RC 1, you’ll need to deactivate the plugin and reactivate it again.
Update August 27: Releasing 1.1. Feature release
- Adds archiving functionality. Use the
jal_democracy_archives()function. Documented in the readme. - Changed the graphs to use percentages instead of pixels.
- Changeset 3215
- Shaved a query for total votes
Update September 26: Releasing 1.2 Feature release
- Shaved quite a few queries in admin panel and elsewhere.
- Now uses correct charset
header(). - Code restructuring and optimization
- No maximum for the number of answers. Cleaner editing and adding screens
- Fixed CSS comments
- Corrected link to my blog from the plugin page
htmlspecialchars()on unencoded links- Added 2 new FAQs to the readme
German users, you can grab a localized version of Democracy at http://www.bueltge.de/wp-plugin-ajax-umfrage-plugin/32/ . I would like to offer a localizable .pot file so that other languages can easily be done, but I have yet to find a tool for Mac that can do this. If you know of any please let me know!
There've been 331 whole comments
5:51 pm on 6/29/2005 1. Andrew
Hi,
I’ll check out the plugin… looks great on your site. I found out about it from the WordPress support forum (http://wordpress.org/support/topic/37853#post-213586), but the link you provided comes up with a 404 error. You may wish to fix!
11:42 pm on 6/29/2005 2. Karl Bedingfield
What a great and easy to use plug-in. Thank you!
Is there a way to display the current poll in the sidebar and older polls (all polls) on another page?
Just wondered .
Thanks again
Karl
8:50 am on 7/3/2005 3. Mario
Andrew,
Thanks for the plug-in. I already implemented it in my blog without any problems.
4:54 pm on 7/5/2005 4. Chad
A question and a suggestion. Why does the total # of votes not match the total of the two options?
I have 10 votes for A (37%), 14 for B (52%) but the total votes is 27? Where did the other ones go?
And also, can you have the jal_democracy() function take an optional argument, being the # of a poll to display? such as jal_democracy(11) will display poll 11? You would still have a primary poll designated for when the argument isn’t set.
Then, I was planning on writing a complimentary plugin, so you can insert polls into the posts themselves. One post could be for poll #7, and another one for poll #8.
Chad
10:46 am on 7/7/2005 5. Sam
Well, this plugin was a clever idea since the last poll plugin you could vote as many times as you wanted. I was kind of a fan of that feature, cuz than whatever you wanted to win, you could make win.
But I guess it’s not a bad idea to have a poll plugin that you can only vote once on.
Nice job.
6:25 pm on 7/10/2005 6. XeroCool
ANyone having problems between Firefox and IE? I can only see it in IE and not firefox. even after I voted.
7:03 am on 7/11/2005 7. dOn
Thanks to your Democracy plugin, my friends are now coming up with the silliest polls ever! It makes things much more interesting!
Well done!
5:04 pm on 7/11/2005 8. Andrew
Updated to Alpha3. Some of the above comments have been addressed and problems should be fixed. Enjoy!
1:13 am on 7/12/2005 9. kalico
Thanks for a great plugin!! Only probs were related to having had WP-polls on my site before…. I recommend fully uninstalling WP-polls (just follow the directions, backward
), including the tables in the database, prior to installing Democracy!
The only thing I don’t see is how to make a page that shows past (inactive) polls, and their results. Is there a way that I’ve missed?
Thanks again.
1:27 am on 7/12/2005 10. Andrew
kalico, that is definitely good advice. Some people have come to me wondering why the admin panel wasn’t working, only to realize that it was the remnant WP-polls admin panel. One simple way to get rid of its remnants is upgrade to the latest version of WordPress (1.5.2). If you haven’t done it already, it’s a perfect reason to upgrade.
I agree, I’d like a polls archive. I guess it’ll be another day of intensive coding tomorrow. *sigh* … I’ve got some small fixes for Alpha3 already written down. Be on the look out tomorrow!
4:17 pm on 7/13/2005 11. Jason
Replying to your post at my site here so you see it.
The error I got on install was about an Insert failing as I think it had more values then there were columns in the table, sorry but I didn’t grab the error as I was just leaving work when I did it and it doesn’t look like it made the logs.
Then when I added the first poll assumedly because the demo poll wasn’t added properly I ended up with a bunch of extra answers (good, bad etc) added into those that I selected.
4:43 pm on 7/13/2005 12. Jason
Also you might want to look at HTML escaping questions and answers those ampersands in my answers broke my XHTML, it would be a pain to always type & in such a scenario.
Also at least the View Results link broke XHTML as well as it uses get parameters with an ampersand, you should switch that any other links with get parameters to use & as well to avoid similar problems.
7:21 pm on 7/13/2005 13. Andrew
Yes, I’ve fixed all internal validation errors for the next version. It would be a pain to account for user-inputted XHTML invalidness, but maybe I should. Are there functions in WordPress that do that?
Thanks for the heads up.
9:02 pm on 7/13/2005 14. Jason
Just use the bult-in php function htmlspecialchars and that should be enough.
7:53 am on 7/14/2005 15. Kevin
Hello, I’m trying out this poll for FirstPersonShow.net at http://FirstPersonShow.net/beta1
Seems like after voting the choice I made is highlighted, but the number is not incremented. (I’ve voted a number of times from different browsers and PCs but still only seeing one as total votes.)
I’ve take the references to GamerZ poll out of the header.php and leftcolumn.php and deactivated the plugin, but do I need to do something else to get this working?
cheers,
Kevin
http://FirstPersonShow.net
“celebrating the uncelebrated”
(Interview Podcast)
12:43 pm on 7/14/2005 16. Andrew
Kevin, that’s a feature of Democracy. It doesn’t allow people to vote multiple times because it logs IP addresses. If you’ve voted from one IP, you can’t vote from it again no matter how many browsers or computers you use.
12:58 pm on 7/14/2005 17. Jason
Another heads up, in FF 1.0.X setting innerHTML in XHTML pages (with MIME type application/xhtml+xml) fails and just sets it to blank as per:
http://www.quirksmode.org/bugreports/archives/2004/11/innerhtml_in_xh.html
This will be fixed in 1.1 and was working for me from home where I’m running a nightly build but on my work laptop with FireFox 1.0 the div was just getting blanked out.
3:13 pm on 7/14/2005 18. Andrew
I was waiting for someone to point that out
I’ve just spent the day getting the data to load with proper XHTML pages. This is how far I got:
I get the response from AJAX and convert it to XML, then appendChild() it into the democracy box. This gives me all the text nodes and all the structure, but none of the HTML behavior. That means: links don’t work. CSS doesn’t work. Etc. If I apply some css like:
#democracy li {
display: list-item;
}
Then the list items will look like list items. I’d basically have to rewrite all the behavior of all the elements involved.
Alternatively, I could parse the XML and use DOM createElement() to make the HTML parse happily. But that would create a lot of bonus code that probably isn’t worth it for supporting such a fringe case of FF 1.0.x with XHTML headers.
So, I think I’ll just suck that up and wait for 1.1 to bring innerHTML support. If you want to work on the code I had and see if you can improve upon it, I’ll be happy to send it to you. It just doesn’t seem worth my time.
9:34 pm on 7/16/2005 19. Christopher Camacho
I’ve implemented this today, and it’s great. I’ve got a feature request, however. How about making it so that it can display a random poll?
3:33 am on 7/18/2005 20. Rich
Hi. Installed and setup, but no admin link in the manage section. Using 1.5.1.3 of WP, with lots of other plugins….any idea where admin is? Thanks…
Rich
9:57 am on 7/18/2005 21. dbt
Rich, are you sure you’re looking under manage and not options? also, make sure it’s enabled. works fine for me in 1.5.1.3
11:48 am on 7/18/2005 22. Rich
DBT,
Yes, looking in the right place. Do get an error in javascript though….a problem in wp-admin/edit.php.
Two in fact…both say “expecting ‘}’” I haven’t editing the edit.php, so I assume its having an issue loading something up in the admin menu bar. As per instructions, I installed the entire Democracy file folder in the plugins folder. No files go directly in the plugins folder, only the plugins/democracy folder, right?
Thanks, Rich
8:33 pm on 7/18/2005 23. Andrew
Rich, that’s strange. You seem to have gotten the installation right. You could try upgrading to Alpha4 that was released a couple days ago, and if the problem is still there, that is indeed weird. Perhaps if you’d allow it you could let me poke around your admin screen and see if I can’t find the problem. Alright, let me know what happens. Thanks
2:40 pm on 7/19/2005 24. Jessica
Very cool plugin! Much easier to install than the WP poll plugin I tried before.
Unfortunately I cannot use it for my purpose, for I need a poll ystem that allows more than one active poll. :,-( For example if user should rate the layout of the blog and other things that will not expire. Is there a chance that this feature can be added in a release later? You would make me very happy.
3:00 pm on 7/19/2005 25. Andrew
Jessica, I’m not sure I understand. So when a user votes, it takes them to the next poll? Just displays random polls until they’ve taken them all?
I’ll work on that for the next version…
8:23 am on 7/20/2005 26. Matt
Excellent, excellent plugin! Much more elegant than the previous polling plugin. One issue though: the progress bars look wierd in IE. No problem in FF, but in IE they’re huge–like 30 pixels tall, with a little blue strip on the top and bottom of each bar and plain white in between. I’m going to look into it (probably just IE being crappy with CSS), but I wanted to make you aware.
11:38 am on 7/20/2005 27. Jessica
Hi Andrew!
No, that’s not what I meant.
It would just be great if you can have more than one active poll. The user can vote in all polls he want to: none, all, just one etc.
For example I would create a poll where you can vote which WP theme one prefers. This is a poll which can be active as long as the blog exists, but of course I want to add other polls later without disabling the first poll.
I hope I made it clear, sorry for my English and thanks for reading.
11:44 am on 7/20/2005 28. Andrew
I’m still not quite sure I got it :s .. You want to be able to create new polls on the backend, but still be displaying the old one? That should be simple, just create a new poll and then reactivate the old one.
Or, do you want to see a kind of “results” page where it shows the standings of old polls that have been made before?
12:25 pm on 7/20/2005 29. Matt
OK well it’s not exactly a real fix, but by adding “background-color: #06c” to the .democracy-choice class in democracy.css I at least filled in all the white space in IE. The bars are still 25px or so tall, but at least they look somewhat presentable now. http://3xmk.com
11:18 pm on 7/21/2005 30. Max Ischenko
Hi Andrew,
I installed your plugin and it works great…except then a problem with i18n. My site is russian-language (UTF8) and so are the polls.
I can setup questions in russians OK, and they are displayed just fine but when user answers, the results displayed as gibberish instead of russian symbols. The same with “add your answer” feature.
I suspect the problem lies in DHTML (i’m using Firefox) but I’m no expert in Js to fix it.
If you could let at it I’d be grateful. Thanks.
1:30 am on 7/22/2005 31. grandMasterKrust
Hi Andrew !
Wow – great plugin ! Its worked like a charm on my personal blog, i am currently setting up another and i am getting a strange conflict with a template !
the layout is all mangled and the options are next to each other in a horizontal structure , but if you vote it reverts back to how the poll should look !
10:01 pm on 7/25/2005 32. Dave
When attempting to put this into a post using David Chait’s QuickPHP I’m getting all sorts of extra
Anyone have any idea how to get around this?
10:02 pm on 7/25/2005 33. Dave
I guess the code tag isn’t working above, but I’m seeing extra breaks put in between the radio button and the answer.
10:11 pm on 7/25/2005 34. Andrew
Dave, you could try pastebinning it, post it in my shoutbox or something. Not really sure what the problem is here..
10:56 pm on 7/25/2005 35. Dave
sent you email with the details
2:45 pm on 7/28/2005 36. Kenzo
Nice plugin
. Can you help me to correct that plz?
Just a question: on IE the progress bars is very big… I tried to change it in css file but no result
http://dreamgirls.globbo.org/
2:54 am on 7/31/2005 37. Dedge
To fix the tall bars in IE, add the following to the .democracy-choice entry in democracy.css:
font-size:0.3px;
9:10 am on 7/31/2005 38. Carlos Maldonado
thanks a lot for such a wonderful piece of software, might be helpful to put somewhere a quick start to know that the two directories deep .zip, needs to be unzipped and the internal “democracy” directory put into wp-content/plugins
other than that, cool!
regards
12:11 pm on 7/31/2005 39. Jackie
Hello! I have installed your democracy plugin and it works great! I am having trouble with the styles though, seems it is not accessing the css file or something, and everything is coming out a bit messy looking.
Trying to remove the bullets, position the choices to the left, style the heading to match my site headings, and remove the extra space at the bottom.
The only way I could figure out to get the white box around the whole thing was a table in my sidebar with the code snip inside of it.
Please let me know what I am doing wrong!!
12:23 pm on 7/31/2005 40. Andrew
Jackie:
It isn’t opening the file because a vital part thing for your theme is missing. You need (in the tag) in your header.php file. That code is a hook for plugins that need to add things like css files and javascript files.
Dedge, I’ll twiddle with that, thanks!
Carlos, I think my plugins could use a few more FAQs in general. Thanks.
1:59 pm on 7/31/2005 41. Jackie
My theme calls for the header.php file, I guess I’m not quite sure what you are referring to… could you be more specific on what I am missing and where/which file it is missing from?
Thank you
6:12 pm on 7/31/2005 42. Jackie
Nevermind, I got some other help with it
Thank you!
11:56 am on 8/1/2005 43. Natai
Whenever someone votes AJAX refreshes but I get a 404 error.
1:22 pm on 8/1/2005 44. Andrew
Natai, are you using the latest version, Beta 1?
I need to see the error myself. Could you reactivate Democracy for a bit so that I can diagnose your problem?
3:22 pm on 8/1/2005 45. CaveCulture
I’ve got a slight validation problem. I’ve installed the plugin and pasted the required code into my side bar. When it comes to validating my page I get a fair few problems.
Now I’ve had validation problems when installing new plugins before but all it took to fix them was to insert/correct a few tags.
I don’t want to paste the list of problems because it will clutter everything up, but it looks like the problem lies within the code. I’m just wondering wether or not you know about it.
Apart from validation problems it looks and works great. I use your shoutbox aswell. Good work on it btw
3:23 pm on 8/1/2005 46. PRpoet
Andrew, first of all Thx for doing all the hard work and coming up with this cool poll plugin.
I’m having the same issue that grandMasterKrust is having:
the layout is all mangled and the options are next to each other in a horizontal structure , but if you vote it reverts back to how the poll should look !
====
I’ve tried tweaking the php code but nothing seems to work. Help! I really want to use your poll.
Thx, PRpoet
P.S. You can see what I mean at http://prpoet.com
3:42 pm on 8/1/2005 47. Andrew
CaveCulture, I’m not aware of any validity problems. From your message, there is no way for me to help you and fix the problems. I need a link to the site having problems with, what kind of error it was, and all that.
PRpoet, I can’t help you if I can’t see what’s happening. It looks like you’ve disabled the poll. Could you re-enable it so I can have a look at the problem?
A note to future support questions:
PLEASE post your URL, do not deactivate the plugin, and I’ll get to it ASAP. It’s incredibly hard to help you when all you tell me is “There is an error. What should I do?”
Thanks.
4:04 pm on 8/1/2005 48. PRpoet
Hi Andrew, here is the link to see the poll:
http://prpoet.com/?page_id=6
I’m using the ‘Blix’ theme and coding the poll code into the sidebar.php template.
After answering the poll, it looks ok. Before that, there seems to be some problems with table elements.
Thx for your help – PRpoet
5:43 pm on 8/1/2005 49. Andrew
CaveCulture, I found you by googling ‘CaveCulture’ … google is my friend!
That XHTML problem is indeed a bug, one that I have fixed in my next version that’ll be released soon.
PRpoet, ah. I played around with the css and found that it was a problem with Blix’s css, not mine. But in any case, you can just add this code and it should be all fixed. I’ll add it to the next version as well.
#democracy label {
float: none;
display: inline;
}
#democracy ul {
padding: 0;
}
10:43 pm on 8/1/2005 50. PRpoet
Thx Andrew, how do I make the radio boxes shorter so they fit within the sidebar? Also, you’ll see an underlined ‘s’ under the last link on the main template, how do I get rid of this? This character only appears after installing the poll.
http://prpoet.com/?page_id=6
Thx again, PRPoet
11:35 pm on 8/1/2005 51. Andrew
strange I didn’t catch that.
#democracy input { width: auto; }
12:45 am on 8/2/2005 52. PRpoet
Andrew, Thx – U Da Man =D
Looks and works great now, I’ve put it on my landing page:
http://prpoet.com
Cheers, PRpoet
12:46 am on 8/2/2005 53. PRpoet
Andrew, Thx – U Da Man =D
Looks and works great now, I’ve put it on my landing page:
prpoet.com
Cheers, PRpoet
2:52 am on 8/2/2005 54. Andrew
** New version of Democracy **
Vlad,
I’ve just been working on this plugin a lot and I’ve found this error. Thanks for the update. You can download the latest version that correctly stores IP addresses now.
The new version addresses a lot of bugs and adds a couple new features. Have fun!
7:05 am on 8/2/2005 55. CaveCulture
i got rc-1 but it doesn’t validate. I turn it on and it doesn’t validate unfortunately. Did you address this bug in this version?
7:38 am on 8/2/2005 56. PRpoet
Andrew, you forgot to put this Blix fix into the Aug 2 democracy.css release:
#democracy input { width: auto; }
PRpoet
11:31 am on 8/2/2005 57. Andrew
Vlad, that is indeed Version 1.0 RC 1. I know in the past people have had problems with their browser caching the file.
Alternative download:
http://www.redalt.com/External/plugins.php?p=democracy
And download the in-development version. That is actually RC 1, and it is stable.
1:13 am on 8/4/2005 58. Michael
Quick little bug:
It took me awhile to figure out why I was getting a parse error on line 454 of democracy.php.
Line 343 uses a short open tag, and our university’s servers have short open tags set to false.
12:23 am on 8/5/2005 59. Lu
Hello! I loved this plug-in!! I’ve installed before “wp-poll”, but I couldn’t customize it, so I’ve looked for another plugin for polls and found yours! It’s too good AND too easy, congrats!
I’d like to erase the number of votes, leaving just the percents. Is it possible? Where can I do this?
Thanks!
12:32 am on 8/6/2005 60. Kenzo
Hi, Thank you Andrew for the new update
I have no problem with alpha4 version, however when I update to RC1 (overwrite democracy.php, js.php, admin.js), I receive this: http://img211.imageshack.us/img211/8889/democracyerror2qe.png
12:35 am on 8/6/2005 61. Kenzo
Forgot to say thanks to Dedge and PRpoet for the nice css fix ^^
1:31 am on 8/6/2005 62. Andrew
Kenzo, READ THE UPGRADE INSTRUCTIONS. I thought it was clear enough by putting that in bold right next to the download link. That oughta fix it
Michael, sorry! Careless error that should be fixed in the next version
Lu, sure. Just delete line 586 of democracy.php:
$output .= " (".$r->votes.")";3:30 am on 8/6/2005 63. Luigi
Hi from Italy
Eheheh Great Plugin this one! I need to use it on my blog, so I translated it in Italian. This localized version is available on my website, I only wanted to let you know
Uhhh, nice blog
10:12 pm on 8/6/2005 64. Kenzo
Thank you, It work now
I have now just a small problem with the xhtml validator on this line in democracy.php:
jal_no_js=true&poll_id=id; ?>”>View Results
Here is the error code (6 times):
Line 461, column 78: cannot generate system identifier for general entity “PHPSESSID”
…href=”/?jal_no_js=true&poll_id=2&PHPSESSID=441ef9267e7fd7e9f352d8f7e16ed5
3:47 am on 8/8/2005 65. Jackie
When I placed the whole folder into the plugins directory it didn’t show up in the plugin manager. I moved the democracy.php file outside the folder and it appeared and I was able to activate it. Now it works fine except I am unable to add another question. Any ideas?
9:08 pm on 8/8/2005 66. Lu
Done!
With your hint, I removed also the “Total Votes”.
Thanks a lot!
3:12 am on 8/13/2005 67. RyanHawke
Hey there:
I think I ran across a bug related to the not voting more than once feature.
On my site, I have 2 blogs using the same database (appended the prefix for one).
Anyway, I installed on both my blogs and it is AWESOME. Easy installation.
However, when I went to install on the second blog, it already shows me as having voted, since I did a test vote on the first blog. Could it be both blogs are sharing the same table? If so, do I need to append a prefix somewhere in one so it uses its own table?
Here are the blogs:
http://unfilterednewsnetwork.com/North_South_Blog/
http://unfilterednewsnetwork.com/Gay_Agenda_Blog/
3:13 am on 8/13/2005 68. RyanHawke
Oh yeah, I forgot to mention on the second blog, it does not allow me to vote but shows as no votes. I also checked the database and the tables were created with the correct prefixes.
3:27 am on 8/13/2005 69. RyanHawke
OK I went ahead and completed two completely different polls since I was using the “starter poll” on both. Still same issue. North_South_Blog shows no answers and inability to vote for me, since I voted on the other one first.
This time, I created 2 new polls but voted on NS first. Then, the GA poll was unavailable.
Any other info you need, feel free to email me.
2:54 am on 8/15/2005 70. Andrew
RyanHawke, the behavior of the site has to do with the way cookies were being set. I had them being set at the root, so a vote was logged for the entire domain, instead of just the WP directory. Regardless, I believe I’ve fixed this in RC 2. Let me know if I haven’t
Err…announcing RC 2! (main changeset and small fix)
I think I’ve fixed some i18n issues, as well as re-adding HTML support.
Kenzo, I’ve added htmlspecialchars() to that bit, so the validity problem should go away. But it does seem a bit odd. You had javascript off and you’re using PHP sessions?
Jackie’s problem has been fixed elsewhere. Just don’t use that confounded plugin manager and you’ll be fine.
11:13 pm on 8/15/2005 71. Matt
Hi Andrew,
I’d like to use Democracy to run a poll, but I want it not in the sidebar, but on a post or a page. How would I go about doing that? (in draft form, at least, both posts and pages just echo “”)
Also, the poll I want to run requires users to judge among a series of images; ideally, each poll option would display an image and some text under the image. Would including an image tag in the poll options work for that?
thanks for your help, and for this plugin.
best,
Matt
Matt
11:15 pm on 8/15/2005 72. Matt
the code in my comment disapperaed…the text that is echoed is simply the php jal_democracy() line …
3:49 am on 8/17/2005 73. marco garcia
hello, i’ve installed your excellent Poll “encuesta” plug in on a site i’m building and was really satisfied with the quality of the script. It installed like a breeze and the admin panel is perfect. I have a quick question. A tiny little problem i can’t get figured out. I’m using the Connection theme and have the Category separated by the question so that the box is not connected. could you or somebody take a quick peek. i’ve played with css and tried somethings in the code but can’t seem to find the solution. i would also like to have the question set flush to the right, how or where do i edit this and what should i enter?
3:49 am on 8/17/2005 74. ryanhawke
Ahh thanks. Yes, this is fixed.
1:01 pm on 8/18/2005 75. Andrew
Marco, try this:
Connections is a little weird about sidebar stuff, but that should work.
1:59 pm on 8/21/2005 76. gutielua
Wow! DEMOCARY ROCKS!!!
I have problems whit wp-poll, on Firefox works but not on IE.
Democracy works for IE & Firefox!!
Regards from Monterrey, MEXICO!
7:24 am on 8/22/2005 77. gutielua.com
What I need to con center the VOTE bottom on sidebar?
I will like do to same for TGA question…
Tnx
12:03 pm on 8/23/2005 78. Andrew
Democracy is now available in Spanish! Download link above
Gutielua, try adding this style rule to your css file:
#democracy p { text-align: center; }1:42 am on 8/24/2005 79. Ash Haque
Awesome plugin! Using it right now and it looks really good. Maybe in a future release there could be a way to generate all the polls into somewhat of an archive like wp-polls.
12:19 pm on 8/26/2005 80. Ross
Thanks for your excellent plugin, I implemented it on my site without any issues! You rock!
8:25 pm on 8/26/2005 81. Finhawke
I really enjoy your plug-in … especially the flexability and single voting feature. It would be great if the polls could be archived to a single category that could be recalled by visitors to view all past polls and their results. This was a feature in the wp-polls plug-in that I would like to see in Democracy. Any chance this will happen?
Thanks again for an excellent plug-in.
John
1:14 am on 8/27/2005 82. Kelley Chambers
I would give it to a solider for private mail to his family, friends, significant other… along with the other 37 I’ve donated in the last 3 months…. I love you Subscriptions for Soliders…. we gave tonight. Long live the US!
2:06 am on 8/27/2005 83. Andrew
Update: Version 1.1 now has archiving functionality!
Well SOOO many people have asked for this archiving feature, so I’ve gone ahead and done it
Tell me what you think of http://blog.jalenack.com/poll-archives/ . Does it need anything more? I’ll release soon.
12:46 pm on 8/29/2005 84. Finhawke
Right on the money. Outstanding!
Thanks, Andrew.
5:58 pm on 8/29/2005 85. Patrick
Just saying thank you as requested! This plugin is up to the excellent standard you set with the shout box.
No problems, no issues. It worked fine first time.
I love it.
6:39 am on 8/30/2005 86. James Moore
Thanks! Just what I needed, and installation was pretty easy!
9:31 am on 8/30/2005 87. Titanas
Translating the strings from english to greek results in a mess when ajax is reloading to display the results. ???? appear where greek words should be. this is an encoding issue i guess. any ideas?
4:30 am on 8/31/2005 88. Rich
So… how do I upgrade from RC 2? The heading of the readme.txt Upgrade section makes me think it doesn’t apply to me: “All versions previous to Democracy RC 1 MUST follow these simple upgrade instructions:”
Just wondering if upgrading from RC 2 means I should follow those same directions or different ones.
1:58 pm on 9/3/2005 89. Alan Köninger
Hi, Thanks for the plugin. Any chance you could allow for multiple polls being active as part of the archive section?
Currently you can only have one poll active, and this is a real disadvantage for someone who wants to keep their polls running concurrently over time and have users voting on multiple polls.
If you did allow for multiple polls being active, then there would be an issue about which poll would display on the non archive section ie. <?php jal_democracy(); ?> section – that could be solved by either adding another button called ‘hightlight’ on the poll admin page, or by displaying the first in the order (order by ID).
Thanks, Alan
3:01 am on 9/5/2005 90. little_china
hey andrew! nice plugin and thank you for making it a lot easier to install than the other polls plugin
i got a question tho, can i edit the number of polls? i really want this coz i’ve already got a poll question and some answered, but i still didn’t have the poll plugin at that time.
click my site to see my blog. hoping to hear from you soon!
cheers!
4:26 pm on 9/8/2005 91. Matt
I have the Bad Behavior plug-in installed on my website. Democracy seems to work fine with Firefox, but when I tried to vote with IE 5, Bad Behavior blocks the computer as a spammer with the error message:
Required header ‘Accept’ missing
10:16 pm on 9/8/2005 92. Patrick
Andrew, I was just wondering if there is a way to allow people be able to vote every 24 hours?
11:55 pm on 9/8/2005 93. Andrew
OO looks like I’ve got some catching up to do.
Titanas, strange. Encoding issue most likely. I’ve been having a lot of trouble with that stuff.
Alan, I’m working on something like that. It’s pretty hard getting multiple instances of polls on the same page. You can call a specific poll by using its ID like: jal_democracy(2); …
James: glad you like it
Little_china, I have no idea what you;re talking about o_o
Matt, very very weird. Try contacting the Bad Behavior author. Are you using the latest version of BB?
Patrick, no. No plans for that. Sorry
1:56 am on 9/10/2005 94. little_china
sorry…i mean, can i edit the number of votes?
thanks!
2:18 am on 9/10/2005 95. Andrew
Oh right. Well not really. If you *really* wanted to you could use something like PHPmyAdmin to change the `votes` column of the appropriate answer. Look in the DemocracyA database.
8:56 pm on 9/11/2005 96. little_china
oh alright, thanks man!
10:30 am on 9/13/2005 97. Jani Tarvainen
I’m absolutely loving this plugin. Great work!
10:08 am on 9/15/2005 98. Heiner Neuling
Dear Andrew,
I’ve tried to make your plugin run on my site, placing the code
on a PAGE (use exec-php plugin for running code inside Pages).
All I can see than is just a kind of code from democracy.php.
Could you please visit the PAGE called POLLS on my above site, to see what could be wrond.
I’m running your Wordspew too, and it works great.
thnx in advance
heiner
8:31 pm on 9/15/2005 99. tony
hi!i like your plugin, can you tell me how to change the color and width of the button and button text? thankyou!
10:56 am on 9/16/2005 100. ZEO
I’ve got a questions,
I dunno why but the spammer kept hitting the js.php.
it’s on my access logs.
and i can confirm that.
any idea?
10:04 pm on 9/18/2005 101. Seth
I was hoping to use this plugin to let visitors vote for specific WordPress posts by using template tags to fill in the info for a poll (post title & URL) within a WordPress Loop. That way, I could put the poll into the WordPress Loop and have a “vote for this post” button for every post, with the rest of the poll inputs determined from template tags and hidden. It looks like this is almost possible, but there is a minimum of 2 answers for a poll and that there can be only one instance of a poll on a page (does this mean putting the poll in the Loop is not allowed?). Is there a way to get around these limitations? In other words, is there a way to have a write-own-answer-only poll in the Loop? Thanks.
6:21 pm on 9/19/2005 102. David
Remove the line “// BLIX fixies” from the css
or comment it: /* BLIX fixies */
It makes the css declaration under it invalid. In this case the input:
#democracy input { width: auto; }
Great plug btw
4:02 pm on 9/20/2005 103. Andrew
Whooppps. I suck. I’ve committed a fix. All that php and javascript mixed in the same package got me mixed up. Doh!
Seth, I don’t think Democracy is the right choice for what you want. I think there are some post-rating plugins around. I’ve never used one though.
Zeo, weird. I can’t think of any reason for them to do that. Let me know if you find out a good reason. thanks
Tony, you can edit the democracy.css file. It has all the color and styling information. If you don’t know CSS, good luck. I just don’t have enough time to help with individual design problems. The WP support forums are usually helpful with CSS issues.
Heiner, it looks alright. The only problem is with the blix CSS. Hopefully this fixes it. Just delete that comment in democracy.css, and it should work.
7:48 pm on 9/23/2005 104. charmaine
hi…i can’t figure this out, please help…
the php jal_democracy(); code was placed in between the ul code from my sidebar. The problem is that the ul code will place an image at the bottom (please check my blog). therefore the last “poll answer” has the ul-footer image.
Is there somewhere in the democracy file where I can remove the ul codes so that it wont have the footer image?
i hope you understand where im coming from…
7:01 am on 9/25/2005 105. David
HEllo All,
I have an issue with UTF-8 chareacters in democracy polls since I upgarded from RC-1 to 1.1.
Accented characters are replaced by strange characters but only in the result page!
To see the pbm in action:
http://82.153.160.104/blog/
Any idea what’s wrong?
Thanks
5:40 pm on 9/25/2005 106. Andrew
I just spent a little while debugging and I think I’ve found the solution. The text was not being sent with the right headers. I’ll be releasing a new version shortly (hopefully), but in the meantime you can try this:
if (!$javascript)
echo “\n\n\t”;
else
header(‘Content-Type: text/html; charset=’.get_option(‘blog_charset’));
?>
In your democracy.php file. Around line 520 (I think), there is a function called jal_SeeResults(). You’ll be replacing this, and all the whitespace above it between ?> and ‘; } ?>
If you don’t think you can do this, have patience and I’ll be releasing a new version soon
4:57 pm on 9/26/2005 107. Andrew
Just updated to 1.2. Check it out.
4:41 am on 9/27/2005 108. David
Installed 1.2 – It’s working now!
Many thanks.
1:45 pm on 9/28/2005 109. Jeremy Abramson
First off, let me say thanks for such a great pluging! But like a couple of others, I’d like to have polls associated with posts, not in the sidebar. Is there a quick/easy way of doing this? (I’d even settle for a not quick or easy way).
Thanks again!
6:46 pm on 9/29/2005 110. Andrew
Well, not really. Check the 1.2 readme!
6:58 pm on 9/29/2005 111. Jeff
Didn’t want the poll on my main site (busy traffic) so I put it on a secondary page, at the bottom. Same issue:
http://celticsblog.net/cheapseats/wp-content/plugins/democracy/democracy.php?jal_nojs=trueThe page cannot be found
Help? Thanks very much.
9:01 pm on 9/29/2005 112. Andrew
Jeff, it appears that the files are all in the wrong place.
First, deactivate democracy. Then delete all the democracy files you uploaded. Then upload the *whole* folder. So it should be
/wp-content/plugins/democracy/.. That folder should containadmin.js, democracy.php, democracy.css, js.php.Then activate again.
6:24 am on 9/30/2005 113. Jeff
makes sense, I’ll try that when I have time
thanks very much for the quick response
10:58 am on 10/2/2005 114. Andy
Thanks for adding those graphical bars. I just tried to install the plug-in. All 4 files are in the correct directory. I can configure the plug-in and I’ve added my first poll. How do I get the poll to show up in the sidebar? Sorry for the silly question. It doesn’t automatically show up.
Also your site is exhibiting some wierd problems in IE6 I’ve attached a screenshot at http://www.rawgreed.com/jalnack.png
Thanks!
1:25 pm on 10/2/2005 115. Jim
Thanks for this plugin. I just upgraded to 1.2 – very easy!
3:05 pm on 10/2/2005 116. Andy
Apologies, I got it. I forgot to add the template tag.
7:09 pm on 10/6/2005 117. Nik
First off, awesome plugin. Thanks for adding the achiving option – very nice. Anyway, I saw on your archive that the bars are quite long, and thus easier to read. I’ve been searching through democracy.php, and I can’t see how to change their size. So sorry if I’m repeating someone – I skimmed over the comments, and I couldn’t see the same question being asked.
2:45 am on 10/12/2005 118. FastPhive
I just installed Democracy 1.2 in WP 1.5.2 and everything seemed to work fine until i tried to rock the vote:
Fatal error: Cannot redeclare jal_edit_poll() in /x/x/x/x/x/htdocs/wp/wp-content/plugins/democracy/democracy.php on line 52
you can give ut a try at: http://www.phlatline.com/wp
Can anyone help me fix this prob? Please, this is a really nice plugin and i would like to use it.
5:55 pm on 10/12/2005 119. ZEO
Just a request, is it possible to have the view result then vote(back) without reloading the entire page?
8:59 pm on 10/12/2005 120. RichF
Hi Andrew…great plugin. I’m having a problem with the CSS display of 1.2 stomping on itself. The title of the poll is being over written with CSS, so that title and first choice are overlaid. I’m still learning css, and took a look at the democracy.css, and don’t think that’s the problem. Can you recommend a fix? Site is http://www.cwcnews.net . THANKS!
9:12 pm on 10/12/2005 121. RichF
Never Mind…find the culprit in the css file of BlueByeYou…thanks for a great tool…Rich
11:50 am on 10/15/2005 122. jude
Hi,
just installed Democracy 1.2 to WP 1.5.2_fi. Looks like it works OK, but it doesn’t – only the first vote counts and the db writes only one answer and IP number – and the number is the one of servers IP. Does anyone have a solution for this problem?
TIA
Jude
2:23 pm on 10/15/2005 123. Andrew
jude, that’s weird. Your server must be configured abnormally, using REMOTE_ADDR as the server address?
You could just comment out the jal_checkIP() calls or make it return; before doing anything. You’d lose the IP checking function, but at least it would work!
Zeo, nope sorry. Too much code for too little benefit.
FastPhive, that’s sooo strange. I really don’t know where to start!
Nik, I think 1.16 uses css percents. Is that the version you’ve got? Just make the css use percents instead of absolute pixels (you might have to change it in the democracy.php part as well).
Sorry to everyone who has written in for support lately, I’ve been really bogged down!
1:32 pm on 10/16/2005 124. John Havlik
Awesome plug-in, it is exactly what I was looking for when I started Googleing for Word Press plug-ins for polling. I’t appears to be working perfectly in FF 1.5 and IE 6. One thing though, if a person was to veiw it in FF and vote then open the page up in IE they can vote again, I assume this works nomatter which browser you switch to, just though you may want to know this.
2:32 pm on 10/16/2005 125. Andrew
John, that’s actually not the case. It appears that one can vote again, but when they submit it isn’t actually counted. That’s because their IP is logged
3:37 pm on 10/23/2005 126. Jorge Andres
Hi. Very nice plug in. Thanks! I have only one question. What lines do i need to comment in order to make Democracy to do NOT log ip adresses?
Thanks for the help. And good luck with your upcoming projects!
1:33 pm on 10/26/2005 127. Richard Hendrix
Andrew,
Is there any way to hard code the path/location in democracy? My site uses domain pointers. I have http://www.blankmindblog.com pointed to a folder in my http://www.frhendrix.com site. Democracy looks in /blog1/blog1/wp-content/plugins/democracy for democracy.php which does not exist.
thanks
11:18 am on 10/27/2005 128. Andrew
Thanks for the excellent plugin! Far easier to use and manage than my previous solution
5:35 am on 10/28/2005 129. leo
I seem to have the same problem as FastPhive getting the same error message when sending a vote.
Fatal error: Cannot redeclare jal_edit_poll() in /x/x/x/x/x/htdocs/wp/wp-content/plugins/democracy/democracy.php on line 52
I updated wp and deactivated all other plugins but the problem remains.
Admin lokks fine
tables are built
cookies are set
no vote-counting
Too bad because I saw it working great on other sites.
11:49 am on 11/8/2005 130. Fredrik
Trying to implement your plugin, but I do not see it in the admin-panel. I see some questions about it above, but no solution. Is there any?
I use Bunnys Technorati Tags and WP-Shortstats as plugins. Could it be that, tried to deactivate them but nothing happened, do I have to uninstall?
I use WP 1.5.2
Would really like to get it to work!
Thx
UPDATE: Fixed it! Egghead behind the keyboard
2:20 pm on 11/8/2005 131. SWR
Is it going to be back available?
Says democrocy.zip doesn’t exist any more.
5:28 pm on 11/8/2005 132. Andrew
Sorry, It’s back.
1:08 pm on 11/9/2005 133. Aaron
1. Is there a way to have the candidates automatically sorted alphabetically or by the current vote count?
2. Is there a way to have multiple polls running concurrently? An example of this might be a concurrent Democrat_Primary and a Republican_Primary poll where each is independent and people can vote and/or add candidates.
8:19 am on 11/12/2005 134. High Octane
After I activate the poll, I get this error.
“Warning: Invalid argument supplied for foreach() in /home/wagnert/public_html/blog/wp-content/plugins/democracy/democracy.php on line 637″
http://www.wagnertech.net/blog/
I’m using journalized-blue theme, and putting it in the right sidebar.
Any ideas?
Thanks in advance.
5:19 am on 11/15/2005 135. High Octane
I would like to add a space between the Poll Question and the Poll answer selection, where do I do his at?
Thanks in advance
7:24 pm on 11/15/2005 136. Pierre
Hi Andrew,
thank you for the great plugin !!
It’s really cool. I made some modifications and i would like to be able to send it (all the archive) to you.
But i found anywhere an email to contact you so… can you email me ?
I add the possibility to choose in admin console to show radio button (unique choice) or checkbox (multiple choice), a link to go directly to the admin console of democracy, the possibility to activate more than one poll and show them in random order (the “old way” is available too you just have to activate only one poll), modify the table in admin console to show if a poll allow user to change answer etc. and lot of other things…
Thanks again for your excellent work, and if you want, do not hesitate to contact me
Pierre
11:59 pm on 11/16/2005 137. Jason Anderson
Very nice! I love AJAX and was looking for a poll plugin using Ajax. This does it well.
5:09 am on 11/18/2005 138. Thomas Reimer
Love this – Great work!
5:12 am on 11/18/2005 139. lex
Thanks for a very nice (and easy) plugin!
5:54 am on 11/19/2005 140. patje
Hey Man,
So glad I searched on to this easy 2 use pluggin. It’s just doing the job, easy install instead of changing several php-files. Keep on brother doing this great job
6:16 pm on 11/19/2005 141. Kenny
Is there a way to modify the number of votes as admin. I’m moving from wp_poll to democracy and would like to copy my old my old posts and answers and don’t want to lose my old data. I just want to recreate my old poll questions and the number of answers. YIKES!
1:41 pm on 11/26/2005 142. patje
ok, great pluggin
))
but is there away (or other pluggin) to disable the ip-check….
for one reason,, my colleagues at work can’t vote because.. there is someing like a proxy server… and since most people don’t work but mostly internet at their desks
8:26 pm on 11/28/2005 143. Ben
Does anybody know how to make the poll answers horizontal with the radio button below each option?
10:34 pm on 11/30/2005 144. Frenzy
Hello,
I’m thinking about implementing this plug-in, but I’m concerned about what happens with people who are behind a proxy server. Since I would only ever see the proxy server’s IP, does that mean that only one person behind the proxy would ever get a chance to vote?
10:28 am on 12/1/2005 145. patje
To Frenzy:
Yep, only one person of the company where I work can vote ;-( if they’re using a proxy
2:26 pm on 12/1/2005 146. The Uncooperative Blogger
Thanks for the plug-in!
One problem, both my wife at her job, and I can clear cookies and vote all we want, so the ip checking is not working on my site. Does anyone have any ideas?
Do I have to give certain permissions to a file or something?
12:25 pm on 12/5/2005 147. Dezso
Thanks for the plug-in! This is something that I would ask for I have had time
Keep on coding… please!
3:10 pm on 12/6/2005 148. Stu
Andrew, thanks for the plugin man. Nice.
5:17 pm on 12/6/2005 149. Benjamin Solah
100 times better then WP polls!! Awesome plug in!
7:49 pm on 12/6/2005 150. Jaron
Fantastic… just what I wanted. Tried lots of other polls but you need to be a rocket scientist to get them to work. Very easy to set-up.
Cheers Jaron
12:56 pm on 12/11/2005 151. Frank
Cool stuff!
11:11 am on 12/12/2005 152. Jessica
Well, well done! So much easier than trying to get AdvancedPoll to work in the system… muchos gracias for your hard work.
9:24 pm on 12/14/2005 153. Alex
Hi… Very nice plugin, but unfortunately it is not work 8(. I made all installation and I can even see the pool on my sidebar, but it is not counting the votes. I tried myself and asked a friend of mine to do it, but is still not working. Do you have any idea how can I fix it??? You can try at http://www.bluetoothlounge.com/
Again, very good job. Please, we need more cool stuff like this one.
Thanks
9:56 am on 12/15/2005 154. edgar
It’s very easy to use. I like it… Thanks. Andrew.
8:07 am on 12/16/2005 155. World Cup Corner
On our site when user votes it shows the results but if you go to some other page or hit refresh results dissapear and you can vote again (but it doesn’t count).
Why are results not remaining after the vote???
6:19 am on 12/18/2005 156. Null
On our site when user votes it shows the results but if you go to some other page or hit refresh results dissapear and you can vote again (but it doesn’t count).
Why are results not remaining after the vote???
CONFIRMED, they all have this, some use of cookies would be nice….
Also if you vote, it takes a while before the results are shown. This makes me click vote a lot. Maybe a message like: You vote is being added. When you click vote will solve this.
And an option to have multiple choiches. Now you can only chose 1 option. Would be nice if it was set in admin per poll if you can choose just one or more options in a poll.
Add these things and it will be a nr 1 AJAXpoll
11:42 am on 12/18/2005 157. Andrew
I’m happy with Democracy’s current feature set.
9:36 am on 12/19/2005 158. World Cup Corner
Andrew, can you please answer my question above.
I just want users can vote only once (like on your page) and when they come back they would automatically see results. I know this works in Democracy but not on my site?
Thanks for your answer.
9:01 am on 12/22/2005 159. Richard
Mate!
It sounds like a fantastic plugin and more comprehensive than all the rest but it doesnt seem to work for me?!
When I go to activate the plugin I get these errors at the top of the page:
—-
WordPress database error: [Invalid default value for 'timestamp']
CREATE TABLE wp_democracyQ ( id int(10) unsigned NOT NULL auto_increment, question varchar(200) NOT NULL default ”, timestamp int(10) NOT NULL default ”, voters text NULL default ”, allowusers enum(’0′,’1′) NOT NULL default ’0′, active enum(’0′,’1′) NOT NULL default ’0′, PRIMARY KEY (id) )
WordPress database error: [Table 'richardsmagic.wp_democracyq' doesn't exist]
INSERT INTO wp_democracyQ VALUES (1, ‘Rate my site’, ’1135266993′, ”, ’0′, ’0′);
WordPress database error: [Duplicate entry '1' for key 1]
INSERT INTO wp_democracyA VALUES (1, 1, ‘Best. Blog. Ever.’, 0, 0);
WordPress database error: [Duplicate entry '2' for key 1]
INSERT INTO wp_democracyA VALUES (2, 1, ‘Could be better…’, 0, 0);
WordPress database error: [Duplicate entry '3' for key 1]
INSERT INTO wp_democracyA VALUES (3, 1, ‘My grandma could make a better website!’, 0, 0);
WordPress database error: [Duplicate entry '4' for key 1]
INSERT INTO wp_democracyA VALUES (4, 1, ‘Ooo look, a butterfly!’, 0, 0);
WordPress database error: [Duplicate entry '5' for key 1]
INSERT INTO wp_democracyA VALUES (5, 1, ‘No Comment’, 0, 0);
Warning: Cannot modify header information – headers already sent by (output started at C:\xampplite\htdocs\rmagic\wp-includes\wp-db.php:98) in C:\xampplite\htdocs\rmagic\wp-admin\admin.php on line 10
Warning: Cannot modify header information – headers already sent by (output started at C:\xampplite\htdocs\rmagic\wp-includes\wp-db.php:98) in C:\xampplite\htdocs\rmagic\wp-admin\admin.php on line 11
Warning: Cannot modify header information – headers already sent by (output started at C:\xampplite\htdocs\rmagic\wp-includes\wp-db.php:98) in C:\xampplite\htdocs\rmagic\wp-admin\admin.php on line 12
Warning: Cannot modify header information – headers already sent by (output started at C:\xampplite\htdocs\rmagic\wp-includes\wp-db.php:98) in C:\xampplite\htdocs\rmagic\wp-admin\admin.php on line 13
—-
I can ignore them and click “manage” > “democracy” but I get these errors too:
–above the no active polls warning–
WordPress database error: [Table 'richardsmagic.wp_democracyq' doesn't exist]
SELECT id FROM wp_democracyQ WHERE active = ’1′
—-
…and…
–just below the manage polls title–
WordPress database error: [Table 'richardsmagic.wp_democracyq' doesn't exist]
SELECT * from wp_democracyQ ORDER BY id
—-
Any idea what Im doing wrong here please, anyone?!
I would really love to get a decent polls program running on the website!
Cheers, Richard (all the way from Australia!)
10:55 am on 12/27/2005 160. Srinath
thx for it goona try it on my site
5:12 am on 12/28/2005 161. Pasika
What about upgrade for WordPress 2.0? It doesn’t seem to work with this version.
8:22 pm on 1/1/2006 162. John Horne
Hi. Thanks for the cool plug-in. Looking forward to using it a lot but so far I’m having problems getting the poll to format the way I want it. I’d like it to look like the polls at
http://bikeportland.org/polls/
but instead the pool is formatting horizontally and wrapping and it looks kinda funky. I’ve tried messing with the css file (I do have a basic understanding of css) but with no success. Here’s the address:
http://www.johnhorneguitar.com/archives/2006/01/01/practice-poll/
I’m using a customized version of the Minima Plus theme and WordPress 2.0. Also, I’m using Exec-PHP 2.0 to put the php into a post.
Hope you can advise-thanks.
John
8:49 pm on 1/2/2006 163. John Horne
Sorry about this, but the address I posted earlier has changed to:
http://www.johnhorneguitar.com/polls/
Hope to hear from someone (especially Andrew) Thanks!
8:56 am on 1/4/2006 164. Henning
Great plugin, thanks! I’m using it already. So easy to set up and use.
12:35 pm on 1/4/2006 165. Josh
Schweeeet plugin!
How hard would it be to be able to associate a poll with a post?
So the poll showed up only on that post page?
Just curious!
11:21 pm on 1/4/2006 166. Lonnie LeMaster
Poll results that are displayed after a vote disappear with a page refresh. Any ideas as to how I can get the results to persist for people who have already voted in a pole? Thanks for the great plug-in.
4:44 am on 1/5/2006 167. mugget
well i just decided to give Democracy a go (haha – that sounds funny
) but i can’t get it to work in posts? does this only work in the sidebar? is there a way i can get a poll to display in a post? that would be really neat, and fit my needs perfectly.
hope that’s not too hard to do…
4:58 pm on 1/6/2006 168. Enno DUMMER
To: 161. Richard
I got the same error on database creation and solved it like this:
1) Delete the already created table wp_democracyA in your database.
2) Open democracy.php in your plugin-folder, search for code:
timestamp int(10) NOT NULL default ”,
and replace it by:
timestamp int(10) NOT NULL default ’0′,
3) Go to WP-admin-panel and activate the plugin.
That’s it, have fun!
7:50 pm on 1/6/2006 169. Ajay
This is a something I have been looking for quite a while.
However, before I use it I have few questions.
What is the exact reason of having an active poll?
Can archive polls be unarchived?
Is there a way to display one random poll on maybe a new visit or page load or similar?
6:55 am on 1/7/2006 170. MAK
@ 171: Enno DUMMER
Thank you for that help, I had the same problem as 161: Richard. My poll works now thanks to you.
I have a different quirk with the Shoutbox since I upgraded to WP 2.0. Before, if I was signed in, it would automatically fill my name in but now, even when I sign into my blog, it thinks I’m just some random guest. Any ideas?
Yes, I will post this question in the proper area, but I thought I would ask here also.
Thanks in advance.
~~ MAK
4:02 pm on 1/8/2006 171. Brooke
What a fun plug in and so well documented in the readme that it worked right off the bat! Amazing! Thanks for all your hard work.
6:55 am on 1/9/2006 172. Ben
This is a great plugin, and with a bit of twiddling, I integrated it nicely into my site. Took forever to find a decent poll app, and now I’ve finally found yours! Thanks a lot!
3:45 pm on 1/9/2006 173. Philip
Is this plugin compatible with the latest release of WordPress, v2.0?
7:05 am on 1/11/2006 174. g marinov
Hi. Just installed Democracy 1.2 and noticed that deleting the only poll (default one) throws errors on the management page. Just for the sake of keeping a tidy plugin, you might want to look at that.. something along the lines of (if sizeof(..) { } )
6:48 am on 1/13/2006 175. perplex
please port this awesome plugin to wp 2.0! will be VERY appreciated
2:50 pm on 1/17/2006 176. Polle
Hi, thanks for this great plugin!
I was wondering if it would be possible to call upon the poll in a post, so not by giving it a permanent place in the sidebar or something? Thanks!
3:17 pm on 1/18/2006 177. Kyle
Let me throw in another request for a WP 2.0 update! Perhaps someone should a poll together to see how many people want it to be updated
1:52 am on 1/19/2006 178. ashish
How do I get it to appear on my side bar ??? I have installed the plugin, created a poll and have activated it. Now what ?? I have read all blogs on this , no where have seen mention of this. Maybe I am the stupid guy, but please humour me !!
2:20 am on 1/19/2006 179. ashish
don’t bother .. it was me !!
3:19 am on 1/19/2006 180. Steve
Will it be possible make this work for individual posts instead of the sidebar?
This would allow an application that lets readers vote on the story,or vote on a last line question relating to the individual post….
This would be very popular I do believe…
10:03 pm on 1/19/2006 181. Chestah
Any chance you could please fix the download link or could someone please create a mirror
.
The download link is leading to an error page
12:08 pm on 1/20/2006 182. Andrew
Sorry, fixx0red!
3:26 am on 1/23/2006 183. Hulmgulm
Hi,
I like your plugin very much. There’s just one thing I’m missing: I’d like to create polls where my visitors can vote for several options at the same time.
Is it possible to add this functionality?
Thanks
Hulmgulm
4:36 pm on 1/23/2006 184. Isaac
Hello,
I’m using the Democracy plug in for a radio show that we’re developing. We’d like to make it so that only we can see the results, but users would see a message that says “Listen to next week’s show for poll results.”
How can this be made possible?
Thanks for any guidance.
-Isaac
2:23 pm on 1/24/2006 185. Luke
Hi Andrew! Thanks for the plugin, but i get an error with IE because there is aa big white space around the poll choice, what can I do?
Thanks
10:23 pm on 1/25/2006 186. jeff
i put your voting script on my asianhottestblogger.com site but when visitor vote on the name ‘yun’ , it is not working. pls try out yourself.
appreciate a prompt response as there is a major contest running.
jeff
2:22 pm on 1/27/2006 187. Bas
I put the script on my website http://edenaar.nl but it doesn’t work. Can somebody take a look at it?
2:24 pm on 1/30/2006 188. Nico
I still got the SESSID amperstand validation error described by Kenzo in XHTML 1.0T, using version 1.2 clean install running WP 2.0.
I fixed (I hope) it using:
ini_set('arg_separator.output','&');..as discribed here: http://www.w3.org/QA/2005/04/php-session
I would be grateful if someone would like to test it out at mu site: teees.com (Three E’s)
8:37 pm on 1/30/2006 189. Maurice Tanner
Very Nice, Thank you. Excellent work
9:53 am on 1/31/2006 190. jeepish
Really nice plugin! Thank you!
My two requests: ability to activate/deactivate a poll, and the ability to show a random poll (selected from the ‘active’ polls) in the sidebar.
I would imagine the archive then to simply list the polls chronologically, and clicking on the name of an active poll to take you to an archive page that has just that poll so a person can vote in it.
Yep – you guessed it — I’ve got wants, but no PHP skills at all.
Thank you!
10:15 am on 1/31/2006 191. Sam. K
I am impressed with this page…setup really nice. Doesn’t take forever to load pics, like mine… Very impressive.. http://lincoln.ziarc.com
10:09 am on 2/4/2006 192. Sistogxp
How can i create a page with a poll (like yours)?? what code i have to use??
2:55 pm on 2/13/2006 193. PM
Simple, Easy… just right. No problems installing. Thanks bunches.
8:55 pm on 2/13/2006 194. meeciteewurkor
Hello, thank you for Democracy.
Could you let me know there the IP’s are stored in the database. I checked wp_democracyA and wp_democracyQ tables, but couldn’t locate the IP’s ?
Are they stored in another field elsewhere?
thank you!
3:50 pm on 2/15/2006 195. shodan
Thank you Andrew, awesome work!
I was wondering if one-click voting was possible instead of radio buttons. I think I’ll tinker with that a bit later. After all, Chaos & Destruction are some of the services I offer
7:50 pm on 2/17/2006 196. Scott
Great plug-in! We’ve deployed in our website – very easy to install, update and use. Thank you.
1:36 pm on 2/18/2006 197. Renegrub
How can I remove the IP restriction so that co-workers or family members can vote in my polls?
8:31 pm on 2/19/2006 198. Bilal
Installed it. Working perfectly. No problems at all except my page is validating. Could you please check?
1:36 pm on 2/25/2006 199. Eddie
Great plugin, thanks Andrew!
I have two questions…
1.) Is it possible to stop the voting (or expire)? So people can only see the resultat from the poll. Example: For a week the people can vote on myne poll, but after that i want only that u can see the resultat from the past week.
2.) Can i archive the poll?
Greetings from the Netherlands,
Eddie
2:10 pm on 2/27/2006 200. Jaan Kanellis
I had the plugin working fine with my website below:
http://www.2006-winter-olympics-turin-italy.com/blog/
Then I went and added a new poll and deleted the old one and now it is not showing up. Any ideas what happended?
1:27 pm on 2/28/2006 201. GTL
I don’t know what I’m doing wrong here. Does this plugin work with WP 2.0.1, and does this version of WP have AJAX? I assumed the answer was “yes” to both, but I follow the instructions step by step to #2 where I go to the plugin panel to activate, but it’s not showing up. I put the entire Democracy folder here:
/htdocs/wp-content/plugins/Democracy
What am I missing? New to WP, so that might explain things?
Thanx…
12:26 pm on 3/2/2006 202. Osvaldo de Sousa
Is this plugin compatible with wordpress 2.0.1? I cannot get the admin panel (or am I looking in the wrong place? – I am looking on the wordpress admin and cannot find something like polls)
Help please!
3:31 pm on 3/2/2006 203. Andrew
Manage > Democracy
6:54 pm on 3/2/2006 204. Pankaj
Andrew nice work. Plugin works well with the wordpress2.1 but my problem is slightly different then others as u know that this plugin check he IP address and u can only vote once insted of that I want to vote more then once. Is there any ways i can stop this IPcheck function? If u assist me in this direction that would be a gr8 help
3:56 pm on 3/4/2006 205. Simon Judge
Thanks for the great plugin.
Simon
2:56 pm on 3/7/2006 206. Joe
Hi,
Good plugin. Two questions though,
first : Is there a way to remove the IP Restriction?
Second : It would be really cool if there was a “Archive” Page where you or the users could view all the old polls and their results. Thanks…
8:20 pm on 3/8/2006 207. Matt
PLEASE consider adding a feature so I can make polls in posts. Thanks!!!
3:27 am on 3/9/2006 208. Matthias
Hi!
Very nice Plugin
Thanks!
But i have a problem. When i visit my site in Microsoft IE i see mainly the Vote theme to vote, on Firefox i see the results and i can not vote. What could i do, to see on firefox the Vote theme, too?
greets
10:29 pm on 3/14/2006 209. Chell
OMG what an awesome plugin! Had it added in no time, and works like a charm. And it’s exactly the sort of poll that I was looking for. Thank you!!
1:40 pm on 3/15/2006 210. tanster
Thank you SO MUCH for developing this plugin!
It is working beautifully (and fully XHTML-validated) over at http://www.officetally.com, with the following tweaks:
- IP logging turned off
- Polls (and archive) are displayed on pages, with the help of phpexec
- Various styling changes to match look and feel of OfficeTally
I *love* how I am able to insert HTML right into the poll choices!
Looking forward to seeing v2.0. (especially multiple choice checkbox polls and multiple polls per page functionality).
Thanks again,
tanster
2:46 am on 3/17/2006 211. Chris
I’ve been using this for about a month now, and I have a visitor that always seems to get an error saying “Go stuff the ballot box elsewhere!”. What is that about and what is causing it?
9:45 am on 3/17/2006 212. Frank
This is pretty cool!
8:45 pm on 3/18/2006 213. Roger
I love this plugin, thanks for writing it. But I’m having a little trouble with the display– the radio buttons appear above the choice labels, and there also a mysterious black dot thrown in. Soemtimes there’s no hover effect. It just doesn’t look right.
Admittedly, this may be a result of my trying to throw up a site while remaining utterly ignorant about the how-tos. I don’t know the difference between PHP and PGP. I can’t tell CSS from CSI. I think Ajax is the blue-dot cleanser. I could go on. Still, any suggestions?
5:43 pm on 3/23/2006 214. Miguel
Hi there, i’m using the spanish version, all ok, but I need to know where I can change these texts: Add an Answer – View Results
Have a nice time
10:51 am on 3/25/2006 215. Mikael
I cannot download it. Is there a new version coming out today or something?
6:00 pm on 3/25/2006 216. vamsi
same problem here. unable to download the zip file. the file is missing?
3:15 am on 3/27/2006 217. vamsi
i’m still unable to download the file
7:40 am on 3/27/2006 218. Freddy
Where’s the plugin? Get blank page when I click on the link. Thx.
12:38 pm on 3/27/2006 219. Andrew
Fixed, sorry
7:17 pm on 3/27/2006 220. GTL
Downloaded Democracy, and it rawks! Thank you so much, Andrew.
I don’t know if the author plans to add an archives feature in v2.0, but in the meantime, here’s a workaround for those who want to have their polls archived. Maybe a little more work than you want to do, but it’ll work.
When you close a poll, do a screenshot of the results, cut the poll results out of the screenshot JPG, save it to an image to be uploaded to a “previous polls and results” post in your blog. You can then add a link underneath your current poll that says “Previous Polls” that will take your visitors to that blog post with the images of previous polls on it. Just a thought.
If you don’t know how to do a screenshot, it’s easy. Here are some simple instructions to make one:
1. Open your browser so you see the poll results clearly -
2. Press and hold your “Control” button on your keyboard, with your other hand, press the button that says “Print Scrn” (right above the “F10″ button on my keyboard) -
3. Open an image viewer/editor – MSPaint, VuePro, etc. – should work with any of ‘em… you just need to be able to crop an image with it and save it as a new image -
4. Click the “Edit” dropdown, then click “paste image” – you should now be looking at your screenshot – an image of your entire browser screen with your poll results showing somewhere on there -
5. Crop out the poll results only, then save as a new .jpg image -
6. Make that post on your blog for “Previous Polls”, upload the image to it.
Look at my current poll in my blog’s right-hand column if you want to see an example of this. Since I’ve just started using Democracy, the old polls were with NeoMyz, but it’s the same idea regardless. The current and future images will be Democracy captures obviously, but you’ll get the idea.
A link to my blog for an example
Not exactly what everybody’s looking for, but it’ll do ’til Andrew has the time to get around to adding an Archives feature.
Hope this helps.
7:59 pm on 3/28/2006 221. Tyler
I have these little black dots in front of each radio button, anyone know how I can get rid of them?
6:22 pm on 3/29/2006 222. Roger
Tyler, what worked for me on this problem was to add the following statement to the ol, ul definition on the theme’s style sheet:
list-style-type: none;
I don’t know if that’s the RIGHT way to fix it, but it worked.
I’m still having a problem with the choice lables appear below the radio buttons, rather than on the same line, and would appreciate help from anyone who knows how to fix that.
11:18 am on 4/1/2006 223. jmyers
The poll does not work for me in IE. Firefox works fine. In IE the vote is simply not counted. You get the options and the vote button. Select and click vote and the results are displayed but the vote is not in the count. I created several pools and this was is case every time.
The fist person to vote with IE works, the vote is counted. No one else can vote with IE after that. I tried firefox on serval different systems and pools and it always worked perfectly.
Thanks
2:28 am on 4/3/2006 224. simon
ATT: Richard and Enno
The following change works in democracy.php:
1.- Replace all instances of timestamp to something else e.g. time.
2.- Edit line 493:
time TIMESTAMP NOT NULL default CURRENT_TIMESTAMP,
3.-Deactivate and Reactivate the plugin.
9:07 am on 4/4/2006 225. Einstein
How can i display old polls on an extra site?
How to create a poll Archiv?
Thanks
1:22 pm on 4/4/2006 226. Steve
Great plug-in. I know you’ve been asked this before, but is there a way to remove the IP restriction? Almost everyone accesses my site from our intranet at work, hence the IP addresses are all the same. Thanks.
4:47 pm on 4/5/2006 227. Christopher Coleman
Is it possible to show only certain polls using the jal_democracy_archives() function? Right now, it looks like it shows all but the most recent one, but I’d only like to show some of them. Is this possible?
4:35 am on 4/8/2006 228. Viper007Bond
For some reason, this plugin isn’t setting a cookie on my site. Do you have any clue why that’d be?
11:41 pm on 4/9/2006 229. davpach
Ok thx for this great plugin,
Just one thing to change can you add in the next version in function jal_democracy the rel=”nofollow” in order to bot like GGbot don’t index twice the same page.
Like that :
jal_add_user_answer=true” id=”jalAddAnswer” rel=”nofollow”>Add an Answer
Merci beaucoup
3:37 am on 4/11/2006 230. toto
Hi to all is there a way to show all users ip in my democracy admin panel
8:03 am on 4/16/2006 231. Iwocpo
Hey…stupid question. Sorry. You say to insert a template tag? What should be the specific verbiage I insert into my sidebar theme? Thanks in advance.
7:22 am on 4/19/2006 232. altar
Hi!
Great plugin! -I haven’t managed to make it work yet…
I’ve installed and activated it alright. I have the admin interface to create polls and all but…. the poll doesn’t appear on the side bar.
I installed automattic’s widgets, could that be a problem?
Thanks
2:22 pm on 4/19/2006 233. elsamu
Hi!
For some strange reason i can’t get the graphs coloured… does somebody know why?
Thank you very much!
7:37 pm on 4/19/2006 234. Marcus
I put the poll on the sidebar, but i want it to just show on the main page, not on single posts. What should i do?
And how i create i page with all the old polls?
12:27 pm on 4/20/2006 235. Alex Perez
Nice plug in. Too bad I can’t get it to work. I get this error
WordPress database error: [Table 'coroblog.wp_democracyQ' doesn't exist]
SELECT id FROM wp_democracyQ WHERE active = ’1′
2:40 am on 4/21/2006 236. hANS
Hi there,
This plugin looks great but I’m having a bit of a problem, coz I don’t know exactley how to install. I put it on my server and activated it in wordpress, but now I have to ‘place a template tag in theme where want the poll to appear, and I don’t know (exactly) how to do this. I’m guessing putting a bit of code in sidebar.php, but exactly what code? I’m very sorry if this is a stupid question but I just couldn’t find the answer anywhere.
Thanx in advance, Hans.
2:46 am on 4/21/2006 237. Alkar
Hi, Andrew. I have created a little plugin to use Democracy as a sidebar widget. It requires Democracy to be installed, it is just a mere widget interface.
6:43 am on 4/24/2006 238. Angie
I’ve got the plugin working, even in posts, thank you. My question, which I saw someone asked above, but I didn’t see an answer, is there any way to have the answers appear to the right of the voting circle, instead of underneath? Thanks for sharing this plugin1
6:49 pm on 4/25/2006 239. Gray Charles
Serious problem with Democracy Poll? I’ve been running your software on my very busy site for quite some time. Problematically, democracy seems to fire up a php.exe process that never closes. My site is very busy, tonight, with Democracy installed, I had 300 php.exe processes. When I took it out of the sidebar the number dropped to about 10.
Contact me via email if you’d like more information or to discuss.
1:13 am on 4/26/2006 240. 啊啊啊
啊啊啊啊啊啊啊啊啊啊
8:12 am on 4/28/2006 241. Brooks
I keep getting these errors on activation.
WordPress database error: [Invalid default value for 'timestamp']
CREATE TABLE wp_democracyQ ( id int(10) unsigned NOT NULL auto_increment, question varchar(200) NOT NULL default ”, timestamp int(10) NOT NULL default ”, voters text NULL default ”, allowusers enum(’0′,’1′) NOT NULL default ’0′, active enum(’0′,’1′) NOT NULL default ’0′, PRIMARY KEY (id) )
WordPress database error: [Table 'ibears.wp_democracyq' doesn't exist]
INSERT INTO wp_democracyQ VALUES (1, ‘Rate my site’, ’1146240566′, ”, ’0′, ’0′);
I’m running wp 2.0 on php 5/mysql 5. Any suggestions?
7:53 pm on 4/29/2006 242. Dilbert
I’m having the same problem as Alter in post 238, but I don’t have widgets installed. Can’t see the polls in IE or firefox…everything seems to be installed correctly though.
2:27 am on 4/30/2006 243. Clemens
Hi,
i have had some minor problems with the 1.0 RC 1 Version – but they look beeing history since i’d install the new one. (Translated German Verion http://www.jessman.com/stuff/democracy_1.2_(de).zip)
Upgrading was very easy too – no dataloss after changing the democracy-folders! very fine!
thanks (to both of you
for this nice plugin
best regards
Clemens from Berlin
10:13 am on 4/30/2006 244. Jon
Great plugin!
Is there any way to allow ‘editor’ level users to manage/create/delete polls? Right now it seems as if only the ‘admin’ level can get at the Manage -> Democracy page.
Thanks!
9:58 pm on 4/30/2006 245. lucas
For those who wanted to know how to insert the template tag: there are instructions in the readme.txt file in the download folder. Open this txt file in your browser. What you do is:
Add where you want the poll to appear, typically in your sidebar.
Then Go to Admin Panel > Manage > Democracy to add and edit polls. You’ll need to activate the default poll if you want it.
12:28 pm on 5/3/2006 246. Seth
Any way to let visitors vote for more than one option in a poll?
10:43 am on 5/4/2006 247. Damon
Hello, thanks for the plugin very much!
but i’ve got an error of using this plugin(Version 1.2).
when i activate democracy, the error shown:
WordPress database error: [Access denied for user 'yscr_bbSUSd'@'localhost' to database 'home']
ALTER TABLE wp_democracyQ ALTER COLUMN timestamp SET DEFAULT ”
Therefore, the polling in my site is not working now. Could you please help??
Thanks a lot.
4:10 pm on 5/4/2006 248. Seth
I’m sorry to re-ask this question, but I’ve posted it here, emailed it to the plug-in author and I still haven’t heard anything.
Is there a way to let voters vote for more than one item in a poll? I’m looking for a check-all-that-apply kind of thing.
Anyone?
2:05 am on 5/7/2006 249. Silko
On a site you will find all that is necessary for the present hunter for a successful hunt.
2:08 am on 5/14/2006 250. navendugoyal
i cannot get it working – help please
wordspew works fine
WordPress database error: [Unknown column 'id' in 'field list']
SELECT id FROM wp_democracyQ WHERE active = ’1′
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 ' 'sdgf', 0)' at line 1]
INSERT INTO wp_democracyA (qid, answers, votes) VALUES (, ‘sdgf’, 0);
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 ' 'dsfg', 0)' at line 1]
INSERT INTO wp_democracyA (qid, answers, votes) VALUES (, ‘dsfg’, 0);
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 ' 'dsfg', 0)' at line 1]
INSERT INTO wp_democracyA (qid, answers, votes) VALUES (, ‘dsfg’, 0);
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 ' 'dfsg', 0)' at line 1]
INSERT INTO wp_democracyA (qid, answers, votes) VALUES (, ‘dfsg’, 0);
NAVENDU G (View site »)
9:44 am on 5/21/2006 251. Joseph K
I’ve encountered the same problem others have mentioned. It seems the database is not created when the plugin is activated.
Is there a fix to this problem?
6:05 am on 5/23/2006 252. CypherHackz
I have downloaded your plugin and will test it first at localhost. If everythings works fine I will put up on my site. Thanks for the plugin.
2:12 pm on 5/23/2006 253. Sangy
Hi, This is a cool plugin and suits exactly what I need. But I’m a novice in scripts. I downloaded the plugin and activated it in WordPress. I know that somewhere I have to write a script for the poll to show. I have the template for the sidebar poll. But I dont know what the php script is and where to insert it. This is a beginner question for some of you. I know. But I really could use some help please
11:26 am on 5/24/2006 254. probertoj
Hello, thanks for the plugin but how can I activate multiple polls at the same time?
6:04 pm on 5/26/2006 255. kalabaw
i cannot run the poll plugin properly. after activating the plugin, the table for the question is not created.
WordPress database error: [Invalid default value for 'timestamp']
CREATE TABLE wp_democracyQ ( id int(10) unsigned NOT NULL auto_increment, question varchar(200) NOT NULL default ”, timestamp int(10) NOT NULL default ”, voters text NULL default ”, allowusers enum(’0′,’1′) NOT NULL default ’0′, active enum(’0′,’1′) NOT NULL default ’0′, PRIMARY KEY (id) )
WordPress database error: [Table 'wordpress.wp_democracyq' doesn't exist]
INSERT INTO wp_democracyQ VALUES (1, ‘Rate my site’, ’1148749275′, ”, ’0′, ’0′);
2:16 pm on 6/1/2006 256. TG
Hi- I saw someone mention this problem up in this mountain of comments, and I was having it as well:
1) you see the poll and vote with no problem, and it displays your results as expected
2) you go to another page on the same site and it appears to ask you to vote again (doesn’t show results) — but it doesn’t count your vote
This is caused by (perhaps other ways, this is one way) Democracy’s javascript setting the domain in the cookie to your WP directory; not a problem if that’s where your site lives (and the right thing to do), but if you split your WP and public site locations (“WP Address” and “Blog Address” in WP admin), you will see this problem.
For my use I just replaced the domain with ‘/’ (root directory) as that’s where my site lives. You can prob use WP functions to figure it out if your setup is different, or be naughty and hardcode it. This is line #126 in js.php, Democracy v.1.2.
Cheers
2:41 pm on 6/5/2006 257. URLkeep
dude… great work *salute*
but i think u must add a badword filter and striptag
7:58 am on 6/8/2006 258. Tandilboy
the ajax 1.2 poll can´t support MySQL 5.0
fix the bug
reply me
8:03 am on 6/8/2006 259. Tandilboy
the 261. kalabaw error is a MySQL Error. the plugin works fine in MySQL 4.0 but in 5.0 servers shows this error
2:27 pm on 6/10/2006 260. elsamu
My hosting just upgraded to MySQL 5.0 and i found Democracy not to work again… any suggestions=?
8:51 pm on 6/13/2006 261. Sefany
Best casino portal. Casino and poker rooms. Reviews and bonus codes.
11:59 pm on 6/13/2006 262. Nippr
Hi there. Love the poll and it works just great. I miss the ability to remove number of votes. I would like to show results as a percentage only (so no number of votes beside every option and no “total votes”). How do I do that? Thanks!
11:21 pm on 6/15/2006 263. Elen
With over five years of online bingo and free bingo experience, we know what it takes to provide the best bingo-oriented gaming environment to our players. When enjoying Bingo you can rest assured that the games are fair, the site is secure, and that our customer service is just seconds away. Bingo.com is #1 in online bingo and free bingo because we have the best players in the world and because we care!
7:17 pm on 6/17/2006 264. Jose Luiz Coe
Hi! I’ve translated this plugin to brazilian portugueses. How Can I send to you? (like the guy who translated to spanish).
7:36 am on 6/21/2006 265. Everton Blair
Hi
Thanks for a great plugin. I have one problem on my site, I want to turn off the images on the plugin but I can’t get it to work – can oyu help please?
thanks
Everton
10:39 pm on 7/11/2006 266. jetfuel
Yepp, my Dreamhost-hosted site uses MySQL 5.0.18 and I’m getting the same errors as the other folks, when trying to activate the plugin.
2:29 pm on 7/14/2006 267. martin
Dude, your democracy plug-in rocks. So much better than the hacked together crap I was doing before. Please let me know when 2.0 is ready!
6:39 am on 7/16/2006 268. Clayton
I just installed Democracy and it looks like exactly what I’m looking for. However, when I put my first poll up in a post the formatting was kind of blocky. I’ve checked out other people’s polls and they all look fine. I must be missing something. I’m guessing I need to either change the css or link to the css. I’m new to all of this, so I’m just not sure what I’m missing.
All I want is for the choices to be next to the buttons and to not have bullets. Here the address of the post. Any ideas?
http://claytonandteresa.com/wordpress/?p=25
2:30 pm on 7/16/2006 269. Tom Bonner
Excellent plug-in: Two minutes to download and read the documentation, another ten minutes to set everything up. In under fifteen minutes I had my first poll live.
I let my readers at http://alphatracks.com know that the poll was created with the Deomocracy plug-in for WordPress.
Thanks for the great work. — Tom
3:44 am on 7/19/2006 270. Jeppe Engell
I have tried to install the plugin but get this error…
WordPress database error: [Invalid default value for 'timestamp']
CREATE TABLE wp_democracyQ ( id int(10) unsigned NOT NULL auto_increment, question varchar(200) NOT NULL default ”, timestamp int(10) NOT NULL default ”, voters text NULL default ”, allowusers enum(’0′,’1′) NOT NULL default ’0′, active enum(’0′,’1′) NOT NULL default ’0′, PRIMARY KEY (id) )
WordPress database error: [Table 'hkdagen_dk_db.wp_democracyQ' doesn't exist]
INSERT INTO wp_democracyQ VALUES (1, ‘Rate my site’, ’1153309353′, ”, ’0′, ’0′);
WordPress database error: [Duplicate entry '1' for key 1]
INSERT INTO wp_democracyA VALUES (1, 1, ‘Best. Blog. Ever.’, 0, 0);
WordPress database error: [Duplicate entry '2' for key 1]
INSERT INTO wp_democracyA VALUES (2, 1, ‘Could be better…’, 0, 0);
WordPress database error: [Duplicate entry '3' for key 1]
INSERT INTO wp_democracyA VALUES (3, 1, ‘My grandma could make a better website!’, 0, 0);
WordPress database error: [Duplicate entry '4' for key 1]
INSERT INTO wp_democracyA VALUES (4, 1, ‘Ooo look, a butterfly!’, 0, 0);
WordPress database error: [Duplicate entry '5' for key 1]
INSERT INTO wp_democracyA VALUES (5, 1, ‘No Comment’, 0, 0);
8:00 am on 7/25/2006 271. roj
Easy setup! Nice work. Thanks
2:22 am on 7/26/2006 272. nicki
i get the same error as Jeppe Engell
12:35 am on 7/27/2006 273. Paolo Gabrielli
I’ve found that with lighttpd the vars Send/GetDemocracy (in js.php) are not correctly set, so the plugin doesn’t work.
1:09 am on 7/29/2006 274. Steve
Great plugin, I just wish I could use/show more than one poll at a time. Looking forward to version 2.0
10:54 pm on 7/30/2006 275. Soap_Dude
I got the same MySQL errors as some of you above. I’m using MySQL 5.0.22 and the default format for the data type timestamp should be ’0000-00-00 00:00:00′. Nevertheless, I’m not sure if the default is supposed to be set to CURRENT_TIMESTAMP. Do the installations again (ie. remove the files from the plugins directory and start over) or run the MySQL query manually should solve the problem.
The query is:
CREATE TABLE yourWordPressDBName.wp_democracyQ ( id int(10) unsigned NOT NULL auto_increment, question varchar(200) NOT NULL default ”, timestamp int(10) NOT NULL default CURRENT_TIMESTAMP, voters text NULL default ”, allowusers enum(’0′,’1′) NOT NULL default ’0′, active enum(’0′,’1′) NOT NULL default ’0′, PRIMARY KEY (id) )
1:51 pm on 8/2/2006 276. doane paper
Great poll plug-in but I’ve got a question. When you vote are the results updated immediately? I’ve voted from a couple of different computers and I can’t seem to get the votes to register in my poll? I’m using WP 2.0.2. Do I need to adjust something?
4:50 am on 8/7/2006 277. webcomic
I have the error:
WordPress database error: [Invalid default value for 'timestamp']
ALTER TABLE wp_democracyQ ALTER COLUMN timestamp SET DEFAULT ''
so I had to de-activate democracy.
2:42 am on 8/14/2006 278. buy text link
buy text link
3:26 am on 8/16/2006 279. Tommy
There seems to be a problem with my poll that’s never happened before.
The poll has 48 choices. 174 has voted and suddenly it doesn’t seem to update the votes anymore.
People can still vote but the new votes aren’t added. What’s up?
4:59 am on 8/16/2006 280. Tommy
Hmmm… I turned off a bunch of plugins and it seems to be working again.
I can’t remember all I turned off but here’s some:
wp-polls, wp-email, wp-stat, and some google sitemap plugin.
6:55 am on 8/16/2006 281. nonBot
Does this work with 2.0? Also, a sample on this page would be nice.
9:44 am on 8/19/2006 282. Marshall
Quick question. If you have not voted on a poll yet but others have you get the option of “view results” What I was wondering is once you have voted is there a “hide results” feature?
5:29 am on 8/20/2006 283. Jan
Is there a demo of this plugin?
7:55 pm on 8/20/2006 284. Tee
Hi. Your plugin is not working right with mysql 5.0. You need to address this now.
12:55 am on 8/22/2006 285. jan
I see it has been asked before, yet not asnwerd.
A lot of my users get the message “Go stuff the ballot box elsewhere!” on a blank page.
How do I get rid of this, so that everyone can vote?
12:13 pm on 9/1/2006 286. Cogmios
when activating i get:
WordPress database error: [Invalid default value for 'timestamp']
CREATE TABLE wp_democracyQ ( id int(10) unsigned NOT NULL auto_increment, question varchar(200) NOT NULL default ”, timestamp int(10) NOT NULL default ”, voters text NULL default ”, allowusers enum(’0′,’1′) NOT NULL default ’0′, active enum(’0′,’1′) NOT NULL default ’0′, PRIMARY KEY (id) )
6:49 am on 9/2/2006 287. Mystech
I’ve added the poll to my wordpress site and the basic functions of the poll seem to work fine, however, even with the “Allow users to add answers” option checked, I cannot see how/where a user can add their answer. Suggestions?
6:53 am on 9/2/2006 288. Mystech
Nevermind, I’m a doofus. That option disappears once you’ve voted, doesn’t it?
7:02 am on 9/3/2006 289. Halil
Is there an easy way to “Pool” heading on the sidebar when there is no active pool in the plugin?
I have deactivated my current pool and my sidebar have an empty listed heading for the “Pool”
11:46 pm on 9/5/2006 290. moieu
Hi,
I installed your plugin and it looks good but functions bad. I get an error page and a strange link when I press vote:
http://www.en4us.com/blog/wp-content/plugins/democracy/democracy.php?jal_nojs=true
Though I have read most of the instructions and faqs, still I can’t help doing it!
8:26 am on 9/6/2006 291. Clark
We use your great plugin to vote for a place to eat. We eould like to force voters and choosers to be registered. Is there a way to prevent “guests” from adding options or voting?
11:42 am on 9/9/2006 292. Liora
“place a template tag in your theme where you want the poll to appear”
Could you explain what a template tag is to those who are new to WordPress? I’ve got your plugin uploaded and activated, but I’m not sure what to do next. Thanks much!
11:49 am on 9/9/2006 293. Bree
Could someone please take a peek at a new blog I’m starting, and tell me how to get rid of the bullets and align the text with the selections, I’d really appreciate it. I’ve seen many of the other polls on other sites, and they’re gorgeous!
I am NOT a php pro, so please provide simple instructions. If I can get this poll to work right, then I’ll put it on my main blog, on another domain.
I spent hours and hours yesterday and today installing and deleting several other poll/survey plugins, including wp-polls, and this seems by far the easiest to install.
thanks so much,
Bree
12:37 pm on 9/9/2006 294. Bree
Never mind my last post…I played with it, and now I can’t even get it to appear on that site anymore!
But I did manage to get the poll on my #1 blog off my main domain, in the side bar, and it looks awesome! I’m very happy with it!
Looking forward to the upgrade!
thanks,
~Bree
1:45 pm on 9/9/2006 295. Bree
** IP Address Disabling Again **
PLEASE, can someone tell me and the rest of us how to disable IP logging. This question has been asked so many times, but we haven’t received an answer yet.
I’m getting ready to install WordPress 2.0 on a colleague’s domain, and want to install Democracy on her blog too; however, everyone at her job is using the same IP address because they’re on a network.
I was hoping to get this installed and setup for her this weekend!
I’m also getting ready to run my yearly Pet Halloween Costume Contest, and would like voters to be able to come back each day and vote for their favorite pet!
Please…simple instructions on how to disable IP logging.
thanks!
~Bree
10:01 pm on 9/10/2006 296. Lonnie
Is there a way to allow votes from the same IP…All 5,000 of the students at my college have the same address…Only one vote gets counted…
Help!
Great resource!!!!
Greetings fromn China
4:08 am on 9/15/2006 297. Farnsworth
Great plugin, but a huge problem.
I have hundreds of URLs with ?jal_add_user_answer=true appended at the end.
I’m very concerned about duplicate content. How can this issue be resolved?
6:35 am on 9/16/2006 298. Farnsworth
I went ahead and de-activated it. Appending the “?jal_no_js=true” to the URLs will cause tons of duplicate content to be indexed.
I can’t risk the issue in Google, and I doubt anyone can. A search of “inurl:?jal_no_js=true” shows 1/2 half million pages already indexed like that.
My suggestion would be to come up with both a 1) robots.txt exclusion and 2) rel = nofollow tag to minimize the damage.
I also know there’s other variations of the URL, so there are now probably many millions of pages in Google that are exact duplicates of the original.
9:37 am on 9/16/2006 299. Andrew Chisholm
Hey. I installed Democracy on my site but when ever a vote is cast, an error is displayed at the top of the page. Could some one take a look and get back to me?
2:47 am on 9/18/2006 300. soylopeor
hi!!
I was thinking in using this plugin but in the trackbacks to this post you can read that there’s a bug that can cause to lost your pagerank forever due to a bug in this fabulous plugin
(in spanish):
http://empresayweb.com/blog/?p=28
Or this other in english:
http://www.blogherald.com/2006/09/17/serious-seo-issue-in-popular-wordpress-plugin/
3:35 am on 9/18/2006 301. Michael
Is there a fix for the google problem? http://www.blog-republic.com/2006/09/17/wordpress-democracy-plugin-warning-seo-nightmare/
6:24 pm on 9/18/2006 302. Simulacrum
I use WordPress 2.0.4 and I can register “Democracy” plugin. It dont work
6:31 pm on 9/18/2006 303. Simulacrum
Sorry, I could say, I can’t register this plugin
10:32 am on 9/20/2006 304. Marrick Linn
Congratulations on a great web site. I am a new computer user and finding you was like coming home. Continued success.
7:57 am on 9/21/2006 305. Snakey
Hi, I have a problem displaying the polls,..I use the sidebar editor plugin and I cant manage do display democracy. I tried the but without any luck.
Any suggestions?
Thanks a lot
9:27 am on 9/21/2006 306. Snakey
?php jal_democracy(1); thats what i tried
10:50 pm on 1/13/2007 307. cat litter
*taps fingers on desk and wonders why nobody is postin*
\”Postin\” -Southern Verb, to post. lol
10:53 pm on 2/8/2007 308. Jack
How do you make it so that visitors can’t see the results of the poll? Thanks.
7:59 am on 5/23/2007 309. brand xanax
brand xanax .
9:06 am on 7/9/2007 310. tacacdudykbi
It as a major dilemma except for us was instantly forgotten – katie price xxx light fluffy.
4:52 am on 7/12/2007 311. Visitor098
I have visited your site 061-times
4:53 am on 7/12/2007 312. Visitor186
I could not find this site in the Search Engines index
1:26 am on 7/15/2007 313. ptucivca
You are tired of a certain online pharmacy adapex quaver in advance, i.
6:31 am on 8/2/2007 314. Visitor719
I have visited your site 011-times
6:31 am on 8/2/2007 315. Visitor553
Your site found in Google: http://google.com/search?q=udm
5:52 pm on 8/2/2007 316. cunt
A barrel. And your fault! Let themselves be bought out. Urk. huge cunt hole If word she.
5:51 am on 8/20/2007 317. erik
is it possible to have a poll in apost?
thanks in advance erik
9:01 am on 9/2/2007 318. DarioDN
Hi guy… it’s possibile view the voters’ ip logs?
tnx
3:05 am on 1/21/2008 319. ColiWeepe
http://www.google.com
http://www.yahoo.com
http://www.msn.com
11:42 am on 2/27/2008 320. galleries
The rest of nature. Oh he was different. free preteen sex galleries Late but when jessie would that.
5:32 am on 6/25/2008 321. staylook
joke site busy red joke pets no day this deliver english
1:13 am on 7/8/2008 322. girlsunwatch
england water no stone google bag mail yes australia juicy me
9:22 pm on 7/20/2008 323. cubegermanto
australia boy look boat bag
4:28 am on 8/21/2008 324. kitchenredmi
yes night deliver white
10:15 am on 8/25/2008 325. sunibmbagkey
vacant dog white dog go ocean site key red
6:21 pm on 9/3/2008 326. noenglishgo
all frog go america night we
9:24 pm on 10/21/2008 327. fox9884
tmcu exkz
10:28 pm on 10/21/2008 328. fox5836
noucs xhbg bovau cuoliz
9:55 am on 10/22/2008 329. porn4792
hjkieq awdl
1:05 pm on 10/25/2008 330. software5232
fxacjw
9:35 pm on 10/31/2008 331. mp509
zsmab dxryvki zagwny