2012-02-15, 11:50 PM
Ever since I moved hosts, I keep getting this SQL Error when installing a plugin to my Plugins library.
I looked it up and found that I have to replace it with 'ENGINE=MyISAM'
But it gets very confusing since I don't know which file it is in.
Here's what I got for Tera Donate 1.2. Where is the file? I can't find it.
Quote:1064 - 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 16
I looked it up and found that I have to replace it with 'ENGINE=MyISAM'
But it gets very confusing since I don't know which file it is in.
Here's what I got for Tera Donate 1.2. Where is the file? I can't find it.
Quote:MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1064 - 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 16
Query:
CREATE TABLE mybb_teradonate (did INT UNSIGNED NOT NULL AUTO_INCREMENT, uid INT UNSIGNED NOT NULL DEFAULT '0', ogid INT UNSIGNED NOT NULL DEFAULT '1', name VARCHAR(20) NOT NULL DEFAULT '', email VARCHAR(120) NOT NULL DEFAULT '', ebank VARCHAR(20) NOT NULL DEFAULT '', amount SMALLINT UNSIGNED NOT NULL DEFAULT '0', currency CHAR(3) NOT NULL DEFAULT '' , note VARCHAR(100) DEFAULT '', ip VARCHAR(39) DEFAULT '', dateline BIGINT(30) UNSIGNED NOT NULL DEFAULT '0', confirmed TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY did (did), KEY uid (uid), KEY ogid (ogid)) TYPE=MyISAM;