I tried installing this and it threw me this error:
A fatal MySQL error was encountered.
Query: CREATE TABLE `fanfiction_recommendations` ( `recid` int(11) NOT NULL auto_increment, `title` varchar(200) NOT NULL default 'Untitled', `author` varchar(200) NOT NULL, `summary` text, `comments` text, `uid` int(11) NOT NULL, `recname` varchar(50) NOT NULL, `url` varchar(255) NOT NULL default 'broken', `catid` varchar(100) NOT NULL default '0', `classes` varchar(200) NOT NULL default '0', `charid` varchar(250) NOT NULL default '0', `rid` varchar(25) NOT NULL default '0', `date` datetime default NULL, `featured` char(1) NOT NULL default '0', `validated` char(1) NOT NULL default '0', `completed` char(1) NOT NULL default '0', `rating` tinyint(4) NOT NULL default '0', `reviews` smallint(6) NOT NULL default '0', PRIMARY KEY (`recid`), KEY `title` (`title`), KEY `catid` (`catid`), KEY `charid` (`charid`), KEY `rid` (`rid`), KEY `featured` (`featured`), KEY `validated` (`validated`), KEY `completed` (`completed`), KEY `classes` (`classes`) ) TYPE=MyISAM;
Error: ()
Any idea how to correct this?
I assume its a database error so access to the test account isn't needed.
Thanks!
I don't have the recommendations module installed to be sure but it looks like the SQL request doesn't call the tableprefix. In your install.php file (in modules/recommendations) do you have something like this?
CREATE TABLE IF NOT EXISTS `fanfiction_recommendations`
If so try changing it to this:
CREATE TABLE IF NOT EXISTS `".TABLEPREFIX."fanfiction_recommendations`
Thank you, but I decided not to use this after all. As soon as I refreshed to the main page, the entire thing was blank and I had to forcibly remove the module from the host as well as reinstall the tables from a backup. Not worth the risk IMO LOL
Again, thank you for your reply.
No problem. I went through the same thing with the challenges module awhile back. The codes on some of these mods are outdated
This stuff gives me a headache.
Anyway, I bodged together yet another fix, so feel free to burn away now 🙂
Btw: This creates tables for recommendations and challenges.
