Hi
Ive started a fiction site and the challenges wont install. When you click on yes want to install it, it comes
up with fatal error as this
A fatal MySQL error was encountered.
Query: CREATE TABLE `fanfiction_challenges` ( `chalid` int(11) NOT NULL auto_increment, `challenger` varchar(200) NOT NULL default '', `uid` int(11) NOT NULL default '0', `title` varchar(250) NOT NULL default '', `catid` varchar(200) NOT NULL default '', `characters` varchar(200) NOT NULL default '', `summary` text NOT NULL, `responses` int(11) NOT NULL default '0', PRIMARY KEY (`chalid`), KEY `title` (`catid`), KEY `uid` (`uid`), KEY `title_2` (`title`), KEY `characters` (`characters`) ) TYPE=MyISAM;
Error: () - See more at: http://www.shegotitgood.com/modules/challenges/install.php?confirm=yes#sthash.FkUb7yRE.dpuf
would be nice to run this on the site is here
http://www.shegotitgood.com
for mystery fiction
thank you
cheers
Kate 😀
then on clickin the admin link I get this error after trying to install the challenges module
A fatal MySQL error was encountered.
Query: SELECT count(chalid) FROM fanfiction_challenges
Error: () - See more at: http://www.shegotitgood.com/admin.php#sthash.uZsMEQZt.dpuf
i will have to remove it in the database if its there as it has also wiped off the site news, welcome message
and also the most recent on the index.hp page
cheers
Kate
Did you try this https://efiction.org/forums/index.php?topic=8862.0 ?
My Hub TrekNation | World of X | Arda Fanfiction
Hi
thank you I will take a look 🙂
thanks, Kate
thank you. x i followed that post. I corrected the php errors but also in my site
I had to in the install file change the type MyIsam to Engine MyIsam because of the
database the website host is using mariahdb, this worked. So hope this is useful to
other users. I got the challenges to work.
Thank you
from Kate
