[-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