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

Its a bug in the install script of version 3.1 - It is not defining the indexes for the series table properly.

You can work around it by installing version 3.0.2, creating your site then upgrading to 3.1 and running the update from the admin page.

I'm updating the .zip right now to correct this.  Thanks.

Thank you for the help!  I just deleted everything and will start fresh when the new .zip file is available.

😀
Amanda

It's up now.

I'm not sure if this is part of the same problem or not, but this is the error message I now receive after deleting everything and reinstalling:

A fatal MySQL error was encountered.
Query: CREATE TABLE `SVUfanfiction_series` ( `seriesid` int(11) NOT NULL auto_increment, `title` varchar(200) NOT NULL default '', `summary` text NOT NULL, `uid` int(11) NOT NULL default '0', `isopen` tinyint(4) NOT NULL default '0', `catid` varchar(200) NOT NULL default '0', `rating` tinyint(4) NOT NULL default '0', `classes` varchar(200) NOT NULL default '', `characters` varchar(250) NOT NULL default '', `reviews` smallint(6) NOT NULL default '0', `challenges` varchar(200) NOT NULL default '', PRIMARY KEY (`seriesid`), KEY `owner` (`uid`), KEY `catid` (`catid`), KEY `characters` (`characters`), KEY `classes` (`classes`), KEY `owner` (`uid`,`title`) ) TYPE=MyISAM;
Error: (1061) Duplicate key name 'owner'

Thanks!

Did you also delete the mysql tables when uninstalling?

Yes, I deleted them, but possibly not all of them.  When I went back to check, I made a serious error and can no longer access my database 🙁  I will be starting from scratch with my database, and that will hopefully resolve all of my problems.  The first trick will be figuring out how to delete my database and starting over.

Thanks!
Amanda

I'm encountering the exact same second error with the Duplicate key name 'owner' with a brand new fresh install. It's created the tables, the settings and all the others.  I've deleted the config.php and all the tables, and the database and started from scratch 4 times and I've encountered this error all four times.

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, Duplicate key name
State the nature of your problem:

A fatal MySQL error was encountered.
Query: CREATE TABLE `fanfiction_series` ( `seriesid` int(11) NOT NULL auto_increment, `title` varchar(200) NOT NULL default '', `summary` text NOT NULL, `uid` int(11) NOT NULL default '0', `isopen` tinyint(4) NOT NULL default '0', `catid` varchar(200) NOT NULL default '0', `rating` tinyint(4) NOT NULL default '0', `classes` varchar(200) NOT NULL default '', `characters` varchar(250) NOT NULL default '', `reviews` smallint(6) NOT NULL default '0', `challenges` varchar(200) NOT NULL default '', PRIMARY KEY (`seriesid`), KEY `owner` (`uid`), KEY `catid` (`catid`), KEY `characters` (`characters`), KEY `classes` (`classes`), KEY `owner` (`uid`,`title`) ) TYPE=MyISAM;
Error: (1061) Duplicate key name 'owner'

Do you have a test account for us? No, can't get that far in the installation.

I'll fix the .zip as soon as I can get the FTP to the site to work.  It seems to be down right now.

To delete an entire database run the following SQL statement from phpmyadmin

drop database name_of_database;

The .zip is updated with the correction for the install script.