Forum

Notifications
Clear all

Cannot Connect to the Database

Lexi Nesmith
(@lexi-nesmith)
Active Member

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

Quote
Topic starter Posted : 08/04/2014 3:03 pm
SJP
 SJP
(@sjp)
Trusted Member

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

ReplyQuote
Posted : 11/04/2014 5:27 pm
Lexi Nesmith
(@lexi-nesmith)
Active Member

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: ()

ReplyQuote
Topic starter Posted : 12/04/2014 11:39 pm
SJP
 SJP
(@sjp)
Trusted Member

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

ReplyQuote
Posted : 14/04/2014 12:12 am
Lexi Nesmith
(@lexi-nesmith)
Active Member

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

ReplyQuote
Topic starter Posted : 14/04/2014 3:20 am
Lexi Nesmith
(@lexi-nesmith)
Active Member

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

ReplyQuote
Topic starter Posted : 15/04/2014 3:45 am
Lyndsie
(@lyndsie)
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?

ReplyQuote
Posted : 01/05/2014 8:16 am
Share: