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”
  • Save the file and proceed to installation.

hope it helps.