Hi,
when trying to run a fresh install of Magento 1.9.1 on a new created virtual server, the installation fails. See below:
Installation script failed :
Zend_Db_Statement_Exception Object
(
[_previous:Zend_Exception:private] =>
[message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'magento_catalogsearch_query' already exists, query was: CREATE TABLE magento_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_MAGENTO_CATALOGSEARCH_QUERY_QUERY_TEXT_STORE_ID_POPULARITY (query_text, store_id, popularity),
INDEX IDX_MAGENTO_CATALOGSEARCH_QUERY_STORE_ID (store_id),
CONSTRAINT FK_MAGENTO_CATSRCH_QR_STORE_ID_MAGENTO_CORE_STORE_STORE_ID FOREIGN KEY (store_id) REFERENCES magento_core_store (store_id) ON DELETE CASCADE ON UPDATE CASCADE
) COMMENT='Catalog search query table' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
[string:Exception:private] =>
[code:protected] => 42
[file:protected] => /home/verleihnix/public_html/lib/Zend/Db/Statement/Pdo.php
[line:protected] => 235
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /home/verleihnix/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php
[line] => 110
[function] => _execute
[class] => Zend_Db_Statement_Pdo
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[1] => Array
(
[file] => /home/verleihnix/public_html/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] => /home/verleihnix/public_html/lib/Zend/Db/Adapter/Abstract.php
[line] => 480
[function] => execute
[class] => Zend_Db_Statement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[3] => Array
(
[file] => /home/verleihnix/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php
[line] => 238
[function] => query
[class] => Zend_Db_Adapter_Abstract
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `magento_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_MAGENTO_CATALOGSEARCH_QUERY_QUERY_TEXT_STORE_ID_POPULARITY (query_text, store_id, popularity),
INDEX IDX_MAGENTO_CATALOGSEARCH_QUERY_STORE_ID (store_id),
CONSTRAINT FK_MAGENTO_CATSRCH_QR_STORE_ID_MAGENTO_CORE_STORE_STORE_ID FOREIGN KEY (store_id) REFERENCES magento_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] => /home/verleihnix/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 428
[function] => query
[class] => Zend_Db_Adapter_Pdo_Abstract
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `magento_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_MAGENTO_CATALOGSEARCH_QUERY_QUERY_TEXT_STORE_ID_POPULARITY (query_text, store_id, popularity),
INDEX IDX_MAGENTO_CATALOGSEARCH_QUERY_STORE_ID (store_id),
CONSTRAINT FK_MAGENTO_CATSRCH_QR_STORE_ID_MAGENTO_CORE_STORE_STORE_ID FOREIGN KEY (store_id) REFERENCES magento_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] => /home/verleihnix/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 2117
[function] => query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `magento_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_MAGENTO_CATALOGSEARCH_QUERY_QUERY_TEXT_STORE_ID_POPULARITY (query_text, store_id, popularity),
INDEX IDX_MAGENTO_CATALOGSEARCH_QUERY_STORE_ID (store_id),
CONSTRAINT FK_MAGENTO_CATSRCH_QR_STORE_ID_MAGENTO_CORE_STORE_STORE_ID FOREIGN KEY (store_id) REFERENCES magento_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] => /home/verleihnix/public_html/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] => magento_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_MAGENTO_CATALOGSEARCH_QUERY_QUERY_TEXT_STORE_ID_POPULARITY] => Array
(
[INDEX_NAME] => IDX_MAGENTO_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_MAGENTO_CATALOGSEARCH_QUERY_STORE_ID] => Array
(
[INDEX_NAME] => IDX_MAGENTO_CATALOGSEARCH_QUERY_STORE_ID
[COLUMNS] => Array
(
[STORE_ID] => Array
(
[NAME] => store_id
[SIZE] =>
[POSITION] => 0
)
)
[TYPE] => index
)
)
[_foreignKeys:protected] => Array
(
[FK_MAGENTO_CATSRCH_QR_STORE_ID_MAGENTO_CORE_STORE_STORE_ID] => Array
(
[FK_NAME] => FK_MAGENTO_CATSRCH_QR_STORE_ID_MAGENTO_CORE_STORE_STORE_ID
[COLUMN_NAME] => store_id
[REF_TABLE_NAME] => magento_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] => /home/verleihnix/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 624
[args] => Array
(
[0] => /home/verleihnix/public_html/app/code/core/Mage/CatalogSearch/sql/catalogsearch_setup/install-1.6.0.0.php
)
[function] => include
)
[8] => Array
(
[file] => /home/verleihnix/public_html/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.8.2.0
)
)
[9] => Array
(
[file] => /home/verleihnix/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 327
[function] => _installResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => 1.8.2.0
)
)
[10] => Array
(
[file] => /home/verleihnix/public_html/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] => /home/verleihnix/public_html/app/code/core/Mage/Install/Model/Installer.php
[line] => 161
[function] => applyAllUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)
)
[12] => Array
(
[file] => /home/verleihnix/public_html/app/code/core/Mage/Install/Model/Installer/Console.php
[line] => 376
[function] => installDb
[class] => Mage_Install_Model_Installer
[type] => ->
[args] => Array
(
)
)
[13] => Array
(
[file] => /home/verleihnix/public_html/install.php
[line] => 136
[function] => install
[class] => Mage_Install_Model_Installer_Console
[type] => ->
[args] => Array
(
)
)
)
[previous:Exception:private] => PDOException Object
(
[message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'magento_catalogsearch_query' already exists
[string:Exception:private] =>
[code:protected] => 42S01
[file:protected] => /home/verleihnix/public_html/lib/Zend/Db/Statement/Pdo.php
[line:protected] => 228
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /home/verleihnix/public_html/lib/Zend/Db/Statement/Pdo.php
[line] => 228
[function] => execute
[class] => PDOStatement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[1] => Array
(
[file] => /home/verleihnix/public_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] => /home/verleihnix/public_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] => /home/verleihnix/public_html/lib/Zend/Db/Adapter/Abstract.php
[line] => 480
[function] => execute
[class] => Zend_Db_Statement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[4] => Array
(
[file] => /home/verleihnix/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php
[line] => 238
[function] => query
[class] => Zend_Db_Adapter_Abstract
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `magento_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_MAGENTO_CATALOGSEARCH_QUERY_QUERY_TEXT_STORE_ID_POPULARITY (query_text, store_id, popularity),
INDEX IDX_MAGENTO_CATALOGSEARCH_QUERY_STORE_ID (store_id),
CONSTRAINT FK_MAGENTO_CATSRCH_QR_STORE_ID_MAGENTO_CORE_STORE_STORE_ID FOREIGN KEY (store_id) REFERENCES magento_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] => /home/verleihnix/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 428
[function] => query
[class] => Zend_Db_Adapter_Pdo_Abstract
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `magento_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_MAGENTO_CATALOGSEARCH_QUERY_QUERY_TEXT_STORE_ID_POPULARITY (query_text, store_id, popularity),
INDEX IDX_MAGENTO_CATALOGSEARCH_QUERY_STORE_ID (store_id),
CONSTRAINT FK_MAGENTO_CATSRCH_QR_STORE_ID_MAGENTO_CORE_STORE_STORE_ID FOREIGN KEY (store_id) REFERENCES magento_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] => /home/verleihnix/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 2117
[function] => query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `magento_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_MAGENTO_CATALOGSEARCH_QUERY_QUERY_TEXT_STORE_ID_POPULARITY (query_text, store_id, popularity),
INDEX IDX_MAGENTO_CATALOGSEARCH_QUERY_STORE_ID (store_id),
CONSTRAINT FK_MAGENTO_CATSRCH_QR_STORE_ID_MAGENTO_CORE_STORE_STORE_ID FOREIGN KEY (store_id) REFERENCES magento_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] => /home/verleihnix/public_html/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] => magento_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_MAGENTO_CATALOGSEARCH_QUERY_QUERY_TEXT_STORE_ID_POPULARITY] => Array
(
[INDEX_NAME] => IDX_MAGENTO_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_MAGENTO_CATALOGSEARCH_QUERY_STORE_ID] => Array
(
[INDEX_NAME] => IDX_MAGENTO_CATALOGSEARCH_QUERY_STORE_ID
[COLUMNS] => Array
(
[STORE_ID] => Array
(
[NAME] => store_id
[SIZE] =>
[POSITION] => 0
)
)
[TYPE] => index
)
)
[_foreignKeys:protected] => Array
(
[FK_MAGENTO_CATSRCH_QR_STORE_ID_MAGENTO_CORE_STORE_STORE_ID] => Array
(
[FK_NAME] => FK_MAGENTO_CATSRCH_QR_STORE_ID_MAGENTO_CORE_STORE_STORE_ID
[COLUMN_NAME] => store_id
[REF_TABLE_NAME] => magento_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] => /home/verleihnix/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 624
[args] => Array
(
[0] => /home/verleihnix/public_html/app/code/core/Mage/CatalogSearch/sql/catalogsearch_setup/install-1.6.0.0.php
)
[function] => include
)
[9] => Array
(
[file] => /home/verleihnix/public_html/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.8.2.0
)
)
[10] => Array
(
[file] => /home/verleihnix/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 327
[function] => _installResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => 1.8.2.0
)
)
[11] => Array
(
[file] => /home/verleihnix/public_html/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] => /home/verleihnix/public_html/app/code/core/Mage/Install/Model/Installer.php
[line] => 161
[function] => applyAllUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)
)
[13] => Array
(
[file] => /home/verleihnix/public_html/app/code/core/Mage/Install/Model/Installer/Console.php
[line] => 376
[function] => installDb
[class] => Mage_Install_Model_Installer
[type] => ->
[args] => Array
(
)
)
[14] => Array
(
[file] => /home/verleihnix/public_html/install.php
[line] => 136
[function] => install
[class] => Mage_Install_Model_Installer_Console
[type] => ->
[args] => Array
(
)
)
)
[previous:Exception:private] =>
[errorInfo] => Array
(
[0] => 42S01
[1] => 1050
[2] => Table 'magento_catalogsearch_query' already exists
)
)
)
FAILED
ERROR: Error in file: "/home/verleihnix/public_html/app/code/core/Mage/CatalogSearch/sql/catalogsearch_setup/install-1.6.0.0.php" - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'magento_catalogsearch_query' already exists, query was: CREATE TABLE magento_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_MAGENTO_CATALOGSEARCH_QUERY_QUERY_TEXT_STORE_ID_POPULARITY (query_text, store_id, popularity),
INDEX IDX_MAGENTO_CATALOGSEARCH_QUERY_STORE_ID (store_id),
CONSTRAINT FK_MAGENTO_CATSRCH_QR_STORE_ID_MAGENTO_CORE_STORE_STORE_ID FOREIGN KEY (store_id) REFERENCES magento_core_store (store_id) ON DELETE CASCADE ON UPDATE CASCADE
) COMMENT='Catalog search query table' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
Any clue what might be the reason for this?
Best regards, Christian
Howdy,
Is that using the Virtualmin Pro install script, or is it a manual install of Magento?
I see this error in the middle of that output:
Base table or view already existsI know you mentioned this was a newly setup domain, but that error makes it sound like that table already exists in that particular database.
You may want to try creating a new database, and using that new database as a place to install Magento.
-Eric
Hi Eric,
thanks for your feedback!
I tried about everything to get this solved, even created that virtual server as well as the database from scratch and ran the install script for Magento but to no avail. I'm running some 20 domains currently in Virtualmin and 3 of them are running Magento just fine. Installations always went thru like a charm.
This issue came up after the most recent webmin update, not sure if it might be related to it though, as there were several other system updates as well. It's only the Magento installer acting up as I tried others and those were processing just fine.
Best regards, Christian
Howdy,
I'll do some testing to see if I can reproduce that issue... what distro/version is it that you're using there? And just to verify, you're also using the most recent Virtualmin version?
-Eric
Hi,
everything's up-to-date as I check for updates daily.
Operating system CentOS Linux 6.6 Perl version 5.010001 Path to Perl /usr/bin/perl Postfix version 2.6.6 Mail injection command /usr/lib/sendmail -t Apache version 2.2.15 PHP versions 5.3.3, 5.4.38 Webalizer version 2.21-02 Logrotate version 3.7.8 MySQL version 5.1.73 ProFTPd version 1.33 SpamAssassin version 3.3.1 ClamAV version 0.98.6
I tried installing Magneto 1.9.1 on a different virtual host...same thing there. I guess it's the installer script and not related to either PHP version or MySQL as all websites are working fine.
Chris
Howdy,
Hmm, that's very odd! I tested that on a couple of systems here, and it worked properly in each case.
Do you think you could try creating a new test Virtual Server -- you could even name it just "test.com", and install Magento into it?
And then, take the full output that you receive during that installation, and paste it into here.
I'd like to get a better idea of where exactly it's failing, as well as see everything it's doing along the way.
Note that in all the tests I've done so far, I've been using the default options for the Magento Install Script.
Thanks!
-Eric
Hi,
ok, I just tried that and the final result is that it worked...but...
It took a bit over 15 minutes (!!!) to install Magento, which is very odd at all because all previous Magento installations as well as other scripts were installed in lightning speed on my 12 CPU server. So there has to be something wrong here. And I wonder why it "works" with default settings, but when I choose to install it in the parent folder with a "not default setting" fresh created MySQL database it fails...after about 10 minutes or even longer as well...
This drives me nuts...
Chris
Just ran another installation on the regular virtual host with the standard database setting, parent directory and custom user/password and got below error only:
Installation script failed :
FAILED ERROR: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'payment_setup' for key 'PRIMARY', query was: INSERT INTO
magento_core_resource(code,version) VALUES (?, ?)More information on using this script can be found at http://www.magentocommerce.com/.
The "installation" took around 5 minutes now...
What does the install script do before actually installing Magento? In php.ini, etc.? Maybe I should try to run a manual installation to see if that would go thru w/o issues...
Chris
Howdy,
Did you happen to get a copy of the full output of your Magento install? If you could paste in the full output of that installation (not just the error, but everything that the installer outputs), that would be helpful.
As far as what the Install Script does -- I believe it just tries to do what the Magento instructions require, and at a glance I don't see any php.ini files, though you can see the Magento Install Script in /usr/libexec/webmin/virtual-server/scripts/magento.pl in case you wanted to review it further.
-Eric
Sorry, I tried to switch language back to English but somehow it wouldn't do it properly so there's a bit of German in it as well. But I guess you know the usual output and can solve the puzzle. ;)
Installiere Skript
Virtueller Server: verleihnix.club http://www.magentocommerce.com:80/downloads/assets/1.9.1.0/magento-1.9.1... gefunden in Cache ..
Configuring webserver PHP settings .. .. bereits fertig.
Webserver wird neu gestartet .. Bitte überprüfen Sie dies ggfs zusätzlich manuell auf einer Unix-Konsole! ... Fertig!
Installiere jetzt Magento Version 1.9.1.0 ..
.. Installation war nur partiell komplett.
Webserver wird neu gestartet .. Bitte überprüfen Sie dies ggfs zusätzlich manuell auf einer Unix-Konsole! ... Fertig!
Hi Eric,
I just setup a completely new root server with CentOS 7 and a fresh installation of Virtualmin, ran all updates, created the first virtual host "test.com" and started the Magento installation using the install scripts section with default settings.
At first Virtualmin downloaded Magento 1.9.1, installed php-mcrypt as that was missing and then started the Magento installation...and while I'm writing this it's still installing...
Even 5 minutes later it was still installing...
So I doubt it has something to do with any other odd setting or alike on my other server running Virtualmin on CentOS 6.6.
Best regards, Christian