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.