PDOException Object
(
    [message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'storepickup_location' already exists
    [string:Exception:private] => 
    [code:protected] => 42S01
    [file:protected] => /var/www/sites/rickys/lib/Zend/Db/Statement/Pdo.php
    [line:protected] => 228
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /var/www/sites/rickys/lib/Zend/Db/Statement/Pdo.php
                    [line] => 228
                    [function] => execute
                    [class] => PDOStatement
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                )

                        )

                )

            [1] => Array
                (
                    [file] => /var/www/sites/rickys/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/sites/rickys/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/sites/rickys/lib/Zend/Db/Adapter/Abstract.php
                    [line] => 479
                    [function] => execute
                    [class] => Zend_Db_Statement
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                )

                        )

                )

            [4] => Array
                (
                    [file] => /var/www/sites/rickys/lib/Zend/Db/Adapter/Pdo/Abstract.php
                    [line] => 238
                    [function] => query
                    [class] => Zend_Db_Adapter_Abstract
                    [type] => ->
                    [args] => Array
                        (
                            [0] => CREATE TABLE storepickup_location (
`location_id` INT( 10 ) unsigned NOT NULL AUTO_INCREMENT,
`name` VARCHAR( 255 ) NOT NULL ,
`type` VARCHAR( 10 ) NOT NULL ,
`parent_id` VARCHAR( 10 ) NOT NULL ,
`status` TINYINT( 1 ) NOT NULL ,
`description` TEXT NOT NULL,
PRIMARY KEY  (`location_id`)
)
                            [1] => Array
                                (
                                )

                        )

                )

            [5] => Array
                (
                    [file] => /var/www/sites/rickys/lib/Varien/Db/Adapter/Pdo/Mysql.php
                    [line] => 419
                    [function] => query
                    [class] => Zend_Db_Adapter_Pdo_Abstract
                    [type] => ->
                    [args] => Array
                        (
                            [0] => CREATE TABLE storepickup_location (
`location_id` INT( 10 ) unsigned NOT NULL AUTO_INCREMENT,
`name` VARCHAR( 255 ) NOT NULL ,
`type` VARCHAR( 10 ) NOT NULL ,
`parent_id` VARCHAR( 10 ) NOT NULL ,
`status` TINYINT( 1 ) NOT NULL ,
`description` TEXT NOT NULL,
PRIMARY KEY  (`location_id`)
)
                            [1] => Array
                                (
                                )

                        )

                )

            [6] => Array
                (
                    [file] => /var/www/sites/rickys/lib/Varien/Db/Adapter/Pdo/Mysql.php
                    [line] => 340
                    [function] => query
                    [class] => Varien_Db_Adapter_Pdo_Mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => CREATE TABLE storepickup_location (
`location_id` INT( 10 ) unsigned NOT NULL AUTO_INCREMENT,
`name` VARCHAR( 255 ) NOT NULL ,
`type` VARCHAR( 10 ) NOT NULL ,
`parent_id` VARCHAR( 10 ) NOT NULL ,
`status` TINYINT( 1 ) NOT NULL ,
`description` TEXT NOT NULL,
PRIMARY KEY  (`location_id`)
)
                        )

                )

            [7] => Array
                (
                    [file] => /var/www/sites/rickys/lib/Varien/Db/Adapter/Pdo/Mysql.php
                    [line] => 608
                    [function] => raw_query
                    [class] => Varien_Db_Adapter_Pdo_Mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => CREATE TABLE storepickup_location (
`location_id` INT( 10 ) unsigned NOT NULL AUTO_INCREMENT,
`name` VARCHAR( 255 ) NOT NULL ,
`type` VARCHAR( 10 ) NOT NULL ,
`parent_id` VARCHAR( 10 ) NOT NULL ,
`status` TINYINT( 1 ) NOT NULL ,
`description` TEXT NOT NULL,
PRIMARY KEY  (`location_id`)
)
                        )

                )

            [8] => Array
                (
                    [file] => /var/www/sites/rickys/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 storepickup_order;
DROP TABLE IF EXISTS storepickup_location;
DROP TABLE IF EXISTS storepickup_holiday;
DROP TABLE IF EXISTS storepickup_store;

CREATE TABLE storepickup_order  (
  `storeorder_id` int(11) NOT NULL auto_increment,
  `order_id` int(11) NOT NULL default '0',
  `store_id` int(11) NOT NULL default '0',
  `shipping_date` date NOT NULL,
  `shipping_time` time NULL,
  PRIMARY KEY  (`storeorder_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

CREATE TABLE storepickup_holiday  (
  `holiday_id` int(11) NOT NULL auto_increment,
  `store_id` int(11) NOT NULL default '0',
  `date` date NOT NULL,
  `comment` varchar(255) default NULL,
  PRIMARY KEY  (`holiday_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

CREATE TABLE storepickup_store (
  `store_id` int(11) unsigned NOT NULL auto_increment,
  `store_name` varchar(255) NOT NULL,
  `store_manager` varchar(255) NOT NULL,
  `store_email` varchar(255) NOT NULL,
  `store_phone` varchar(20) NOT NULL,
  `store_fax` varchar(20) NOT NULL,
  `description` text NOT NULL,
  `status` smallint(6) NOT NULL default '0',
  `address` text NOT NULL,
  `address_2` text NOT NULL,
  `state` varchar(255) NOT NULL,
  `suburb` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `region_id` INT( 10 ) UNSIGNED NOT NULL,
  `city_id` INT( 10 ) UNSIGNED NOT NULL,
  `suburb_id` INT( 10 ) UNSIGNED NOT NULL,  
  `zipcode` varchar(255) NOT NULL,
  `state_id` int(11) NOT NULL,
  `country` varchar(255) NOT NULL,
  `store_latitude` varchar(20) NOT NULL,
  `store_longitude` varchar(20) NOT NULL,
  `monday_open` varchar(5) NOT NULL,
  `monday_close` varchar(5) NOT NULL,
  `tuesday_open` varchar(5) NOT NULL,
  `tuesday_close` varchar(5) NOT NULL,
  `wednesday_open` varchar(5) NOT NULL,
  `wednesday_close` varchar(5) NOT NULL,
  `thursday_open` varchar(5) NOT NULL,
  `thursday_close` varchar(5) NOT NULL,
  `friday_open` varchar(5) NOT NULL,
  `friday_close` varchar(5) NOT NULL,
  `saturday_open` varchar(5) NOT NULL,
  `saturday_close` varchar(5) NOT NULL,
  `sunday_open` varchar(5) NOT NULL,
  `sunday_close` varchar(5) NOT NULL,
  `minimum_gap` int(11) NOT NULL default '45',
  PRIMARY KEY  (`store_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

CREATE TABLE storepickup_location (
`location_id` INT( 10 ) unsigned NOT NULL AUTO_INCREMENT,
`name` VARCHAR( 255 ) NOT NULL ,
`type` VARCHAR( 10 ) NOT NULL ,
`parent_id` VARCHAR( 10 ) NOT NULL ,
`status` TINYINT( 1 ) NOT NULL ,
`description` TEXT NOT NULL,
PRIMARY KEY  (`location_id`)
);


                        )

                )

            [9] => Array
                (
                    [file] => /var/www/sites/rickys/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 storepickup_order;
DROP TABLE IF EXISTS storepickup_location;
DROP TABLE IF EXISTS storepickup_holiday;
DROP TABLE IF EXISTS storepickup_store;

CREATE TABLE storepickup_order  (
  `storeorder_id` int(11) NOT NULL auto_increment,
  `order_id` int(11) NOT NULL default '0',
  `store_id` int(11) NOT NULL default '0',
  `shipping_date` date NOT NULL,
  `shipping_time` time NULL,
  PRIMARY KEY  (`storeorder_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

CREATE TABLE storepickup_holiday  (
  `holiday_id` int(11) NOT NULL auto_increment,
  `store_id` int(11) NOT NULL default '0',
  `date` date NOT NULL,
  `comment` varchar(255) default NULL,
  PRIMARY KEY  (`holiday_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

CREATE TABLE storepickup_store (
  `store_id` int(11) unsigned NOT NULL auto_increment,
  `store_name` varchar(255) NOT NULL,
  `store_manager` varchar(255) NOT NULL,
  `store_email` varchar(255) NOT NULL,
  `store_phone` varchar(20) NOT NULL,
  `store_fax` varchar(20) NOT NULL,
  `description` text NOT NULL,
  `status` smallint(6) NOT NULL default '0',
  `address` text NOT NULL,
  `address_2` text NOT NULL,
  `state` varchar(255) NOT NULL,
  `suburb` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `region_id` INT( 10 ) UNSIGNED NOT NULL,
  `city_id` INT( 10 ) UNSIGNED NOT NULL,
  `suburb_id` INT( 10 ) UNSIGNED NOT NULL,  
  `zipcode` varchar(255) NOT NULL,
  `state_id` int(11) NOT NULL,
  `country` varchar(255) NOT NULL,
  `store_latitude` varchar(20) NOT NULL,
  `store_longitude` varchar(20) NOT NULL,
  `monday_open` varchar(5) NOT NULL,
  `monday_close` varchar(5) NOT NULL,
  `tuesday_open` varchar(5) NOT NULL,
  `tuesday_close` varchar(5) NOT NULL,
  `wednesday_open` varchar(5) NOT NULL,
  `wednesday_close` varchar(5) NOT NULL,
  `thursday_open` varchar(5) NOT NULL,
  `thursday_close` varchar(5) NOT NULL,
  `friday_open` varchar(5) NOT NULL,
  `friday_close` varchar(5) NOT NULL,
  `saturday_open` varchar(5) NOT NULL,
  `saturday_close` varchar(5) NOT NULL,
  `sunday_open` varchar(5) NOT NULL,
  `sunday_close` varchar(5) NOT NULL,
  `minimum_gap` int(11) NOT NULL default '45',
  PRIMARY KEY  (`store_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

CREATE TABLE storepickup_location (
`location_id` INT( 10 ) unsigned NOT NULL AUTO_INCREMENT,
`name` VARCHAR( 255 ) NOT NULL ,
`type` VARCHAR( 10 ) NOT NULL ,
`parent_id` VARCHAR( 10 ) NOT NULL ,
`status` TINYINT( 1 ) NOT NULL ,
`description` TEXT NOT NULL,
PRIMARY KEY  (`location_id`)
);


                        )

                )

            [10] => Array
                (
                    [file] => /var/www/sites/rickys/app/code/local/Magestore/Storepickup/sql/storepickup_setup/mysql4-install-0.2.0.php
                    [line] => 81
                    [function] => run
                    [class] => Mage_Core_Model_Resource_Setup
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 

DROP TABLE IF EXISTS storepickup_order;
DROP TABLE IF EXISTS storepickup_location;
DROP TABLE IF EXISTS storepickup_holiday;
DROP TABLE IF EXISTS storepickup_store;

CREATE TABLE storepickup_order  (
  `storeorder_id` int(11) NOT NULL auto_increment,
  `order_id` int(11) NOT NULL default '0',
  `store_id` int(11) NOT NULL default '0',
  `shipping_date` date NOT NULL,
  `shipping_time` time NULL,
  PRIMARY KEY  (`storeorder_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

CREATE TABLE storepickup_holiday  (
  `holiday_id` int(11) NOT NULL auto_increment,
  `store_id` int(11) NOT NULL default '0',
  `date` date NOT NULL,
  `comment` varchar(255) default NULL,
  PRIMARY KEY  (`holiday_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

CREATE TABLE storepickup_store (
  `store_id` int(11) unsigned NOT NULL auto_increment,
  `store_name` varchar(255) NOT NULL,
  `store_manager` varchar(255) NOT NULL,
  `store_email` varchar(255) NOT NULL,
  `store_phone` varchar(20) NOT NULL,
  `store_fax` varchar(20) NOT NULL,
  `description` text NOT NULL,
  `status` smallint(6) NOT NULL default '0',
  `address` text NOT NULL,
  `address_2` text NOT NULL,
  `state` varchar(255) NOT NULL,
  `suburb` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `region_id` INT( 10 ) UNSIGNED NOT NULL,
  `city_id` INT( 10 ) UNSIGNED NOT NULL,
  `suburb_id` INT( 10 ) UNSIGNED NOT NULL,  
  `zipcode` varchar(255) NOT NULL,
  `state_id` int(11) NOT NULL,
  `country` varchar(255) NOT NULL,
  `store_latitude` varchar(20) NOT NULL,
  `store_longitude` varchar(20) NOT NULL,
  `monday_open` varchar(5) NOT NULL,
  `monday_close` varchar(5) NOT NULL,
  `tuesday_open` varchar(5) NOT NULL,
  `tuesday_close` varchar(5) NOT NULL,
  `wednesday_open` varchar(5) NOT NULL,
  `wednesday_close` varchar(5) NOT NULL,
  `thursday_open` varchar(5) NOT NULL,
  `thursday_close` varchar(5) NOT NULL,
  `friday_open` varchar(5) NOT NULL,
  `friday_close` varchar(5) NOT NULL,
  `saturday_open` varchar(5) NOT NULL,
  `saturday_close` varchar(5) NOT NULL,
  `sunday_open` varchar(5) NOT NULL,
  `sunday_close` varchar(5) NOT NULL,
  `minimum_gap` int(11) NOT NULL default '45',
  PRIMARY KEY  (`store_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

CREATE TABLE storepickup_location (
`location_id` INT( 10 ) unsigned NOT NULL AUTO_INCREMENT,
`name` VARCHAR( 255 ) NOT NULL ,
`type` VARCHAR( 10 ) NOT NULL ,
`parent_id` VARCHAR( 10 ) NOT NULL ,
`status` TINYINT( 1 ) NOT NULL ,
`description` TEXT NOT NULL,
PRIMARY KEY  (`location_id`)
);


                        )

                )

            [11] => Array
                (
                    [file] => /var/www/sites/rickys/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 624
                    [args] => Array
                        (
                            [0] => /var/www/sites/rickys/app/code/local/Magestore/Storepickup/sql/storepickup_setup/mysql4-install-0.2.0.php
                        )

                    [function] => include
                )

            [12] => Array
                (
                    [file] => /var/www/sites/rickys/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] => 0.4.0
                        )

                )

            [13] => Array
                (
                    [file] => /var/www/sites/rickys/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 327
                    [function] => _installResourceDb
                    [class] => Mage_Core_Model_Resource_Setup
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 0.4.0
                        )

                )

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

                )

            [16] => Array
                (
                    [file] => /var/www/sites/rickys/app/code/core/Mage/Core/Model/App.php
                    [line] => 343
                    [function] => _initModules
                    [class] => Mage_Core_Model_App
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [17] => Array
                (
                    [file] => /var/www/sites/rickys/app/Mage.php
                    [line] => 683
                    [function] => run
                    [class] => Mage_Core_Model_App
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                    [scope_code] => base
                                    [scope_type] => website
                                    [options] => Array
                                        (
                                        )

                                )

                        )

                )

            [18] => Array
                (
                    [file] => /var/www/sites/rickys/index.php
                    [line] => 87
                    [function] => run
                    [class] => Mage
                    [type] => ::
                    [args] => Array
                        (
                            [0] => base
                            [1] => website
                        )

                )

        )

    [previous:Exception:private] => 
    [errorInfo] => Array
        (
            [0] => 42S01
            [1] => 1050
            [2] => Table 'storepickup_location' already exists
        )

)