Magento Notes - SQL Error mysql4-upgrade-0.7.46-0.7.47.php
I tried running the installation for a new Magento project this morning, and I used version 1.1.8 and had the following error message:
“Erro during installation magento mysql4-upgrade-0.7.46-0.7.47.php” - SQLSTATE[42000]“ with additional text indicating access violation with the database user account. I know that i don’t have an issue with permissions as I have setup other Magento stores using the same db user/pswd.
Anyways, the fix for this is to locate the file: mysql4-upgrade-0.7.46-0.7.47.php inside: app/code/core/Mage/Catalog/sql/catalog_setup and comment out lines 66-69 where it issues command to lock the database:
$installer->run(”
LOCK TABLES `{$installer->getTable(’catalog_category_product_index’)}` WRITE, `{$installer->getTable(’catalog_category_product’)}` READ, `{$installer->getTable(’catalog_category_entity’)}` READ;
/*!40000 ALTER TABLE `{$installer->getTable(’catalog_category_product_index’)}` DISABLE KEYS */;
“);
and then also comment out lines: 85-88 where it unlocks the database again:
$installer->run(”
/*!40000 ALTER TABLE `{$installer->getTable(’catalog_category_product_index’)}` ENABLE KEYS */;
UNLOCK TABLES;
“);
Then go into: app/etc and rename the local.xml file and rerun the Magento setup. You should be fine this time around.