You have an error in your SQL syntax near 'TYPE=MyISAM'

Posted: Thu Oct 09, 2014 12:55 am

Code:

October 9, 2014, 5:54 am File: /db/mysqli.php - Line: 201


Code: 1064 - Message: You have an error in your SQL syntax; check the manual that corresponds to your DataBase server version for the right syntax to use near 'TYPE=MyISAM' at line 1


SQL was: CREATE TABLE IF NOT EXISTS nuke_optimize_gain(gain decimal(10,3)) TYPE=MyISAM

PHP: 5.5.38

If you have this error on your dblog file

Open your FTP admin/modules/optimize.php

Search for

Code:

$sql_query = 'CREATE TABLE IF NOT EXISTS ' . $prefix . '_optimize_gain(gain decimal(10,3)) TYPE=MyISAM';

Replace with

Code:

$sql_query = 'CREATE TABLE IF NOT EXISTS ' . $prefix . '_optimize_gain(gain decimal(10,3)) ENGINE=MyISAM';

That's all folks!

Site Admin Joined: Jun 04, 2004 Posts: 6433

Yes, as was already noted here.

Posted: Thu Oct 09, 2014 5:58 am

Oops. Sorry. I didn't search properly I guess. Very Happy

Thanks!