Stocks by attributes

[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!