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

Little Endian vs Big Endian

Refers to the way the data is stored in memory.

Bytes order: Byte3 Byte2 Byte1 Byte0

Little Endian is stored from right to left. (Least significant bit is stored to the lowest address in memory)

Big Endian stored from left to right (most significant bit  is stored to the lowest address in memory)

Reference
http://people.cs.umass.edu/~verts/cs32/endian.html

Least significant bit
http://en.wikipedia.org/wiki/Least_significant_bit

Most Significant Bit
http://en.wikipedia.org/wiki/Most_significant_bit

Install VMware Tools Ubuntu

1. First Mount the ISO (cd-drive) containing the the VMware tools files
   mount /dev/cdrom  /media/cdrom

2. Second copy the file
   cp /media/cdrom/* /tmp

3. Unzip the files
   tar -xzf vm...tar.gz

4. Run the VMware perl script and follow the prompts

5. If you run into issue such as missing linux headers just run the following command to install them:
   $sudo apt-get install linux-headers-$(uname -r)

Upgrade Ubuntu from 9.04 to 12.04

First Verify the version of Ubuntu that you are running:

sudo lsb_release -a
$ sudo apt-get update
$ sudo apt-get upgrade
$ sudo apt-get install update-manager-core

Update Jaunty 9.04 to Karmic 9.10
update /etc/apt/sources.list and replace "jaunty" with "karmic"
$ sudo apt-get update
$ sudo do-release-upgrade

if do-release-upgrade is not working just do a 
apt-get upgrade

Update Karmic 9.10 to Lucid 10.04 
update /etc/apt/sources.list and replace "karmic" with "lucid"
$ sudo apt-get update
$ sudo do-release-upgrade

if do-release-upgrade is not working just do a 
apt-get upgrade

From Version 10.04 to 12.04 the Upgrade Get easier:
All you have to do is run the following command:

sudo do-release-upgrade

and follow the prompts.

Useful Links

List of Ubuntu Releases
http://en.wikipedia.org/wiki/List_of_Ubuntu_releases

How to update Ubuntu server from 9.04 to 10.04
http://thanhsiang.org/faqing/node/156

Lucid to Maverick
http://www.ubuntugeek.com/how-to-upgrade-from-ubuntu-10-04-lucid-to-ubuntu-10-10-maverick-desktop-and-server.html