Thread Starter
gorod
(@gorod)
http://imageshack.us/f/29/wqta.jpg/
Here is a screenshot of the error.
The plugin doesn’t save any polls.
Thread Starter
gorod
(@gorod)
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 :
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
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.