Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RavenNuke(tm) v2.5x
Author Message
Doulos
Life Cycles Becoming CPU Cycles


Joined: Jun 06, 2005
Posts: 652

PostPosted: Fri Aug 22, 2014 2:45 pm Reply with quote

Uploaded all new files from RavenNuke_v2.51.7z and get this error when I tried to optimize my RN database:
Quote:
Code: 1064 - Message: 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=MyISAM' at line 1
SQL was: CREATE TABLE IF NOT EXISTS nuke_optimize_gain(gain decimal(10,3)) TYPE=MyISAM


Should I change line admin/modules/optimize.php line 76 from:
Code:
   $sql_query = 'CREATE TABLE IF NOT EXISTS ' . $prefix . '_optimize_gain(gain decimal(10,3)) TYPE=MyISAM';


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


I did this and did not receive any error, but I want to be sure it is the right thing to do.
 
View user's profile Send private message
neralex
Site Admin


Joined: Aug 22, 2007
Posts: 1482

PostPosted: Fri Aug 22, 2014 2:57 pm Reply with quote

ENGINE=MyISAM is the current way to do this.

_________________
Only registered users can see links on this board! Get registered or login!

Last edited by neralex on Sun Aug 24, 2014 5:42 pm; edited 1 time in total 
View user's profile Send private message
Doulos
PostPosted: Fri Aug 22, 2014 4:33 pm Reply with quote

OK, thanks.
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RavenNuke(tm) v2.5x

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©