Wednesday, October 5, 2011

Mangento exporting SQL issue

While exporting mySQL if you every get into the problem]


ERROR 1064 (42000) at line 688: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USING BTREE,
  KEY `FK_ATTRIBUTE_VARCHAR_ENTITY` (`entity_id`),
  KEY `FK_CATALO' at line 9

and the mySQL is 
UNIQUE KEY `IDX_BASE` (`entity_type_id`,`entity_id`,`attribute_id`,`store_id`) USING BTREE

You need to replace all such instance by 

UNIQUE KEY `IDX_BASE` USING BTREE(`entity_type_id`,`entity_id`,`attribute_id`,`store_id`)

1 comment:

  1. Cafe Casino is a superb place to seek out|to search out} a little diversity in online playing sites. One thing we liked was that the entire on line casino video games library at Las Atlantis could be performed on the go on their optimized web site, which we found stood a lot as} some other mobile website we’ve tried. The welcome bonus at Slots.lv begins casino.edu.kg at a 200% match for fiat and 300% for Bitcoin users. If you’re someone that likes moving smaller chunks of money though, we found their minimum $150 deposit again to bank cards, bank accounts, and Bitcoin to be a bit extreme. But not many may have skilled this age-old basic in a reimagined digital setting.

    ReplyDelete