Error In Adding Poll

https://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;

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 :
https://www.flagworld.com/news/

I’ve installed and configured 4 other wordpress today;
https://www.flagworld.com/roadtests/ (Works fine)
https://www.flagworld.com/nouvelles/
https://www.flagworld.com/bruitsdepaddock/
https://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

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

@ 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.