Posted on by macoymejia

Installing #VtigerCRM 5.2.1 in MySQL 5.5

In MySQL 5.5, “Type=InnoDB” paramaters in CREATE TABLE routing was deprecated. So you have to use “ENGINE=InnoDB” instead.

And to make your VtigerCRM proceed to installation using MySQL 5.5, you just have to do the following:

  • edit DatabaseShema.xml 
     $ vim schema/DatabaseSchema.xml
  • Replace all  “Type=InnoDB” to “ENGINE=InnoDB” 
    :%s/Type=InnoDB/ENGINE=InnoDB/c
  • Save the file and proceed to installation.

hope it helps.