FAQ mysql_fetch_row(): error

Posted: Thu Feb 05, 2004 3:42 am

Everything seems to be working fine except my FAQ section. When I'm in admin and try to add or edit anything in the FAQ module I see this error:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/xscptwxl/public_html/includes/sql_layer.php on line 286

As a result I can't do anything with the module. Help!

Posted: Thu Feb 05, 2004 4:53 am

use debug mode, then you will find problem.
backup your sql_layer.php

use this

Code:

<?php

/************************************************************************/
/* PHP-NUKE: Web Portal System */
/* =========================== */
/* */
/* Copyright (c) 2002 by Francisco Burzi */
/* http://phpnuke.org */
/* */
/* postgres fix by Rub? Campos - Oscar Silla */
/* */
/* 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. */
/************************************************************************/

if (eregi("sql_layer.php",$_SERVER['PHP_SELF'])) {
Header("Location: ../index.php");
die();
}

/* $dbtype = "MySQL"; */
/* $dbtype = "mSQL"; */
/* $dbtype = "postgres"; */
/* $dbtype = "postgres_local";// When postmaster start without "-i" option. */
/* $dbtype = "ODBC"; */
/* $dbtype = "ODBC_Adabas"; */
/* $dbtype = "Interbase"; */
/* $dbtype = "Sybase"; */

/*
* sql_connect($host, $user, $password, $db)
* returns the connection ID
*/

class ResultSet {
var $result;
var $total_rows;
var $fetched_rows;

function set_result( $res ) {
 $this->result = $res;
}

function get_result() {
 return $this->result;
}

function set_total_rows( $rows ) {
 $this->total_rows = $rows;
}

function get_total_rows() {
 return $this->total_rows;
}

function set_fetched_rows( $rows ) {
 $this->fetched_rows = $rows;
}

function get_fetched_rows() {
 return $this->fetched_rows;
}

function increment_fetched_rows() {
 $this->fetched_rows = $this->fetched_rows + 1;
}
}

function sql_connect($host, $user, $password, $db)
{
global $dbtype;
switch ($dbtype) {

case "MySQL":
$dbi=@mysql_connect($host, $user, $password);
mysql_select_db($db);
return $dbi;
break;;

case "mSQL":
$dbi=msql_connect($host);
msql_select_db($db);
return $dbi;
break;;

case "postgres":
$dbi=@pg_connect("host=$host user=$user password=$password port=5432 dbname=$db");
return $dbi;
break;;

case "postgres_local":
$dbi=@pg_connect("user=$user password=$password dbname=$db");
return $dbi;
break;;

case "ODBC":
$dbi=@odbc_connect($db,$user,$password);
return $dbi;
break;;

case "ODBC_Adabas":
$dbi=@odbc_connect($host.":".$db,$user,$password);
return $dbi;
break;;

case "Interbase":
$dbi=@ibase_connect($host.":".$db,$user,$password);
return $dbi;
break;;

case "Sybase":
$dbi=@sybase_connect($host, $user, $password);
sybase_select_db($db,$dbi);
return $dbi;
break;;

default:
break;;
}

}

function sql_logout($id)
{
global $dbtype;
switch ($dbtype) {

case "MySQL":
$dbi=@mysql_close($id);
return $dbi;
break;;

case "mSQL":
$dbi=@msql_close($id);
return $dbi;
break;;

case "postgres":
case "postgres_local":
$dbi=@pg_close($id);
return $dbi;
break;;

case "ODBC":
case "ODBC_Adabas":
$dbi=@odbc_close($id);
return $dbi;
break;;

case "Interbase":
$dbi=@ibase_close($id);
return $dbi;
break;;

case "Sybase":
$dbi=@sybase_close($id);
return $dbi;
break;;

default:
break;;
}
}

/*
* sql_query($query, $id)
* executes an SQL statement, returns a result identifier
*/

function sql_query($query, $id)
{

global $dbtype;
global $sql_debug;
$sql_debug = 0;
if($sql_debug) echo "SQL query: ".str_replace(",",", ",$query)." ";
switch ($dbtype) {

case "MySQL":
$res=@mysql_query($query, $id);
if (mysql_errno()) { echo mysql_error()." "; }
return $res;
break;;

case "mSQL":
$res=@msql_query($query, $id);
return $res;
break;;

case "postgres":
case "postgres_local":
$res=pg_exec($id,$query);
$result_set = new ResultSet;
$result_set->set_result( $res );
$result_set->set_total_rows( sql_num_rows( $result_set ) );
$result_set->set_fetched_rows( 0 );
return $result_set;
break;;

case "ODBC":
case "ODBC_Adabas":
$res=@odbc_exec($id,$query);
return $res;
break;;

case "Interbase":
$res=@ibase_query($id,$query);
return $res;
break;;

case "Sybase":
$res=@sybase_query($query, $id);
return $res;
break;;

default:
break;;

}
}

/*
* sql_num_rows($res)
* given a result identifier, returns the number of affected rows
*/

function sql_num_rows($res)
{
global $dbtype;
switch ($dbtype) {

case "MySQL":
$rows=mysql_num_rows($res);
if (mysql_errno()) { echo mysql_error()." "; }
return $rows;
break;;

case "mSQL":
$rows=msql_num_rows($res);
return $rows;
break;;

case "postgres":
case "postgres_local":
$rows=pg_numrows( $res->get_result() );
return $rows;
break;;

case "ODBC":
case "ODBC_Adabas":
$rows=odbc_num_rows($res);
return $rows;
break;;

case "Interbase":
echo " Error! PHP dosen't support ibase_numrows! ";
return $rows;
break;;

case "Sybase":
$rows=sybase_num_rows($res);
return $rows;
break;;

default:
break;;
}
}

/*
* sql_fetch_row(&$res,$row)
* given a result identifier, returns an array with the resulting row
* Needs also a row number for compatibility with postgres
*/

function sql_fetch_row(&$res, $nr=0)
{
global $dbtype;
switch ($dbtype) {

case "MySQL":
$row = mysql_fetch_row($res);
if (mysql_errno()) { echo mysql_error()." "; }
return $row;
break;;

case "mSQL":
$row = msql_fetch_row($res);
return $row;
break;;

case "postgres":
case "postgres_local":
if ( $res->get_total_rows() > $res->get_fetched_rows() ) {
 $row = pg_fetch_row($res->get_result(), $res->get_fetched_rows() );
 $res->increment_fetched_rows();
 return $row;
} else {
 return false;
}
break;;

case "ODBC":
case "ODBC_Adabas":
$row = array();
$cols = odbc_fetch_into($res, $nr, $row);
return $row;
break;;

case "Interbase":
$row = ibase_fetch_row($res);
return $row;
break;;

case "Sybase":
$row = sybase_fetch_row($res);
return $row;
break;;

default:
break;;
}
}

/*
* sql_fetch_array($res,$row)
* given a result identifier, returns an associative array
* with the resulting row using field names as keys.
* Needs also a row number for compatibility with postgres.
*/

function sql_fetch_array(&$res, $nr=0)
{
global $dbtype;
switch ($dbtype)
{
case "MySQL":
$row = array();
$row = mysql_fetch_array($res);
if (mysql_errno()) { echo mysql_error()." "; }
return $row;
break;;

case "mSQL":
$row = array();
$row = msql_fetch_array($res);
return $row;
break;;

case "postgres":
case "postgres_local":
if( $res->get_total_rows() > $res->get_fetched_rows() ) {
 $row = array();
 $row = pg_fetch_array($res->get_result(), $res->get_fetched_rows() );
 $res->increment_fetched_rows();
 return $row;
} else {
 return false;
}
break;;

/*
* ODBC doesn't have a native _fetch_array(), so we have to
* use a trick. Beware: this might cause HUGE loads!
*/

case "ODBC":
$row = array();
$result = array();
$result = odbc_fetch_row($res, $nr);
$nf = odbc_num_fields($res); /* Field numbering starts at 1 */
for($count=1; $count < $nf+1; $count++)
{
$field_name = odbc_field_name($res, $count);
$field_value = odbc_result($res, $field_name);
$row[$field_name] = $field_value;
}
return $row;
break;;

case "ODBC_Adabas":
$row = array();
$result = array();
$result = odbc_fetch_row($res, $nr);

$nf = count($result)+2; /* Field numbering starts at 1 */
for($count=1; $count < $nf; $count++) {
 $field_name = odbc_field_name($res, $count);
 $field_value = odbc_result($res, $field_name);
 $row[$field_name] = $field_value;
}
return $row;
break;;

case "Interbase":
$orow=ibase_fetch_object($res);
$row=get_object_vars($orow);
return $row;
break;;

case "Sybase":
$row = sybase_fetch_array($res);
return $row;
break;;

}
}

function sql_fetch_object(&$res, $nr=0)
{
global $dbtype;
switch ($dbtype)
{
case "MySQL":
$row = mysql_fetch_object($res);
if (mysql_errno()) { echo mysql_error()." "; }
if($row) return $row;
else return false;
break;;

case "mSQL":
$row = msql_fetch_object($res);
if($row) return $row;
else return false;
break;;

case "postgres":
case "postgres_local":
if( $res->get_total_rows() > $res->get_fetched_rows() ) {
 $row = pg_fetch_object( $res->get_result(), $res->get_fetched_rows() );
 $res->increment_fetched_rows();
 if($row) return $row;
 else return false;
} else {
 return false;
}
break;;

case "ODBC":
$result = odbc_fetch_row($res, $nr);
if(!$result) return false;
$nf = odbc_num_fields($res); /* Field numbering starts at 1 */
for($count=1; $count < $nf+1; $count++)
{
$field_name = odbc_field_name($res, $count);
$field_value = odbc_result($res, $field_name);
$row->$field_name = $field_value;
}
return $row;
break;;

case "ODBC_Adabas":
$result = odbc_fetch_row($res, $nr);
if(!$result) return false;

$nf = count($result)+2; /* Field numbering starts at 1 */
for($count=1; $count < $nf; $count++) {
 $field_name = odbc_field_name($res, $count);
 $field_value = odbc_result($res, $field_name);
 $row->$field_name = $field_value;
}
return $row;
break;;

case "Interbase":
$orow = ibase_fetch_object($res);
if($orow)
{
 $arow=get_object_vars($orow);
 while(list($name,$key)=each($arow))
 {
 $name=strtolower($name);
 $row->$name=$key;
 }
 return $row;
}else return false;
break;;

case "Sybase":
$row = sybase_fetch_object($res);
return $row;
break;;

}
}

/*** Function Free Result for function free the memory ***/
function sql_free_result($res) {
global $dbtype;
switch ($dbtype) {

case "MySQL":
$row = mysql_free_result($res);
if (mysql_errno()) { echo mysql_error()." "; }
return $row;
break;;

 case "mSQL":
$row = msql_free_result($res);
return $row;
break;;

 case "postgres":
case "postgres_local":
$rows=pg_FreeResult( $res->get_result() );
return $rows;
break;;

case "ODBC":
case "ODBC_Adabas":
$rows=odbc_free_result($res);
return $rows;
break;;

case "Interbase":
echo " Error! PHP dosen't support ibase_numrows! ";
return $rows;
break;;

case "Sybase":
$rows=sybase_free_result($res);
return $rows;
break;;
}
}

?>

Posted: Thu Feb 05, 2004 4:55 am

This differ from original is

if (mysql_errno()) { echo mysql_error()." "; }

Posted: Thu Feb 12, 2004 9:07 am

I'm getting the same error, if anyone knows a fix for it.
Thanks
Phil
http://www.miniz.com

Nuke Cadet Joined: Feb 12, 2004 Posts: 5

Thanks xgate32. That debug version of sql_layer.php did the trick.

To those of you who haven't replaced your default sql_layer.php with the one posted above, I recommend you do. It was simple finding the problem afterward.

The fix (at least on my site):
In both /admin/modules/adminfaq.php & /modules/FAQ/index.php
Find all instances of faqCategories and replace with faqcategories

One letter with the wrong case and all hell breaks loose. Razz

Nuke Soldier Joined: Feb 04, 2004 Posts: 12

haha this is so funny. I did the fix like the above says. ok. Now I get a different error.

Posted: Sun Feb 15, 2004 6:42 pm

And the error is?

Or if you prefer to fix it by yourself then good for you.

Wink

Nuke Soldier Joined: Feb 04, 2004 Posts: 12

Table 'phpnuke.nuke_faqCategories' doesn't exist

Warning: Supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/chanistheman.com/httpdocs/nuke/includes/sql_layer.php on line 288
Table 'phpnuke.nuke_faqCategories' doesn't exist

Posted: Sun Feb 15, 2004 6:55 pm

sengsara wrote:

This will help you pinpoint the exact problem.

Now you know that the problem is wrong table name! And there's a post above that you should read.

Thraxus wrote:

Thanks xgate32. That debug version of sql_layer.php did the trick.

To those of you who haven't replaced your default sql_layer.php with the one posted above, I recommend you do. It was simple finding the problem afterward.

The fix (at least on my site):
In both /admin/modules/adminfaq.php & /modules/FAQ/index.php
Find all instances of faqCategories and replace with faqcategories

One letter with the wrong case and all hell breaks loose. Razz

Nuke Soldier Joined: Feb 04, 2004 Posts: 12

why are there so many errors in php nuke?

Posted: Sun Feb 15, 2004 7:00 pm

Oh dear.

Nuke Soldier Joined: Feb 04, 2004 Posts: 12

I did that and still the same error.

Lieutenant Joined: Dec 28, 2003 Posts: 292

Also, change all instances of faqAnswer to faqanswer

Nuke Soldier Joined: Nov 21, 2003 Posts: 25

Ugh! I'm still having a bit of a problem. Using PhPNuke 6.9, I have:

1) renamed the tables to faqanswer and faqcategories;
2)replaced all instances of faqAnswer and faqCategories with lower case in my /admin/modules/adminfaq.php and /modules/faq/index.php
3) replaced my default sql_layer.php with the code above.

Now I am getting the following error:

You have an error in your SQL syntax near 'nine'' at line 1

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/virtual/site65/fst/var/www/html/includes/sql_layer.php on line 289
You have an error in your SQL syntax near 'nine'' at line 1

here is the code from lines 287 - 292:

Code:

case "MySQL":
$row = mysql_fetch_row($res);
if (mysql_errno()) { echo mysql_error()." "; }
return $row;
break;;

Do I need to reload my default sql_layer.php once I have fixed some problem or do I leave the code above as my new sql_layer.php?

Nuke Soldier Joined: Nov 21, 2003 Posts: 25

Found the answer, rather my service provider did.

http://www.nukecops.com/postp97267.html#97267