PDOException Object
(
[message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'udsprofile_vendor_shipping' already exists
[string:Exception:private] =>
[code:protected] => 42S01
[file:protected] => /var/Uncovet/www/lib/Zend/Db/Statement/Pdo.php
[line:protected] => 228
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /var/Uncovet/www/lib/Zend/Db/Statement/Pdo.php
[line] => 228
[function] => execute
[class] => PDOStatement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[1] => Array
(
[file] => /var/Uncovet/www/lib/Varien/Db/Statement/Pdo/Mysql.php
[line] => 110
[function] => _execute
[class] => Zend_Db_Statement_Pdo
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[2] => Array
(
[file] => /var/Uncovet/www/lib/Zend/Db/Statement.php
[line] => 300
[function] => _execute
[class] => Varien_Db_Statement_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[3] => Array
(
[file] => /var/Uncovet/www/lib/Zend/Db/Adapter/Abstract.php
[line] => 479
[function] => execute
[class] => Zend_Db_Statement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[4] => Array
(
[file] => /var/Uncovet/www/lib/Zend/Db/Adapter/Pdo/Abstract.php
[line] => 238
[function] => query
[class] => Zend_Db_Adapter_Abstract
[type] => ->
[args] => Array
(
[0] => -- DROP TABLE IF EXISTS `udsprofile_vendor_shipping`;
CREATE TABLE `udsprofile_vendor_shipping` (
`vendor_id` int(11) unsigned NOT NULL,
`shipping_id` int(10) unsigned NOT NULL,
`carrier_code` varchar(100) NOT NULL DEFAULT '',
`method_code` varchar(255) NOT NULL DEFAULT '',
`est_use_custom` tinyint(1) DEFAULT NULL,
`est_carrier_code` varchar(100) NOT NULL DEFAULT '',
`est_method_code` varchar(255) NOT NULL DEFAULT '',
`sort_order` int(10) DEFAULT NULL,
KEY `IDX_udsprofile_vendor_shipping_method` (`shipping_id`),
KEY `IDX_udsprofile_vendor_shipping_vendor` (`vendor_id`),
CONSTRAINT `FK_udsprofile_vendor_shipping_method` FOREIGN KEY (`shipping_id`) REFERENCES `udropship_shipping` (`shipping_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_udsprofile_vendor_shipping_vendor` FOREIGN KEY (`vendor_id`) REFERENCES `udropship_vendor` (`vendor_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8
[1] => Array
(
)
)
)
[5] => Array
(
[file] => /var/Uncovet/www/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 419
[function] => query
[class] => Zend_Db_Adapter_Pdo_Abstract
[type] => ->
[args] => Array
(
[0] => -- DROP TABLE IF EXISTS `udsprofile_vendor_shipping`;
CREATE TABLE `udsprofile_vendor_shipping` (
`vendor_id` int(11) unsigned NOT NULL,
`shipping_id` int(10) unsigned NOT NULL,
`carrier_code` varchar(100) NOT NULL DEFAULT '',
`method_code` varchar(255) NOT NULL DEFAULT '',
`est_use_custom` tinyint(1) DEFAULT NULL,
`est_carrier_code` varchar(100) NOT NULL DEFAULT '',
`est_method_code` varchar(255) NOT NULL DEFAULT '',
`sort_order` int(10) DEFAULT NULL,
KEY `IDX_udsprofile_vendor_shipping_method` (`shipping_id`),
KEY `IDX_udsprofile_vendor_shipping_vendor` (`vendor_id`),
CONSTRAINT `FK_udsprofile_vendor_shipping_method` FOREIGN KEY (`shipping_id`) REFERENCES `udropship_shipping` (`shipping_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_udsprofile_vendor_shipping_vendor` FOREIGN KEY (`vendor_id`) REFERENCES `udropship_vendor` (`vendor_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8
[1] => Array
(
)
)
)
[6] => Array
(
[file] => /var/Uncovet/www/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 340
[function] => query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => -- DROP TABLE IF EXISTS `udsprofile_vendor_shipping`;
CREATE TABLE `udsprofile_vendor_shipping` (
`vendor_id` int(11) unsigned NOT NULL,
`shipping_id` int(10) unsigned NOT NULL,
`carrier_code` varchar(100) NOT NULL DEFAULT '',
`method_code` varchar(255) NOT NULL DEFAULT '',
`est_use_custom` tinyint(1) DEFAULT NULL,
`est_carrier_code` varchar(100) NOT NULL DEFAULT '',
`est_method_code` varchar(255) NOT NULL DEFAULT '',
`sort_order` int(10) DEFAULT NULL,
KEY `IDX_udsprofile_vendor_shipping_method` (`shipping_id`),
KEY `IDX_udsprofile_vendor_shipping_vendor` (`vendor_id`),
CONSTRAINT `FK_udsprofile_vendor_shipping_method` FOREIGN KEY (`shipping_id`) REFERENCES `udropship_shipping` (`shipping_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_udsprofile_vendor_shipping_vendor` FOREIGN KEY (`vendor_id`) REFERENCES `udropship_vendor` (`vendor_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8
)
)
[7] => Array
(
[file] => /var/Uncovet/www/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 608
[function] => raw_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => -- DROP TABLE IF EXISTS `udsprofile_vendor_shipping`;
CREATE TABLE `udsprofile_vendor_shipping` (
`vendor_id` int(11) unsigned NOT NULL,
`shipping_id` int(10) unsigned NOT NULL,
`carrier_code` varchar(100) NOT NULL DEFAULT '',
`method_code` varchar(255) NOT NULL DEFAULT '',
`est_use_custom` tinyint(1) DEFAULT NULL,
`est_carrier_code` varchar(100) NOT NULL DEFAULT '',
`est_method_code` varchar(255) NOT NULL DEFAULT '',
`sort_order` int(10) DEFAULT NULL,
KEY `IDX_udsprofile_vendor_shipping_method` (`shipping_id`),
KEY `IDX_udsprofile_vendor_shipping_vendor` (`vendor_id`),
CONSTRAINT `FK_udsprofile_vendor_shipping_method` FOREIGN KEY (`shipping_id`) REFERENCES `udropship_shipping` (`shipping_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_udsprofile_vendor_shipping_vendor` FOREIGN KEY (`vendor_id`) REFERENCES `udropship_vendor` (`vendor_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8
)
)
[8] => Array
(
[file] => /var/Uncovet/www/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 590
[function] => multi_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] =>
-- DROP TABLE IF EXISTS `udsprofile_vendor_shipping`;
CREATE TABLE `udsprofile_vendor_shipping` (
`vendor_id` int(11) unsigned NOT NULL,
`shipping_id` int(10) unsigned NOT NULL,
`carrier_code` varchar(100) NOT NULL DEFAULT '',
`method_code` varchar(255) NOT NULL DEFAULT '',
`est_use_custom` tinyint(1) DEFAULT NULL,
`est_carrier_code` varchar(100) NOT NULL DEFAULT '',
`est_method_code` varchar(255) NOT NULL DEFAULT '',
`sort_order` int(10) DEFAULT NULL,
KEY `IDX_udsprofile_vendor_shipping_method` (`shipping_id`),
KEY `IDX_udsprofile_vendor_shipping_vendor` (`vendor_id`),
CONSTRAINT `FK_udsprofile_vendor_shipping_method` FOREIGN KEY (`shipping_id`) REFERENCES `udropship_shipping` (`shipping_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_udsprofile_vendor_shipping_vendor` FOREIGN KEY (`vendor_id`) REFERENCES `udropship_vendor` (`vendor_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
)
)
[9] => Array
(
[file] => /var/Uncovet/www/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 933
[function] => multiQuery
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] =>
-- DROP TABLE IF EXISTS `udsprofile_vendor_shipping`;
CREATE TABLE `udsprofile_vendor_shipping` (
`vendor_id` int(11) unsigned NOT NULL,
`shipping_id` int(10) unsigned NOT NULL,
`carrier_code` varchar(100) NOT NULL DEFAULT '',
`method_code` varchar(255) NOT NULL DEFAULT '',
`est_use_custom` tinyint(1) DEFAULT NULL,
`est_carrier_code` varchar(100) NOT NULL DEFAULT '',
`est_method_code` varchar(255) NOT NULL DEFAULT '',
`sort_order` int(10) DEFAULT NULL,
KEY `IDX_udsprofile_vendor_shipping_method` (`shipping_id`),
KEY `IDX_udsprofile_vendor_shipping_vendor` (`vendor_id`),
CONSTRAINT `FK_udsprofile_vendor_shipping_method` FOREIGN KEY (`shipping_id`) REFERENCES `udropship_shipping` (`shipping_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_udsprofile_vendor_shipping_vendor` FOREIGN KEY (`vendor_id`) REFERENCES `udropship_vendor` (`vendor_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
)
)
[10] => Array
(
[file] => /var/Uncovet/www/app/code/community/Unirgy/DropshipShippingProfile/sql/udsprofile_setup/mysql4-install-1.0.0.php
[line] => 33
[function] => run
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] =>
-- DROP TABLE IF EXISTS `udsprofile_vendor_shipping`;
CREATE TABLE `udsprofile_vendor_shipping` (
`vendor_id` int(11) unsigned NOT NULL,
`shipping_id` int(10) unsigned NOT NULL,
`carrier_code` varchar(100) NOT NULL DEFAULT '',
`method_code` varchar(255) NOT NULL DEFAULT '',
`est_use_custom` tinyint(1) DEFAULT NULL,
`est_carrier_code` varchar(100) NOT NULL DEFAULT '',
`est_method_code` varchar(255) NOT NULL DEFAULT '',
`sort_order` int(10) DEFAULT NULL,
KEY `IDX_udsprofile_vendor_shipping_method` (`shipping_id`),
KEY `IDX_udsprofile_vendor_shipping_vendor` (`vendor_id`),
CONSTRAINT `FK_udsprofile_vendor_shipping_method` FOREIGN KEY (`shipping_id`) REFERENCES `udropship_shipping` (`shipping_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_udsprofile_vendor_shipping_vendor` FOREIGN KEY (`vendor_id`) REFERENCES `udropship_vendor` (`vendor_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
)
)
[11] => Array
(
[file] => /var/Uncovet/www/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 624
[args] => Array
(
[0] => /var/Uncovet/www/app/code/community/Unirgy/DropshipShippingProfile/sql/udsprofile_setup/mysql4-install-1.0.0.php
)
[function] => include
)
[12] => Array
(
[file] => /var/Uncovet/www/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] => 1.0.2
)
)
[13] => Array
(
[file] => /var/Uncovet/www/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 327
[function] => _installResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => 1.0.2
)
)
[14] => Array
(
[file] => /var/Uncovet/www/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] => /var/Uncovet/www/app/code/local/Mage/Core/Model/App.php
[line] => 423
[function] => applyAllUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)
)
[16] => Array
(
[file] => /var/Uncovet/www/app/code/local/Mage/Core/Model/App.php
[line] => 349
[function] => _initModules
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
)
)
[17] => Array
(
[file] => /var/Uncovet/www/app/Mage.php
[line] => 683
[function] => run
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
[0] => Array
(
[scope_code] =>
[scope_type] => store
[options] => Array
(
)
)
)
)
[18] => Array
(
[file] => /var/Uncovet/www/index.php
[line] => 93
[function] => run
[class] => Mage
[type] => ::
[args] => Array
(
[0] =>
[1] => store
)
)
)
[previous:Exception:private] =>
[errorInfo] => Array
(
[0] => 42S01
[1] => 1050
[2] => Table 'udsprofile_vendor_shipping' already exists
)
)