Warning: Mysql_fetch_array(): Supplied Argument Is Not A Valid Mysql Result Resource In Includes/functions/database.php On Line 99?

[akent64]

After including the sort order contribution for product attributes I seem to have the following error at the top of a page when I click on a product:

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/oscommerce/includes/functions/database.php on line 99

 

The code on this line is:

 

return mysql_fetch_array($db_query, MYSQL_ASSOC);

 

I’m no expert but there doesn’t seem to be a problem with the code, has anyone had a similar problem?

 

This error means that the product cannot found for some reason even though it is there?!

 

Any help would be greatly appreciated

 

Thanks

 

Andy

[Guest]

Try sorting the attributes and see if that gets rid of the error. If the admin is not updated then the products are not updated and this might cause the error.

[akent64]

Try sorting the attributes and see if that gets rid of the error. If the admin is not updated then the products are not updated and this might cause the error.

 

I have tried this and re-entering a new product but nothing seem to be working

[Guest]

what changes have you made? This error could be caused if you passed an invalid argument to tep_db_query function