Hi Guys,
I have a big issue, basically our server had a kernel panic and had to be rebuilt I have my backup and mySql Backup and I have re created the account on my server, I have uploaded the file backup and imported the database back in but I am getting the following error when trying to visit the site. Can anyone shed some light on what might be going wrong?
Error in file: "/home/das/public_html/OldSite/app/code/core/Mage/Customer/sql/customer_setup/install-1.6.0.0.php" - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'customer_entity' already exists, query was: CREATE TABLE `customer_entity` (
`entity_id` int NOT NULL COMMENT 'Entity Id' ,
`entity_type_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Entity Type Id' ,
`attribute_set_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Attribute Set Id' ,
`website_id` smallint UNSIGNED NULL COMMENT 'Website Id' ,
`email` varchar(255) NULL COMMENT 'Email' ,
`group_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Group Id' ,
`increment_id` varchar(50) NULL COMMENT 'Increment Id' ,
`store_id` smallint UNSIGNED NULL default '0' COMMENT 'Store Id' ,
`created_at` timestamp NOT NULL default 0 COMMENT 'Created At' ,
`updated_at` timestamp NOT NULL default 0 COMMENT 'Updated At' ,
`is_active` smallint UNSIGNED NOT NULL default '1' COMMENT 'Is Active' ,
PRIMARY KEY (`entity_id`),
INDEX `IDX_CUSTOMER_ENTITY_STORE_ID` (`store_id`),
INDEX `IDX_CUSTOMER_ENTITY_ENTITY_TYPE_ID` (`entity_type_id`),
INDEX `IDX_CUSTOMER_ENTITY_EMAIL_WEBSITE_ID` (`email`, `website_id`),
INDEX `IDX_CUSTOMER_ENTITY_WEBSITE_ID` (`website_id`),
CONSTRAINT `FK_CUSTOMER_ENTITY_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `FK_CUSTOMER_ENTITY_WEBSITE_ID_CORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE SET NULL ON UPDATE CASCADE
) COMMENT='Customer Entity' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
Trace:
#0 /home/das/public_html/OldSite/app/code/core/Mage/Core/Model/Resource/Setup.php(644): Mage::exception('Mage_Core', 'Error in file: ...')
#1 /home/das/public_html/OldSite/app/code/core/Mage/Core/Model/Resource/Setup.php(421): Mage_Core_Model_Resource_Setup->_modifyResourceDb('install', '', '1.6.2.0.4')
#2 /home/das/public_html/OldSite/app/code/core/Mage/Core/Model/Resource/Setup.php(327): Mage_Core_Model_Resource_Setup->_installResourceDb('1.6.2.0.4')
#3 /home/das/public_html/OldSite/app/code/core/Mage/Core/Model/Resource/Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /home/das/public_html/OldSite/app/code/core/Mage/Core/Model/App.php(428): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /home/das/public_html/OldSite/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Model_App->_initModules()
#6 /home/das/public_html/OldSite/app/Mage.php(684): Mage_Core_Model_App->run(Array)
