script needing fixing.

[daydie2008]

Can any of you kind peeps solve my mistery.

I have a script called utopSites had it a while, but now it wont work for some reason, i uplaod all files and backup database.

but i get:

[B]Internal Server Error[/B]
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, [e-mail] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

I found out this was due to the .htaccess so i renamed it so it doesnt work and then i backed up the database.

After backing up the database i get the following error:

[B]Fatal error: Cannot access empty property in /home/content/d/a/y/daydie/html/TopList/admin/lib/db_mysql.php on line 129[/B]

I cannot run the setup.php file for auto install it just says Setup at the top and script dont work.

Download to files:
http://rapidshare.com/files/264089094/uTopSites_v1_5_1.rar

Cheers, Hope you can help me, download the files and try for yourself, if u can fix this it would be really helpfull. maybe a lil thank you reward.

Any ideas guys,

[daydie2008]

Anyone please?..........

[Bjom]

home/content/d/a/y/daydie/html/TopList/admin/lib/db_mysql.php on line 129

what is inside the file db_mysql.php? what is on line 129 of that file?

[daydie2008]

function query_once($query_string)
{
$this->query($query_string);
$get = $this->fetch_array($this->query_id);
$this->free_result($this->$query_id);
return $get;
}

[daydie2008]

thank you for trying to help me btw

[Bjom]

yeah. so there is a reference to another function or property (most likely the latter)... why not post enough code for us to actually have a chance finding the error? This is not a quiz show.

Apparently a value is missing - why? Review your code and find out where it is being set.

[daydie2008]

Im no good at coding buddy.

heres the full file that has error:

<?php

class sqldb {
	var $scriptname = ""; //nama script ni


var $user="";
var $pass="";
var $server="";
var $database="";

var $query_id = 0; // query id
var $query_counter = 0;
var $link_id = 0;
var $use_persistent = "0";

var $insert_into = "";
var $insert_data = array();
/* ----------------------------------------------------------- */
function start($server,$user,$password,$database)
{
  $this->server   = $server;
  $this->user     = $user;
  $this->pass = $password;
  $this->database = $database;

  $this->connect();
}

function connect()
{

	if ($this->use_persistent == 0)
	{
		$this->link_id = mysql_connect($this->server,$this->user,$this->pass);
	}
	else
	{
		$this->link_id = mysql_pconnect($this->server,$this->user,$this->pass);
	}

	if (!$this->link_id)
	{
		$this->error("Connection to Database ".$this->database." Failed");
	}

	if(!@mysql_select_db($this->database, $this->link_id))
	{
		$this->error("This database (".$this->database.",)cannot be used");
	}

	unset ($this->password);		
}

function show_all()
{
	return "<br /><br /><b> Debug Mode - All Queries :</b><hr size=1> ".$this->query_show."<br />";
}

function query($string)
{

	if (trim($string != ""))
	{
		$this->query_counter++;
		$this->query_show .= stripslashes($string)."<hr size='1'>";			
		$this->query_id = mysql_query($string);
	}

	if (!$this->query_id) {
  		$this->error("mySQL Error on Query : ".$string);
	}	

	return $this->query_id;
}

function query_insert()
{
	if ( $this->insert_into && (is_array($this->insert_data)) )
	{
		$this->query_counter++;
		$this->query_show .= stripslashes($string)."<hr size='1'>";			

		foreach ($this->insert_data as $key => $val)
		{
			$value .= $key."='".$val."',";
		}

		if ( (substr($value,-1)) == "," )
		{
			$value = substr($value,0,-1);
		}

		$this->query_id = mysql_query("INSERT INTO ".$this->insert_into." SET $value");
	}

	if (!$this->query_id) {
  		$this->error("mySQL Error on Query : ".$string);
	}	

	return $this->query_id;
}

function fetch_array($query_id=-1)
{
	if ($query_id != -1)
	{
		$this->query_id = $query_id;
	}

	$this->result = mysql_fetch_array($this->query_id);
	return $this->result;
}	

function free_result($query_id=-1)
{
	if ($query_id != -1)
	{
  		$this->query_id = $query_id;
	}

	return @mysql_free_result($this->query_id);
}

function query_once($query_string)
{
	$this->query($query_string);
	$get = $this->fetch_array($this->query_id);
	[B]$this->free_result($this->$query_id);[/B]
	return $get;
}

function num_rows($query_id=-1)
{
	if ($quert_id != -1) {
		$this->query_id=$query_id;
	}

	return mysql_num_rows($this->query_id);
}

function insert_id()
{
	return mysql_insert_id($this->link_id);
}

function get_errordesc()
{
	$this->error=mysql_error();
	return $this->error;
}

function get_error_no()
{
	$this->errorno=mysql_errno();
	return $this->errorno;
}

function close()
{
	mysql_close();
}

function error($msg)
{
	global $HTTP_SERVER_VARS,$root;
		$this->error_desc=mysql_error();
		$this->error_no=mysql_errno();


		$the_error = "<b>WARNING!</b><br />";
		$the_error .= "DB Error $this->scriptname: $msg <br /> Some more usefull information you might want to know: <br />";
			$the_error .= "<li> Mysql Error : $this->error_desc";
			$the_error .= "<li> Mysql Error no # : $this->error_no";
			$the_error .= "<li> Date : ".date("F j, Y, g:i a");
			$the_error .= "<li> Referer: ".$HTTP_SERVER_VARS['HTTP_REFERER'];
			$the_error .= "<li>Script: ".$HTTP_SERVER_VARS['REQUEST_URI'];


	echo $the_error;
  	die();
}




} // end of class
?>

I have uploaded all script above, there is a link bud.

[Bjom]

oops. I should have seen this from the part you showed me.

Try this first:

Remove the $ in front of the query_id in the line that produces the error

This needs changed:

function query_once($query_string)
{
$this->query($query_string);
$get = $this->fetch_array($this->query_id);
$this->free_result($this->$query_id);
return $get;
} 

to this:

function query_once($query_string)
{
$this->query($query_string);
$get = $this->fetch_array($this->query_id);
$this->free_result($this->query_id); //here is the change
return $get;
} 

[daydie2008]

its working 🙂

cheers pal. much aprichated.