Cant add products to shopping cart when logged in

[Kimschulz]

hi

Im helping a company with a problem in their shopping system (they are using latest stable from oscommerce) .

Their problem is that when you are logged in as a user, then you cant add items to the shopping cart (when you press the "add to shopping cart" button then you're redirected to the shoppingcart, but it is empty). Next time you try to add an item to the cart, then there comes an error like:

Warning: Supplied argument is not a valid MySQL result resource in /home/sites/site17/web/catalog/includes/functions/database.php on line 39

(actually there comes one for each time I have tried to add a product).

 

This has worked earlier, and Im pretty sure that it is somthing in the database that makes this error (there is 100.000+ products).

Everything seems to be allright on the site though (except for this)

 

Does anyone know how to fix this (please dont say - clean out the database and start over :-) )

[Kimschulz]

hi

Im helping a company with a problem in their shopping system (they are using latest stable from oscommerce) .

Their problem is that when you are logged in as a user, then you cant add items to the shopping cart (when you press the "add to shopping cart" button then you're redirected to the shoppingcart, but it is empty). Next time you try to add an item to the cart, then there comes an error like:

Warning: Supplied argument is not a valid MySQL result resource in /home/sites/site17/web/catalog/includes/functions/database.php on line 39

(actually there comes one for each time I have tried to add a product).

 

This has worked earlier, and Im pretty sure that it is somthing in the database that makes this error (there is 100.000+ products).

Everything seems to be allright on the site though (except for this)

 

Does anyone know how to fix this (please dont say - clean out the database and start over :-) )

 

I can also add that the customer_basket table works fine except that it set the final_price to 0.00.

phpMyAdmin says(table names are the normal ones):

 

4 | 190 | Y10363 | 1 | 0.00 | 20021008

 

The products database looks fine too (some of the cols aren't filled

but we dont use them either.