MyBB Codes
Its My birthday [plugin] "FIXED" !! - Printable Version

+- MyBB Codes (http://www.mybbcodes.com)
+-- Forum: Babjusi's Previous Forum General Stuff (/forumdisplay.php?fid=42)
+--- Forum: General Support (/forumdisplay.php?fid=46)
+--- Thread: Its My birthday [plugin] "FIXED" !! (/showthread.php?tid=5394)


Its My birthday [plugin] "FIXED" !! - Technoman - 10-31-2014 05:51 PM

Hi i know you did not make this plugin, but can you possiably tell me what this sql means?




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=ENGINE' at line 12
Query:
    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=ENGINE;

Please contact the MyBB Group for technical support.


Here is the plugin url
http://mods.mybb.com/reviews/its-my-birthday

Im using the new 1.8.1 mybb forum so if there is anything i need to edit so that this plugin works i would be very happy!

Thank You


RE: Its My birthday [plugin] - Technoman - 10-31-2014 08:28 PM

I figured it out
TYPE=ENGINE
i changed it to
ENGINE=MyISAM
and no sql errors now works. Wink