PDOException Object
(
    [message:protected] => SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'swift_code'
    [string:Exception:private] => 
    [code:protected] => 42S21
    [file:protected] => /var/www/vhosts/netpetshop.co.uk/htdocs/lib/Zend/Db/Statement/Pdo.php
    [line:protected] => 228
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /var/www/vhosts/netpetshop.co.uk/htdocs/lib/Zend/Db/Statement/Pdo.php
                    [line] => 228
                    [function] => execute
                    [class] => PDOStatement
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                )

                        )

                )

            [1] => Array
                (
                    [file] => /var/www/vhosts/netpetshop.co.uk/htdocs/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/www/vhosts/netpetshop.co.uk/htdocs/lib/Zend/Db/Statement.php
                    [line] => 300
                    [function] => _execute
                    [class] => Varien_Db_Statement_Pdo_Mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                )

                        )

                )

            [3] => Array
                (
                    [file] => /var/www/vhosts/netpetshop.co.uk/htdocs/lib/Zend/Db/Adapter/Abstract.php
                    [line] => 479
                    [function] => execute
                    [class] => Zend_Db_Statement
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                )

                        )

                )

            [4] => Array
                (
                    [file] => /var/www/vhosts/netpetshop.co.uk/htdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php
                    [line] => 238
                    [function] => query
                    [class] => Zend_Db_Adapter_Abstract
                    [type] => ->
                    [args] => Array
                        (
                            [0] => ALTER TABLE affiliatepluspayment_bankaccount
    ADD COLUMN `swift_code` varchar(100) NOT NULL default ''
                            [1] => Array
                                (
                                )

                        )

                )

            [5] => Array
                (
                    [file] => /var/www/vhosts/netpetshop.co.uk/htdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php
                    [line] => 389
                    [function] => query
                    [class] => Zend_Db_Adapter_Pdo_Abstract
                    [type] => ->
                    [args] => Array
                        (
                            [0] => ALTER TABLE affiliatepluspayment_bankaccount
    ADD COLUMN `swift_code` varchar(100) NOT NULL default ''
                            [1] => Array
                                (
                                )

                        )

                )

            [6] => Array
                (
                    [file] => /var/www/vhosts/netpetshop.co.uk/htdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php
                    [line] => 327
                    [function] => query
                    [class] => Varien_Db_Adapter_Pdo_Mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => ALTER TABLE affiliatepluspayment_bankaccount
    ADD COLUMN `swift_code` varchar(100) NOT NULL default ''
                        )

                )

            [7] => Array
                (
                    [file] => /var/www/vhosts/netpetshop.co.uk/htdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php
                    [line] => 593
                    [function] => raw_query
                    [class] => Varien_Db_Adapter_Pdo_Mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => ALTER TABLE affiliatepluspayment_bankaccount
    ADD COLUMN `swift_code` varchar(100) NOT NULL default ''
                        )

                )

            [8] => Array
                (
                    [file] => /var/www/vhosts/netpetshop.co.uk/htdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php
                    [line] => 575
                    [function] => multi_query
                    [class] => Varien_Db_Adapter_Pdo_Mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 

ALTER TABLE affiliatepluspayment_bankaccount
    ADD COLUMN `swift_code` varchar(100) NOT NULL default '';

ALTER TABLE affiliateplus_account
    ADD COLUMN `recurring_payment` tinyint(1) NOT NULL default '1',
    ADD COLUMN `last_received_date` date NULL,
    ADD COLUMN `recurring_method` varchar(100) NOT NULL default 'paypal',
    ADD COLUMN `moneybooker_email` varchar(255) NOT NULL default '';


CREATE TABLE affiliatepluspayment_moneybooker(
    `payment_moneybooker_id` int(10) unsigned NOT NULL auto_increment,
    `payment_id` int(10) unsigned NOT NULL,
    `email` varchar(255) NOT NULL default '',
    `transaction_id` varchar(255) NOT NULL default '',
    `description` text NOT NULL default '',
    INDEX(`payment_id`),
    FOREIGN KEY (`payment_id`) REFERENCES affiliateplus_payment (`payment_id`) ON DELETE CASCADE ON UPDATE CASCADE,
    PRIMARY KEY (`payment_moneybooker_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


ALTER TABLE affiliateplus_payment
    ADD COLUMN `is_recurring` tinyint(1) NOT NULL default '0';

    
                        )

                )

            [9] => Array
                (
                    [file] => /var/www/vhosts/netpetshop.co.uk/htdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 933
                    [function] => multiQuery
                    [class] => Varien_Db_Adapter_Pdo_Mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 

ALTER TABLE affiliatepluspayment_bankaccount
    ADD COLUMN `swift_code` varchar(100) NOT NULL default '';

ALTER TABLE affiliateplus_account
    ADD COLUMN `recurring_payment` tinyint(1) NOT NULL default '1',
    ADD COLUMN `last_received_date` date NULL,
    ADD COLUMN `recurring_method` varchar(100) NOT NULL default 'paypal',
    ADD COLUMN `moneybooker_email` varchar(255) NOT NULL default '';


CREATE TABLE affiliatepluspayment_moneybooker(
    `payment_moneybooker_id` int(10) unsigned NOT NULL auto_increment,
    `payment_id` int(10) unsigned NOT NULL,
    `email` varchar(255) NOT NULL default '',
    `transaction_id` varchar(255) NOT NULL default '',
    `description` text NOT NULL default '',
    INDEX(`payment_id`),
    FOREIGN KEY (`payment_id`) REFERENCES affiliateplus_payment (`payment_id`) ON DELETE CASCADE ON UPDATE CASCADE,
    PRIMARY KEY (`payment_moneybooker_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


ALTER TABLE affiliateplus_payment
    ADD COLUMN `is_recurring` tinyint(1) NOT NULL default '0';

    
                        )

                )

            [10] => Array
                (
                    [file] => /var/www/vhosts/netpetshop.co.uk/htdocs/app/code/local/Magestore/Affiliatepluspayment/sql/affiliatepluspayment_setup/mysql4-upgrade-0.1.0-0.3.0.php
                    [line] => 34
                    [function] => run
                    [class] => Mage_Core_Model_Resource_Setup
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 

ALTER TABLE affiliatepluspayment_bankaccount
    ADD COLUMN `swift_code` varchar(100) NOT NULL default '';

ALTER TABLE affiliateplus_account
    ADD COLUMN `recurring_payment` tinyint(1) NOT NULL default '1',
    ADD COLUMN `last_received_date` date NULL,
    ADD COLUMN `recurring_method` varchar(100) NOT NULL default 'paypal',
    ADD COLUMN `moneybooker_email` varchar(255) NOT NULL default '';


CREATE TABLE affiliatepluspayment_moneybooker(
    `payment_moneybooker_id` int(10) unsigned NOT NULL auto_increment,
    `payment_id` int(10) unsigned NOT NULL,
    `email` varchar(255) NOT NULL default '',
    `transaction_id` varchar(255) NOT NULL default '',
    `description` text NOT NULL default '',
    INDEX(`payment_id`),
    FOREIGN KEY (`payment_id`) REFERENCES affiliateplus_payment (`payment_id`) ON DELETE CASCADE ON UPDATE CASCADE,
    PRIMARY KEY (`payment_moneybooker_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


ALTER TABLE affiliateplus_payment
    ADD COLUMN `is_recurring` tinyint(1) NOT NULL default '0';

    
                        )

                )

            [11] => Array
                (
                    [file] => /var/www/vhosts/netpetshop.co.uk/htdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 624
                    [args] => Array
                        (
                            [0] => /var/www/vhosts/netpetshop.co.uk/htdocs/app/code/local/Magestore/Affiliatepluspayment/sql/affiliatepluspayment_setup/mysql4-upgrade-0.1.0-0.3.0.php
                        )

                    [function] => include
                )

            [12] => Array
                (
                    [file] => /var/www/vhosts/netpetshop.co.uk/htdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 437
                    [function] => _modifyResourceDb
                    [class] => Mage_Core_Model_Resource_Setup
                    [type] => ->
                    [args] => Array
                        (
                            [0] => upgrade
                            [1] => 0.1.0
                            [2] => 0.4.0
                        )

                )

            [13] => Array
                (
                    [file] => /var/www/vhosts/netpetshop.co.uk/htdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 320
                    [function] => _upgradeResourceDb
                    [class] => Mage_Core_Model_Resource_Setup
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 0.1.0
                            [1] => 0.4.0
                        )

                )

            [14] => Array
                (
                    [file] => /var/www/vhosts/netpetshop.co.uk/htdocs/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/www/vhosts/netpetshop.co.uk/htdocs/app/code/core/Mage/Core/Model/App.php
                    [line] => 412
                    [function] => applyAllUpdates
                    [class] => Mage_Core_Model_Resource_Setup
                    [type] => ::
                    [args] => Array
                        (
                        )

                )

            [16] => Array
                (
                    [file] => /var/www/vhosts/netpetshop.co.uk/htdocs/app/code/core/Mage/Core/Model/App.php
                    [line] => 338
                    [function] => _initModules
                    [class] => Mage_Core_Model_App
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [17] => Array
                (
                    [file] => /var/www/vhosts/netpetshop.co.uk/htdocs/app/Mage.php
                    [line] => 640
                    [function] => run
                    [class] => Mage_Core_Model_App
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                    [scope_code] => netpetshop
                                    [scope_type] => website
                                    [options] => Array
                                        (
                                        )

                                )

                        )

                )

            [18] => Array
                (
                    [file] => /var/www/vhosts/netpetshop.co.uk/htdocs/index.php
                    [line] => 126
                    [function] => run
                    [class] => Mage
                    [type] => ::
                    [args] => Array
                        (
                            [0] => netpetshop
                            [1] => website
                        )

                )

        )

    [previous:Exception:private] => 
    [errorInfo] => Array
        (
            [0] => 42S21
            [1] => 1060
            [2] => Duplicate column name 'swift_code'
        )

)