Corrupted data base...
 
Notifications
Clear all

Corrupted data base while trying to run a different program - SOLVED!!!!

4 Posts
3 Users
0 Reactions
1,167 Views
(@losille)
Posts: 40
Eminent Member
Topic starter
 

URL to your eFiction:[/b] http://cfmmusicscene.com/cfm
[b]Version of eFiction:
35
Have you bridged eFiction, if so with what?:[/b] No
Version of PHP: can be found out from your host 5.2.6
Version of MySQL: can be found out from your host 4.1.22-standard
Have you searched for your problem: (yes/no) yes
If so, what terms did you try:
over wrote mysql with another program
corrupted mysql
A fatal MySQL error was encountered.
ERROR: Failed to connect to the database!
State the nature of your problem: Copy and paste any errors you are receiving.

Everything was running fine.
I created a data base for a different program
Apparently I loaded the .sql file for the new program into efiction.
Efiction stopped working. This error came up.

A fatal MySQL error was encountered.
ERROR: Failed to connect to the database!

The database is there as well as all of the data.
I added the install file and got these errors:

Warning: include(version.php) [function.include]: failed to open stream: No such file or directory in /home/***/install/languages/en.php on line 2

Warning: include(version.php) [function.include]: failed to open stream: No such file or directory in /home/install/languages/en.php on line 2

Warning: include() [function.include]: Failed opening 'version.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /homeinstall/languages/en.php on line 2

Warning: include(../version.php) [function.include]: failed to open stream: No such file or directory in /home/upgrade11.php on line 124

Warning: include(../version.php) [function.include]: failed to open stream: No such file or directory in /home/install/upgrade11.php on line 124

Warning: include() [function.include]: Failed opening '../version.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/nstall/upgrade11.php on line 124

Warning: mysqli_connect() [function.mysqli-connect]: (28000/1045): Access denied for user '@'localhost' (using password: YES) in /home/aa962jp/public_html/***includes/mysqli_functions.php on line 7
A fatal MySQL error was encountered.
ERROR: Failed to connect to the database!

I found the reference to my php on line 7 but I couldn't figure it our.

I admit I am lost and I can't figure out how to get back to using my website.

Thanks in advance everyone here has always been very helpful and I do appreciate it.

Do you have a test account for us? NO


 
Posted : 09/04/2009 8:19 am
(@jacci)
Posts: 503
Honorable Member
 

have you tried dropping all the tables in the database and then importing a backup of your efiction tables, assuming you have a backup of them before they corrupted?


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 : 09/04/2009 8:54 am
(@tammy)
Posts: 2577
Member Moderator
 

Check your mysql users for the database.  It's not connecting so it's probably going to be a problem with your config.php file or some of the information in it.


 
Posted : 09/04/2009 11:11 am
(@losille)
Posts: 40
Eminent Member
Topic starter
 

I spent over an hour looking though the posts and really confused myself.

While falling asleep this morning I started running all the things I read through my mind and realized what I needed to do.  I got up and deleted my user name then reentered it with the correct password for the database. It came back immediately.

Thanks for your help.


 
Posted : 09/04/2009 5:41 pm
Share: