Zend_Db_Statement_Exception Object
(
    [_previous:Zend_Exception:private] => 
    [message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'catalogsearch_query' already exists
    [string:Exception:private] => 
    [code:protected] => 42
    [file:protected] => /var/www/comforium.com/htdocs/lib/Zend/Db/Statement/Pdo.php
    [line:protected] => 234
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /var/www/comforium.com/htdocs/lib/Varien/Db/Statement/Pdo/Mysql.php
                    [line] => 110
                    [function] => _execute
                    [class] => Zend_Db_Statement_Pdo
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                )

                        )

                )

            [1] => Array
                (
                    [file] => /var/www/comforium.com/htdocs/app/code/core/Zend/Db/Statement.php
                    [line] => 291
                    [function] => _execute
                    [class] => Varien_Db_Statement_Pdo_Mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                )

                        )

                )

            [2] => Array
                (
                    [file] => /var/www/comforium.com/htdocs/lib/Zend/Db/Adapter/Abstract.php
                    [line] => 479
                    [function] => execute
                    [class] => Zend_Db_Statement
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                )

                        )

                )

            [3] => Array
                (
                    [file] => /var/www/comforium.com/htdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php
                    [line] => 238
                    [function] => query
                    [class] => Zend_Db_Adapter_Abstract
                    [type] => ->
                    [args] => Array
                        (
                            [0] => CREATE TABLE `catalogsearch_query` (
  `query_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Query ID' ,
  `query_text` varchar(255) NULL COMMENT 'Query text' ,
  `num_results` int UNSIGNED NOT NULL default '0' COMMENT 'Num results' ,
  `popularity` int UNSIGNED NOT NULL default '0' COMMENT 'Popularity' ,
  `redirect` varchar(255) NULL COMMENT 'Redirect' ,
  `synonym_for` varchar(255) NULL COMMENT 'Synonym for' ,
  `store_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Store ID' ,
  `display_in_terms` smallint NOT NULL default '1' COMMENT 'Display in terms' ,
  `is_active` smallint NULL default '1' COMMENT 'Active status' ,
  `is_processed` smallint NULL default '0' COMMENT 'Processed status' ,
  `updated_at` timestamp NOT NULL default 0 COMMENT 'Updated at' ,
  PRIMARY KEY (`query_id`),
  INDEX `IDX_CATALOGSEARCH_QUERY_QUERY_TEXT_STORE_ID_POPULARITY` (`query_text`, `store_id`, `popularity`),
  INDEX `IDX_CATALOGSEARCH_QUERY_STORE_ID` (`store_id`),
  CONSTRAINT `FK_CATALOGSEARCH_QUERY_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE
) COMMENT='Catalog search query table' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
                            [1] => Array
                                (
                                )

                        )

                )

            [4] => Array
                (
                    [file] => /var/www/comforium.com/htdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php
                    [line] => 428
                    [function] => query
                    [class] => Zend_Db_Adapter_Pdo_Abstract
                    [type] => ->
                    [args] => Array
                        (
                            [0] => CREATE TABLE `catalogsearch_query` (
  `query_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Query ID' ,
  `query_text` varchar(255) NULL COMMENT 'Query text' ,
  `num_results` int UNSIGNED NOT NULL default '0' COMMENT 'Num results' ,
  `popularity` int UNSIGNED NOT NULL default '0' COMMENT 'Popularity' ,
  `redirect` varchar(255) NULL COMMENT 'Redirect' ,
  `synonym_for` varchar(255) NULL COMMENT 'Synonym for' ,
  `store_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Store ID' ,
  `display_in_terms` smallint NOT NULL default '1' COMMENT 'Display in terms' ,
  `is_active` smallint NULL default '1' COMMENT 'Active status' ,
  `is_processed` smallint NULL default '0' COMMENT 'Processed status' ,
  `updated_at` timestamp NOT NULL default 0 COMMENT 'Updated at' ,
  PRIMARY KEY (`query_id`),
  INDEX `IDX_CATALOGSEARCH_QUERY_QUERY_TEXT_STORE_ID_POPULARITY` (`query_text`, `store_id`, `popularity`),
  INDEX `IDX_CATALOGSEARCH_QUERY_STORE_ID` (`store_id`),
  CONSTRAINT `FK_CATALOGSEARCH_QUERY_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE
) COMMENT='Catalog search query table' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
                            [1] => Array
                                (
                                )

                        )

                )

            [5] => Array
                (
                    [file] => /var/www/comforium.com/htdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php
                    [line] => 2117
                    [function] => query
                    [class] => Varien_Db_Adapter_Pdo_Mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => CREATE TABLE `catalogsearch_query` (
  `query_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Query ID' ,
  `query_text` varchar(255) NULL COMMENT 'Query text' ,
  `num_results` int UNSIGNED NOT NULL default '0' COMMENT 'Num results' ,
  `popularity` int UNSIGNED NOT NULL default '0' COMMENT 'Popularity' ,
  `redirect` varchar(255) NULL COMMENT 'Redirect' ,
  `synonym_for` varchar(255) NULL COMMENT 'Synonym for' ,
  `store_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Store ID' ,
  `display_in_terms` smallint NOT NULL default '1' COMMENT 'Display in terms' ,
  `is_active` smallint NULL default '1' COMMENT 'Active status' ,
  `is_processed` smallint NULL default '0' COMMENT 'Processed status' ,
  `updated_at` timestamp NOT NULL default 0 COMMENT 'Updated at' ,
  PRIMARY KEY (`query_id`),
  INDEX `IDX_CATALOGSEARCH_QUERY_QUERY_TEXT_STORE_ID_POPULARITY` (`query_text`, `store_id`, `popularity`),
  INDEX `IDX_CATALOGSEARCH_QUERY_STORE_ID` (`store_id`),
  CONSTRAINT `FK_CATALOGSEARCH_QUERY_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE
) COMMENT='Catalog search query table' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
                        )

                )

            [6] => Array
                (
                    [file] => /var/www/comforium.com/htdocs/app/code/core/Mage/CatalogSearch/sql/catalogsearch_setup/install-1.6.0.0.php
                    [line] => 84
                    [function] => createTable
                    [class] => Varien_Db_Adapter_Pdo_Mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Varien_Db_Ddl_Table Object
                                (
                                    [_tableName:protected] => catalogsearch_query
                                    [_schemaName:protected] => 
                                    [_tableComment:protected] => Catalog search query table
                                    [_columns:protected] => Array
                                        (
                                            [QUERY_ID] => Array
                                                (
                                                    [COLUMN_NAME] => query_id
                                                    [COLUMN_TYPE] => integer
                                                    [COLUMN_POSITION] => 0
                                                    [DATA_TYPE] => integer
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 1
                                                    [PRIMARY] => 1
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 1
                                                    [COMMENT] => Query ID
                                                )

                                            [QUERY_TEXT] => Array
                                                (
                                                    [COLUMN_NAME] => query_text
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 1
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 255
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Query text
                                                )

                                            [NUM_RESULTS] => Array
                                                (
                                                    [COLUMN_NAME] => num_results
                                                    [COLUMN_TYPE] => integer
                                                    [COLUMN_POSITION] => 2
                                                    [DATA_TYPE] => integer
                                                    [DEFAULT] => 0
                                                    [NULLABLE] => 
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 1
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Num results
                                                )

                                            [POPULARITY] => Array
                                                (
                                                    [COLUMN_NAME] => popularity
                                                    [COLUMN_TYPE] => integer
                                                    [COLUMN_POSITION] => 3
                                                    [DATA_TYPE] => integer
                                                    [DEFAULT] => 0
                                                    [NULLABLE] => 
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 1
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Popularity
                                                )

                                            [REDIRECT] => Array
                                                (
                                                    [COLUMN_NAME] => redirect
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 4
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 255
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Redirect
                                                )

                                            [SYNONYM_FOR] => Array
                                                (
                                                    [COLUMN_NAME] => synonym_for
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 5
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 255
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Synonym for
                                                )

                                            [STORE_ID] => Array
                                                (
                                                    [COLUMN_NAME] => store_id
                                                    [COLUMN_TYPE] => smallint
                                                    [COLUMN_POSITION] => 6
                                                    [DATA_TYPE] => smallint
                                                    [DEFAULT] => 0
                                                    [NULLABLE] => 
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 1
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Store ID
                                                )

                                            [DISPLAY_IN_TERMS] => Array
                                                (
                                                    [COLUMN_NAME] => display_in_terms
                                                    [COLUMN_TYPE] => smallint
                                                    [COLUMN_POSITION] => 7
                                                    [DATA_TYPE] => smallint
                                                    [DEFAULT] => 1
                                                    [NULLABLE] => 
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Display in terms
                                                )

                                            [IS_ACTIVE] => Array
                                                (
                                                    [COLUMN_NAME] => is_active
                                                    [COLUMN_TYPE] => smallint
                                                    [COLUMN_POSITION] => 8
                                                    [DATA_TYPE] => smallint
                                                    [DEFAULT] => 1
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Active status
                                                )

                                            [IS_PROCESSED] => Array
                                                (
                                                    [COLUMN_NAME] => is_processed
                                                    [COLUMN_TYPE] => smallint
                                                    [COLUMN_POSITION] => 9
                                                    [DATA_TYPE] => smallint
                                                    [DEFAULT] => 0
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Processed status
                                                )

                                            [UPDATED_AT] => Array
                                                (
                                                    [COLUMN_NAME] => updated_at
                                                    [COLUMN_TYPE] => timestamp
                                                    [COLUMN_POSITION] => 10
                                                    [DATA_TYPE] => timestamp
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Updated at
                                                )

                                        )

                                    [_indexes:protected] => Array
                                        (
                                            [IDX_CATALOGSEARCH_QUERY_QUERY_TEXT_STORE_ID_POPULARITY] => Array
                                                (
                                                    [INDEX_NAME] => IDX_CATALOGSEARCH_QUERY_QUERY_TEXT_STORE_ID_POPULARITY
                                                    [COLUMNS] => Array
                                                        (
                                                            [QUERY_TEXT] => Array
                                                                (
                                                                    [NAME] => query_text
                                                                    [SIZE] => 
                                                                    [POSITION] => 0
                                                                )

                                                            [STORE_ID] => Array
                                                                (
                                                                    [NAME] => store_id
                                                                    [SIZE] => 
                                                                    [POSITION] => 1
                                                                )

                                                            [POPULARITY] => Array
                                                                (
                                                                    [NAME] => popularity
                                                                    [SIZE] => 
                                                                    [POSITION] => 2
                                                                )

                                                        )

                                                    [TYPE] => index
                                                )

                                            [IDX_CATALOGSEARCH_QUERY_STORE_ID] => Array
                                                (
                                                    [INDEX_NAME] => IDX_CATALOGSEARCH_QUERY_STORE_ID
                                                    [COLUMNS] => Array
                                                        (
                                                            [STORE_ID] => Array
                                                                (
                                                                    [NAME] => store_id
                                                                    [SIZE] => 
                                                                    [POSITION] => 0
                                                                )

                                                        )

                                                    [TYPE] => index
                                                )

                                        )

                                    [_foreignKeys:protected] => Array
                                        (
                                            [FK_CATALOGSEARCH_QUERY_STORE_ID_CORE_STORE_STORE_ID] => Array
                                                (
                                                    [FK_NAME] => FK_CATALOGSEARCH_QUERY_STORE_ID_CORE_STORE_STORE_ID
                                                    [COLUMN_NAME] => store_id
                                                    [REF_TABLE_NAME] => core_store
                                                    [REF_COLUMN_NAME] => store_id
                                                    [ON_DELETE] => CASCADE
                                                    [ON_UPDATE] => CASCADE
                                                )

                                        )

                                    [_options:protected] => Array
                                        (
                                            [type] => INNODB
                                            [charset] => utf8
                                            [collate] => utf8_general_ci
                                        )

                                )

                        )

                )

            [7] => Array
                (
                    [file] => /var/www/comforium.com/htdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 624
                    [args] => Array
                        (
                            [0] => /var/www/comforium.com/htdocs/app/code/core/Mage/CatalogSearch/sql/catalogsearch_setup/install-1.6.0.0.php
                        )

                    [function] => include
                )

            [8] => Array
                (
                    [file] => /var/www/comforium.com/htdocs/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.6.0.0
                        )

                )

            [9] => Array
                (
                    [file] => /var/www/comforium.com/htdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 327
                    [function] => _installResourceDb
                    [class] => Mage_Core_Model_Resource_Setup
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 1.6.0.0
                        )

                )

            [10] => Array
                (
                    [file] => /var/www/comforium.com/htdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 235
                    [function] => applyUpdates
                    [class] => Mage_Core_Model_Resource_Setup
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [11] => Array
                (
                    [file] => /var/www/comforium.com/htdocs/app/code/core/Mage/Core/Model/App.php
                    [line] => 417
                    [function] => applyAllUpdates
                    [class] => Mage_Core_Model_Resource_Setup
                    [type] => ::
                    [args] => Array
                        (
                        )

                )

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

                )

            [13] => Array
                (
                    [file] => /var/www/comforium.com/htdocs/app/Mage.php
                    [line] => 691
                    [function] => run
                    [class] => Mage_Core_Model_App
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                    [scope_code] => france
                                    [scope_type] => store
                                    [options] => Array
                                        (
                                        )

                                )

                        )

                )

            [14] => Array
                (
                    [file] => /var/www/comforium.com/htdocs/index.php
                    [line] => 104
                    [function] => run
                    [class] => Mage
                    [type] => ::
                    [args] => Array
                        (
                            [0] => france
                            [1] => store
                        )

                )

        )

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

                                )

                        )

                    [1] => Array
                        (
                            [file] => /var/www/comforium.com/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/comforium.com/htdocs/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] => /var/www/comforium.com/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/comforium.com/htdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php
                            [line] => 238
                            [function] => query
                            [class] => Zend_Db_Adapter_Abstract
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => CREATE TABLE `catalogsearch_query` (
  `query_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Query ID' ,
  `query_text` varchar(255) NULL COMMENT 'Query text' ,
  `num_results` int UNSIGNED NOT NULL default '0' COMMENT 'Num results' ,
  `popularity` int UNSIGNED NOT NULL default '0' COMMENT 'Popularity' ,
  `redirect` varchar(255) NULL COMMENT 'Redirect' ,
  `synonym_for` varchar(255) NULL COMMENT 'Synonym for' ,
  `store_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Store ID' ,
  `display_in_terms` smallint NOT NULL default '1' COMMENT 'Display in terms' ,
  `is_active` smallint NULL default '1' COMMENT 'Active status' ,
  `is_processed` smallint NULL default '0' COMMENT 'Processed status' ,
  `updated_at` timestamp NOT NULL default 0 COMMENT 'Updated at' ,
  PRIMARY KEY (`query_id`),
  INDEX `IDX_CATALOGSEARCH_QUERY_QUERY_TEXT_STORE_ID_POPULARITY` (`query_text`, `store_id`, `popularity`),
  INDEX `IDX_CATALOGSEARCH_QUERY_STORE_ID` (`store_id`),
  CONSTRAINT `FK_CATALOGSEARCH_QUERY_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE
) COMMENT='Catalog search query table' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
                                    [1] => Array
                                        (
                                        )

                                )

                        )

                    [5] => Array
                        (
                            [file] => /var/www/comforium.com/htdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php
                            [line] => 428
                            [function] => query
                            [class] => Zend_Db_Adapter_Pdo_Abstract
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => CREATE TABLE `catalogsearch_query` (
  `query_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Query ID' ,
  `query_text` varchar(255) NULL COMMENT 'Query text' ,
  `num_results` int UNSIGNED NOT NULL default '0' COMMENT 'Num results' ,
  `popularity` int UNSIGNED NOT NULL default '0' COMMENT 'Popularity' ,
  `redirect` varchar(255) NULL COMMENT 'Redirect' ,
  `synonym_for` varchar(255) NULL COMMENT 'Synonym for' ,
  `store_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Store ID' ,
  `display_in_terms` smallint NOT NULL default '1' COMMENT 'Display in terms' ,
  `is_active` smallint NULL default '1' COMMENT 'Active status' ,
  `is_processed` smallint NULL default '0' COMMENT 'Processed status' ,
  `updated_at` timestamp NOT NULL default 0 COMMENT 'Updated at' ,
  PRIMARY KEY (`query_id`),
  INDEX `IDX_CATALOGSEARCH_QUERY_QUERY_TEXT_STORE_ID_POPULARITY` (`query_text`, `store_id`, `popularity`),
  INDEX `IDX_CATALOGSEARCH_QUERY_STORE_ID` (`store_id`),
  CONSTRAINT `FK_CATALOGSEARCH_QUERY_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE
) COMMENT='Catalog search query table' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
                                    [1] => Array
                                        (
                                        )

                                )

                        )

                    [6] => Array
                        (
                            [file] => /var/www/comforium.com/htdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php
                            [line] => 2117
                            [function] => query
                            [class] => Varien_Db_Adapter_Pdo_Mysql
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => CREATE TABLE `catalogsearch_query` (
  `query_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Query ID' ,
  `query_text` varchar(255) NULL COMMENT 'Query text' ,
  `num_results` int UNSIGNED NOT NULL default '0' COMMENT 'Num results' ,
  `popularity` int UNSIGNED NOT NULL default '0' COMMENT 'Popularity' ,
  `redirect` varchar(255) NULL COMMENT 'Redirect' ,
  `synonym_for` varchar(255) NULL COMMENT 'Synonym for' ,
  `store_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Store ID' ,
  `display_in_terms` smallint NOT NULL default '1' COMMENT 'Display in terms' ,
  `is_active` smallint NULL default '1' COMMENT 'Active status' ,
  `is_processed` smallint NULL default '0' COMMENT 'Processed status' ,
  `updated_at` timestamp NOT NULL default 0 COMMENT 'Updated at' ,
  PRIMARY KEY (`query_id`),
  INDEX `IDX_CATALOGSEARCH_QUERY_QUERY_TEXT_STORE_ID_POPULARITY` (`query_text`, `store_id`, `popularity`),
  INDEX `IDX_CATALOGSEARCH_QUERY_STORE_ID` (`store_id`),
  CONSTRAINT `FK_CATALOGSEARCH_QUERY_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE
) COMMENT='Catalog search query table' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
                                )

                        )

                    [7] => Array
                        (
                            [file] => /var/www/comforium.com/htdocs/app/code/core/Mage/CatalogSearch/sql/catalogsearch_setup/install-1.6.0.0.php
                            [line] => 84
                            [function] => createTable
                            [class] => Varien_Db_Adapter_Pdo_Mysql
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => Varien_Db_Ddl_Table Object
                                        (
                                            [_tableName:protected] => catalogsearch_query
                                            [_schemaName:protected] => 
                                            [_tableComment:protected] => Catalog search query table
                                            [_columns:protected] => Array
                                                (
                                                    [QUERY_ID] => Array
                                                        (
                                                            [COLUMN_NAME] => query_id
                                                            [COLUMN_TYPE] => integer
                                                            [COLUMN_POSITION] => 0
                                                            [DATA_TYPE] => integer
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 1
                                                            [PRIMARY] => 1
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 1
                                                            [COMMENT] => Query ID
                                                        )

                                                    [QUERY_TEXT] => Array
                                                        (
                                                            [COLUMN_NAME] => query_text
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 1
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 255
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Query text
                                                        )

                                                    [NUM_RESULTS] => Array
                                                        (
                                                            [COLUMN_NAME] => num_results
                                                            [COLUMN_TYPE] => integer
                                                            [COLUMN_POSITION] => 2
                                                            [DATA_TYPE] => integer
                                                            [DEFAULT] => 0
                                                            [NULLABLE] => 
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 1
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Num results
                                                        )

                                                    [POPULARITY] => Array
                                                        (
                                                            [COLUMN_NAME] => popularity
                                                            [COLUMN_TYPE] => integer
                                                            [COLUMN_POSITION] => 3
                                                            [DATA_TYPE] => integer
                                                            [DEFAULT] => 0
                                                            [NULLABLE] => 
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 1
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Popularity
                                                        )

                                                    [REDIRECT] => Array
                                                        (
                                                            [COLUMN_NAME] => redirect
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 4
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 255
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Redirect
                                                        )

                                                    [SYNONYM_FOR] => Array
                                                        (
                                                            [COLUMN_NAME] => synonym_for
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 5
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 255
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Synonym for
                                                        )

                                                    [STORE_ID] => Array
                                                        (
                                                            [COLUMN_NAME] => store_id
                                                            [COLUMN_TYPE] => smallint
                                                            [COLUMN_POSITION] => 6
                                                            [DATA_TYPE] => smallint
                                                            [DEFAULT] => 0
                                                            [NULLABLE] => 
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 1
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Store ID
                                                        )

                                                    [DISPLAY_IN_TERMS] => Array
                                                        (
                                                            [COLUMN_NAME] => display_in_terms
                                                            [COLUMN_TYPE] => smallint
                                                            [COLUMN_POSITION] => 7
                                                            [DATA_TYPE] => smallint
                                                            [DEFAULT] => 1
                                                            [NULLABLE] => 
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Display in terms
                                                        )

                                                    [IS_ACTIVE] => Array
                                                        (
                                                            [COLUMN_NAME] => is_active
                                                            [COLUMN_TYPE] => smallint
                                                            [COLUMN_POSITION] => 8
                                                            [DATA_TYPE] => smallint
                                                            [DEFAULT] => 1
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Active status
                                                        )

                                                    [IS_PROCESSED] => Array
                                                        (
                                                            [COLUMN_NAME] => is_processed
                                                            [COLUMN_TYPE] => smallint
                                                            [COLUMN_POSITION] => 9
                                                            [DATA_TYPE] => smallint
                                                            [DEFAULT] => 0
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Processed status
                                                        )

                                                    [UPDATED_AT] => Array
                                                        (
                                                            [COLUMN_NAME] => updated_at
                                                            [COLUMN_TYPE] => timestamp
                                                            [COLUMN_POSITION] => 10
                                                            [DATA_TYPE] => timestamp
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Updated at
                                                        )

                                                )

                                            [_indexes:protected] => Array
                                                (
                                                    [IDX_CATALOGSEARCH_QUERY_QUERY_TEXT_STORE_ID_POPULARITY] => Array
                                                        (
                                                            [INDEX_NAME] => IDX_CATALOGSEARCH_QUERY_QUERY_TEXT_STORE_ID_POPULARITY
                                                            [COLUMNS] => Array
                                                                (
                                                                    [QUERY_TEXT] => Array
                                                                        (
                                                                            [NAME] => query_text
                                                                            [SIZE] => 
                                                                            [POSITION] => 0
                                                                        )

                                                                    [STORE_ID] => Array
                                                                        (
                                                                            [NAME] => store_id
                                                                            [SIZE] => 
                                                                            [POSITION] => 1
                                                                        )

                                                                    [POPULARITY] => Array
                                                                        (
                                                                            [NAME] => popularity
                                                                            [SIZE] => 
                                                                            [POSITION] => 2
                                                                        )

                                                                )

                                                            [TYPE] => index
                                                        )

                                                    [IDX_CATALOGSEARCH_QUERY_STORE_ID] => Array
                                                        (
                                                            [INDEX_NAME] => IDX_CATALOGSEARCH_QUERY_STORE_ID
                                                            [COLUMNS] => Array
                                                                (
                                                                    [STORE_ID] => Array
                                                                        (
                                                                            [NAME] => store_id
                                                                            [SIZE] => 
                                                                            [POSITION] => 0
                                                                        )

                                                                )

                                                            [TYPE] => index
                                                        )

                                                )

                                            [_foreignKeys:protected] => Array
                                                (
                                                    [FK_CATALOGSEARCH_QUERY_STORE_ID_CORE_STORE_STORE_ID] => Array
                                                        (
                                                            [FK_NAME] => FK_CATALOGSEARCH_QUERY_STORE_ID_CORE_STORE_STORE_ID
                                                            [COLUMN_NAME] => store_id
                                                            [REF_TABLE_NAME] => core_store
                                                            [REF_COLUMN_NAME] => store_id
                                                            [ON_DELETE] => CASCADE
                                                            [ON_UPDATE] => CASCADE
                                                        )

                                                )

                                            [_options:protected] => Array
                                                (
                                                    [type] => INNODB
                                                    [charset] => utf8
                                                    [collate] => utf8_general_ci
                                                )

                                        )

                                )

                        )

                    [8] => Array
                        (
                            [file] => /var/www/comforium.com/htdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
                            [line] => 624
                            [args] => Array
                                (
                                    [0] => /var/www/comforium.com/htdocs/app/code/core/Mage/CatalogSearch/sql/catalogsearch_setup/install-1.6.0.0.php
                                )

                            [function] => include
                        )

                    [9] => Array
                        (
                            [file] => /var/www/comforium.com/htdocs/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.6.0.0
                                )

                        )

                    [10] => Array
                        (
                            [file] => /var/www/comforium.com/htdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
                            [line] => 327
                            [function] => _installResourceDb
                            [class] => Mage_Core_Model_Resource_Setup
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => 1.6.0.0
                                )

                        )

                    [11] => Array
                        (
                            [file] => /var/www/comforium.com/htdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
                            [line] => 235
                            [function] => applyUpdates
                            [class] => Mage_Core_Model_Resource_Setup
                            [type] => ->
                            [args] => Array
                                (
                                )

                        )

                    [12] => Array
                        (
                            [file] => /var/www/comforium.com/htdocs/app/code/core/Mage/Core/Model/App.php
                            [line] => 417
                            [function] => applyAllUpdates
                            [class] => Mage_Core_Model_Resource_Setup
                            [type] => ::
                            [args] => Array
                                (
                                )

                        )

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

                        )

                    [14] => Array
                        (
                            [file] => /var/www/comforium.com/htdocs/app/Mage.php
                            [line] => 691
                            [function] => run
                            [class] => Mage_Core_Model_App
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => Array
                                        (
                                            [scope_code] => france
                                            [scope_type] => store
                                            [options] => Array
                                                (
                                                )

                                        )

                                )

                        )

                    [15] => Array
                        (
                            [file] => /var/www/comforium.com/htdocs/index.php
                            [line] => 104
                            [function] => run
                            [class] => Mage
                            [type] => ::
                            [args] => Array
                                (
                                    [0] => france
                                    [1] => store
                                )

                        )

                )

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

        )

)