PDOException Object
(
    [message:protected] => SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fedexfreight_account_id' in 'field list'
    [string:Exception:private] => 
    [code:protected] => 42S22
    [file:protected] => /chroot/home/plasticc/plasticcontainercity.com/html/lib/Zend/Db/Statement/Pdo.php
    [line:protected] => 228
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /chroot/home/plasticc/plasticcontainercity.com/html/lib/Zend/Db/Statement/Pdo.php
                    [line] => 228
                    [function] => execute
                    [class] => PDOStatement
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                )

                        )

                )

            [1] => Array
                (
                    [file] => /chroot/home/plasticc/plasticcontainercity.com/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] => /chroot/home/plasticc/plasticcontainercity.com/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] => /chroot/home/plasticc/plasticcontainercity.com/html/lib/Zend/Db/Adapter/Abstract.php
                    [line] => 479
                    [function] => execute
                    [class] => Zend_Db_Statement
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                )

                        )

                )

            [4] => Array
                (
                    [file] => /chroot/home/plasticc/plasticcontainercity.com/html/lib/Zend/Db/Adapter/Pdo/Abstract.php
                    [line] => 238
                    [function] => query
                    [class] => Zend_Db_Adapter_Abstract
                    [type] => ->
                    [args] => Array
                        (
                            [0] => INSERT IGNORE INTO dropship
    (dropship_id,title,description,warehouse_code,status,country,region,zipcode,street,city,email,contact,manualmail,manualship,created_time,update_time,latitude,longitude,ismetapak,geo_address,fedex_account_id,fedexsoap_key,fedexsoap_password,fedexsoap_meter_number,fedexsoap_allowed_methods,ups_password,ups_access_license_number,ups_user_id,ups_shipper_number,ups_shipping_origin,max_package_weight,ups_allowed_methods,ups_unit_of_measure,usps_user_id,usps_password,usps_allowed_methods,fedexfreight_account_id,fedexfreight_key,fedexfreight_password,fedexfreight_meter_number,fedexfreight_street,fedexfreight_city,fedexfreight_zipcode,fedexfreight_state,fedexfreight_country,fedexfreight_freight_role,fedexfreight_payment_type)
    SELECT shipmanager_id,title,description,null,status,country,region,zipcode,street,city,email,contact,null,null,created_time,update_time,latitude,longitude,false,geo_address,fedex_account_id,fedexsoap_key,fedexsoap_password,fedexsoap_meter_number,null,ups_password,ups_access_license_number,ups_user_id,ups_shipper_number,ups_shipping_origin,null,ups_allowed_methods,ups_unit_of_measure,usps_user_id,'',null,fedexfreight_account_id,fedexfreight_key,fedexfreight_password,fedexfreight_meter_number,fedexfreight_street,fedexfreight_city,fedexfreight_zipcode,fedexfreight_state,fedexfreight_country,fedexfreight_freight_role,fedexfreight_payment_type
    FROM shipmanager
                            [1] => Array
                                (
                                )

                        )

                )

            [5] => Array
                (
                    [file] => /chroot/home/plasticc/plasticcontainercity.com/html/lib/Varien/Db/Adapter/Pdo/Mysql.php
                    [line] => 428
                    [function] => query
                    [class] => Zend_Db_Adapter_Pdo_Abstract
                    [type] => ->
                    [args] => Array
                        (
                            [0] => INSERT IGNORE INTO dropship
    (dropship_id,title,description,warehouse_code,status,country,region,zipcode,street,city,email,contact,manualmail,manualship,created_time,update_time,latitude,longitude,ismetapak,geo_address,fedex_account_id,fedexsoap_key,fedexsoap_password,fedexsoap_meter_number,fedexsoap_allowed_methods,ups_password,ups_access_license_number,ups_user_id,ups_shipper_number,ups_shipping_origin,max_package_weight,ups_allowed_methods,ups_unit_of_measure,usps_user_id,usps_password,usps_allowed_methods,fedexfreight_account_id,fedexfreight_key,fedexfreight_password,fedexfreight_meter_number,fedexfreight_street,fedexfreight_city,fedexfreight_zipcode,fedexfreight_state,fedexfreight_country,fedexfreight_freight_role,fedexfreight_payment_type)
    SELECT shipmanager_id,title,description,null,status,country,region,zipcode,street,city,email,contact,null,null,created_time,update_time,latitude,longitude,false,geo_address,fedex_account_id,fedexsoap_key,fedexsoap_password,fedexsoap_meter_number,null,ups_password,ups_access_license_number,ups_user_id,ups_shipper_number,ups_shipping_origin,null,ups_allowed_methods,ups_unit_of_measure,usps_user_id,'',null,fedexfreight_account_id,fedexfreight_key,fedexfreight_password,fedexfreight_meter_number,fedexfreight_street,fedexfreight_city,fedexfreight_zipcode,fedexfreight_state,fedexfreight_country,fedexfreight_freight_role,fedexfreight_payment_type
    FROM shipmanager
                            [1] => Array
                                (
                                )

                        )

                )

            [6] => Array
                (
                    [file] => /chroot/home/plasticc/plasticcontainercity.com/html/lib/Varien/Db/Adapter/Pdo/Mysql.php
                    [line] => 347
                    [function] => query
                    [class] => Varien_Db_Adapter_Pdo_Mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => INSERT IGNORE INTO dropship
    (dropship_id,title,description,warehouse_code,status,country,region,zipcode,street,city,email,contact,manualmail,manualship,created_time,update_time,latitude,longitude,ismetapak,geo_address,fedex_account_id,fedexsoap_key,fedexsoap_password,fedexsoap_meter_number,fedexsoap_allowed_methods,ups_password,ups_access_license_number,ups_user_id,ups_shipper_number,ups_shipping_origin,max_package_weight,ups_allowed_methods,ups_unit_of_measure,usps_user_id,usps_password,usps_allowed_methods,fedexfreight_account_id,fedexfreight_key,fedexfreight_password,fedexfreight_meter_number,fedexfreight_street,fedexfreight_city,fedexfreight_zipcode,fedexfreight_state,fedexfreight_country,fedexfreight_freight_role,fedexfreight_payment_type)
    SELECT shipmanager_id,title,description,null,status,country,region,zipcode,street,city,email,contact,null,null,created_time,update_time,latitude,longitude,false,geo_address,fedex_account_id,fedexsoap_key,fedexsoap_password,fedexsoap_meter_number,null,ups_password,ups_access_license_number,ups_user_id,ups_shipper_number,ups_shipping_origin,null,ups_allowed_methods,ups_unit_of_measure,usps_user_id,'',null,fedexfreight_account_id,fedexfreight_key,fedexfreight_password,fedexfreight_meter_number,fedexfreight_street,fedexfreight_city,fedexfreight_zipcode,fedexfreight_state,fedexfreight_country,fedexfreight_freight_role,fedexfreight_payment_type
    FROM shipmanager
                        )

                )

            [7] => Array
                (
                    [file] => /chroot/home/plasticc/plasticcontainercity.com/html/lib/Varien/Db/Adapter/Pdo/Mysql.php
                    [line] => 617
                    [function] => raw_query
                    [class] => Varien_Db_Adapter_Pdo_Mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => INSERT IGNORE INTO dropship
    (dropship_id,title,description,warehouse_code,status,country,region,zipcode,street,city,email,contact,manualmail,manualship,created_time,update_time,latitude,longitude,ismetapak,geo_address,fedex_account_id,fedexsoap_key,fedexsoap_password,fedexsoap_meter_number,fedexsoap_allowed_methods,ups_password,ups_access_license_number,ups_user_id,ups_shipper_number,ups_shipping_origin,max_package_weight,ups_allowed_methods,ups_unit_of_measure,usps_user_id,usps_password,usps_allowed_methods,fedexfreight_account_id,fedexfreight_key,fedexfreight_password,fedexfreight_meter_number,fedexfreight_street,fedexfreight_city,fedexfreight_zipcode,fedexfreight_state,fedexfreight_country,fedexfreight_freight_role,fedexfreight_payment_type)
    SELECT shipmanager_id,title,description,null,status,country,region,zipcode,street,city,email,contact,null,null,created_time,update_time,latitude,longitude,false,geo_address,fedex_account_id,fedexsoap_key,fedexsoap_password,fedexsoap_meter_number,null,ups_password,ups_access_license_number,ups_user_id,ups_shipper_number,ups_shipping_origin,null,ups_allowed_methods,ups_unit_of_measure,usps_user_id,'',null,fedexfreight_account_id,fedexfreight_key,fedexfreight_password,fedexfreight_meter_number,fedexfreight_street,fedexfreight_city,fedexfreight_zipcode,fedexfreight_state,fedexfreight_country,fedexfreight_freight_role,fedexfreight_payment_type
    FROM shipmanager
                        )

                )

            [8] => Array
                (
                    [file] => /chroot/home/plasticc/plasticcontainercity.com/html/lib/Varien/Db/Adapter/Pdo/Mysql.php
                    [line] => 599
                    [function] => multi_query
                    [class] => Varien_Db_Adapter_Pdo_Mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 

    INSERT IGNORE INTO dropship
    (dropship_id,title,description,warehouse_code,status,country,region,zipcode,street,city,email,contact,manualmail,manualship,created_time,update_time,latitude,longitude,ismetapak,geo_address,fedex_account_id,fedexsoap_key,fedexsoap_password,fedexsoap_meter_number,fedexsoap_allowed_methods,ups_password,ups_access_license_number,ups_user_id,ups_shipper_number,ups_shipping_origin,max_package_weight,ups_allowed_methods,ups_unit_of_measure,usps_user_id,usps_password,usps_allowed_methods,fedexfreight_account_id,fedexfreight_key,fedexfreight_password,fedexfreight_meter_number,fedexfreight_street,fedexfreight_city,fedexfreight_zipcode,fedexfreight_state,fedexfreight_country,fedexfreight_freight_role,fedexfreight_payment_type)
    SELECT shipmanager_id,title,description,null,status,country,region,zipcode,street,city,email,contact,null,null,created_time,update_time,latitude,longitude,false,geo_address,fedex_account_id,fedexsoap_key,fedexsoap_password,fedexsoap_meter_number,null,ups_password,ups_access_license_number,ups_user_id,ups_shipper_number,ups_shipping_origin,null,ups_allowed_methods,ups_unit_of_measure,usps_user_id,'',null,fedexfreight_account_id,fedexfreight_key,fedexfreight_password,fedexfreight_meter_number,fedexfreight_street,fedexfreight_city,fedexfreight_zipcode,fedexfreight_state,fedexfreight_country,fedexfreight_freight_role,fedexfreight_payment_type
    FROM shipmanager;


    INSERT IGNORE INTO dropship_shipping
    (dropship_id,shipping_id)
    SELECT shipmanager_id,shipping_id
    FROM shipmanager_shipping;

    SELECT @entity_type_id:=entity_type_id from eav_entity_type where entity_type_code='catalog_product';
    SELECT @attribute_id:=attribute_id FROM eav_attribute WHERE attribute_code='warehouse' AND eav_attribute.entity_type_id = @entity_type_id;

    UPDATE eav_attribute SET
        backend_model = 'eav/entity_attribute_backend_array',
        frontend_input = 'multiselect',
        backend_type = 'varchar',
        is_required = 0,
        source_model = 'dropcommon/dropship'
    WHERE eav_attribute.attribute_id = @attribute_id;

    INSERT into catalog_product_entity_varchar (entity_type_id, attribute_id, store_id, entity_id, value)
        SELECT entity_type_id, attribute_id, store_id, entity_id, value
        FROM catalog_product_entity_int
        WHERE attribute_id = @attribute_id ;

    DELETE FROM catalog_product_entity_int WHERE attribute_id =  @attribute_id;

                        )

                )

            [9] => Array
                (
                    [file] => /chroot/home/plasticc/plasticcontainercity.com/html/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 933
                    [function] => multiQuery
                    [class] => Varien_Db_Adapter_Pdo_Mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 

    INSERT IGNORE INTO dropship
    (dropship_id,title,description,warehouse_code,status,country,region,zipcode,street,city,email,contact,manualmail,manualship,created_time,update_time,latitude,longitude,ismetapak,geo_address,fedex_account_id,fedexsoap_key,fedexsoap_password,fedexsoap_meter_number,fedexsoap_allowed_methods,ups_password,ups_access_license_number,ups_user_id,ups_shipper_number,ups_shipping_origin,max_package_weight,ups_allowed_methods,ups_unit_of_measure,usps_user_id,usps_password,usps_allowed_methods,fedexfreight_account_id,fedexfreight_key,fedexfreight_password,fedexfreight_meter_number,fedexfreight_street,fedexfreight_city,fedexfreight_zipcode,fedexfreight_state,fedexfreight_country,fedexfreight_freight_role,fedexfreight_payment_type)
    SELECT shipmanager_id,title,description,null,status,country,region,zipcode,street,city,email,contact,null,null,created_time,update_time,latitude,longitude,false,geo_address,fedex_account_id,fedexsoap_key,fedexsoap_password,fedexsoap_meter_number,null,ups_password,ups_access_license_number,ups_user_id,ups_shipper_number,ups_shipping_origin,null,ups_allowed_methods,ups_unit_of_measure,usps_user_id,'',null,fedexfreight_account_id,fedexfreight_key,fedexfreight_password,fedexfreight_meter_number,fedexfreight_street,fedexfreight_city,fedexfreight_zipcode,fedexfreight_state,fedexfreight_country,fedexfreight_freight_role,fedexfreight_payment_type
    FROM shipmanager;


    INSERT IGNORE INTO dropship_shipping
    (dropship_id,shipping_id)
    SELECT shipmanager_id,shipping_id
    FROM shipmanager_shipping;

    SELECT @entity_type_id:=entity_type_id from eav_entity_type where entity_type_code='catalog_product';
    SELECT @attribute_id:=attribute_id FROM eav_attribute WHERE attribute_code='warehouse' AND eav_attribute.entity_type_id = @entity_type_id;

    UPDATE eav_attribute SET
        backend_model = 'eav/entity_attribute_backend_array',
        frontend_input = 'multiselect',
        backend_type = 'varchar',
        is_required = 0,
        source_model = 'dropcommon/dropship'
    WHERE eav_attribute.attribute_id = @attribute_id;

    INSERT into catalog_product_entity_varchar (entity_type_id, attribute_id, store_id, entity_id, value)
        SELECT entity_type_id, attribute_id, store_id, entity_id, value
        FROM catalog_product_entity_int
        WHERE attribute_id = @attribute_id ;

    DELETE FROM catalog_product_entity_int WHERE attribute_id =  @attribute_id;

                        )

                )

            [10] => Array
                (
                    [file] => /chroot/home/plasticc/plasticcontainercity.com/html/app/code/community/Webshopapps/Shipmanager/sql/shipmanager_setup/mysql4-upgrade-1.0.1-2.0.1.php
                    [line] => 45
                    [function] => run
                    [class] => Mage_Core_Model_Resource_Setup
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 

    INSERT IGNORE INTO dropship
    (dropship_id,title,description,warehouse_code,status,country,region,zipcode,street,city,email,contact,manualmail,manualship,created_time,update_time,latitude,longitude,ismetapak,geo_address,fedex_account_id,fedexsoap_key,fedexsoap_password,fedexsoap_meter_number,fedexsoap_allowed_methods,ups_password,ups_access_license_number,ups_user_id,ups_shipper_number,ups_shipping_origin,max_package_weight,ups_allowed_methods,ups_unit_of_measure,usps_user_id,usps_password,usps_allowed_methods,fedexfreight_account_id,fedexfreight_key,fedexfreight_password,fedexfreight_meter_number,fedexfreight_street,fedexfreight_city,fedexfreight_zipcode,fedexfreight_state,fedexfreight_country,fedexfreight_freight_role,fedexfreight_payment_type)
    SELECT shipmanager_id,title,description,null,status,country,region,zipcode,street,city,email,contact,null,null,created_time,update_time,latitude,longitude,false,geo_address,fedex_account_id,fedexsoap_key,fedexsoap_password,fedexsoap_meter_number,null,ups_password,ups_access_license_number,ups_user_id,ups_shipper_number,ups_shipping_origin,null,ups_allowed_methods,ups_unit_of_measure,usps_user_id,'',null,fedexfreight_account_id,fedexfreight_key,fedexfreight_password,fedexfreight_meter_number,fedexfreight_street,fedexfreight_city,fedexfreight_zipcode,fedexfreight_state,fedexfreight_country,fedexfreight_freight_role,fedexfreight_payment_type
    FROM shipmanager;


    INSERT IGNORE INTO dropship_shipping
    (dropship_id,shipping_id)
    SELECT shipmanager_id,shipping_id
    FROM shipmanager_shipping;

    SELECT @entity_type_id:=entity_type_id from eav_entity_type where entity_type_code='catalog_product';
    SELECT @attribute_id:=attribute_id FROM eav_attribute WHERE attribute_code='warehouse' AND eav_attribute.entity_type_id = @entity_type_id;

    UPDATE eav_attribute SET
        backend_model = 'eav/entity_attribute_backend_array',
        frontend_input = 'multiselect',
        backend_type = 'varchar',
        is_required = 0,
        source_model = 'dropcommon/dropship'
    WHERE eav_attribute.attribute_id = @attribute_id;

    INSERT into catalog_product_entity_varchar (entity_type_id, attribute_id, store_id, entity_id, value)
        SELECT entity_type_id, attribute_id, store_id, entity_id, value
        FROM catalog_product_entity_int
        WHERE attribute_id = @attribute_id ;

    DELETE FROM catalog_product_entity_int WHERE attribute_id =  @attribute_id;

                        )

                )

            [11] => Array
                (
                    [file] => /chroot/home/plasticc/plasticcontainercity.com/html/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 624
                    [args] => Array
                        (
                            [0] => /chroot/home/plasticc/plasticcontainercity.com/html/app/code/community/Webshopapps/Shipmanager/sql/shipmanager_setup/mysql4-upgrade-1.0.1-2.0.1.php
                        )

                    [function] => include
                )

            [12] => Array
                (
                    [file] => /chroot/home/plasticc/plasticcontainercity.com/html/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] => 1.0.1
                            [2] => 2.0.1
                        )

                )

            [13] => Array
                (
                    [file] => /chroot/home/plasticc/plasticcontainercity.com/html/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 320
                    [function] => _upgradeResourceDb
                    [class] => Mage_Core_Model_Resource_Setup
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 1.0.1
                            [1] => 2.0.1
                        )

                )

            [14] => Array
                (
                    [file] => /chroot/home/plasticc/plasticcontainercity.com/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] => /chroot/home/plasticc/plasticcontainercity.com/html/app/code/core/Mage/Core/Model/App.php
                    [line] => 417
                    [function] => applyAllUpdates
                    [class] => Mage_Core_Model_Resource_Setup
                    [type] => ::
                    [args] => Array
                        (
                        )

                )

            [16] => Array
                (
                    [file] => /chroot/home/plasticc/plasticcontainercity.com/html/app/code/core/Mage/Core/Model/App.php
                    [line] => 343
                    [function] => _initModules
                    [class] => Mage_Core_Model_App
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [17] => Array
                (
                    [file] => /chroot/home/plasticc/plasticcontainercity.com/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] => /chroot/home/plasticc/plasticcontainercity.com/html/index.php
                    [line] => 95
                    [function] => run
                    [class] => Mage
                    [type] => ::
                    [args] => Array
                        (
                            [0] => 
                            [1] => store
                        )

                )

        )

    [previous:Exception:private] => 
    [errorInfo] => Array
        (
            [0] => 42S22
            [1] => 1054
            [2] => Unknown column 'fedexfreight_account_id' in 'field list'
        )

)