Magento Forum

DB Error of Innodb
 
anandnadaar
Jr. Member
 
Total Posts:  7
Joined:  2011-11-02
 

Hi,

I am getting this pathetic error on my site - www.dailybodycare.com

Can someone please on what needs to be done ?

I was getting ENGINE=INNODB not found error.. so I Googled and found that if you delete 3 files from - VAR/Lib/Mysql -
ib_logfile1
ib_logfile0
ibdata1

So I deleted them and restarted mysql . and now some other error is occurring which even Google has no solution to.

PLEASE HELP!!!

 
Magento Community Magento Community
Magento Community
Magento Community
 
chiefair
Mentor
 
Avatar
Total Posts:  1848
Joined:  2009-06-04
 

So, what’s the some other error that has resulted from removing the transaction logs and the InnoDB table store?

 
Magento Community Magento Community
Magento Community
Magento Community
 
anandnadaar
Jr. Member
 
Total Posts:  7
Joined:  2011-11-02
 

Hey,
I am sorry but the link I placed here was to check for the error since the error is a huge list.

Anyways for the reference here I have quoted the error below..  Please HELP.. it is really frustrating and sad I am not able to solve it.

Zend_Db_Statement_Exception Object
(
[_previous:Zend_Exception:private] =>
[message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘core_resource’ already exists
[string:Exception:private] =>
[code:protected] => 42
[file:protected] => /home/kreation/public_html/lib/Zend/Db/Statement/Pdo.php
[line:protected] => 234
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /home/kreation/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/kreation/public_html/lib/Zend/Db/Statement.php
[line] => 300
[function] => _execute
[class] => Varien_Db_Statement_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => Array
(
)

)

)

[2] => Array
(
[file] => /home/kreation/public_html/lib/Zend/Db/Adapter/Abstract.php
[line] => 479
[function] => execute
[class] => Zend_Db_Statement
[type] => ->
[args] => Array
(
[0] => Array
(
)

)

)

[3] => Array
(
[file] => /home/kreation/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php
[line] => 238
[function] => query
[class] => Zend_Db_Adapter_Abstract
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `core_resource` (
`code` varchar(50) NOT NULL COMMENT ‘Resource Code’,
`version` varchar(50) NULL COMMENT ‘Resource Version’,
`data_version` varchar(50) NULL COMMENT ‘Data Version’,
PRIMARY KEY (`code`)
) COMMENT=’Resources’ ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
[1] => Array
(
)

)

)

[4] => Array
(
[file] => /home/kreation/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 419
[function] => query
[class] => Zend_Db_Adapter_Pdo_Abstract
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `core_resource` (
`code` varchar(50) NOT NULL COMMENT ‘Resource Code’,
`version` varchar(50) NULL COMMENT ‘Resource Version’,
`data_version` varchar(50) NULL COMMENT ‘Data Version’,
PRIMARY KEY (`code`)
) COMMENT=’Resources’ ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
[1] => Array
(
)

)

)

[5] => Array
(
[file] => /home/kreation/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 2039
[function] => query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `core_resource` (
`code` varchar(50) NOT NULL COMMENT ‘Resource Code’,
`version` varchar(50) NULL COMMENT ‘Resource Version’,
`data_version` varchar(50) NULL COMMENT ‘Data Version’,
PRIMARY KEY (`code`)
) COMMENT=’Resources’ ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
)

)

[6] => Array
(
[file] => /home/kreation/public_html/app/code/core/Mage/Core/sql/core_setup/install-1.6.0.0.php
[line] => 47
[function] => createTable
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => Varien_Db_Ddl_Table Object
(
[_tableName:protected] => core_resource
[_schemaName:protected] =>
[_tableComment:protected] => Resources
[_columns:protected] => Array
(
[CODE] => Array
(
[COLUMN_NAME] => code
[COLUMN_TYPE] => text
[COLUMN_POSITION] => 0
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] =>
[LENGTH] => 50
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] => 1
[PRIMARY_POSITION] => 0
[IDENTITY] =>
[COMMENT] => Resource Code
)

[VERSION] => Array
(
[COLUMN_NAME] => version
[COLUMN_TYPE] => text
[COLUMN_POSITION] => 1
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => 50
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] => 0
[IDENTITY] =>
[COMMENT] => Resource Version
)

[DATA_VERSION] => Array
(
[COLUMN_NAME] => data_version
[COLUMN_TYPE] => text
[COLUMN_POSITION] => 2
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => 50
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] => 0
[IDENTITY] =>
[COMMENT] => Data Version
)

)

[_indexes:protected] => Array
(
)

[_foreignKeys:protected] => Array
(
)

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

)

)

)

[7] => Array
(
[file] => /home/kreation/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 624
[args] => Array
(
[0] => /home/kreation/public_html/app/code/core/Mage/Core/sql/core_setup/install-1.6.0.0.php
)

[function] => include
)

[8] => Array
(
[file] => /home/kreation/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.6.0.2
)

)

[9] => Array
(
[file] => /home/kreation/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.6.0.2
)

)

[10] => Array
(
[file] => /home/kreation/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/kreation/public_html/app/code/core/Mage/Core/Model/App.php
[line] => 417
[function] => applyAllUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)

)

[12] => Array
(
[file] => /home/kreation/public_html/app/code/core/Mage/Core/Model/App.php
[line] => 343
[function] => _initModules
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
)

)

[13] => Array
(
[file] => /home/kreation/public_html/app/Mage.php
[line] => 683
[function] => run
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
[0] => Array
(
[scope_code] =>
[scope_type] => store
[options] => Array
(
)

)

)

)

[14] => Array
(
[file] => /home/kreation/public_html/index.php
[line] => 88
[function] => run
[class] => Mage
[type] => ::
[args] => Array
(
[0] =>
[1] => store
)

)

)

[previous:Exception:private] => PDOException Object
(
[message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘core_resource’ already exists
[string:Exception:private] =>
[code:protected] => 42S01
[file:protected] => /home/kreation/public_html/lib/Zend/Db/Statement/Pdo.php
[line:protected] => 228
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /home/kreation/public_html/lib/Zend/Db/Statement/Pdo.php
[line] => 228
[function] => execute
[class] => PDOStatement
[type] => ->
[args] => Array
(
[0] => Array
(
)

)

)

[1] => Array
(
[file] => /home/kreation/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/kreation/public_html/lib/Zend/Db/Statement.php
[line] => 300
[function] => _execute
[class] => Varien_Db_Statement_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => Array
(
)

)

)

[3] => Array
(
[file] => /home/kreation/public_html/lib/Zend/Db/Adapter/Abstract.php
[line] => 479
[function] => execute
[class] => Zend_Db_Statement
[type] => ->
[args] => Array
(
[0] => Array
(
)

)

)

[4] => Array
(
[file] => /home/kreation/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php
[line] => 238
[function] => query
[class] => Zend_Db_Adapter_Abstract
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `core_resource` (
`code` varchar(50) NOT NULL COMMENT ‘Resource Code’,
`version` varchar(50) NULL COMMENT ‘Resource Version’,
`data_version` varchar(50) NULL COMMENT ‘Data Version’,
PRIMARY KEY (`code`)
) COMMENT=’Resources’ ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
[1] => Array
(
)

)

)

[5] => Array
(
[file] => /home/kreation/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 419
[function] => query
[class] => Zend_Db_Adapter_Pdo_Abstract
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `core_resource` (
`code` varchar(50) NOT NULL COMMENT ‘Resource Code’,
`version` varchar(50) NULL COMMENT ‘Resource Version’,
`data_version` varchar(50) NULL COMMENT ‘Data Version’,
PRIMARY KEY (`code`)
) COMMENT=’Resources’ ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
[1] => Array
(
)

)

)

[6] => Array
(
[file] => /home/kreation/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 2039
[function] => query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `core_resource` (
`code` varchar(50) NOT NULL COMMENT ‘Resource Code’,
`version` varchar(50) NULL COMMENT ‘Resource Version’,
`data_version` varchar(50) NULL COMMENT ‘Data Version’,
PRIMARY KEY (`code`)
) COMMENT=’Resources’ ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
)

)

[7] => Array
(
[file] => /home/kreation/public_html/app/code/core/Mage/Core/sql/core_setup/install-1.6.0.0.php
[line] => 47
[function] => createTable
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => Varien_Db_Ddl_Table Object
(
[_tableName:protected] => core_resource
[_schemaName:protected] =>
[_tableComment:protected] => Resources
[_columns:protected] => Array
(
[CODE] => Array
(
[COLUMN_NAME] => code
[COLUMN_TYPE] => text
[COLUMN_POSITION] => 0
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] =>
[LENGTH] => 50
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] => 1
[PRIMARY_POSITION] => 0
[IDENTITY] =>
[COMMENT] => Resource Code
)

[VERSION] => Array
(
[COLUMN_NAME] => version
[COLUMN_TYPE] => text
[COLUMN_POSITION] => 1
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => 50
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] => 0
[IDENTITY] =>
[COMMENT] => Resource Version
)

[DATA_VERSION] => Array
(
[COLUMN_NAME] => data_version
[COLUMN_TYPE] => text
[COLUMN_POSITION] => 2
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => 50
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] => 0
[IDENTITY] =>
[COMMENT] => Data Version
)

)

[_indexes:protected] => Array
(
)

[_foreignKeys:protected] => Array
(
)

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

)

)

)

[8] => Array
(
[file] => /home/kreation/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 624
[args] => Array
(
[0] => /home/kreation/public_html/app/code/core/Mage/Core/sql/core_setup/install-1.6.0.0.php
)

[function] => include
)

[9] => Array
(
[file] => /home/kreation/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.6.0.2
)

)

[10] => Array
(
[file] => /home/kreation/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.6.0.2
)

)

[11] => Array
(
[file] => /home/kreation/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/kreation/public_html/app/code/core/Mage/Core/Model/App.php
[line] => 417
[function] => applyAllUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)

)

[13] => Array
(
[file] => /home/kreation/public_html/app/code/core/Mage/Core/Model/App.php
[line] => 343
[function] => _initModules
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
)

)

[14] => Array
(
[file] => /home/kreation/public_html/app/Mage.php
[line] => 683
[function] => run
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
[0] => Array
(
[scope_code] =>
[scope_type] => store
[options] => Array
(
)

)

)

)

[15] => Array
(
[file] => /home/kreation/public_html/index.php
[line] => 88
[function] => run
[class] => Mage
[type] => ::
[args] => Array
(
[0] =>
[1] => store
)

)

)

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

)

)

Magento Commerce
There has been an error processing your request

Error in file: “/home/kreation/public_html/app/code/core/Mage/Core/sql/core_setup/install-1.6.0.0.php” - SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘core_resource’ already exists

Trace:
#0 /home/kreation/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(645): Mage::exception(’Mage_Core’, ‘Error in file: ...’)
#1 /home/kreation/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(421): Mage_Core_Model_Resource_Setup->_modifyResourceDb(’install’, ‘’, ‘1.6.0.2’)
#2 /home/kreation/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(327): Mage_Core_Model_Resource_Setup->_installResourceDb(’1.6.0.2’)
#3 /home/kreation/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /home/kreation/public_html/app/code/core/Mage/Core/Model/App.php(417): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /home/kreation/public_html/app/code/core/Mage/Core/Model/App.php(343): Mage_Core_Model_App->_initModules()
#6 /home/kreation/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#7 /home/kreation/public_html/index.php(88): Mage::run(’’, ‘store’)
#8 {main}

Error log record number: 1311072745487
Magento is a trademark of Magento Inc. Copyright © 2012 Magento Inc.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top