Thread: Database Access Error

Well folks, this one has been driving me nuts !!! I have been modifying the Dolphin code to remove all the dating info, and have come across this error when the user clicks on "Read Comments". I have been commenting out code such as Children, Occcupation, Description you, Descripton me, mostly to do with the profiles, searches, but nothing to do with "mail".

Warning: mail(): Bad parameters to mail() function, mail not sent.

I did not touch anything to do with mail.

Has anyone else come across this, and can maybe point me in the right direction. I know it's hard because you don't know what I have modified, but I just thought I'd throw this out there in case someone has come across the same situation. I'm almost done with the mod, other than the virtual kisses, (which look like a....well, lets just say it looks like a pain to get rid of them). Other than these, hopefully minor problems, I'll be good to go.

Thanks for any info.

Midnight

When you click on "Read Comments" - what is the URL that is generated - that is - what URL do you see next in your browsers address box?

Smoge

Thanks for the reply Smoge, the address is:

http://gogeorgetown.com/php_uploads/profile.php?ID=1

Thanks for the help

Not much I can do there... no comments listed...

Anyways - you can do it - and copy and paste the URL here that generates the actual error.

Smoge

Thanks again for the reply Smoge. Here's what I did. I created a new member (joe123). I log in and go to the control panel, click on "Read Comments" (I know that there are no comments loaded) and I get this:

Warning: mail(): Bad parameters to mail() function, mail not sent. in /home/content/m/i/d/midnight251/html/php_uploads/inc/db.inc.php on line 153

I'm not really sure what to make of it. The URL address in my browser is: http://gogeorgetown.com/php_uploads/profile.php?ID=2

What exactly is "Read Comments" anyway, and where do you enter said comments. Are these comments from other members?

I'm just trying to get this site bang on, so when the member clicks on something, the don't get any errors or warnings, etc. This will be strictly a community site for a small/mid size town, no dating info etc (still working on a few things, but one at a time).

Thanks for any help/info you can provide, and let me know if you require any more info regarding the above Warning message.

Mike

in db.inc.php - line 153 - thats part of the bug report email send function:

f

Code:

function db_arr( $query, $error_checking = 1  )
{
	global $BUG_REPORT_EMAIL;
	global $MySQL;
	global $site;	

	$res = mysql_query( $query, $MySQL->link  );
	if ( $error_checking && !$res )
	{
		if ( defined('NON_VISUAL_PROCESSING') && NON_VISUAL_PROCESSING == 'YES' )
			echo 'Database access error';
		else
			echo PrintErr( 'Database access error' );
		mail( $BUG_REPORT_EMAIL, $site['url'] . "\nError", "Error in $_SERVER[PHP_SELF]: " . mysql_error() . "\nQuery: '$query'" );
		exit;	
	}
	$arr = mysql_fetch_array( $res );
	return $arr;
}

So - it appears your site has a DB error - but it can not be sent to you because of an email problem.

Are you on a windows or linux server?

As for seeing the DB error (since you cant get the mail right now), you could try changing (but change it back later)

Code:

	else
			echo PrintErr( 'Database access error' );

to

Code:

	else {
			echo PrintErr( 'Database access error' );
                        echo $query;
              }

Smoge

Wow, thanks for the quick response, man that was fast. I am on a Linux server. Thanks for the info, I'll try it, and let you know how it goes. Again, thanks for the quick response, (and by the way, that's the fastest response I've had on any help forum, and over the years, I've been on a few).

Thanks again

Mike

I am new and i installed succesfuly dolphin 5.5 but i am getting and error . "Database access error" when trying to wiew a profile. Can anybody help me ?

Originally Posted by Smoge

in db.inc.php - line 153 - thats part of the bug report email send function:

f

Code:

function db_arr( $query, $error_checking = 1  )
{
	global $BUG_REPORT_EMAIL;
	global $MySQL;
	global $site;	

	$res = mysql_query( $query, $MySQL->link  );
	if ( $error_checking && !$res )
	{
		if ( defined('NON_VISUAL_PROCESSING') && NON_VISUAL_PROCESSING == 'YES' )
			echo 'Database access error';
		else
			echo PrintErr( 'Database access error' );
		mail( $BUG_REPORT_EMAIL, $site['url'] . "\nError", "Error in $_SERVER[PHP_SELF]: " . mysql_error() . "\nQuery: '$query'" );
		exit;	
	}
	$arr = mysql_fetch_array( $res );
	return $arr;
}

So - it appears your site has a DB error - but it can not be sent to you because of an email problem.

Are you on a windows or linux server?

As for seeing the DB error (since you cant get the mail right now), you could try changing (but change it back later)

Code:

	else
			echo PrintErr( 'Database access error' );

to

Code:

	else {
			echo PrintErr( 'Database access error' );
                        echo $query;
              }

Smoge

Yes I added these codes in db.inc.

I am new installed dolphin 5.5 on windows server (localhost). And database seems good (there are 96 tables). I properly set database name, password and other info when installing dolphin. However when I try to join as a new member, I see this error:

Error
Database access error

INSERT INTO `Profiles` SET `ProfileType` = 'single', `NickName` = 'testuser', `RealName` = '', `Sex` = 'female', `Country` = '', `City` = '', `zip` = '', `Children` = '', `WhereChildren` = '', `DateOfBirth` = '--', `Height` = '', `BodyType` = '', `Ethnicity` = '', `Religion` = '', `MaritalStatus` = '', `Occupation` = '', `Language1` = '', `Language2` = '', `Language3` = '', `Education` = '', `Income` = '', `Smoker` = '', `Drinker` = '', `Headline` = 'nah', `DescriptionMe` = 'sddsssssssssssssssssssssssssssssssssssddsssssssss ssssssssssssssssssssssssddssssssssssssssssssssssss sssssssssddsssssssssssssssssssssssssssssssssddssss sssssssssssssssssssssssssssssddsssssssssssssssssss ssssssssssssssddsssssssssssssssssssssssssssssssssd dssssssssssssssssssssssssssssssss', `Email` = 'mail@test.com', `EmailFlag` = '', `EmailNotify` = '', `HomePage` = '', `Phone` = '', `HomeAddress` = '', `IM` = '', `IcqUIN` = '', `Password` = 'passtest', `LookingFor` = '', `LookingAge` = '-', `LookingHeight` = '', `LookingBodyType` = '', `Relationship` = '', `DescriptionYou` = '', `LastReg` = NOW(), `seed` = 5355

Please help us...

Originally Posted by RICHY

Yes I added these codes in db.inc.

Database access error

INSERT INTO `Profiles` SET `ProfileType` = 'single', `NickName` = 'testuser', `RealName` = '', `Sex` = 'female', `Country` = '', `City` = '', `zip` = '', `Children` = '', `WhereChildren` = '', `DateOfBirth` = '--', `Height` = '', `BodyType` = '', `Ethnicity` = '', `Religion` = '', `MaritalStatus` = '', `Occupation` = '', `Language1` = '', `Language2` = '', `Language3` = '', `Education` = '', `Income` = '', `Smoker` = '', `Drinker` = '', `Headline` = 'nah', `DescriptionMe` = 'sddsssssssssssssssssssssssssssssssssssddsssssssss ssssssssssssssssssssssssddssssssssssssssssssssssss sssssssssddsssssssssssssssssssssssssssssssssddssss sssssssssssssssssssssssssssssddsssssssssssssssssss ssssssssssssssddsssssssssssssssssssssssssssssssssd dssssssssssssssssssssssssssssssss', `Email` = 'mail@test.com', `EmailFlag` = '', `EmailNotify` = '', `HomePage` = '', `Phone` = '', `HomeAddress` = '', `IM` = '', `IcqUIN` = '', `Password` = 'passtest', `LookingFor` = '', `LookingAge` = '-', `LookingHeight` = '', `LookingBodyType` = '', `Relationship` = '', `DescriptionYou` = '', `LastReg` = NOW(), `seed` = 5355

Please help us...

I cant find any syntax error from the above SQL Query.

Try to add more debug information do this :

else
{
echo PrintErr( 'Database access error' );
echo "SQL ERROR : ".mysql_error()." QUERY : ".$query;
}