Democracy AJAX Poll

By | June 29th, 2005 | 480 Comments | Code | Internet

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 / class hooks 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...else statements 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 &amp; 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 &amp; 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 :)
Just a question: on IE the progress bars is very big… I tried to change it in css file but no result :( . Can you help me to correct that plz?
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 :D 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 :P

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:

<h2>Encuestas</h2>

<ul>
 <li><?php jal_democracy(); ?></li>
</ul>

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 :D

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=true

The 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 contain admin.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 :P ) 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 :P .

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 :P

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… :D
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′

:-( . Hopefuly someone can help me.

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

149 discussions elsewhere