Stocks by attributes

[Cunk]

We're having some trouble with this addon. I've managed to copy all the files over to our cart (after making sure they weren't going to wipe out anything) and I can successfully add stock quantities for product attributes.

However, if I then go to purchase something and proceed to the checkout I'm told the item is out of stock (I added 20 items of every combo available). This happens no matter which item or combination of attributes I choose.

Any ideas what I should look for?

Here's our cart in case you want to see what I mean:

http://www.rasebike.com/cart/

[Cunk]

I disabled the stock check for now so if you visit our cart you won't see the "No Stock" warning. I don't want customers seeing that while I try to figure this out.

(No editing posts on these forums? That's strange.

edit: Oh, I guess there's a time limit. Still strange.)

[gl3ny]

Can someone please help me with this error. I'm running version 1.3.8a and have installed stocks by attribute v1.4.9.

1146 Table 'db71128_gmgcart.products_with_attributes_stock' doesn't exist
in:
[SELECT quantity FROM products_with_attributes_stock AS a LEFT JOIN cart1_products_attributes AS b ON (b.options_id=4 AND b.options_values_id=4) WHERE a.products_id = '3' AND a.stock_attributes = b.products_attributes_id AND a.quantity > 0 order by b.products_options_sort_order]

I've tried searching this thread but cannot make sense of it and scared of doing more damage.

Any help greatly appreciated!!!

[DivaVocals]

Can someone please help me with this error. I'm running version 1.3.8a and have installed stocks by attribute v1.4.9.

1146 Table 'db71128_gmgcart.products_with_attributes_stock' doesn't exist
in:
[SELECT quantity FROM products_with_attributes_stock AS a LEFT JOIN cart1_products_attributes AS b ON (b.options_id=4 AND b.options_values_id=4) WHERE a.products_id = '3' AND a.stock_attributes = b.products_attributes_id AND a.quantity > 0 order by b.products_options_sort_order]

I've tried searching this thread but cannot make sense of it and scared of doing more damage.

Any help greatly appreciated!!!

Nothing to be scared of.. You haven't done any "damage" it simply doesn't work..

How did you install the SQL patch for this mod?? The error means that the table needed to store attributes stock is missing..

[gl3ny]

Nothing to be scared of.. You haven't done any "damage" it simply doesn't work..

How did you install the SQL patch for this mod?? The error means that the table needed to store attributes stock is missing..

I copied the text, Admin>tools>SQL patch>send

[DivaVocals]

I copied the text, Admin>tools>SQL patch>send

Try uploading the patch instead and see if you get a different result..

[gl3ny]

Try uploading the patch instead and see if you get a different result..

Uploading patch to where? Sorry noob

[DivaVocals]

I copied the text, Admin>tools>SQL patch>send

Uploading patch to where? Sorry noob

Same place you copied and pasted the SQL patch. Upload versus Copy & Paste..

[gl3ny]

Same place you copied and pasted the SQL patch. Upload versus Copy & Paste..

Ok I see what you mean, I'm sorry. It's only my 3rd day using zen so I'm not that familiar with it yet.

I ended up doing a fresh install because of all the playing around I've been doing. I just took my time installing Stocks By Attributes and its working perfectly now.

Thanks for your help!

[exeter_acres]

Anyone??

Trying to get this mod to work.....

I have installed it in a test database..
No errors..
I can adjust the quantities in admin....

but when i add an item to the cart that I have set its attribute to zero, nothing happens and it is allowed to be added to the cart....

did I miss something?

thoughts on this??

Thanks
Exeter