PDOException Object
(
[message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'poll' already exists
[string:private] =>
[code:protected] => 42S01
[file:protected] => /www/htdocs/w00a082e/endstufen/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line:protected] => 276
[trace:private] => Array
(
[0] => Array
(
[file] => /www/htdocs/w00a082e/endstufen/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 276
[function] => query
[class] => PDO
[type] => ->
[args] => Array
(
[0] => -- DROP TABLE IF EXISTS poll;
CREATE TABLE poll (
`poll_id` int(10) unsigned NOT NULL auto_increment,
`poll_title` varchar(255) NOT NULL default '',
`votes_count` int(10) unsigned NOT NULL default '0',
`store_id` smallint(6) NOT NULL default '0',
`date_posted` datetime NOT NULL default '0000-00-00 00:00:00',
`date_closed` datetime default NULL,
`active` smallint(6) NOT NULL default '1',
`closed` tinyint(1) NOT NULL default '0',
`answers_display` smallint(6) default NULL,
PRIMARY KEY (`poll_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
)
)
[1] => Array
(
[file] => /www/htdocs/w00a082e/endstufen/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 397
[function] => raw_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => -- DROP TABLE IF EXISTS poll;
CREATE TABLE poll (
`poll_id` int(10) unsigned NOT NULL auto_increment,
`poll_title` varchar(255) NOT NULL default '',
`votes_count` int(10) unsigned NOT NULL default '0',
`store_id` smallint(6) NOT NULL default '0',
`date_posted` datetime NOT NULL default '0000-00-00 00:00:00',
`date_closed` datetime default NULL,
`active` smallint(6) NOT NULL default '1',
`closed` tinyint(1) NOT NULL default '0',
`answers_display` smallint(6) default NULL,
PRIMARY KEY (`poll_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
)
)
[2] => Array
(
[file] => /www/htdocs/w00a082e/endstufen/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 612
[function] => multi_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] =>
-- DROP TABLE IF EXISTS poll;
CREATE TABLE poll (
`poll_id` int(10) unsigned NOT NULL auto_increment,
`poll_title` varchar(255) NOT NULL default '',
`votes_count` int(10) unsigned NOT NULL default '0',
`store_id` smallint(6) NOT NULL default '0',
`date_posted` datetime NOT NULL default '0000-00-00 00:00:00',
`date_closed` datetime default NULL,
`active` smallint(6) NOT NULL default '1',
`closed` tinyint(1) NOT NULL default '0',
`answers_display` smallint(6) default NULL,
PRIMARY KEY (`poll_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
insert into poll(`poll_id`,`poll_title`,`votes_count`,`store_id`,`date_posted`,`date_closed`,`active`,`closed`,`answers_display`) values (1,'What is your favorite color',5,1, NOW(),NULL,1,0,NULL);
-- DROP TABLE IF EXISTS poll_answer;
CREATE TABLE poll_answer (
`answer_id` int(10) unsigned NOT NULL auto_increment,
`poll_id` int(10) unsigned NOT NULL default '0',
`answer_title` varchar(255) NOT NULL default '',
`votes_count` int(10) unsigned NOT NULL default '0',
`answer_order` smallint(6) NOT NULL default '0',
PRIMARY KEY (`answer_id`),
KEY `FK_POLL_PARENT` (`poll_id`),
CONSTRAINT `FK_POLL_PARENT` FOREIGN KEY (`poll_id`) REFERENCES poll (`poll_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
insert into poll_answer(`answer_id`,`poll_id`,`answer_title`,`votes_count`,`answer_order`) values (1,1,'Green',4,0),(2,1,'Red',1,0),(3,1,'Black',0,0),(4,1,'Magenta',0,0);
-- DROP TABLE IF EXISTS poll_store;
CREATE TABLE poll_store (
`poll_id` int(10) unsigned NOT NULL default '0',
`store_id` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`poll_id`,`store_id`),
CONSTRAINT `FK_POLL_STORE` FOREIGN KEY (`poll_id`) REFERENCES poll (`poll_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO poll_store (`poll_id`,`store_id`) VALUES(1,1);
-- DROP TABLE IF EXISTS poll_vote;
CREATE TABLE poll_vote (
`vote_id` int(10) unsigned NOT NULL auto_increment,
`poll_id` int(10) unsigned NOT NULL default '0',
`poll_answer_id` int(10) unsigned NOT NULL default '0',
`ip_address` bigint(20) default NULL,
`customer_id` int(11) default NULL,
`vote_time` timestamp NOT NULL,
PRIMARY KEY (`vote_id`),
KEY `FK_POLL_ANSWER` (`poll_answer_id`),
CONSTRAINT `FK_POLL_ANSWER` FOREIGN KEY (`poll_answer_id`) REFERENCES poll_answer (`answer_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
)
)
[3] => Array
(
[file] => /www/htdocs/w00a082e/endstufen/app/code/core/Mage/Poll/sql/poll_setup/mysql4-install-0.7.0.php
[line] => 86
[function] => run
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] =>
-- DROP TABLE IF EXISTS poll;
CREATE TABLE poll (
`poll_id` int(10) unsigned NOT NULL auto_increment,
`poll_title` varchar(255) NOT NULL default '',
`votes_count` int(10) unsigned NOT NULL default '0',
`store_id` smallint(6) NOT NULL default '0',
`date_posted` datetime NOT NULL default '0000-00-00 00:00:00',
`date_closed` datetime default NULL,
`active` smallint(6) NOT NULL default '1',
`closed` tinyint(1) NOT NULL default '0',
`answers_display` smallint(6) default NULL,
PRIMARY KEY (`poll_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
insert into poll(`poll_id`,`poll_title`,`votes_count`,`store_id`,`date_posted`,`date_closed`,`active`,`closed`,`answers_display`) values (1,'What is your favorite color',5,1, NOW(),NULL,1,0,NULL);
-- DROP TABLE IF EXISTS poll_answer;
CREATE TABLE poll_answer (
`answer_id` int(10) unsigned NOT NULL auto_increment,
`poll_id` int(10) unsigned NOT NULL default '0',
`answer_title` varchar(255) NOT NULL default '',
`votes_count` int(10) unsigned NOT NULL default '0',
`answer_order` smallint(6) NOT NULL default '0',
PRIMARY KEY (`answer_id`),
KEY `FK_POLL_PARENT` (`poll_id`),
CONSTRAINT `FK_POLL_PARENT` FOREIGN KEY (`poll_id`) REFERENCES poll (`poll_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
insert into poll_answer(`answer_id`,`poll_id`,`answer_title`,`votes_count`,`answer_order`) values (1,1,'Green',4,0),(2,1,'Red',1,0),(3,1,'Black',0,0),(4,1,'Magenta',0,0);
-- DROP TABLE IF EXISTS poll_store;
CREATE TABLE poll_store (
`poll_id` int(10) unsigned NOT NULL default '0',
`store_id` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`poll_id`,`store_id`),
CONSTRAINT `FK_POLL_STORE` FOREIGN KEY (`poll_id`) REFERENCES poll (`poll_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO poll_store (`poll_id`,`store_id`) VALUES(1,1);
-- DROP TABLE IF EXISTS poll_vote;
CREATE TABLE poll_vote (
`vote_id` int(10) unsigned NOT NULL auto_increment,
`poll_id` int(10) unsigned NOT NULL default '0',
`poll_answer_id` int(10) unsigned NOT NULL default '0',
`ip_address` bigint(20) default NULL,
`customer_id` int(11) default NULL,
`vote_time` timestamp NOT NULL,
PRIMARY KEY (`vote_id`),
KEY `FK_POLL_ANSWER` (`poll_answer_id`),
CONSTRAINT `FK_POLL_ANSWER` FOREIGN KEY (`poll_answer_id`) REFERENCES poll_answer (`answer_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
)
)
[4] => Array
(
[file] => /www/htdocs/w00a082e/endstufen/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 360
[args] => Array
(
[0] => /www/htdocs/w00a082e/endstufen/app/code/core/Mage/Poll/sql/poll_setup/mysql4-install-0.7.0.php
)
[function] => include
)
[5] => Array
(
[file] => /www/htdocs/w00a082e/endstufen/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 260
[function] => _modifyResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => install
[1] =>
[2] => 0.7.2
)
)
[6] => Array
(
[file] => /www/htdocs/w00a082e/endstufen/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 224
[function] => _installResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => 0.7.2
)
)
[7] => Array
(
[file] => /www/htdocs/w00a082e/endstufen/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 153
[function] => applyUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
)
)
[8] => Array
(
[file] => /www/htdocs/w00a082e/endstufen/app/code/core/Mage/Core/Model/App.php
[line] => 363
[function] => applyAllUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)
)
[9] => Array
(
[file] => /www/htdocs/w00a082e/endstufen/app/code/core/Mage/Core/Model/App.php
[line] => 295
[function] => _initModules
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
)
)
[10] => Array
(
[file] => /www/htdocs/w00a082e/endstufen/app/Mage.php
[line] => 596
[function] => run
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
[0] => Array
(
[scope_code] =>
[scope_type] => store
[options] => Array
(
)
)
)
)
[11] => Array
(
[file] => /www/htdocs/w00a082e/endstufen/index.php
[line] => 78
[function] => run
[class] => Mage
[type] => ::
[args] => Array
(
[0] =>
[1] => store
)
)
)
[errorInfo] => Array
(
[0] => 42S01
[1] => 1050
[2] => Table 'poll' already exists
)
)