MySQL Bugs: #72142: Error when instaling Blab! blog

Bug #72142	Error when instaling Blab! blog
Submitted:	27 Mar 2014 5:50	Modified:	27 Mar 2014 16:39
Reporter:	Alvar Fuertes	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	6.0.9.11421	OS:	MacOS (V 10.9.2 )
Assigned to:		CPU Architecture:	Any

Description:
Im trying to install blog BlaB! IM and get next error msg: 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 'TYPE=HEAP MAX_ROWS=15000' at line 5

How to repeat:
Download BlaB! IM (http://hot-things.net/cs/section.php?sid=4)

How to install BlaB! IM

Create an empty database using PhpMyAdmin or a similar program depending on the database engine you are about to use.

[how to create a new MySQL database in cPanel]

Unzip the files from the TAR.GZ archive in an empty directory keeping the directory structure. You can use 7-ZIP, WinZip, WinRar or any other archive extractor.

Open config.php by a text editor and set the following variables: $dbss['user'] - database user, $dbss['pass'] - database password and $dbss['name'] - database name.

Upload the whole directory (and all files/subdirectories in it) to your server with an FTP program.

Load install.php in your web browser: 
http://yoursite.com/blab_im/install.php and follow the instructions.

Sorry, correct MySQL Ver. is mysql-5.6.16-osx10.7-x86_64

Thx.

http://dev.mysql.com/doc/refman/5.6/en/create-table.html

Let me show the actual error here.
Using TYPE instead of ENGINE is no longer supported. This is not a bug.

mysql> create table t(a int) type=heap;
ERROR 1064 (42000): 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 'type=heap' at line 1

mysql> create table t(a int) engine=heap;
Query OK, 0 rows affected (0.01 sec)

Hi, error fixed. Thx.

Best regards.