Have you created a database in the mysql area of your domain?
_FATALERRORQuery: SELECT * FROM hpfanfictions_fanfiction_settings WHERE sitekey = '22081986'
Error: (1146) Table 'hpfanfictions.hpfanfictions_fanfiction_settings' doesn't exist
and there seems to be something up with the settings table prefix too in that error message.
why is nothing ever easy?
url: http://www.pretendercentre.com/missingpieces/
php: 5.2.5 msql: 5.0.45-community
efic version: 3.4.3 latest patches: yes
bridges: none mods: challenges, displayword, beta-search
Yes, I settled everything and everything creates with phpMyAdmin.
But it is necessary not to take into account of:
_FATALERRORQuery: SELECT * FROM hpfanfictions_fanfiction_settings WHERE sitekey = '22081986'
Error: (1146) Table 'hpfanfictions.hpfanfictions_fanfiction_settings' doesn't exist
Because no table is create seen that I block in the stage 2 after the writing in config.php.
Thus I cannot creer tables and make the rest of the installation.
Looking at this part "hpfanfictions.hpfanfictions_fanfiction_settings" It looks like you keep adding hpfanfictions in the set up somewhere (as a prefix maybe)? You do have a mysql database already set up, yes? And you have the correct user name and password to them? Is this an upgrade or a new install? When I had trouble with the upgrade it wanted a prefix which I wasn't using in my previous 2.x version. I just typed in 'main' in the prefix and the install went through. On my myPHPAdmin table there's only one instance where the prefix main is in it...
You might go into myPHPAdmin, and look to see what tables you have. If you have one with hpfanfictions_fanfiction_setings and one that says hpfanfiction.hpfanfiction_fanfiction_settings I would get rid of one of those and stick with the one you want to use. Then try the install again.
******************************************
Mucking around in eFiction since circa 2001 (ver. 1.0)
Now running v.3
All my data mysql are correct because they are accepted and registered in config.php.
Otherwise I would have had an error message saying that it is impossible to connect me to the database; but it is not the case.
Yes, I make a new installation and no table is create in my database hpfanfiction.
😥
😥
There isn't much we can do to help you. You've got something wrong with your install, particularly your settings table.
Look here at your error message.
_FATALERRORQuery: SELECT * FROM hpfanfictions_fanfiction_settings WHERE sitekey = '22081986'
Error: (1146) Table 'hpfanfictions.hpfanfictions_fanfiction_settings' doesn't exist
The first thing efiction does is create the settings table and it appears yours wasn't set up properly. If you have access to phpMyAdmin, you might want to try completely deleting your tables and starting over.
If no one replies to your posts, it's because we don't know what's wrong. We're not being mean or ignoring you.
OK, I go creer tables manually.
I tried the manual installation of tables but I have this message : "Maintenance"
http://www.harrypotterfanfictions-france.com/
Somebody they could supply me néccéssaires tables.
Thank you
Your site is in maintenance mode. Log in and change it in the admin panel. I think it's on the first page under settings. It looks like your tables installed ok.
I have no links of the administration / admin panel.
I am not an administrator by default.
How to become an administrator and remove the maintenance from tables sql ?
and this message for skin "elegance"
A fatal MySQL error was encountered.
Query: SELECT nid, author, title, story, UNIX_TIMESTAMP(time) as date, comments FROM fanfiction_news ORDER BY time DESC LIMIT 1
Error: (1054) Unknown column 'comments' in 'field list'
When you set up your site, what did you enter for your username and password during the install? Log in as that user and turn off maintenance mode.
I preferred installed the version 2.x of Efiction, the installation took place well but for the update, I have to keep(guard) even tables sql because in that case I have this error:
A fatal MySQL error was encountered.
Query: DROP TABLE IF EXISTS testfanfiction_settings
Error: (1045) Access denied for user 'apache'@'localhost' (using password: NO)
sounds like it doesn't have the user and password information for your database

How can it be done?
