"Table 'fanfic...
 
Notifications
Clear all

"Table 'fanfiction_authorfields' already exists

7 Posts
4 Users
0 Reactions
2,415 Views
(@guest2220)
Posts: 0
 

URL to your eFiction: http://fortunasarchive.com
Version of eFiction:3.3.1
Have you bridged eFiction, if so with what?: No
Version of PHP: 5, but am not 100% sure since the info.php file comes up 404 not found
Version of MySQL: 5.0
Have you searched for your problem: Yes
If so, what terms did you try:fanfiction_authorfields
State the nature of your problem: A fatal MySQL error was encountered.
Query: CREATE TABLE `fanfiction_authorfields` ( `field_id` int(11) NOT NULL AUTO_INCREMENT, `field_type` tinyint(4) NOT NULL default '0', `field_name` varchar(30) NOT NULL default ' ', `field_title` varchar(255) NOT NULL default ' ', `field_options` text, `field_code_in` text, `field_code_out` text, `field_on` tinyint(1) NOT NULL default '0', PRIMARY KEY (`field_id`) ) TYPE=MyISAM;
Error: (1050) Table 'fanfiction_authorfields' already exists
Do you have a test account for us? not able to complete the installation

I had previously tried to install efiction, but for some reason when I uploaded the folder to maintain the hierarchy, I ended up getting a 404 error. I attempted to take all of the files off of my web space and start again, and every time I try to do the automatic installs, I get this error. I have just started to get into php, and am really lost at this point, so if there is any manual stuff that needs to be entered, I may not be able to follow, sorry.


 
Posted : 14/03/2008 1:25 am
(@guest2220)
Posts: 0
 

oops! I feel pretty dumb right now 😳 I don't think I removed all of the files before uploading them again, overwriting should have fixed it, but I am going to try and clean everything off the server, upload and install again. I'll post if I have the same error


 
Posted : 14/03/2008 1:30 am
(@tammy)
Posts: 2577
Member Moderator
 

You forgot to empty your database. 


 
Posted : 14/03/2008 8:56 am
(@guest2220)
Posts: 0
 

Thanks, that worked πŸ˜€


 
Posted : 14/03/2008 10:09 pm
(@my_daroga)
Posts: 19
Active Member
 

This sounds like the problem I'm having and posted about here. But I'm confused; where does it say to empty the database? And doesn't that remove your categories etc?


 
Posted : 03/04/2008 11:49 pm
Jan_AQ
(@jan_aq)
Posts: 1300
Noble Member
 

She was trying to install, not upgrade. And yes, it would delete everything, including categories. If you try to do a new install, and the database exists, you will get errors, because it can't create something that already exists.


Whoever said nothing is impossible never tried slamming a revolving door.

url: https://www.potionsandsnitches.org/fanfiction
php: 7.4.33 msql: 5.6.51-community GPL
efic version: 3.5.5 latest patches: yes
bridges: none mods: challenges, tracker, story end, beta, word

 
Posted : 04/04/2008 1:16 am
(@my_daroga)
Posts: 19
Active Member
 

I seem to have forgotten how to read, along with how to run my archive. Thanks!


 
Posted : 04/04/2008 11:01 am
Share: