Notifications
Clear all

Error: (1072) Key column 'challenges' doesn't exist in table

2 Posts
2 Users
0 Reactions
2,741 Views
(@ataraxis)
Posts: 10
Active Member
Topic starter
 

URL to your eFiction: http://www.magdelena.net/efiction/
Version of eFiction: 3.1
Have you bridged eFiction, if so with what?: No
Version of PHP: 5.0.5
Version of MySQL: 4.1.21-standard-log
Have you searched for your problem: yes
If so, what terms did you try: Step 3
State the nature of your problem:

I just got Tammy's latest modified eFiction 3.1 script, based on the recent errors in doing a fresh install which had the error of 'owner' key already existing in Step 3 and now this new install error is reporting at Step 3:

A fatal MySQL error was encountered.
Query: CREATE TABLE `fanfiction_stories` ( `sid` int(11) NOT NULL auto_increment, `title` varchar(200) NOT NULL default 'Untitled', `summary` text NULL, `storynotes` text NULL, `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, `updated` datetime NOT NULL default '0000-00-00 00:00:00', `uid` int(11) NOT NULL default '0', `coauthors` varchar(50) NOT NULL default '0', `featured` char(1) NOT NULL default '0', `validated` char(1) NOT NULL default '0', `completed` char(1) NOT NULL default '0', `rr` char(1) NOT NULL default '0', `wordcount` int(11) NOT NULL default '0', `rating` tinyint(4) NOT NULL default '0', `reviews` smallint(6) NOT NULL default '0', `count` int(11) NOT NULL default '0', PRIMARY KEY (`sid`), KEY `title` (`title`), KEY `catid` (`catid`), KEY `charid` (`charid`), KEY `rid` (`rid`), KEY `uid` (`uid`), KEY `featured` (`featured`), KEY `completed` (`completed`), KEY `rr` (`rr`), KEY `challenges` (`challenges`), KEY `validateduid` (`validated`,`uid`), KEY `recent` (`updated`,`validated`) ) TYPE=MyISAM;
Error: (1072) Key column 'challenges' doesn't exist in table

I replaced the existing install folder documents with the newest scripts, and removed and recreated the MySQL database and user, as well as removed the config.php file..


 
Posted : 19/01/2007 5:21 pm
(@tammy)
Posts: 2577
Member Moderator
 

Grab it again.  I updated it once more.


 
Posted : 19/01/2007 5:56 pm
Share: