cancel
Showing results for 
Search instead for 
Did you mean: 

New 1.9.2.4 installation

New 1.9.2.4 installation

Hi

 

i am trying to install magento 1.9.2.4 and have come up against the following error.

 

========================

 

 

Error in file: "/var/www/vhosts/mydomain.agency/uk.mydomain.agency/app/code/core/Mage/Weee/sql/weee_setup/install-1.6.0.0.php" - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'weee_tax' already exists, query was: CREATE TABLE `weee_tax` (
  `value_id` int NOT NULL auto_increment COMMENT 'Value Id' ,
  `website_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Website Id' ,
  `entity_id` int UNSIGNED NOT NULL default '0' COMMENT 'Entity Id' ,
  `country` varchar(2) NULL COMMENT 'Country' ,
  `value` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Value' ,
  `state` varchar(255) NOT NULL default '*' COMMENT 'State' ,
  `attribute_id` smallint UNSIGNED NOT NULL COMMENT 'Attribute Id' ,
  `entity_type_id` smallint UNSIGNED NOT NULL COMMENT 'Entity Type Id' ,
  PRIMARY KEY (`value_id`),
  INDEX `IDX_WEEE_TAX_WEBSITE_ID` (`website_id`),
  INDEX `IDX_WEEE_TAX_ENTITY_ID` (`entity_id`),
  INDEX `IDX_WEEE_TAX_COUNTRY` (`country`),
  INDEX `IDX_WEEE_TAX_ATTRIBUTE_ID` (`attribute_id`),
  CONSTRAINT `FK_WEEE_TAX_COUNTRY_DIRECTORY_COUNTRY_COUNTRY_ID` FOREIGN KEY (`country`) REFERENCES `directory_country` (`country_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_WEEE_TAX_ENTITY_ID_CATALOG_PRODUCT_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_WEEE_TAX_WEBSITE_ID_CORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_WEEE_TAX_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE
) COMMENT='Weee Tax' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
Trace: #0 /var/www/vhosts/mydomain.agency/uk.mydomain.agency/app/code/core/Mage/Core/Model/Resource/Setup.php(644): Mage::exception('Mage_Core', 'Error in file: ...') #1 /var/www/vhosts/mydomain.agency/uk.mydomain.agency/app/code/core/Mage/Core/Model/Resource/Setup.php(421): Mage_Core_Model_Resource_Setup->_modifyResourceDb('install', '', '1.6.0.0') #2 /var/www/vhosts/mydomain.agency/uk.mydomain.agency/app/code/core/Mage/Core/Model/Resource/Setup.php(327): Mage_Core_Model_Resource_Setup->_installResourceDb('1.6.0.0') #3 /var/www/vhosts/mydomain.agency/uk.mydomain.agency/app/code/core/Mage/Core/Model/Resource/Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates() #4 /var/www/vhosts/mydomain.agency/uk.mydomain.agency/app/code/core/Mage/Core/Model/App.php(428): Mage_Core_Model_Resource_Setup::applyAllUpdates() #5 /var/www/vhosts/mydomain.agency/uk.mydomain.agency/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Model_App->_initModules() #6 /var/www/vhosts/mydomain.agency/uk.mydomain.agency/app/Mage.php(684): Mage_Core_Model_App->run(Array) #7 /var/www/vhosts/mydomain.agency/uk.mydomain.agency/index.php(83): Mage::run('', 'store') #8 {main}

 

========================

 

can anyone shed any light, 

 

thanks

2 REPLIES

Re: New 1.9.2.4 installation

Is this a fresh installation or an upgrade? 

 

If it is an upgrade, have you attempted any upgrade which didn't complete? 

James Lee | Moderator • Magento Master
See My Recommended Magento Hosting & Security Tips

Re: New 1.9.2.4 installation

@aarondurber01

 

 

Please delete weee_tax table in your DataBase after check.

 

Query solved? Accept as Solution.Thanks
Eric Baily