Poll Plugin for WordPress

Viewing 15 replies - 1 through 15 (of 27 total)

  • Which poll plugin?

    If you are referring to the one here: https://www.lesterchan.net/portfolio/programming.php then you are in luck, as yesterday evening I managed to get it to work with 1.5, as I mentioned in another post.

    I have managed to get the plugin to work with a bit of fiddling.
    You can download a zip with the ammended files from:
    https://www.mtaylor.co.uk/temp/wp-polls_050403.zip
    Make sure you look through the readme file, as ther are some changes there as well. Other changes are documented at the ends of the source code files.

    I hope this works for you.

    Thread Starter pera

    (@pera)

    Thanks, it’s working ??

    I just tried to install this plugin and I got this message when I ran wp-admin/polls-install.php

    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 ‘( aid int(10) unsigned NOT NULL auto_increment, qid int(10) NOT]
    CREATE TABLE ( aid int(10) unsigned NOT NULL auto_increment, qid int(10) NOT NULL default ‘0’, answers varchar(200) NOT NULL default ”, votes int(10) NOT NULL default ‘0’, PRIMARY KEY (aid))

    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 ‘( id int(10) unsigned NOT NULL auto_increment, question varchar]
    CREATE TABLE ( id int(10) unsigned NOT NULL auto_increment, question varchar(200) NOT NULL default ”, timestamp varchar(20) NOT NULL default ”, total_votes int(10) NOT NULL default ‘0’, PRIMARY KEY (id))

    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 ‘VALUES (1, ‘How Is My Site?’, ‘1112894265’, 0)’ at line 1]
    INSERT INTO VALUES (1, ‘How Is My Site?’, ‘1112894265’, 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 ‘VALUES (1, 1, ‘Good’, 0)’ at line 1]
    INSERT INTO VALUES (1, 1, ‘Good’, 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 ‘VALUES (2, 1, ‘Excellent’, 0)’ at line 1]
    INSERT INTO VALUES (2, 1, ‘Excellent’, 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 ‘VALUES (3, 1, ‘Bad’, 0)’ at line 1]
    INSERT INTO VALUES (3, 1, ‘Bad’, 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 ‘VALUES (4, 1, ‘Can Be Improved’, 0)’ at line 1]
    INSERT INTO VALUES (4, 1, ‘Can Be Improved’, 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 ‘VALUES (5, 1, ‘No Comments’, 0)’ at line 1]
    INSERT INTO VALUES (5, 1, ‘No Comments’, 0);

    Can some one please tell me what to do now? I don’t know what it means. ??
    I asked my host if they had upgraded the Zend Optimizer when they upgraded PHP to version 4.3.10 and they just to me that it is at the latest version currently.

    I don’t know what to do. ??

    I’m having some difficulty also, even following Mathew’s very clear directions I’m getting:

    Fatal error: Call to undefined function: vote_poll() in /home2/jason/public_html/gm/wp-content/themes/parishuddha/index.php on line 1

    hmm…might it work with a different theme?

    nope.

    Fatal error: Call to undefined function: vote_poll() in /home2/jason/public_html/gm/wp-content/themes/clasikue/index.php on line 4

    Nevermind…I’m a loser. Well, that, and no where does it say in the directions that one needs to activate at the dashboard, just to use the whatever.php to install. I’m just glad to get it going.

    I’d like to display 2 or more polls on one page, the problem is of course the cookie disallows the other polls. Here is the cookie line:

    // If User Click Vote
    if(isset($_POST[‘vote’])) { $voted = true; }
    // Check User Cookie
    if(isset($_COOKIE[“voted_”.$polls_questions[0][‘id’]])) { $voted = true; }

    I am calling the polls by ID:
    <?php get_polls(‘3’); ?>
    <?php get_polls(‘2’); ?>
    <?php get_polls(‘1’); ?>

    Is this a quick change? Thanks so much

    hmmm, it all works here, but once i cast a vote i get this on top of my page:

    Warning: Cannot modify header information – headers already sent by (output started at /home/.feabhra/shdsmith/sietsesmith.com/blog/wp-content/themes/connections/index.php:4) in /home/.feabhra/shdsmith/sietsesmith.com/blog/wp-content/plugins/polls.php on line 80

    what does it mean? (im a total n00b at coding..)

    hmm, i seem to have fixed it.. dont ask me how ??

    It all installs fine and shows up but when you vote the results always stay at 0% no votes – any ideas.

    ive got the error:

    [quote]

    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 ‘( aid int(10) unsigned NOT NULL auto_increment, qid int(10) NOT]
    CREATE TABLE ( aid int(10) unsigned NOT NULL auto_increment, qid int(10) NOT NULL default ‘0’, answers varchar(200) NOT NULL default ”, votes int(10) NOT NULL default ‘0’, PRIMARY KEY (aid))

    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 ‘( id int(10) unsigned NOT NULL auto_increment, question varchar]
    CREATE TABLE ( id int(10) unsigned NOT NULL auto_increment, question varchar(200) NOT NULL default ”, timestamp varchar(20) NOT NULL default ”, total_votes tinyint(4) NOT NULL default ‘0’, PRIMARY KEY (id))

    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 ‘VALUES (1, ‘How Is My Site?’, ‘1075479885’, 0)’ at line 1]
    INSERT INTO VALUES (1, ‘How Is My Site?’, ‘1075479885’, 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 ‘VALUES (1, 1, ‘Good’, 0)’ at line 1]
    INSERT INTO VALUES (1, 1, ‘Good’, 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 ‘VALUES (2, 1, ‘Excellent’, 0)’ at line 1]
    INSERT INTO VALUES (2, 1, ‘Excellent’, 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 ‘VALUES (3, 1, ‘Bad’, 0)’ at line 1]
    INSERT INTO VALUES (3, 1, ‘Bad’, 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 ‘VALUES (4, 1, ‘Can Be Improved’, 0)’ at line 1]
    INSERT INTO VALUES (4, 1, ‘Can Be Improved’, 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 ‘VALUES (5, 1, ‘No Comments’, 0)’ at line 1]
    INSERT INTO VALUES (5, 1, ‘No Comments’, 0);[/quote]

    y? whats wrong?

    hi all, my guess is that u all didnt put in the tables to wp-settings.

    -> Installation Instructions
    ————————————————–
    // Open wp-settings.php

    Find:
    ——————————————————————
    $wpdb->postmeta = $table_prefix . ‘postmeta’;
    ——————————————————————
    Add Below It:
    ——————————————————————
    $wpdb->pollsa = $table_prefix . ‘pollsa’;
    $wpdb->pollsq = $table_prefix . ‘pollsq’;
    ——————————————————————

    no, we did this ??

    Those of you with the MySQL error – are you SURE you made the changes to the wp-settings and uploaded it? I got the MySQL error, the exact same thing until I realized I’d forgotten to upload the wp-settings file. Once I did that, it installed with a snap.

    *off to try polls now…*

    I’m getting a similar error listed above. Everything seemed to install just fine, but after anyone casts a vote, I get the following message on the screen:

    Warning: Cannot modify header information – headers already sent by (output started at /home/tir-na-o/public_html/WordPress/wp-content/themes/plain-vanilla/header.php:6) in /home/tir-na-o/public_html/WordPress/wp-content/plugins/polls.php on line 71

    any ideas?

Viewing 15 replies - 1 through 15 (of 27 total)
  • The topic ‘Poll Plugin for WordPress’ is closed to new replies.