Centova Technologies Forum

Centova Cast v3 => Bugs and issues => Topic started by: djduck on March 02, 2013, 04:42:22 am

Title: Issue when installing fresh install
Post by: djduck on March 02, 2013, 04:42:22 am

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

Title: Re: Issue when installing fresh install
Post by: wisez on March 02, 2013, 11:00:40 am

Are you using MySQl 5.5.x ?

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

Maybe that's the problem.

Title: Re: Issue when installing fresh install
Post by: alanb on March 02, 2013, 10:01:10 pm

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

Title: Re: Issue when installing fresh install
Post by: djduck on March 03, 2013, 11:45:15 am

I installed it on a remote server then transferred the SQL and it worked.

Title: Re: Issue when installing fresh install
Post by: Centova - Steve B. on March 03, 2013, 08:03:53 pm

Wrong forum -- I've moved it to the correct one where this is now a duplicate of this thread (http://forums.centova.com/index.php?topic=2262).