MyBB Community Forums

Full Version: Anyone can fix this plugin???
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I am getting mysql error. the main topic is
its my birthday
Geting error Sad

MyBB SQL Error

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 12
CREATE TABLE mybb_g33k_itsmybirthday_bdaywishes ( wid int unsigned NOT NULL auto_increment, pid int unsigned NOT NULL default '0', uid int unsigned NOT NULL default '0', tid int unsigned NOT NULL default '0', fid int unsigned NOT NULL default '0', username varchar(80) NOT NULL default '', bdayuser varchar(80) NOT NULL default '', dateline bigint(30) NOT NULL default '0', KEY pid (pid, uid), PRIMARY KEY (wid) ) TYPE=MyISAM;
open the plugin's main php file in a code editor (eg. notepad++) and edit all
occurrences of TYPE=MyISAM; with ENGINE=MyISAM; --- save file & use it
it worked thnx