Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Help with this error


Guest

Recommended Posts

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/fordsroc/.panel/web/ecommerce/os/catalog/includes/functions/database.php on line 46

 

 

I am not sure what this means, it happens whenever I click on a product

 

Thanks,

Scott

Link to comment
Share on other sites

Here is line 46

    $result = mysql_num_rows($db_query);

 

Here is the full php file

<?
 function tep_db_connect() {
   global $db_link;
   
   if (USE_PCONNECT) @$db_link = mysql_pconnect(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD);
   else @$db_link = mysql_connect(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD);

   if ($db_link) @mysql_select_db(DB_DATABASE);
   return $db_link;
 }

 function tep_db_close() {
   global $db_link;

   $result = mysql_close($db_link);
   
   return $result;
 }

 function tep_db_query($db_query) {
   global $db_link;

   if (STORE_DB_TRANSACTIONS) {
      error_log("QUERY " . $db_query . "\n", 3, STORE_PAGE_PARSE_TIME_LOG);
   }

   $result = mysql_query($db_query, $db_link);

   if (STORE_DB_TRANSACTIONS) {
      $result_error = mysql_error();
      error_log("RESULT " . $result . " " . $result_error . "\n", 3, STORE_PAGE_PARSE_TIME_LOG);
   }

   return $result;
 }

 function tep_db_fetch_array($db_query) {

   $result = mysql_fetch_array($db_query);

   return $result;
 }

 function tep_db_num_rows($db_query) {

   $result = mysql_num_rows($db_query);

   return $result;
 }

 function tep_db_data_seek($db_query, $row_number) {

   $result = mysql_data_seek($db_query, $row_number);

   return $result;
 }

 function tep_db_insert_id() {

   $result = mysql_insert_id();

   return $result;
 }

 function tep_db_free_result($db_query) {

   $result = mysql_free_result($db_query);

   return $result;
 }
?>

 

and I appologize for my earlier post, I have not touched this database.php file at all.

 

Thanks,

Scott

Link to comment
Share on other sites

Here is my database.php file, unmodified.

 

<?php

/*

  $Id: database.php,v 1.21 2003/06/09 21:21:59 hpdl Exp $

 

  osCommerce, Open Source E-Commerce Solutions

  http://www.oscommerce.com

 

  Copyright © 2003 osCommerce

 

  Released under the GNU General Public License

*/

 

  function tep_db_connect($server = DB_SERVER, $username = DB_SERVER_USERNAME, $password = DB_SERVER_PASSWORD, $database = DB_DATABASE, $link = 'db_link') {

    global $$link;

 

    if (USE_PCONNECT == 'true') {

      $$link = mysql_pconnect($server, $username, $password);

    } else {

      $$link = mysql_connect($server, $username, $password);

    }

 

    if ($$link) mysql_select_db($database);

 

    return $$link;

  }

 

  function tep_db_close($link = 'db_link') {

    global $$link;

 

    return mysql_close($$link);

  }

 

  function tep_db_error($query, $errno, $error) {

    die('<font color="#000000"><b>' . $errno . ' - ' . $error . '<br><br>' . $query . '<br><br><small><font color="#ff0000">[TEP STOP]</font></small><br><br></b></font>');

  }

 

  function tep_db_query($query, $link = 'db_link') {

    global $$link;

 

    if (defined('STORE_DB_TRANSACTIONS') && (STORE_DB_TRANSACTIONS == 'true')) {

      error_log('QUERY ' . $query . "\n", 3, STORE_PAGE_PARSE_TIME_LOG);

    }

 

    $result = mysql_query($query, $$link) or tep_db_error($query, mysql_errno(), mysql_error());

 

    if (defined('STORE_DB_TRANSACTIONS') && (STORE_DB_TRANSACTIONS == 'true')) {

      $result_error = mysql_error();

      error_log('RESULT ' . $result . ' ' . $result_error . "\n", 3, STORE_PAGE_PARSE_TIME_LOG);

    }

 

    return $result;

  }

 

  function tep_db_perform($table, $data, $action = 'insert', $parameters = '', $link = 'db_link') {

    reset($data);

    if ($action == 'insert') {

      $query = 'insert into ' . $table . ' (';

      while (list($columns, ) = each($data)) {

        $query .= $columns . ', ';

      }

      $query = substr($query, 0, -2) . ') values (';

      reset($data);

      while (list(, $value) = each($data)) {

        switch ((string)$value) {

          case 'now()':

            $query .= 'now(), ';

            break;

          case 'null':

            $query .= 'null, ';

            break;

          default:

            $query .= '\'' . tep_db_input($value) . '\', ';

            break;

        }

      }

      $query = substr($query, 0, -2) . ')';

    } elseif ($action == 'update') {

      $query = 'update ' . $table . ' set ';

      while (list($columns, $value) = each($data)) {

        switch ((string)$value) {

          case 'now()':

            $query .= $columns . ' = now(), ';

            break;

          case 'null':

            $query .= $columns .= ' = null, ';

            break;

          default:

            $query .= $columns . ' = \'' . tep_db_input($value) . '\', ';

            break;

        }

      }

      $query = substr($query, 0, -2) . ' where ' . $parameters;

    }

 

    return tep_db_query($query, $link);

  }

 

  function tep_db_fetch_array($db_query) {

    return mysql_fetch_array($db_query, MYSQL_ASSOC);

  }

 

  function tep_db_num_rows($db_query) {

    return mysql_num_rows($db_query);

  }

 

  function tep_db_data_seek($db_query, $row_number) {

    return mysql_data_seek($db_query, $row_number);

  }

 

  function tep_db_insert_id() {

    return mysql_insert_id();

  }

 

  function tep_db_free_result($db_query) {

    return mysql_free_result($db_query);

  }

 

  function tep_db_fetch_fields($db_query) {

    return mysql_fetch_field($db_query);

  }

 

  function tep_db_output($string) {

    return htmlspecialchars($string);

  }

 

  function tep_db_input($string) {

    return addslashes($string);

  }

 

  function tep_db_prepare_input($string) {

    if (is_string($string)) {

      return trim(tep_sanitize_string(stripslashes($string)));

    } elseif (is_array($string)) {

      reset($string);

      while (list($key, $value) = each($string)) {

        $string[$key] = tep_db_prepare_input($value);

      }

      return $string;

    } else {

      return $string;

    }

  }

?>

Link to comment
Share on other sites

I just tried to replace my database file with yours and it brought up 8 errors similar to my one error, so that is not the answer LOL Thanks for the help so far though!

 

Scott

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...