URL to your eFiction: http://www.sinful-dreams.com/haunted/fic/index.php
Version of eFiction: 3.5.1
Have you bridged eFiction, if so with what?: No
Version of PHP: 5.2.5
Version of MySQL: 5.0.75
Have you searched for your problem: Yes
If so, what terms did you try: log in, log in and out, log out, dbfunctions.php on line 2
State the nature of your problem: Can not log into the site, had a hard time logging out. (See errors below)
Do you have a test account for us? Yes, user name: test
user password: test123
Errors received after log in attempt:
Warning: include_once(_BASEDIRincludes/mysqli_functions.php) [function.include-once]: failed to open stream: No such file or directory in /home4/sinfuldr/public_html/haunted/fic/includes/dbfunctions.php on line 2
Warning: include_once() [function.include]: Failed opening '_BASEDIRincludes/mysqli_functions.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home4/sinfuldr/public_html/haunted/fic/includes/dbfunctions.php on line 2
Fatal error: Call to undefined function dbconnect() in /home4/sinfuldr/public_html/haunted/fic/config.php on line 10
One of my users/admins reported that they were unable to log into the site and that I had trouble logging out (so I could see what was happening and try to fix it) and finally managed it only to not be able to log back in again.
I had thought the upgrade from 3.2 went well, the only other thing that I had a major problem with was my categories, warnings, genres not being accessible after upgrade.
I ended up deleting those and adding in new, which worked fine, and updating all my stories, which there was only about 40 of, so I didn't worry about it.
I've checked the dbfunctions.php file and all the table info and passwords seem to be correct, I have no clue where to look now.
Any help with this would be much appreciated.
What it's saying is that the file includes/mysqli_functions.php is missing. Is this true, or is it really there?
it's there, at least my file manager says it's there, lol
this is what it has in that file....
mysqli_functions.php
PHP script text
--------------------------------------------------------------------------------<?php
// Some DB functions
if(!function_exists("dbconnect")) { // just in case. Some people seemed to be having an issue and this was the easiest fix.function dbconnect($dbhost, $dbuser, $dbpass, $dbname ) {
$mysql_access = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
if(!$mysql_access) {
include(_BASEDIR."languages/en.php"); // Because we haven't got a language set yet.
die(_FATALERROR." "._NOTCONNECTED);
}
return $mysql_access;
}function dbquery($query) {
global $debug, $headerSent, $dbconnect;
if($debug && $headerSent) echo "<!-- $query -->n";
$result = mysqli_query($dbconnect, $query) or die( _FATALERROR."Query: ".$query."<br />Error: (".mysqli_errno( $dbconnect ).") ".mysqli_error( $dbconnect ));
return $result;
}function dbnumrows($query) {
global $debug, $dbconnect;
if ($query === false && $debug) {
echo "<!-- dbnumrows ".mysqli_error( $dbconnect )." -->n";
}
$query = mysqli_num_rows($query);
return $query;
}function dbassoc($query) {
global $debug, $dbconnect;
if ($query === false && $debug) {
echo "<!-- dbassoc ".mysqli_error( $dbconnect )." -->n";
}
$query = mysqli_fetch_assoc($query);
return $query;
}function dbinsertid($tablename = 0) {
global $dbconnect;
return mysqli_insert_id( $dbconnect );
}function dbrow($query) {
global $debug, $dbconnect;
if ($query === false && $debug) {
if($error) echo "<!-- dbrow ".mysql_errori( $dbconnect )." -->n";
}
$query = mysqli_fetch_array($query);
return $query;
}function dbclose() {
global $dbconnect;
mysqli_close( $dbconnect );
}// Used to escape text being put into the database.
function escapestring($str) {
global $dbconnect;
return mysqli_real_escape_string($dbconnect, $str);
}// End DB functions
}
?>
I would upload a fresh copy of mysqli_functions.php in your includes folder to replace it. Sometimes it helps especially if the original file in the database got corrupted somehow.
******************************************
Mucking around in eFiction since circa 2001 (ver. 1.0)
Now running v.3
I would upload a fresh copy of mysqli_functions.php in your includes folder to replace it. Sometimes it helps especially if the original file in the database got corrupted somehow.
I tried that twice actually, with no results.
Thanks for trying to help.
Maybe it might have to do with file permissions. What are mysqliconnect.php and config.php set to?
Config file settings:
<?php
$dbhost = "localhost";
$dbname = "xxxx"; <--- this is correct but also a password for my sites, so I xxxx'd it out
$dbuser= "xxxx"; <--- this is correct but also a password for my sites, so I xxxx'd it out
$dbpass = "xxxxx" <--- this is correct but also a password for my sites, so I xxxx'd it out
$sitekey = "kHVNSg6i8v";
$settingsprefix = "settings";include_once("includes/dbfunctions.php");
if(!empty($sitekey)) $dbconnect = dbconnect($dbhost, $dbuser,$dbpass, $dbname);?>
I cannot find a file named: mysqliconnect.php or is this part of a different file?
I have one named mysql_functions.php and one called mysqli_functions.php
Eh, my bad. I meant mysqli_functions.php. I'm apparently full of fail on my last post, because I meant to ask what are they CHMODed to.
(Also, you may not want to show your database name and user like that either. I'm always super paranoid about that kind of stuff.)
lol, no prob....by the way, i xxxx'd out that info above.
mysqli is set to 644
config is set to 644
Both of mine are set to 755. You might try that and see if it helps.
Nope, didn't help, lol
Also, just checked out your site, it's great! I totally fell in love with your Photobooth3 skin. I'm also extremely jealous of your skin(s) based on Elegance, I have no luck adding anything to that skin (other than changing colors) and I'm not sure why.
Thank for trying to help though!
It's not looking in the right place. The script is leaving out a slash between _BASEDIR and the foldername. You might try editing your settings to add a slash on the end of your site url. I don't' know if that will mess anything up though, but it should allow you to log in at least. (You'll probably have to edit this directly in your database.)
It's not looking in the right place. The script is leaving out a slash between _BASEDIR and the foldername. You might try editing your settings to add a slash on the end of your site url. I don't' know if that will mess anything up though, but it should allow you to log in at least. (You'll probably have to edit this directly in your database.)
okay, i'll try that, where in my database do I edit that?
i'm looking at my database and it has a bunch of files
fanfiction_blocks
fanfiction_modules
and lots of others, am I in the right place? Just don't wannna mess anythng up more than it is, lol
Thanks again
She may be talking about Admin > Settings, and then the field Site URL. (Which does correspond to a field in fanfiction_settings.)
still no luck guys.
Changed the site name, added the / but didn't help.
I might have to just start over with the site, I've only got 44 stories on there.
So it wouldn't be horrible to reload and I can make a whole new site and just copy and paste (at least the ones that aren't rated members only) and just copy all my welcome/footer/etc. stuff over from the old. And all my skins are ready to be upload.
I don't know what else to do.
Thanks again to everyone who tried to help!
