_FATALERRORQuery: SELECT * FROM fanfiction_settings WHERE sitekey = 'MwE4xJRnSW'
Error: (1046) No database selected
Hello, first off I'm very new to this kind of thing. I'm sitting here at my desk at work trying to figure out what in Gods name did I do wrong. I finially was able this morning to install efiction to my site:
http://fiction.shadowgalleryonline.net
After I put in the information it needed to start the install, this is what came up:
_FATALERRORQuery: SELECT * FROM fanfiction_settings WHERE sitekey = 'MwE4xJRnSW'
Error: (1046) No database selected
I read through the forums, but didn't see anything like this so I thought to post a new thread in hopes that someone would be able to help a newbie out. Any information is welcomed... Thanks!
Edit to add: It would help if I told you which one I was installing 3.50, I believe it's the new one that's been released here at this site.
Are you sure you set up the MySQL database? You might want to double check and just be sure.
My Site:
eFiction: v3.4.3
PHP: 5.2.6
MySQL: 5.0.45-community
Mods: Challenges, Submit Time and Word Count
So you uploaded all the files and saw Step 1 of the installation? And you entered the proper information for your database?
This wiki page might be helpful: https://efiction.org/wiki/index.php5?title=Installing_3.0
Thanks for that link, I printed it out and also read the "ReadMe" text as well. I also then decided to reinstall it just incase I missed something.
So now I've got another or the same warning, it seems that I have no clue as to what to do at this point.
Here is what I've gotten:
Warning: main(version.php): failed to open stream: No such file or directory in /home/content/s/k/e/skeller1980/html/fiction/install/languages/en.php on line 2
Warning: main(): Failed opening 'version.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/content/s/k/e/skeller1980/html/fiction/install/languages/en.php on line 2
A fatal MySQL error was encountered.
Query: SHOW TABLES LIKE 'fanfiction_settings'
Error: (1046) No database selected
Then once I removed the install folder from my site, I receive another issue:
_FATALERRORQuery: SELECT * FROM fanfiction_settings WHERE sitekey = 'L8GHeizAqc'
Error: (1046) No database selected
What does this mean? What am I missing? I know it the same error from first post, but I have no idea how to do this.
Thanks for that link, I printed it out and also read the "ReadMe" text as well. I also then decided to reinstall it just incase I missed something.
So now I've got another or the same warning, it seems that I have no clue as to what to do at this point.
Here is what I've gotten:
Warning: main(version.php): failed to open stream: No such file or directory in /home/content/s/k/e/skeller1980/html/fiction/install/languages/en.php on line 2
Warning: main(): Failed opening 'version.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/content/s/k/e/skeller1980/html/fiction/install/languages/en.php on line 2
A fatal MySQL error was encountered.
Query: SHOW TABLES LIKE 'fanfiction_settings'
Error: (1046) No database selectedSee this, it's a 'bug'.
Then once I removed the install folder from my site, I receive another issue:
_FATALERRORQuery: SELECT * FROM fanfiction_settings WHERE sitekey = 'L8GHeizAqc'
Error: (1046) No database selectedWhat does this mean? What am I missing? I know it the same error from first post, but I have no idea how to do this.
It means that there was an error connecting to your database, most likely that your settings in config.php are incorrect.
Thanks for that link, I printed it out and also read the "ReadMe" text as well. I also then decided to reinstall it just incase I missed something.
So now I've got another or the same warning, it seems that I have no clue as to what to do at this point.
Here is what I've gotten:
Warning: main(version.php): failed to open stream: No such file or directory in /home/content/s/k/e/skeller1980/html/fiction/install/languages/en.php on line 2
Warning: main(): Failed opening 'version.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/content/s/k/e/skeller1980/html/fiction/install/languages/en.php on line 2
A fatal MySQL error was encountered.
Query: SHOW TABLES LIKE 'fanfiction_settings'
Error: (1046) No database selectedSee this, it's a 'bug'.
Then once I removed the install folder from my site, I receive another issue:
_FATALERRORQuery: SELECT * FROM fanfiction_settings WHERE sitekey = 'L8GHeizAqc'
Error: (1046) No database selectedWhat does this mean? What am I missing? I know it the same error from first post, but I have no idea how to do this.
It means that there was an error connecting to your database, most likely that your settings in config.php are incorrect.
Okay, then how do I fix that? My hosting site is godaddy, the set ups that I'm finding while reading how to set this up is different from theirs (or maybe I have no clue what I'm seeing). How do I fix this?
You need to make sure that your settings are correct. Have you verified this? Don't tell us what they are here (for security), but you're absolutely positively sure that you have the right hostname, database name, database username, and database password?
A browse through Go Daddy's support forum shows me that you should have access to your MySQL databases and be able to set them up/verify them yourself. Some useful support topics:
Setting up a MySQL database: http://help.godaddy.com/article/36
Finding your hostname: http://help.godaddy.com/article/39
At the eFic wiki, about setting up databases.
If you're sure your database is set up correctly, note this section of the wiki (from the last link above):
Note the database and user names: Most of the time, your webhost user name is prefixed to the name of the database. When entering your database name and user, enter them just as they are listed on your database page even if that's not exactly how you created them. So for example, say you use the username Bob7 to log in to your cPanel. Then, you create a MySQL database called "stuff" and a MySQL username called "user7". Your database name would most likely be bob7_stuff and your username bob7_user7, and this will be reflected in the list of current databases.
I'm a little concerned you said you had removed the install folder even though you were getting the database connection error, because I don't know that your database tables would have been created if the script couldn't access your database (unless maybe it's intermittent?). You should look in the databse through PHPMyAdmin or whatever other tool your host provides to see if there are tables in your database. There are something like 17 steps in the install process, most of which deal with creating and populating the tables.
