SugarCRM Installer acl_actions: Query Failed…

[-none-][FATAL] Error creating table: acl_actions: Query Failed: CREATE TABLE acl_actions (id char(36)  NOT NULL ,date_entered datetime  NULL ,date_modified datetime  NULL ,modified_user_id char(36)  NULL ,created_by char(36)  NULL ,name varchar  NULL ,category varchar  NULL ,acltype varchar  NULL ,aclaccess int(3)  NULL ,deleted bool  DEFAULT 0  NULL  , PRIMARY KEY (id),   KEY idx_aclaction_id_del (id, deleted),   KEY idx_category_name (category, name)) CHARACTER SET utf8 COLLATE utf8_general_ci: MySQL error 1064: 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 'NULL ,category varchar  NULL ,acltype varchar  NULL ,aclaccess int(3)  NULL ,del' at line 1

Solution: There is no need to hack into the code and do stuffs. Why would you want hack into a software that you are trying to install? If that is the case, this software is just crap and you should avoid it. Just saying you need PHP and MySQL is not cutting it, we need the right version numbers.

First verify that you meet the requirements:
http://support.sugarcrm.com/05_Resources/02_Supported_Platforms

Here the solution that worked for me:

I was running php 5.2 so I upgraded it to PHP 5.8
I was running Mysql 5.0.XX I upgraded it to Mysql 5.5.XXX
As a result the install when though without a glitch and even the AJAX errors vanished.

Reference
If you still want the hack solution that worked for me please check the following link:
http://forums.sugarcrm.com/f115/6-4-3-installer-sql-bug-name-varchar-null-79327/index2.html#post278199

Let's share thisShare on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn