Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

After clicking on category link 2 mysql resource errors


ttoomey

Recommended Posts

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

Assault

If you want to find it you'll have to google "Assault T-Shirts" because posting my damn url in my signature is against the forum rules.

T-Shirts with an edge

Powered by OSCommerce + about 20 different custom addons and some Wordpress

Link to comment
Share on other sites

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

Assault

If you want to find it you'll have to google "Assault T-Shirts" because posting my damn url in my signature is against the forum rules.

T-Shirts with an edge

Powered by OSCommerce + about 20 different custom addons and some Wordpress

Link to comment
Share on other sites

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

Assault

If you want to find it you'll have to google "Assault T-Shirts" because posting my damn url in my signature is against the forum rules.

T-Shirts with an edge

Powered by OSCommerce + about 20 different custom addons and some Wordpress

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...