PDOException Object
(
[message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'mgto_report_event_types' already exists
[string:private] =>
[code:protected] => 42S01
[file:protected] => /srv/www/vhosts/icteetbr/www/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line:protected] => 230
[trace:private] => Array
(
[0] => Array
(
[file] => /srv/www/vhosts/icteetbr/www/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 230
[function] => query
[class] => PDO
[type] => ->
[args] => Array
(
[0] => -- DROP TABLE IF EXISTS mgto_report_event_types;
CREATE TABLE mgto_report_event_types (
`event_type_id` smallint(6) unsigned NOT NULL auto_increment,
`event_name` varchar(32) NOT NULL,
PRIMARY KEY (`event_type_id`),
KEY `event_type_id` (`event_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
)
)
[1] => Array
(
[file] => /srv/www/vhosts/icteetbr/www/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 339
[function] => raw_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => -- DROP TABLE IF EXISTS mgto_report_event_types;
CREATE TABLE mgto_report_event_types (
`event_type_id` smallint(6) unsigned NOT NULL auto_increment,
`event_name` varchar(32) NOT NULL,
PRIMARY KEY (`event_type_id`),
KEY `event_type_id` (`event_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
)
)
[2] => Array
(
[file] => /srv/www/vhosts/icteetbr/www/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 535
[function] => multi_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] =>
-- DROP TABLE IF EXISTS mgto_report_event_types;
CREATE TABLE mgto_report_event_types (
`event_type_id` smallint(6) unsigned NOT NULL auto_increment,
`event_name` varchar(32) NOT NULL,
PRIMARY KEY (`event_type_id`),
KEY `event_type_id` (`event_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO mgto_report_event_types VALUES
(1, 'catalog_product_view'),
(2, 'sendfriend_product'),
(3, 'catalog_product_compare_add_product'),
(4, 'checkout_cart_add_product'),
(5, 'wishlist_add_product'),
(6, 'wishlist_share');
-- DROP TABLE IF EXISTS mgto_report_event;
CREATE TABLE mgto_report_event (
`event_id` bigint(20) unsigned NOT NULL auto_increment,
`logged_at` datetime NOT NULL default '0000-00-00 00:00:00',
`event_type_id` smallint(6) unsigned NOT NULL default '0',
`object_id` int(10) unsigned NOT NULL default '0',
`subject_id` int(10) unsigned NOT NULL default '0',
`store_id` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`event_id`),
KEY `subject_id` (`subject_id`),
KEY `object_id` (`object_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
)
)
[3] => Array
(
[file] => /srv/www/vhosts/icteetbr/www/app/code/core/Mage/Reports/sql/reports_setup/mysql4-install-0.7.1.php
[line] => 71
[function] => run
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] =>
-- DROP TABLE IF EXISTS mgto_report_event_types;
CREATE TABLE mgto_report_event_types (
`event_type_id` smallint(6) unsigned NOT NULL auto_increment,
`event_name` varchar(32) NOT NULL,
PRIMARY KEY (`event_type_id`),
KEY `event_type_id` (`event_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO mgto_report_event_types VALUES
(1, 'catalog_product_view'),
(2, 'sendfriend_product'),
(3, 'catalog_product_compare_add_product'),
(4, 'checkout_cart_add_product'),
(5, 'wishlist_add_product'),
(6, 'wishlist_share');
-- DROP TABLE IF EXISTS mgto_report_event;
CREATE TABLE mgto_report_event (
`event_id` bigint(20) unsigned NOT NULL auto_increment,
`logged_at` datetime NOT NULL default '0000-00-00 00:00:00',
`event_type_id` smallint(6) unsigned NOT NULL default '0',
`object_id` int(10) unsigned NOT NULL default '0',
`subject_id` int(10) unsigned NOT NULL default '0',
`store_id` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`event_id`),
KEY `subject_id` (`subject_id`),
KEY `object_id` (`object_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
)
)
[4] => Array
(
[file] => /srv/www/vhosts/icteetbr/www/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 274
[args] => Array
(
[0] => /srv/www/vhosts/icteetbr/www/app/code/core/Mage/Reports/sql/reports_setup/mysql4-install-0.7.1.php
)
[function] => include
)
[5] => Array
(
[file] => /srv/www/vhosts/icteetbr/www/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 167
[function] => _modifyResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => install
[1] =>
[2] => 0.7.7
)
)
[6] => Array
(
[file] => /srv/www/vhosts/icteetbr/www/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 155
[function] => _installResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => 0.7.7
)
)
[7] => Array
(
[file] => /srv/www/vhosts/icteetbr/www/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 121
[function] => applyUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
)
)
[8] => Array
(
[file] => /srv/www/vhosts/icteetbr/www/app/code/core/Mage/Core/Model/Config.php
[line] => 263
[function] => applyAllUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)
)
[9] => Array
(
[file] => /srv/www/vhosts/icteetbr/www/app/code/core/Mage/Core/Model/App.php
[line] => 263
[function] => init
[class] => Mage_Core_Model_Config
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[10] => Array
(
[file] => /srv/www/vhosts/icteetbr/www/app/Mage.php
[line] => 434
[function] => init
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
[0] => default
[1] => store
[2] => Array
(
)
)
)
[11] => Array
(
[file] => /srv/www/vhosts/icteetbr/www/app/Mage.php
[line] => 455
[function] => app
[class] => Mage
[type] => ::
[args] => Array
(
[0] => default
[1] => store
[2] => Array
(
)
)
)
[12] => Array
(
[file] => /srv/www/vhosts/icteetbr/www/index.php
[line] => 52
[function] => run
[class] => Mage
[type] => ::
[args] => Array
(
[0] => default
)
)
)
[errorInfo] => Array
(
[0] => 42S01
[1] => 1050
[2] => Table 'mgto_report_event_types' already exists
)
)