Issue when installing fresh install

Read 7378 times
I am receiving this error when trying to install the web part.

Error populating database: Could not execute query: 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=MEMORY' at line 1
Are you using MySQl 5.5.x ?

In MySQL 5.5.+ they changed the syntax of TYPE to "ENGINE".

Maybe that's the problem.
to temp fix this  edit the centovacast.sql file in the /usr/local/centovacast/system folder and do a global replace text

replace TYPE=MEMORY

with

ENGINE=MEMORY

then try the install again.   Its related to using MySQL 5.5.x
I installed it on a remote server then transferred the SQL and it worked.
Wrong forum -- I've moved it to the correct one where this is now a duplicate of this thread.