Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Individual Product Shipping module


Recommended Posts

I have reviewed the mod instructions 4 times now, and I just cant see what im doing wrong to get this error. Im a newbie to this, so dont kill me too bad..


When i go to the:

Categories / Products - of the admin section - I get the following error message.


Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /web/sailrowc/public_html/store/admin/includes/functions/database.php on line 99


So i went to the the database.php file ....


96 }


98 function tep_db_fetch_array($db_query) {

99 return mysql_fetch_array($db_query, MYSQL_ASSOC);

100 }


What have i done wrong to screw this up? The error above wont let me edit current products. In fact, it doesnt show the current products, but the store still has the current products.


My site is www.sailrowcanoe.com .. yes, its basic, but im learning! :)


Thanks for any assistance for helping this phpdummy.



Link to comment
Share on other sites

The error is probably in admin/categories.php. Look carefully at all of the changes that you have made. Look for code like this:

      $product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'");
     $product = tep_db_fetch_array($product_query);

Note that the $product_query in the first line matches the same variable in the second line. There are a number of pairs like this, and I can't tell from the error message which one has gotten borked up. Just look for similar code in all of the areas that you have modified.




See my profile for a list of my addons and ways to get support.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...