Having all kinds of issues with the block feature in the admin, when I try to initialize or click on options I get mysql errors, also I tried to set the site news to inactive but it just refuses to go away, below are some of the errors I got, has anyone else had these issues?
A fatal MySQL error was encountered.
Query: CREATE TABLE IF NOT EXISTS `fanfiction_poll_votes` ( `vote_id` int(11) NOT NULL auto_increment, `vote_user` int(11) NOT NULL default '0', `vote_opt` int(11) NOT NULL default '0', `vote_poll` int(11) NOT NULL default '0', PRIMARY KEY (`vote_id`), KEY `vote_user` (`vote_user`,`vote_poll`) ) TYPE=MyISAM;
Error: ()
A fatal MySQL error was encountered.
Query: CREATE TABLE IF NOT EXISTS `fanfiction_online` ( `online_uid` int(11) NOT NULL default '0', `online_ip` int(11) NOT NULL default '0', `online_timestamp` int(11) NOT NULL default '0' ) TYPE=MyISAM;
Error: ()
A fatal MySQL error was encountered.
Query: SELECT * FROM fanfiction_poll WHERE poll_end IS NULL OR poll_end = '0000-00-00 00:00:00' ORDER BY poll_id DESC LIMIT 1
Error: ()
Somebody is asking for a Hinne Whooping!
Hi Methen,
What version of eFiction are you using?
"TYPE=MyISAM" is an old command, and no longer valid. An update to the latest version of the script should assist in eliminating this error. Otherwise, locate the files where "TYPE=MyISAM" is located and change it to "ENGINE=MyISAM".
For information about the original error, click here
eFiction Archives:
The latest version...
Somebody is asking for a Hinne Whooping!
