PDOException Object
(
[message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'am_feed_profile' already exists
[string:Exception:private] =>
[code:protected] => 42S01
[file:protected] => /home/homepro/public_html/lib/Zend/Db/Statement/Pdo.php
[line:protected] => 228
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /home/homepro/public_html/lib/Zend/Db/Statement/Pdo.php
[line] => 228
[function] => execute
[class] => PDOStatement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[1] => Array
(
[file] => /home/homepro/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php
[line] => 110
[function] => _execute
[class] => Zend_Db_Statement_Pdo
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[2] => Array
(
[file] => /home/homepro/public_html/app/code/core/Zend/Db/Statement.php
[line] => 291
[function] => _execute
[class] => Varien_Db_Statement_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[3] => Array
(
[file] => /home/homepro/public_html/lib/Zend/Db/Adapter/Abstract.php
[line] => 480
[function] => execute
[class] => Zend_Db_Statement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[4] => Array
(
[file] => /home/homepro/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php
[line] => 238
[function] => query
[class] => Zend_Db_Adapter_Abstract
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `am_feed_profile` (
`feed_id` mediumint(8) unsigned NOT NULL auto_increment,
`store_id` smallint(6) NOT NULL,
`status` smallint(1) NOT NULL,
`generated_at` datetime NOT NULL default '0000-00-00 00:00:00',
`delivery_at` datetime NOT NULL default '0000-00-00 00:00:00',
`type` tinyint(1) NOT NULL,
`title` varchar(255) NOT NULL,
`filename` varchar(255) NOT NULL,
`mode` tinyint(1) NOT NULL default '0',
`cond_stock` tinyint(1) NOT NULL default '1',
`cond_disabled` tinyint(1) NOT NULL default '1',
`cond_type` text NOT NULL default '',
`cond_advanced` text NOT NULL default '',
`xml_header` text NOT NULL default '',
`xml_body` text NOT NULL default '',
`xml_footer` text NOT NULL default '',
`xml_item` varchar(255) default '',
`csv` text NOT NULL,
`csv_header` tinyint(1) NOT NULL default '0',
`csv_enclosure` tinyint(1) NOT NULL default '0',
`csv_delimiter` tinyint(1) NOT NULL default '0',
`frm_date` varchar(255) NOT NULL,
`frm_price` tinyint(1) NOT NULL default '2',
`frm_url` tinyint(1) NOT NULL default '0',
`frm_image_url` tinyint(1) NOT NULL default '0',
`default_image` tinyint(1) NOT NULL default '0',
`delivery_type` tinyint(1) NOT NULL default '0',
`delivered` tinyint(1) NOT NULL default '0',
`send_email` varchar(50) default '',
`ftp_host` varchar(128) default '',
`ftp_user` varchar(255) default '',
`ftp_pass` varchar(255) default '',
`ftp_folder` varchar(255) default '/',
`ftp_is_passive` tinyint(1) NOT NULL default '0',
`info_total` int NOT NULL default '0',
`info_cnt` smallint(6) NOT NULL default '0',
`info_errors` tinyint(1) NOT NULL default '0',
`freq` tinyint(2) NOT NULL,
`on_days` text NOT NULL default '',
`hour_from` tinyint(2) NOT NULL,
`hour_to` tinyint(2) NOT NULL,
`error_email` varchar(50) default '',
PRIMARY KEY (`feed_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
[1] => Array
(
)
)
)
[5] => Array
(
[file] => /home/homepro/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 504
[function] => query
[class] => Zend_Db_Adapter_Pdo_Abstract
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `am_feed_profile` (
`feed_id` mediumint(8) unsigned NOT NULL auto_increment,
`store_id` smallint(6) NOT NULL,
`status` smallint(1) NOT NULL,
`generated_at` datetime NOT NULL default '0000-00-00 00:00:00',
`delivery_at` datetime NOT NULL default '0000-00-00 00:00:00',
`type` tinyint(1) NOT NULL,
`title` varchar(255) NOT NULL,
`filename` varchar(255) NOT NULL,
`mode` tinyint(1) NOT NULL default '0',
`cond_stock` tinyint(1) NOT NULL default '1',
`cond_disabled` tinyint(1) NOT NULL default '1',
`cond_type` text NOT NULL default '',
`cond_advanced` text NOT NULL default '',
`xml_header` text NOT NULL default '',
`xml_body` text NOT NULL default '',
`xml_footer` text NOT NULL default '',
`xml_item` varchar(255) default '',
`csv` text NOT NULL,
`csv_header` tinyint(1) NOT NULL default '0',
`csv_enclosure` tinyint(1) NOT NULL default '0',
`csv_delimiter` tinyint(1) NOT NULL default '0',
`frm_date` varchar(255) NOT NULL,
`frm_price` tinyint(1) NOT NULL default '2',
`frm_url` tinyint(1) NOT NULL default '0',
`frm_image_url` tinyint(1) NOT NULL default '0',
`default_image` tinyint(1) NOT NULL default '0',
`delivery_type` tinyint(1) NOT NULL default '0',
`delivered` tinyint(1) NOT NULL default '0',
`send_email` varchar(50) default '',
`ftp_host` varchar(128) default '',
`ftp_user` varchar(255) default '',
`ftp_pass` varchar(255) default '',
`ftp_folder` varchar(255) default '/',
`ftp_is_passive` tinyint(1) NOT NULL default '0',
`info_total` int NOT NULL default '0',
`info_cnt` smallint(6) NOT NULL default '0',
`info_errors` tinyint(1) NOT NULL default '0',
`freq` tinyint(2) NOT NULL,
`on_days` text NOT NULL default '',
`hour_from` tinyint(2) NOT NULL,
`hour_to` tinyint(2) NOT NULL,
`error_email` varchar(50) default '',
PRIMARY KEY (`feed_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
[1] => Array
(
)
)
)
[6] => Array
(
[file] => /home/homepro/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 423
[function] => query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `am_feed_profile` (
`feed_id` mediumint(8) unsigned NOT NULL auto_increment,
`store_id` smallint(6) NOT NULL,
`status` smallint(1) NOT NULL,
`generated_at` datetime NOT NULL default '0000-00-00 00:00:00',
`delivery_at` datetime NOT NULL default '0000-00-00 00:00:00',
`type` tinyint(1) NOT NULL,
`title` varchar(255) NOT NULL,
`filename` varchar(255) NOT NULL,
`mode` tinyint(1) NOT NULL default '0',
`cond_stock` tinyint(1) NOT NULL default '1',
`cond_disabled` tinyint(1) NOT NULL default '1',
`cond_type` text NOT NULL default '',
`cond_advanced` text NOT NULL default '',
`xml_header` text NOT NULL default '',
`xml_body` text NOT NULL default '',
`xml_footer` text NOT NULL default '',
`xml_item` varchar(255) default '',
`csv` text NOT NULL,
`csv_header` tinyint(1) NOT NULL default '0',
`csv_enclosure` tinyint(1) NOT NULL default '0',
`csv_delimiter` tinyint(1) NOT NULL default '0',
`frm_date` varchar(255) NOT NULL,
`frm_price` tinyint(1) NOT NULL default '2',
`frm_url` tinyint(1) NOT NULL default '0',
`frm_image_url` tinyint(1) NOT NULL default '0',
`default_image` tinyint(1) NOT NULL default '0',
`delivery_type` tinyint(1) NOT NULL default '0',
`delivered` tinyint(1) NOT NULL default '0',
`send_email` varchar(50) default '',
`ftp_host` varchar(128) default '',
`ftp_user` varchar(255) default '',
`ftp_pass` varchar(255) default '',
`ftp_folder` varchar(255) default '/',
`ftp_is_passive` tinyint(1) NOT NULL default '0',
`info_total` int NOT NULL default '0',
`info_cnt` smallint(6) NOT NULL default '0',
`info_errors` tinyint(1) NOT NULL default '0',
`freq` tinyint(2) NOT NULL,
`on_days` text NOT NULL default '',
`hour_from` tinyint(2) NOT NULL,
`hour_to` tinyint(2) NOT NULL,
`error_email` varchar(50) default '',
PRIMARY KEY (`feed_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
)
)
[7] => Array
(
[file] => /home/homepro/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 693
[function] => raw_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `am_feed_profile` (
`feed_id` mediumint(8) unsigned NOT NULL auto_increment,
`store_id` smallint(6) NOT NULL,
`status` smallint(1) NOT NULL,
`generated_at` datetime NOT NULL default '0000-00-00 00:00:00',
`delivery_at` datetime NOT NULL default '0000-00-00 00:00:00',
`type` tinyint(1) NOT NULL,
`title` varchar(255) NOT NULL,
`filename` varchar(255) NOT NULL,
`mode` tinyint(1) NOT NULL default '0',
`cond_stock` tinyint(1) NOT NULL default '1',
`cond_disabled` tinyint(1) NOT NULL default '1',
`cond_type` text NOT NULL default '',
`cond_advanced` text NOT NULL default '',
`xml_header` text NOT NULL default '',
`xml_body` text NOT NULL default '',
`xml_footer` text NOT NULL default '',
`xml_item` varchar(255) default '',
`csv` text NOT NULL,
`csv_header` tinyint(1) NOT NULL default '0',
`csv_enclosure` tinyint(1) NOT NULL default '0',
`csv_delimiter` tinyint(1) NOT NULL default '0',
`frm_date` varchar(255) NOT NULL,
`frm_price` tinyint(1) NOT NULL default '2',
`frm_url` tinyint(1) NOT NULL default '0',
`frm_image_url` tinyint(1) NOT NULL default '0',
`default_image` tinyint(1) NOT NULL default '0',
`delivery_type` tinyint(1) NOT NULL default '0',
`delivered` tinyint(1) NOT NULL default '0',
`send_email` varchar(50) default '',
`ftp_host` varchar(128) default '',
`ftp_user` varchar(255) default '',
`ftp_pass` varchar(255) default '',
`ftp_folder` varchar(255) default '/',
`ftp_is_passive` tinyint(1) NOT NULL default '0',
`info_total` int NOT NULL default '0',
`info_cnt` smallint(6) NOT NULL default '0',
`info_errors` tinyint(1) NOT NULL default '0',
`freq` tinyint(2) NOT NULL,
`on_days` text NOT NULL default '',
`hour_from` tinyint(2) NOT NULL,
`hour_to` tinyint(2) NOT NULL,
`error_email` varchar(50) default '',
PRIMARY KEY (`feed_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
)
)
[8] => Array
(
[file] => /home/homepro/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 675
[function] => multi_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] =>
CREATE TABLE `am_feed_profile` (
`feed_id` mediumint(8) unsigned NOT NULL auto_increment,
`store_id` smallint(6) NOT NULL,
`status` smallint(1) NOT NULL,
`generated_at` datetime NOT NULL default '0000-00-00 00:00:00',
`delivery_at` datetime NOT NULL default '0000-00-00 00:00:00',
`type` tinyint(1) NOT NULL,
`title` varchar(255) NOT NULL,
`filename` varchar(255) NOT NULL,
`mode` tinyint(1) NOT NULL default '0',
`cond_stock` tinyint(1) NOT NULL default '1',
`cond_disabled` tinyint(1) NOT NULL default '1',
`cond_type` text NOT NULL default '',
`cond_advanced` text NOT NULL default '',
`xml_header` text NOT NULL default '',
`xml_body` text NOT NULL default '',
`xml_footer` text NOT NULL default '',
`xml_item` varchar(255) default '',
`csv` text NOT NULL,
`csv_header` tinyint(1) NOT NULL default '0',
`csv_enclosure` tinyint(1) NOT NULL default '0',
`csv_delimiter` tinyint(1) NOT NULL default '0',
`frm_date` varchar(255) NOT NULL,
`frm_price` tinyint(1) NOT NULL default '2',
`frm_url` tinyint(1) NOT NULL default '0',
`frm_image_url` tinyint(1) NOT NULL default '0',
`default_image` tinyint(1) NOT NULL default '0',
`delivery_type` tinyint(1) NOT NULL default '0',
`delivered` tinyint(1) NOT NULL default '0',
`send_email` varchar(50) default '',
`ftp_host` varchar(128) default '',
`ftp_user` varchar(255) default '',
`ftp_pass` varchar(255) default '',
`ftp_folder` varchar(255) default '/',
`ftp_is_passive` tinyint(1) NOT NULL default '0',
`info_total` int NOT NULL default '0',
`info_cnt` smallint(6) NOT NULL default '0',
`info_errors` tinyint(1) NOT NULL default '0',
`freq` tinyint(2) NOT NULL,
`on_days` text NOT NULL default '',
`hour_from` tinyint(2) NOT NULL,
`hour_to` tinyint(2) NOT NULL,
`error_email` varchar(50) default '',
PRIMARY KEY (`feed_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
CREATE TABLE `am_feed_field` (
`field_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`code` varchar(128) NOT NULL,
`title` varchar(255) NOT NULL,
`base_attr` varchar(255) NOT NULL,
`default_value` varchar(255) NOT NULL,
`transform` varchar(255) NOT NULL,
`mapping` text NOT NULL default '',
PRIMARY KEY (`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
)
)
[9] => Array
(
[file] => /home/homepro/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 933
[function] => multiQuery
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] =>
CREATE TABLE `am_feed_profile` (
`feed_id` mediumint(8) unsigned NOT NULL auto_increment,
`store_id` smallint(6) NOT NULL,
`status` smallint(1) NOT NULL,
`generated_at` datetime NOT NULL default '0000-00-00 00:00:00',
`delivery_at` datetime NOT NULL default '0000-00-00 00:00:00',
`type` tinyint(1) NOT NULL,
`title` varchar(255) NOT NULL,
`filename` varchar(255) NOT NULL,
`mode` tinyint(1) NOT NULL default '0',
`cond_stock` tinyint(1) NOT NULL default '1',
`cond_disabled` tinyint(1) NOT NULL default '1',
`cond_type` text NOT NULL default '',
`cond_advanced` text NOT NULL default '',
`xml_header` text NOT NULL default '',
`xml_body` text NOT NULL default '',
`xml_footer` text NOT NULL default '',
`xml_item` varchar(255) default '',
`csv` text NOT NULL,
`csv_header` tinyint(1) NOT NULL default '0',
`csv_enclosure` tinyint(1) NOT NULL default '0',
`csv_delimiter` tinyint(1) NOT NULL default '0',
`frm_date` varchar(255) NOT NULL,
`frm_price` tinyint(1) NOT NULL default '2',
`frm_url` tinyint(1) NOT NULL default '0',
`frm_image_url` tinyint(1) NOT NULL default '0',
`default_image` tinyint(1) NOT NULL default '0',
`delivery_type` tinyint(1) NOT NULL default '0',
`delivered` tinyint(1) NOT NULL default '0',
`send_email` varchar(50) default '',
`ftp_host` varchar(128) default '',
`ftp_user` varchar(255) default '',
`ftp_pass` varchar(255) default '',
`ftp_folder` varchar(255) default '/',
`ftp_is_passive` tinyint(1) NOT NULL default '0',
`info_total` int NOT NULL default '0',
`info_cnt` smallint(6) NOT NULL default '0',
`info_errors` tinyint(1) NOT NULL default '0',
`freq` tinyint(2) NOT NULL,
`on_days` text NOT NULL default '',
`hour_from` tinyint(2) NOT NULL,
`hour_to` tinyint(2) NOT NULL,
`error_email` varchar(50) default '',
PRIMARY KEY (`feed_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
CREATE TABLE `am_feed_field` (
`field_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`code` varchar(128) NOT NULL,
`title` varchar(255) NOT NULL,
`base_attr` varchar(255) NOT NULL,
`default_value` varchar(255) NOT NULL,
`transform` varchar(255) NOT NULL,
`mapping` text NOT NULL default '',
PRIMARY KEY (`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
)
)
[10] => Array
(
[file] => /home/homepro/public_html/app/code/local/Amasty/Feed/sql/amfeed_setup/mysql4-install-1.0.0.php
[line] => 81
[function] => run
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] =>
CREATE TABLE `am_feed_profile` (
`feed_id` mediumint(8) unsigned NOT NULL auto_increment,
`store_id` smallint(6) NOT NULL,
`status` smallint(1) NOT NULL,
`generated_at` datetime NOT NULL default '0000-00-00 00:00:00',
`delivery_at` datetime NOT NULL default '0000-00-00 00:00:00',
`type` tinyint(1) NOT NULL,
`title` varchar(255) NOT NULL,
`filename` varchar(255) NOT NULL,
`mode` tinyint(1) NOT NULL default '0',
`cond_stock` tinyint(1) NOT NULL default '1',
`cond_disabled` tinyint(1) NOT NULL default '1',
`cond_type` text NOT NULL default '',
`cond_advanced` text NOT NULL default '',
`xml_header` text NOT NULL default '',
`xml_body` text NOT NULL default '',
`xml_footer` text NOT NULL default '',
`xml_item` varchar(255) default '',
`csv` text NOT NULL,
`csv_header` tinyint(1) NOT NULL default '0',
`csv_enclosure` tinyint(1) NOT NULL default '0',
`csv_delimiter` tinyint(1) NOT NULL default '0',
`frm_date` varchar(255) NOT NULL,
`frm_price` tinyint(1) NOT NULL default '2',
`frm_url` tinyint(1) NOT NULL default '0',
`frm_image_url` tinyint(1) NOT NULL default '0',
`default_image` tinyint(1) NOT NULL default '0',
`delivery_type` tinyint(1) NOT NULL default '0',
`delivered` tinyint(1) NOT NULL default '0',
`send_email` varchar(50) default '',
`ftp_host` varchar(128) default '',
`ftp_user` varchar(255) default '',
`ftp_pass` varchar(255) default '',
`ftp_folder` varchar(255) default '/',
`ftp_is_passive` tinyint(1) NOT NULL default '0',
`info_total` int NOT NULL default '0',
`info_cnt` smallint(6) NOT NULL default '0',
`info_errors` tinyint(1) NOT NULL default '0',
`freq` tinyint(2) NOT NULL,
`on_days` text NOT NULL default '',
`hour_from` tinyint(2) NOT NULL,
`hour_to` tinyint(2) NOT NULL,
`error_email` varchar(50) default '',
PRIMARY KEY (`feed_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
CREATE TABLE `am_feed_field` (
`field_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`code` varchar(128) NOT NULL,
`title` varchar(255) NOT NULL,
`base_attr` varchar(255) NOT NULL,
`default_value` varchar(255) NOT NULL,
`transform` varchar(255) NOT NULL,
`mapping` text NOT NULL default '',
PRIMARY KEY (`field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
)
)
[11] => Array
(
[file] => /home/homepro/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 624
[args] => Array
(
[0] => /home/homepro/public_html/app/code/local/Amasty/Feed/sql/amfeed_setup/mysql4-install-1.0.0.php
)
[function] => include
)
[12] => Array
(
[file] => /home/homepro/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 421
[function] => _modifyResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => install
[1] =>
[2] => 3.5.7
)
)
[13] => Array
(
[file] => /home/homepro/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 327
[function] => _installResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => 3.5.7
)
)
[14] => Array
(
[file] => /home/homepro/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 235
[function] => applyUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
)
)
[15] => Array
(
[file] => /home/homepro/public_html/app/code/core/Mage/Core/Model/App.php
[line] => 428
[function] => applyAllUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)
)
[16] => Array
(
[file] => /home/homepro/public_html/app/code/core/Mage/Core/Model/App.php
[line] => 354
[function] => _initModules
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
)
)
[17] => Array
(
[file] => /home/homepro/public_html/app/Mage.php
[line] => 684
[function] => run
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
[0] => Array
(
[scope_code] =>
[scope_type] => store
[options] => Array
(
)
)
)
)
[18] => Array
(
[file] => /home/homepro/public_html/index.php
[line] => 84
[function] => run
[class] => Mage
[type] => ::
[args] => Array
(
[0] =>
[1] => store
)
)
)
[previous:Exception:private] =>
[errorInfo] => Array
(
[0] => 42S01
[1] => 1050
[2] => Table 'am_feed_profile' already exists
)
)