WordPress.org

Ready to get started?Download WordPress

Forums

WP-Polls
[resolved] Error In Adding Poll (11 posts)

  1. gorod
    Member
    Posted 1 year ago #

    Hello,
    just installed WP-polls on my site and it doesn't seem to work.
    After trying to create a first poll I get the following message on top :

    Error In Adding Poll 'Test'.

    Error In Adding Poll's Answer 'yes'.

    Error In Adding Poll's Answer 'no'.

    http://wordpress.org/extend/plugins/wp-polls/

  2. gorod
    Member
    Posted 1 year ago #

    http://imageshack.us/f/29/wqta.jpg/

    Here is a screenshot of the error.

    The plugin doesn't save any polls.

  3. gorod
    Member
    Posted 1 year ago #

    Found the problem. Plugin didn't create table for wp-polls.

    Have to run query manually in phpmyadmin:

    --
    -- Table structure for table wp_pollsa
    --

    CREATE TABLE IF NOT EXISTS wp_pollsa (
    polla_aid int(10) NOT NULL auto_increment,
    polla_qid int(10) NOT NULL default '0',
    polla_answers varchar(200) character set latin1 NOT NULL default '',
    polla_votes int(10) NOT NULL default '0',
    PRIMARY KEY (polla_aid)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

    -- --------------------------------------------------------

    --
    -- Table structure for table wp_pollsip
    --

    CREATE TABLE IF NOT EXISTS wp_pollsip (
    pollip_id int(10) NOT NULL auto_increment,
    pollip_qid varchar(10) character set latin1 NOT NULL default '',
    pollip_aid varchar(10) character set latin1 NOT NULL default '',
    pollip_ip varchar(100) character set latin1 NOT NULL default '',
    pollip_host varchar(200) character set latin1 NOT NULL default '',
    pollip_timestamp varchar(20) character set latin1 NOT NULL default '0000-00-00 00:00:00',
    pollip_user tinytext character set latin1 NOT NULL,
    pollip_userid int(10) NOT NULL default '0',
    PRIMARY KEY (pollip_id)
    ) ENGINE=MyISAM DEFAULT CHARSET=ucs2;

    -- --------------------------------------------------------

    --
    -- Table structure for table wp_pollsq
    --

    CREATE TABLE IF NOT EXISTS wp_pollsq (
    pollq_id int(10) NOT NULL auto_increment,
    pollq_question varchar(200) character set latin1 NOT NULL default '',
    pollq_timestamp varchar(20) character set latin1 NOT NULL default '',
    pollq_totalvotes int(10) NOT NULL default '0',
    pollq_active tinyint(1) NOT NULL default '1',
    pollq_expiry varchar(20) character set latin1 NOT NULL default '',
    pollq_multiple tinyint(3) NOT NULL default '0',
    pollq_totalvoters int(10) NOT NULL default '0',
    PRIMARY KEY (pollq_id)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

  4. Lester Chan
    Member
    Plugin Author

    Posted 1 year ago #

    are you using WP Multisite?

  5. DanFlag
    Member
    Posted 1 year ago #

    Hi,

    I've got the same problem : Error In Adding Poll
    I noticed because de default poll was not created.
    I do not use WP Multisite nor I have used it in the past, at least I dont remember doing so.

    The weird thing is that I have the problem on just one instance of WP3.6 here :
    http://www.flagworld.com/news/

    I've installed and configured 4 other wordpress today;
    http://www.flagworld.com/roadtests/ (Works fine)
    http://www.flagworld.com/nouvelles/
    http://www.flagworld.com/bruitsdepaddock/
    http://www.flagworld.com/karting/
    The last three work fine, even with some minor tweaking to translate to French.

    So far I've tried completely deleting and re-installing a few times, it just does not work

  6. Lester Chan
    Member
    Plugin Author

    Posted 1 year ago #

    Could you check whether wp_pollsa, wp_pollsq and wp_pollsip tables are created? It seems those table are not created when the plugin is being activated

  7. DanFlag
    Member
    Posted 1 year ago #

    Well how about that, it seems they are indeed missing

  8. DanFlag
    Member
    Posted 1 year ago #

    I added the tables manually through the query, it's fine now, Thank you for your help.

  9. Florisschimandl
    Member
    Posted 11 months ago #

    I seem to have the same problem working on localhost.
    The tables are created but i'm using a different prefix.
    Could that be a problem for wp-polls ?

    And what about the multisite support ?
    Is it already working ?

    Thanks

  10. Lester Chan
    Member
    Plugin Author

    Posted 11 months ago #

    @ Florisschimandl: sorry there is no MS support and hence you can't do a network activate.

  11. bool
    Member
    Posted 9 months ago #

    Maybe database user don't have permissions to create tables.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags