After clicking on category link 2 mysql resource errors

[ttoomey]

http://www.plaksmacker.com/catalog/default...4236e6d286ef146

 

 

you can click on that or just goto

http://shop.plaksmacker.com and click on a category (only orthodontics has products in it so click on that one) with products in it and you see the 2 errors at the bottom of the page:

 

Warning: Supplied argument is not a valid MySQL result resource in /home/ttoomey/plaksmacker.com/catalog/includes/functions/database.php on line 107

 

Warning: Supplied argument is not a valid MySQL result resource in /home/ttoomey/plaksmacker.com/catalog/includes/functions/database.php on line 99

 

 

Now as far as I know database.php is unaltered, anyone know what this is or have a similiar problem? I haven't seen any topics on it yet despite my thorough search through the forums

[ttoomey]

The problem ended up being the recommendations contribution I added into the footer.php

 

After commenting it out the error went away. Now its good that I figured out how to get the errors to go away, but its bad that I really wanted to use that contribution.

 

Something must be wrong with the sql, I think it may be returning a 0 for the result set and that is why the errors are occuring now this may or may not be because i am still setting up the store so there is no data in that table because there have been no purchases yet. I guess we'll just have to see.

 

I'll keep this forum updated

[ttoomey]

fixed:

 

in the admin panel the recommendations under configuration was set to true, set it to false and everything works wonderfully.

 

2 hours down the shithole for 1 freakin setting, lol