MyBB Community Forums
Anyone can fix this plugin??? - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Extensions (https://community.mybb.com/forum-201.html)
+--- Forum: Plugins (https://community.mybb.com/forum-73.html)
+---- Forum: Plugin Support (https://community.mybb.com/forum-72.html)
+---- Thread: Anyone can fix this plugin??? (/thread-103192.html)



Anyone can fix this plugin??? - ronak123 - 2011-09-05

I am getting mysql error. the main topic is
http://mods.mybb.com/view/its-my-birthday
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
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=MyISAM;


RE: Anyone can fix this plugin??? - ranjani - 2011-09-05

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


RE: Anyone can fix this plugin??? - ronak123 - 2011-09-06

it worked thnx