URL to your eFiction: www.efiction.svufanfiction.com
Version of eFiction: 3.1
Have you bridged eFiction, if so with what?: No
Version of PHP: phpMyAdmin 2.6.3-pl1
Version of MySQL: MySQL 4.1.14
Have you searched for your problem: Yes
If so, what terms did you try: Duplicate key name owner
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
After having problems with my first install attempt and corruption of mySQL database, my webhost deleted mySQL database and I recreated it from scratch. I deleted all the eFiction files previously uploaded to my web server and tried a fresh install, dowloading the new .zip file under downloads.
These are the six tables listed when I create mySQL database with my webhost: columns_priv ; db ; func ; host ; tables_priv ; user
Is it possible that my webhost will not allow eFiction to run? The only information I was able to find from them was this about the user table:
Warning: Modifying or deleting the user table, or deleting the mysql database itself, can permanently damage your database. If you accidentally delete or modify one of these items, you may need to reset your MySQL settings, which requires erasing the database and all the data contained within.
I'm really lost as to what I'm doing. I'm trying to learn, but am getting really frustrated. I'd appreciate any help that I can get.
THANK YOU!
Amanda
It's a bug. It happened to me too, and I had to go into phpMyAdmin and add the table by hand. You just need to delete this from the query and it'll run ok:
KEY `owner` (`uid`),
I just updated the .zip. This should be fixed now. Sorry for the trouble.
Thank You!! I was able to get it to install 😀 Dumb me made an installation error...I hate my webhost, but the reload should go just fine since I was able to do it once.
Thanks again! I'm really excited to get this set up...now my users can stop bugging me to do updates faster
-Amanda
FYI for Tammy, I was running the upgrade from 1.1, so that needs to be fixed too, if you haven't already...
And, yeah, I'm really slow about upgrading.
