mysql_error

vividona

hi experts,

I programmed this small article script

I got this mysql error

http://bhl.43i.net/

but in my apache there is no error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/dothost.eu/vhosts/bhl.43i.net/index.php on line 69

NogDog

Most of the time that occurs when MySQL was not able to parse/process the query that was sent to it, causing the mysql_query() function to return false instead of a result resource. You therefore need to look at the preceding code that creates the query SQL and determine where it is failing.

vividona

NogDog;10893027 wrote:
Most of the time that occurs when MySQL was not able to parse/process the query that was sent to it, causing the mysql_query() function to return false instead of a result resource. You therefore need to look at the preceding code that creates the query SQL and determine where it is failing.

yes,

I found the query which make this error in three lines

but the query is correct and it is work in my apache

why this error

djjjozsi

post that source code.

and print us the mysql_error() as well.

vividona

I know I am an old fashion

<?PHP
#  ------------------------------------------------------------------------------------------#
#                BHLsimpleTool - PHP Content Management System                             #
#                    Copyright (c) 2008 bhl.org                                                          #
#                       <http://www.bhl.org/>                                                             #
#  -----------------------------------------------------------------------------------------#
#  This program is free software; you can redistribute it and/or modify                #
#  it under the terms of the GNU General Public License as published by                #
#  the Free Software Foundation; either version 2 of the License, or                    #
#  (at your option) any later version.                                                                 #
#-------------------------------------------------------------------------------------------#
#  This program is distributed in the hope tat it will be useful,                            #
#  but WITHOUT ANY WARRANTY; without even the implied warranty of            #
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the     #
#  GNU General Public License for more details.                                                 #
#  -----------------------------------------------------------------------------------------#

$classname = "BHL_login";
$path = "classes/{$classname}.php";
	try{
	if ( ! file_exists( $path ) ) {
		throw new Exception( "No such file as {$path}" );
	}
require_once( $path );
	if ( ! class_exists( $classname ) ) {
		throw new Exception( "No such class as $classname" );
	}
	}
	catch ( Exception $e ) {
		echo "Error : ".$e->getMessage();
	}	
class RunIndex extends BHL_login{

private $DirInstall;

public function __construct($DirInstall=""){
	parent::__construct();
	$this->setDir($DirInstall);
	echo '<html dir="rtl">
	<head>
	<meta http-equiv="Content-Type" content="text/html; charset=windows-1256">
	<title>BHLsimpleTool v1.0 - index page</title>
	</head>';
	echo '<table width="860" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#996600">
	  <tr>
		<th >';
	require_once('lang/BHL_english.php');
}

public function getDir(){
	return $this->DirInstall;
}

public function setDir($DirInstall){
	$this->DirInstall =  dirname(__FILE__);
}

public function ReqInstall($DirInstall){
	if (file_exists($this->getDir()) && file_exists(dirname(__FILE__) . '/install.php') && file_exists(dirname(__FILE__) . '/readme.php'))
		header("Location: install.php");
}
public function LoadHtml(){
	try{
	if(!$_SESSION['uid'] == true){
	require_once('Themes/default/header.php');
	$checkactive = sprintf( "SELECT * FROM %s ",
	parent::BhlPermitTbl) die(mysql_error());
	$ActiveQuery = mysql_query($checkactive);
	$row = mysql_fetch_array($ActiveQuery);
	$CloseBhl = $row['bhlclose'];
	if(!$CloseBhl == 0){
		throw new Exception("<br/>&#1575;&#1604;&#1605;&#1608;&#1602;&#1593; &#1605;&#1594;&#1604;&#1602; &#1605;&#1606; &#1602;&#1576;&#1604; &#1575;&#1604;&#1573;&#1583;&#1575;&#1585;&#1577; &#1604;&#1594;&#1585;&#1590; &#1575;&#1604;&#1589;&#1610;&#1575;&#1606;&#1577; &#1575;&#1604;&#1585;&#1580;&#1575;&#1569; &#1575;&#1604;&#1586;&#1610;&#1575;&#1585;&#1577; &#1604;&#1575;&#1581;&#1602;&#1575;&#1611;<br/><br/>");
	}
	echo '<table width="860" border="0" align="center" cellpadding="0" cellspacing="0">
		<tr><th scope="col">
	  <tr>
		<th scope="col"><table width="150" border="1" align="right" cellpadding="0" cellspacing="0">
		  <tr>
			<th scope="col"><a
	href="index.php"><img src="Themes/default/images/main2.png" width="150" height="40" /></th>
			</tr>
			<tr>
			<th scope="col"><a
	href="oper/article.php"><img src="Themes/default/images/article.png" width="150" height="40" /></th>
			</tr>
			<tr>
			<th scope="col"><a
	href="callus.php"><img src="Themes/default/images/callus.png" width="150" height="40" /></th>
			</tr>
			<tr>
			<th scope="col">';parent::IndexLoginningIn( $UserName, $UserPswd );
			echo '</th>
			</tr>
			<tr>
			<th scope="col">';parent::BhlStats();
			echo '</th>
			</tr>
			<tr>
			<th scope="col">';parent::ViewLastMems($UserId, $UserName, $Uregcode);
			echo '</th>
			</tr>
		</table>
		<table width="700" border="0" align="right" cellpadding="0" cellspacing="0" bordercolor="#996600">
			<tr>
			  <th scope="col">';
			parent::ViewThread($ArtiSub, $ArtiBod);
			echo '</th>
			</tr>
			<tr>
			<th align="right" scope="col"></th>
			</tr>
			<tr>
			<th scope="col">';
			parent::ViewLastArtis($ArtiSub, $ArtiBod);
	echo '</th></tr>
		  </table></th>
	  </tr>
	</table>';

	}elseif($_SESSION['idgroup'] == true){
	require_once('Themes/default/header2.php');
	echo '<table width="860" border="0" align="center" cellpadding="0" cellspacing="0">
		<tr><th scope="col">';
	echo '<table width="860" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#996600">
	  <tr>
		<th scope="col"><table width="150" border="1" align="right" cellpadding="0" cellspacing="0">
		  <tr>
			<th scope="col"><a
	href="index.php"><img src="Themes/default/images/main2.png" width="150" height="40" /></th>
			</tr>
			<tr>
			<th scope="col"><a
	href="oper/article.php"><img src="Themes/default/images/article.png" width="150" height="40" /></th>
			</tr>
			<tr>
			<th scope="col"><a
	href="callus.php"><img src="Themes/default/images/callus.png" width="150" height="40" /></th>
			</tr>
			<tr>';
			if($_SESSION['idgroup'] == 1){
			echo '<th scope="col"><a
	href="administrator/index.php"><img src="Themes/default/images/admin.png" width="150" height="40" /></th>
			</tr>';
			}
			echo '<tr>
			<th scope="col">';parent::BhlStats();
			echo '</th>
			</tr>';
			echo '<tr>
			<th scope="col">';parent::ViewLastMems($UserId, $UserName, $Uregcode);
			echo '</th>
			</tr>';
		echo '</table>
		<table width="700" border="0" align="right" cellpadding="0" cellspacing="0" bordercolor="#996600">
			<tr>
			  <th scope="col">';
			parent::ViewThread($ArtiSub, $ArtiBod);
			echo '</th>
			</tr>
			<tr>
			<th align="right" scope="col">&nbsp;</th>
			</tr>
			<tr>
			<th scope="col">';
			parent::ViewLastArtis($ArtiSub, $ArtiBod);
	echo '</th></tr>
		  </table></th>
	  </tr>
	</table>';
	}else{
	require_once('Themes/default/header2.php');
	$checkactive = sprintf( "SELECT * FROM %s ",
	parent::BhlPermitTbl);
	$ActiveQuery = mysql_query($checkactive);
	$row = mysql_fetch_array($ActiveQuery);
	$CloseBhl = $row['bhlclose'];
	if(!$CloseBhl == 0){
		throw new Exception("<br/>&#1575;&#1604;&#1605;&#1608;&#1602;&#1593; &#1605;&#1594;&#1604;&#1602; &#1605;&#1606; &#1602;&#1576;&#1604; &#1575;&#1604;&#1573;&#1583;&#1575;&#1585;&#1577; &#1604;&#1594;&#1585;&#1590; &#1575;&#1604;&#1589;&#1610;&#1575;&#1606;&#1577; &#1575;&#1604;&#1585;&#1580;&#1575;&#1569; &#1575;&#1604;&#1586;&#1610;&#1575;&#1585;&#1577; &#1604;&#1575;&#1581;&#1602;&#1575;&#1611;<br/><br/>");
	}
	echo '<table width="860" border="0" align="center" cellpadding="0" cellspacing="0">
		<tr><th scope="col">';
	echo '<table width="860" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#996600">
	  <tr>
		<th scope="col"><table width="150" border="1" align="right" cellpadding="0" cellspacing="0">
		  <tr>
			<th scope="col"><a
	href="index.php"><img src="Themes/default/images/main2.png" width="150" height="40" /></th>
			</tr>
			<tr>
			<th scope="col"><a
	href="oper/article.php"><img src="Themes/default/images/article.png" width="150" height="40" /></th>
			</tr>
			<tr>
			<th scope="col"><a
	href="callus.php"><img src="Themes/default/images/callus.png" width="150" height="40" /></th>
			</tr>
			<tr>';
			if($_SESSION['idgroup'] == 1){
			echo '<th scope="col"><a
	href="administrator/index.php"><img src="Themes/default/images/admin.png" width="150" height="40" /></th>
			</tr>';
			}
			echo '<tr>
			<th scope="col">';parent::BhlStats();
			echo '</th>
			</tr>';
			echo '<tr>
			<th scope="col">';parent::ViewLastMems($UserId, $UserName, $Uregcode);
			echo '</th>
			</tr>';
		echo '</table>
		<table width="700" border="0" align="right" cellpadding="0" cellspacing="0" bordercolor="#996600">
			<tr>
			  <th scope="col">';
			parent::ViewThread($ArtiSub, $ArtiBod);
			echo '</th>
			</tr>
			<tr>
			<th align="right" scope="col">&nbsp;</th>
			</tr>
			<tr>
			<th scope="col">';
			parent::ViewLastArtis($ArtiSub, $ArtiBod);
	echo '</th></tr>
		  </table></th>
	  </tr>
	</table>';
	}
	}
	catch ( Exception $e ) {
			echo $e->getMessage();
	}
}
}
$Index = new RunIndex();
$Index->getDir();
$Index->setDir($DirInstall);
$Index->ReqInstall($DirInstall);
$Index->LoadHtml();
require_once('Themes/default/footer.php');
require_once('Themes/default/style.css');
echo '</th>
  </tr>
</table>';

?>

djjjozsi

$checkactive = sprintf( "SELECT * FROM %s ",
parent::BhlPermitTbl) die(mysql_error());

for example:

    $checkactive = sprintf( "SELECT * FROM %s ",
    parent::BhlPermitTbl);
    $ActiveQuery = mysql_query($checkactive) or die( "&#1582;&#1591;&#1571; &#1601;&#1610; &#1575;&#1604;&#1575;&#1587;&#1578;&#1593;&#1604;". mysql_error ());
    $row = mysql_fetch_array($ActiveQuery);

what is the connection between a string create and a mysql_error?

i think you wanted to write to the next rows to stop-die with mysql_error(), aren't you ?

vividona

I tried it

I got this msg

Parse error: syntax error, unexpected T_EXIT in /home/dothost.eu/vhosts/bhl.43i.net/index.php on line 67

djjjozsi

lets print $checkactive after create, and just for debugging,

use on the top of your php program:

//error_reporting(E_ERROR | E_PARSE);
error_reporting(E_ALL);
ini_set("display_errors", 1);

i think the table name has not a value...

NogDog

For debugging, check the result of mysql_query():

    public function LoadHtml(){
        try{
        if(!$_SESSION['uid'] == true){
        require_once('Themes/default/header.php');
        $checkactive = sprintf( "SELECT * FROM %s ",
        parent::BhlPermitTbl);
        $ActiveQuery = mysql_query($checkactive);
        if($ActiveQuery == false) { die(mysql_error()."<br />\n$checkactive"); }

If the query fails, it will give you both the error message and show the actual query string that was used.

vividona

when installing

$sql2 = mysql_query("
		CREATE TABLE `bhlpermissions` (
  `uid` mediumint(11) unsigned NOT NULL auto_increment,
  `contents` varchar(30) NOT NULL,
  `comments` varchar(30) NOT NULL,
  `bhlclose` varchar(30) NOT NULL,
  PRIMARY KEY  (`uid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
		");
$sqll= mysql_query("INSERT INTO `bhlpermissions` (`contents`, `comments`, `bhlclose`) VALUES (0, 0, 0)");
		if(!$sql2){
		echo "<li><font color='#0000FF'>Error:</font> We can not create table bhlpermissions --> ( ".$this->getErrors()." )</li>";
		}else{
		echo '<li>Table bhlpermissions successfully created .</li>';
		}

after installation process finished I checked phpmyadmin
I found the all rows have got (0) value
and this is what I need

the strangest thing
in apache all fine