symfony - Symfony2 and Match Against, table InnoDB -

i had problem implement match against symfony2, solve problem stackoverflow : match against script not working symfony2

i did picoss said, have problem :

sqlstate[hy000]: general error: 1214 used table type doesn't support fulltext indexes

after search on google suppose reason because of innodb table type, don't know how change in symfony2 (and have search on table generated entity of fosuserbundle. second solution can upgrade mysql version (i on 5.1.66-0 version, not sure if solve problem or not).

do have other ideas ?

thanks

you can add engine option in @orm/table definition:

for annotions:

<?php  namespace my\bundle\entity;  use doctrine\orm\mapping orm;  /**  * myentity  *  * @orm\table(name="my_entity", options={"engine"="myisam"})  * @orm\entity(repositoryclass="my\bundle\entity\repository\myentityrepository")  */ class myentity {     //... } 

hope helps