Products error

[street]

Hi there,

OSCMAX V2.0 RC3

Some products in the categories sometimes disappear and leave a warning like this:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/123/public_html/catalog/templates/123123/content/index_nested.tpl.php on line 176

And Line 176 is $parentcat=mysql_fetch_assoc($query);

If I delete the product, the error will gone. However the error will appear later if the same product added in the list.

Any solution? Thanks a lot.

Street

[pgmarshall]

Firstly, v2.0 RC3 is quite old - just want to check that you have patched your store with the security releases?

With no way to look at the error - it sounds like something specific to the product - are you entering any illegal SQL characters in the name or descriptions eg. ' " / \ etc.

I would stongly recommend that you consider upgrading your store to v2.5 once the stable release is out.