Support » Plugin: WP-Polls » Error In Adding Poll

  • Resolved gorod

    (@gorod)


    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/

Viewing 10 replies - 1 through 10 (of 10 total)
  • http://imageshack.us/f/29/wqta.jpg/

    Here is a screenshot of the error.

    The plugin doesn’t save any polls.

    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;

    Plugin Author Lester Chan

    (@gamerz)

    are you using WP Multisite?

    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

    Plugin Author Lester Chan

    (@gamerz)

    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

    Well how about that, it seems they are indeed missing

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

    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

    Plugin Author Lester Chan

    (@gamerz)

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

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

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Error In Adding Poll’ is closed to new replies.