Notifications
Clear all

Cannot Connect to the Database

7 Posts
3 Users
0 Reactions
3,451 Views
(@lexi-nesmith)
Posts: 13
Active Member
Topic starter
 

URL to your eFiction: manorfiction.monkeemanor.net
Version of eFiction: 3.5.3
Have you bridged eFiction, if so with what?: No
Version of PHP: 5.5
Version of MySQL: 3.5.8.2
Have you searched for your problem: (yes/no)
If so, what terms did you try: cannot connect to database, configuration setup, mysql_connect()
State the nature of your problem:

I attempted to upgrade my fiction archive to the newest version. At first I had successfully upgraded my settings, but then my welcome message and all of my stats disappeared. Then, I made the mistake of logging out of my account, and I kept getting a "do not have permission" error to login to my account. Then, I attempted to delete everything from my web server, except for my stories folder and skins folder, and reinstalled everything in the efiction 3.5.3 folder. Now I'm getting this database error. Please help!

Warning: mysql_connect(): No such file or directory in /misc/32/397/896/298/6/user/web/manorfiction.monkeemanor.net/install/install.php on line 903
Cannot connect to the database. The information you supplied appears to be incorrect. Please try again.

Do you have a test account for us? no

 
Posted : 08/04/2014 9:03 am
 SJP
(@sjp)
Posts: 66
Trusted Member
 

I'm not sure if this will help, but did you update the config.php file with your database information?

 
Posted : 11/04/2014 11:27 am
(@lexi-nesmith)
Posts: 13
Active Member
Topic starter
 

At this point, I'm just trying to do a completely new installation. I'm getting stuck at this error:

A fatal MySQL error was encountered.
Query: CREATE TABLE IF NOT EXISTS`settingsfanfiction_settings` ( `sitekey` varchar(50) NOT NULL default '1', `sitename` varchar(200) NOT NULL default 'Your Site', `slogan` varchar(200) NOT NULL default 'It''s a cool site!', `url` varchar(200) NOT NULL default ' http://www.yoursite.com', `siteemail` varchar(200) NOT NULL default 'you@yoursite.com', `tableprefix` varchar(50) NOT NULL default '', `skin` varchar(50) NOT NULL default 'default', `hiddenskins` varchar(255) default '', `language` varchar(10) NOT NULL default 'en', `submissionsoff` tinyint(1) NOT NULL default '0', `storiespath` varchar(20) NOT NULL default 'stories', `store` varchar(5) NOT NULL default 'files', `autovalidate` tinyint(1) NOT NULL default '0', `coauthallowed` int(1) NOT NULL default '0', `maxwords` int(11) NOT NULL default '0', `minwords` int(11) NOT NULL default '0', `imageupload` tinyint(1) NOT NULL default '0', `imageheight` int(11) NOT NULL default '200', `imagewidth` int(11) NOT NULL default '200', `roundrobins` tinyint(1) NOT NULL default '0', `allowseries` tinyint(4) NOT NULL default '2', `tinyMCE` tinyint(1) NOT NULL default '0', `allowed_tags` varchar(200) NOT NULL default '

', `favorites` tinyint(1) NOT NULL default '0', `multiplecats` tinyint(1) NOT NULL default '0', `newscomments` tinyint(1) NOT NULL default '0', `logging` tinyint(1) NOT NULL default '0', `maintenance` tinyint(1) NOT NULL default '0', `debug` tinyint(1) NOT NULL default '0', `captcha` tinyint(1) NOT NULL default '0', `dateformat` varchar(20) NOT NULL default 'd/m/y', `timeformat` varchar(20) NOT NULL default '- h:i a', `recentdays` tinyint(2) NOT NULL default '7', `displaycolumns` tinyint(1) NOT NULL default '1', `itemsperpage` tinyint(2) NOT NULL default '25', `extendcats` tinyint(1) NOT NULL default '0', `displayindex` tinyint(1) NOT NULL default '0', `defaultsort` tinyint(1) NOT NULL default '0', `displayprofile` tinyint(1) NOT NULL default '0', `linkstyle` tinyint(1) NOT NULL default '0', `linkrange` tinyint(2) NOT NULL default '5', `reviewsallowed` tinyint(1) NOT NULL default '0', `ratings` tinyint(1) NOT NULL default '0', `anonreviews` tinyint(1) NOT NULL default '0', `revdelete` tinyint(1) NOT NULL default '0', `rateonly` tinyint(1) NOT NULL default '0', `pwdsetting` tinyint(1) NOT NULL default '0', `alertson` tinyint(1) NOT NULL default '0', `disablepopups` tinyint(1) NOT NULL default '0', `agestatement` tinyint(1) NOT NULL default '0', `words` text, `version` varchar(10) NOT NULL default '3.5.3', `smtp_host` varchar(200) default NULL, `smtp_username` varchar(50) default NULL, `smtp_password` varchar(50) default NULL, PRIMARY KEY (`sitekey`) ) SEARCH=MyISAM;
Error: ()

 
Posted : 12/04/2014 5:39 pm
 SJP
(@sjp)
Posts: 66
Trusted Member
 

There's an issue with the install.php file in the download for 3.5.3. See this post for a fix: https://efiction.org/forums/index.php?topic=8470.0

 
Posted : 13/04/2014 6:12 pm
(@lexi-nesmith)
Posts: 13
Active Member
Topic starter
 

I downloaded the corrected file, and I'm still having the same issue.

 
Posted : 13/04/2014 9:20 pm
(@lexi-nesmith)
Posts: 13
Active Member
Topic starter
 

This is the latest error when I try to go to the corrected install.php file located in the forum you linked me to:

Warning: include(../includes/class.TemplatePower.inc.php): failed to open stream: No such file or directory in /misc/32/397/896/298/6/user/web/manorfiction.monkeemanor.net/install.php on line 102

Warning: include(../includes/class.TemplatePower.inc.php): failed to open stream: No such file or directory in /misc/32/397/896/298/6/user/web/manorfiction.monkeemanor.net/install.php on line 102

Warning: include(): Failed opening '../includes/class.TemplatePower.inc.php' for inclusion (include_path='.:/usr/share/pear') in /misc/32/397/896/298/6/user/web/manorfiction.monkeemanor.net/install.php on line 102

Warning: include(../languages/en.php): failed to open stream: No such file or directory in /misc/32/397/896/298/6/user/web/manorfiction.monkeemanor.net/install.php on line 105

Warning: include(../languages/en.php): failed to open stream: No such file or directory in /misc/32/397/896/298/6/user/web/manorfiction.monkeemanor.net/install.php on line 105

Warning: include(): Failed opening '../languages/en.php' for inclusion (include_path='.:/usr/share/pear') in /misc/32/397/896/298/6/user/web/manorfiction.monkeemanor.net/install.php on line 105

Warning: include(../languages/en_admin.php): failed to open stream: No such file or directory in /misc/32/397/896/298/6/user/web/manorfiction.monkeemanor.net/install.php on line 106

Warning: include(../languages/en_admin.php): failed to open stream: No such file or directory in /misc/32/397/896/298/6/user/web/manorfiction.monkeemanor.net/install.php on line 106

Warning: include(): Failed opening '../languages/en_admin.php' for inclusion (include_path='.:/usr/share/pear') in /misc/32/397/896/298/6/user/web/manorfiction.monkeemanor.net/install.php on line 106

Warning: include(../includes/corefunctions.php): failed to open stream: No such file or directory in /misc/32/397/896/298/6/user/web/manorfiction.monkeemanor.net/install.php on line 132

Warning: include(../includes/corefunctions.php): failed to open stream: No such file or directory in /misc/32/397/896/298/6/user/web/manorfiction.monkeemanor.net/install.php on line 132

Warning: include(): Failed opening '../includes/corefunctions.php' for inclusion (include_path='.:/usr/share/pear') in /misc/32/397/896/298/6/user/web/manorfiction.monkeemanor.net/install.php on line 132

Fatal error: Class 'TemplatePower' not found in /misc/32/397/896/298/6/user/web/manorfiction.monkeemanor.net/install.php on line 137

 
Posted : 14/04/2014 9:45 pm
(@lyndsie)
Posts: 1263
Member Moderator
 

It's not finding a file at the path root/includes/class.TemplatePower.inc.php. Assuming you are not missing this file in the includes folder, then it might be because it looks like your install file is at the root instead of in the install folder. Possibly the install file is trying to navigate to the TemplatePower file and can't find it because the install file itself isn't where it expects to be.

So, assuming you aren't missing the class.TemplatePower.inc.php file, then trying moving install.php inside the install folder?

 
Posted : 01/05/2014 2:16 am
Share: