|
Dec 1 Tuesday |
Magento Database Import Error: USING BTREE, KEY `FK_ATTRIBUTE_VARCHAR_ENTITY` (`entity_id`), KEY `FK_CATALO’ at line 9
10
Comment(s)
Tonight I was setting up a staging environment for a client of ours so they would have the ability to “visually” interact with the recent data migration our team has performed (OSCommerce to Magento, in case anyone was wondering). Here’s the error I was receiving:
The reason behind this is that there is an inconsistency in the way the export syntax was being handled as I imported into the staging environment (which evidently has a different MySQL version running). Thus, the staging site was expecting different syntax for the following:
As a rule of thumb, one can either
and replaced it with this:
Hope this helps someone who is experiencing the same error and spending way too much time trying to understand the incompatible syntax. |

New Here?
Search Our Blog
Tag Cloud

Live Support is