Problem installatio...
 
Notifications
Clear all

Problem installation

42 Posts
7 Users
0 Reactions
7,910 Views
(@jacci)
Posts: 503
Honorable Member
 

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

 
Posted : 26/03/2007 11:58 am
(@titipotter)
Posts: 24
Eminent Member
Topic starter
 

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.


 
Posted : 26/03/2007 12:06 pm
(@babaca)
Posts: 722
Member Moderator
 

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

 
Posted : 26/03/2007 1:03 pm
(@titipotter)
Posts: 24
Eminent Member
Topic starter
 

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.


 
Posted : 26/03/2007 1:42 pm
(@titipotter)
Posts: 24
Eminent Member
Topic starter
 

😥


 
Posted : 28/03/2007 11:42 am
(@titipotter)
Posts: 24
Eminent Member
Topic starter
 

😥


 
Posted : 29/03/2007 5:49 pm
(@carissa)
Posts: 791
Member Moderator
 

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.


 
Posted : 29/03/2007 7:01 pm
(@titipotter)
Posts: 24
Eminent Member
Topic starter
 

OK, I go creer tables manually.


 
Posted : 31/03/2007 3:28 pm
(@titipotter)
Posts: 24
Eminent Member
Topic starter
 

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


 
Posted : 31/03/2007 4:14 pm
(@carissa)
Posts: 791
Member Moderator
 

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.


 
Posted : 31/03/2007 7:00 pm
(@titipotter)
Posts: 24
Eminent Member
Topic starter
 

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'


 
Posted : 01/04/2007 7:49 pm
(@carissa)
Posts: 791
Member Moderator
 

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.


 
Posted : 01/04/2007 11:20 pm
(@titipotter)
Posts: 24
Eminent Member
Topic starter
 

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)


 
Posted : 02/04/2007 10:49 am
(@chelle)
Posts: 122
Estimable Member
 

sounds like it doesn't have the user and password information for your database


 
Posted : 02/04/2007 10:59 am
(@titipotter)
Posts: 24
Eminent Member
Topic starter
 

How can it be done?


 
Posted : 02/04/2007 11:06 am
Page 2 / 3
Share: