cancel
Showing results for 
Search instead for 
Did you mean: 

Install Magento 1.9.2.2 ERROR

Highlighted
New Contributor

Install Magento 1.9.2.2 ERROR

Hi

 

I am presenting an error at the time of installation I can do?

 

a:5:{i:0;s:2075:"Error in file: "C:\xampp\htdocs\magento\app\code\core\Mage\SalesRule\sql\salesrule_setup\install-1.6.0.0.php" - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'salesrule' already exists, query was: CREATE TABLE `salesrule` (
`rule_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Rule Id' ,
`name` varchar(255) NULL COMMENT 'Name' ,
`description` text NULL COMMENT 'Description' ,
`from_date` date NULL COMMENT 'From Date' ,
`to_date` date NULL COMMENT 'To Date' ,
`uses_per_customer` int NOT NULL default '0' COMMENT 'Uses Per Customer' ,
`customer_group_ids` text NULL COMMENT 'Customer Group Ids' ,
`is_active` smallint NOT NULL default '0' COMMENT 'Is Active' ,
`conditions_serialized` mediumtext NULL COMMENT 'Conditions Serialized' ,
`actions_serialized` mediumtext NULL COMMENT 'Actions Serialized' ,
`stop_rules_processing` smallint NOT NULL default '1' COMMENT 'Stop Rules Processing' ,
`is_advanced` smallint UNSIGNED NOT NULL default '1' COMMENT 'Is Advanced' ,
`product_ids` text NULL COMMENT 'Product Ids' ,
`sort_order` int UNSIGNED NOT NULL default '0' COMMENT 'Sort Order' ,
`simple_action` varchar(32) NULL COMMENT 'Simple Action' ,
`discount_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Discount Amount' ,
`discount_qty` decimal(12,4) NULL COMMENT 'Discount Qty' ,
`discount_step` int UNSIGNED NOT NULL COMMENT 'Discount Step' ,
`simple_free_shipping` smallint UNSIGNED NOT NULL default '0' COMMENT 'Simple Free Shipping' ,
`apply_to_shipping` smallint UNSIGNED NOT NULL default '0' COMMENT 'Apply To Shipping' ,
`times_used` int UNSIGNED NOT NULL default '0' COMMENT 'Times Used' ,
`is_rss` smallint NOT NULL default '0' COMMENT 'Is Rss' ,
`website_ids` text NULL COMMENT 'Website Ids' ,
`coupon_type` smallint UNSIGNED NOT NULL default '1' COMMENT 'Coupon Type' ,
PRIMARY KEY (`rule_id`),
INDEX `IDX_SALESRULE_IS_ACTIVE_SORT_ORDER_TO_DATE_FROM_DATE` (`is_active`, `sort_order`, `to_date`, `from_date`)
) COMMENT='Salesrule' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci";i:1;s:944:"#0 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(644): Mage::exception('Mage_Core', 'Error in file: ...')
#1 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(421): Mage_Core_Model_Resource_Setup->_modifyResourceDb('install', '', '1.6.0.3')
#2 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(327): Mage_Core_Model_Resource_Setup->_installResourceDb('1.6.0.3')
#3 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\App.php(428): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\App.php(354): Mage_Core_Model_App->_initModules()
#6 C:\xampp\htdocs\magento\app\Mage.php(684): Mage_Core_Model_App->run(Array)
#7 C:\xampp\htdocs\magento\index.php(83): Mage::run('', 'store')
#8 {main}";s:3:"url";s:9:"/magento/";s:11:"script_name";s:18:"/magento/index.php";s:4:"skin";s:7:"default";}
2 REPLIES
M2 Certified

Re: Install Magento 1.9.2.2 ERROR

Is it maybe possible you ran the installer twice? When a table exists, it's either because you're using a database that's already used to install Magento or you're trying to run the installation twice.

If this response was helpful to you, consider giving kudos to this post.
If this response solved your problem, click accept as solution to help others solve this
Moderator

Re: Install Magento 1.9.2.2 ERROR

Hi @juliansarmiento did you find a solution to your problem or you still have issues? Its correct what @Arjen Miedema this would suggest that the table is allready is created by the installer.

 

If the problem is solved please share with us what you did to solve it, so we can mark the issued solved and other users may also learn what to do (if there was something do do)