Individual Product Shipping module

[flwareagle]

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 }

97

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.

 

Les

[♥kymation]

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.

 

Regards

Jim