[jakesp69]

Hi guys i get this error message when i try and install my pre-made php script.

Database access error. Please contact the site administrator.
UPDATE PHPAUCTION_settings SET sitename='', siteurl='', adminmail=''
Access denied for user 'nobody'@'localhost' (using password: NO)

Now i know barely anything to do with php so cpuld someone please try and figure this out.
If you request to see one of the files source i will post it on here within 5 minutes.

Sorry if i dont give much information but as i said i am learning php and have no idea what this means.
I was just going by the instructions.

[digioz]

Looks like you have't set your user setting for your database connection. What the error message is saying is that there is no user called 'Nobody' for your local database. Just create a user with database read/write permission set the database info in the configuration file and try again.

[jakesp69]

Im on my phone at the moment but i have created a database on mysql. Now when i have to install the script i have to enter the db name and host and stuff. I found it quite weird when i put the wrong host in and it said that it couldnt find that db. So i found the right hostname and stuff and got through to the next step which is just where it compiles the config.php file. Then i dont know what the next step is ill find out in the morning but thats where it comes up with the error.

Do i have to do anything to the db or am i supposed to just leave it empty. It is confusing me to death.

And thanks for the reply.

[digioz]

There should be a username and password area in the configuration file. Set those and it should work.

[jakesp69]

Ok in the morning ill try it out and i will tell you the result. Thank you.

[jakesp69]

Ok i was looking at the config file for the script.

I couldnt find a username or password section so now i am really confused. I will post the source code of the config file:

Code:

<?
#///////////////////////////////////////////////////////
#//  Web2035 Auctions Revision 2005 - COPYRIGHT 2004 Phpauction.org ALL RIGHTS RESERVED//
#///////////////////////////////////////////////////////

#// ########################################################################################################
$PHPAUCTION_TESTMODE = 'no'; // Possible values: 'yes, 'no'		
#// ########################################################################################################

//-- This is the directory where passwd.inc.php file resides - requires ending slash

//-- DO NOT TOUCH THE LINES BELOW

$include_path = "@include_path@"; 

//-- This is the directory where users pictures will be uploaded - requires ending slash
//-- Under Windows use something like C:\path\to\you\uploaddir\

$image_upload_path = "@image_upload_path@"; 
$uploaded_path = "@uploaded_path@"; 


//-- This string is added to passwords before generating the MD5 hash
//-- Be sure to never change it after the firt set up or 
//-- your users passwords will not work
$MD5_PREFIX = "@MD5_PREFIX@";

/* DO NOT TOUCH THE LINES ABOVE

This is the log file generated by cron.php - insert the complete
file name (including the absolute path).
If you don't want to generate a log file for cron activity simply
leave this line commented. Change the path like above include path.
*/
#$logFileName = "/home/auction/public_html/auction/logs/cron.txt";
#$logFileName = "C:\path\to\cron.txt";
/*
Set this to TRUE if you want cron to generates HTML output
BESIDES the cron file declared above. cron.php cannot generates
only HTML output.
*/
$cronScriptHTMLOutput = FALSE;

//-- Seller's PayPal email address for fee payment in Winner's email
$ppemail = "deedeeweedee@gmail.com";

//-- Minimum Seller's Fee imposed on small sale amounts
$min_fee = 2.50;

//-- Seller's percentage Fee used in Fee calculations
$p_fee = .09;

//-- Thumbnail maximum width
$max = 85;

//-- Category pictures maximum width
$cat_width = 32;

//-- Item page picture's maximum width(400-600 recommended)
$picwidth = 600;

//-- Message Board Header/Footer Link Activation "1"=ON  "0"=OFF
//-- Message Board must be installed in /mboard directory
//-- Defult is OFF ("0")
$msgbd = 0;

//-- Forum Header/Footer Link Activation "1"=ON  "0"=OFF
//-- Forum must be installed in /forum directory
//-- Defult is OFF ("0")
$forumbd = 0;

//-- Index page 'Zoom' feature for thumbnails
//-- 1 - ON, 2 - OFF
//-- Defult is ON ("1")
$zoom = "1";

//-- Use the Proxy Auction
//-- 1 - ON (proxy auctions), 2 - OFF (NO proxy auctions)
//-- Default is ON ("1")
$prxy = "1";

//-- Index page Table background color
$tablebg = "#EEEEEE";

//-- The following "gradient" GIF files are supplied for the navigation and table bars:
//-- menubg1.gif (gradient light blue),menubg2,gif (green)
//-- menubg3.gif (wine-redish),menubg4.gif (lt blue-odd one),menubg5.gif (dark blue)
//-- menubg6.gif (light cream), menubg7.gif (light brown)
//-- You CAN mix and match in 3 areas below. We've used menubg1.gif at startup.
//-- Be aware that your nav and tableheader bar fonts have to be a color that will be seen!
//-- You can add your own images to the ROOT directory. Keep them under 24 px in height!
//-- If you don't use them, program defaults to Headercolors, Tablecolors you set in admin panel.

//-- Header navigation bar background image in root directory
$nav_bg = "menubg1.gif";

//-- Table header titles background image in root directory
$thead_bg = "menubg1.gif";

//-- Footer navigation bar background image in root directory
$ft_bg = "menubg1.gif";

//-- DO NOT TOUCH THE LINES BELOW
include $include_path."settings.inc.php";
include $include_path."messages.inc.php";
include $include_path."languages.inc.php";
?>

Ok if you need to see other files source code please tell me and i will show you.
Thanks

[digioz]

Take a look inside the file settings.inc.php to see if you have database login options there. It should be inside the includes folder.

[jakesp69]

Ok i opened up the file and im pretty sure its not in here. Unless its just a noob mistake i will post the source code underneath for settings.inc.php

Code:

<?#//v.2.5.2
/*=======================================================================
*																	  *
* Don't edit the code below unless you really know what you are doing  *
*																	  *
=======================================================================*/
//--
$password_file = $include_path."passwd.inc.php";
include($password_file);
//-- Database connection
if(!mysql_connect($DbHost,$DbUser,$DbPassword)) {
	$NOTCONNECTED = TRUE;
}
if(!mysql_select_db($DbDatabase)) {
	$NOTCONNECTED = TRUE;
}

session_start();

#// RETRIEVE SETTINGS AND CREATE SESSION VARIABLES FOR THEM
include $include_path."fonts.inc.php";
include $include_path."fontsize.inc.php";

$query = "select * from PHPAUCTION_settings";
$RES = @mysql_query($query);
if($RES) {
	$SETTINGS = mysql_fetch_array($RES);
	
	#// Rtrieve fonts and colors settings
	$query = "SELECT * FROM PHPAUCTION_fontsandcolors";
	$R__ = mysql_query($query);
	if($R__) {
		$FONTSANDCOLORS = mysql_fetch_array($R__);
		while(list($k,$v) = each($FONTSANDCOLORS)) {
			$SETTINGS[$k] = $v;
		}
	}
	
	$std_font = "<FONT FACE=".$FONTS[$SETTINGS["std_font"]]."
  					 SIZE=".$FONTSIZE[$SETTINGS["std_font_size"]]." 
  					 COLOR=".$SETTINGS["std_font_color"].">";
	if($SETTINGS["std_font_bold"] == 'y') {
		$std_font .= "<B>";
	} if($SETTINGS["std_font_italic"] == 'y') {
		$std_font .= "<I>";
	}
	$nav_font = "<FONT FACE=".$FONTS[$SETTINGS["nav_font"]]."
  					 SIZE=".$FONTSIZE[$SETTINGS["nav_font_size"]]." 
  					 COLOR=".$SETTINGS["nav_font_color"].">";
	if($SETTINGS["nav_font_bold"] == 'y') {
		$nav_font .= "<B>";
	}
	if($SETTINGS["nav_font_italic"] == 'y')	{
		$nav_font .= "<I>";
	}
	$footer_font = "<FONT FACE=".$FONTS[$SETTINGS["footer_font"]]."
  					 SIZE=".$FONTSIZE[$SETTINGS["footer_font_size"]]." 
  					 COLOR=".$SETTINGS["footer_font_color"].">";
	if($SETTINGS["footer_font_bold"] == 'y') {
		$footer_font .= "<B>";
	}
	if($SETTINGS["footer_font_italic"] == 'y') {
		$footer_font .= "<I>";
	}
	$tlt_font = "<FONT FACE=".$FONTS[$SETTINGS["tlt_font"]]."
  					 SIZE=".$FONTSIZE[$SETTINGS["tlt_font_size"]]." 
  					 COLOR=".$SETTINGS["tlt_font_color"].">";
	if($SETTINGS["tlt_font_bold"] == 'y') {
		$tlt_font .= "<B>";
	}
	if($SETTINGS["tlt_font_italic"] == 'y')	{
		$tlt_font .= "<I>";
	}
	$err_font = "<FONT FACE=".$FONTS[$SETTINGS["err_font"]]."
  					 SIZE=".$FONTSIZE[$SETTINGS["err_font_size"]]." 
  					 COLOR=".$SETTINGS["err_font_color"].">";
	if($SETTINGS["err_font_bold"] == 'y') {
		$err_font .= "<B>";
	}
	if($SETTINGS["err_font_italic"] == 'y') {
		$err_font .= "<I>";
	}
	$sml_font = "<FONT FACE=".$FONTS[$SETTINGS["sml_font"]]."
  					 SIZE=".$FONTSIZE[$SETTINGS["sml_font_size"]]." 
  					 COLOR=".$SETTINGS["sml_font_color"].">";
	if($SETTINGS["sml_font_bold"] == 'y') {
		$sml_font .= "<B>";
	}
	if($SETTINGS["sml_font_italic"] == 'y') {
		$sml_font .= "<I>";
	}
}
$_SESSION["SETTINGS"]=$SETTINGS;
$_SESSION["std_font"]=$std_font;

$query = "select * from PHPAUCTION_storesettings";
$RES_ = @mysql_query($query);
if($RES_ && mysql_num_rows($RES_)>0) {
	$STORESENABLED = mysql_result($RES_,0,"enabled");
} else {
	$STORESENABLED="n";
}
if(!isset($prefix)) $prefix="";
$_SESSION["STORESENABLED"]=$STORESENABLED;

include($include_path."currency.inc.php");

include($include_path."errors.inc.php");

#// Gian - sept 12 2002
include($include_path."https.inc.php");

?>

[digioz]

Take a look inside the file "includes/passwd.inc.php" for the database connection info as well (don't post the content here, as it would be a security risk). Also, I found this guide to the installation process of phpAuction script which may help you:

Tutorial: Manually install phpauction | Tom Slayer's blog

Pete