Failed to create ad...
 
Notifications
Clear all

Failed to create admin account during install [solved]

13 Posts
5 Users
0 Reactions
3,089 Views
(@guest1943)
Posts: 0
 

URL to your eFiction: http://arthurian.dreamthoughts.org/
Version of eFiction: 3.3
Have you bridged eFiction, if so with what?: No
Version of PHP: 4.4.6
Version of MySQL: 4.1.21
Have you searched for your problem: yes
If so, what terms did you try: "admin account"
State the nature of your problem:

A fatal MySQL error was encountered.
Query: INSERT INTO aficfanfiction_authors(`penname`, `email`, `password`, `date`) VALUES('The Management', 'abbygoutal@gmail.com', '3fc8388ac63eeac384f358b954fe8d79', now( ))
Error: (1146) Table 'efiction.aficfanfiction_authors' doesn't exist

Do you have a test account for us? no

I got as far as ?step=10 in the install, and got this.  And it was going so well, too. *facepalm*

aficfanfiction_authors does indeed not exist (fanfiction_authors does, however).  I gave it the prefix "afic" at some point during the install, since I'm thinking of running a second archive later, but it doesn't seem to have created *any* tables with that prefix.


 
Posted : 11/06/2007 6:56 am
(@guest1945)
Posts: 0
 

That's the exact same thing I just got!  I'm re-uploading the files and will try to reinstall, but I'm relieved to see it's not just me.


 
Posted : 12/06/2007 2:04 am
(@guest1943)
Posts: 0
 

Hah, likewise.

I'm thinking I may just try reinstalling and skip the prefix this time -- it won't be /that/ big a deal to run a second copy if I do start another archive.


 
Posted : 12/06/2007 2:17 am
(@guest1945)
Posts: 0
 

I was dumb and used the prefix again.  *sighs*  So this next time I'm following your lead and skipping that.  Wish me luck!


 
Posted : 12/06/2007 3:27 am
Jan_AQ
(@jan_aq)
Posts: 1300
Noble Member
 

If you mess up with the prefixes, you can just edit the tables' names in your database with something like phpmyAdmin.

The prefix for your tables should be listed in the setting page of your archive. If you can't get into that, look at the fanfiction_settings table.

Reupload all your files (except for TinyMCE), some things might not have been uploaded completely. After you do that and you still can't create the author table try this:

To create fanfiction_authors table in your databse, put this into the SQL, "Run SQL query/queries on database" space using phpmyAdmin:

*code removed*


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 : 12/06/2007 4:44 am
(@guest1943)
Posts: 0
 

As far as I know I didn't mess up; I entered it where it was asked for.

fanfiction_authors already exists.  It seems to have been trying to write to aficfanfiction_authors, which doesn't for some reason.

I'll keep trying.


 
Posted : 12/06/2007 4:56 am
Jan_AQ
(@jan_aq)
Posts: 1300
Noble Member
 

If fanfiction_authors exists and aficfanfiction_authors doesn't, just rename fanfiction_authors to aficfanfiction_authors.


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 : 12/06/2007 4:58 am
(@guest1943)
Posts: 0
 

I wound up just re-running the install without the prefix, and it seems to be working. πŸ™‚ Thanks for your response.


 
Posted : 12/06/2007 5:21 am
 Elle
(@jenny)
Posts: 594
Honorable Member
 

The problem is that the install isn't creating the tables with the prefix.. it's just creating the tables without the prefix so it's just fanfiction_ instead of tableprefixfanfiction_ ?

The settings table is created with the prefix no problem, it's just the other ones.


archive: dramione.org
site: accio.nu

Available for skin/mod commission! πŸ™‚

 
Posted : 23/06/2007 10:51 am
(@carissa)
Posts: 791
Member Moderator
 

Actually, Jenny, I think that's the way it's supposed to work. You can have a different tableprefix for the settings table, or at least I do on my install and it hasn't caused any problems...


 
Posted : 24/06/2007 1:15 pm
 Elle
(@jenny)
Posts: 594
Honorable Member
 

But if there were multiple installs then they would clash? :S


archive: dramione.org
site: accio.nu

Available for skin/mod commission! πŸ™‚

 
Posted : 24/06/2007 1:20 pm
(@carissa)
Posts: 791
Member Moderator
 

No they wouldn't. You can still set a table prefix for all the tables to separate them. It just doesn't have to be the same as the prefix for the settings table for that particular install.

If you are trying to set a prefix for those tables and it's not working, then there is something wrong. I think you do it in two separate places in the install. Does it ask you twice? 


 
Posted : 24/06/2007 1:50 pm
(@gokugirl)
Posts: 60
Trusted Member
 

I received the same error, and again even after I made sure not to give the settings table and the other tables the same prefix. The easiest way to fix this is to go into phpMyAdmin and delete the prefix from the settings table (edit the table, NOT empty it) then hit the back button to redo step 10. If you plan on running multiple copies of eFiction from the same database (or already are, unless the previous install has table prefixes) this is not a good idea. It's likely that you'll run into the same problem again.


- My eFiction Skins: http://www.gokugirl.com/efiction.php
- The Otaku Institute: http://oi.gokugirl.com
- The OI Same-Sex Archive: http://oisa.gokugirl.com
- The Dragon Ball Fanfiction Library: http://dbfl.gokugirl.com

 
Posted : 28/08/2007 7:00 pm
Share: