Problems with addon: Dynamic Drop Downs for Stock By Attribute

[mentose457]

I am having troubles with this addon aswell. My website displays this on each product page.

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

The thing i notice is that my table is actually named zen_products_with_attributes_stock. I searched through the files I uploaded and couldn't find where the table was defined. Any help would be appreciated.

Brent

[mentose457]

Nevermind, Pete_srcs already posted the fix. I just didnt understand it the first time i read it. Thanks Pete.

I am having troubles with this addon aswell. My website displays this on each product page.


The thing i notice is that my table is actually named zen_products_with_attributes_stock. I searched through the files I uploaded and couldn't find where the table was defined. Any help would be appreciated.

Brent

So after solving this problem for the 2nd time I figured I should post my solution here!

I'm using Zen 1.3.9d, with stock_by_attributes4.7 and dynamic_drop_downs_for_stock_by_attributes_1-3-4. The problem I found was with the entry in the "includes/database_tables.php" file. The instructions left out the "DB_PREFIX" part. You should add as shown below:

define('TABLE_PRODUCTS_STOCK', DB_PREFIX . 'products_with_attributes_stock');

Worked for me, hope this helps someone else out!

Pete

[mattys]

would be good to have a working version for zencart v1.5.0 - this going to happen?

[DivaVocals]

would be good to have a working version for zencart v1.5.0 - this going to happen?

Only if a volunteer comes along to update it.. Of course if someone updates this they should fix it so it works fully as intended..

[pokerdis]

Hello All,

I really just want to full uninstall Dynamic Drop Downs for Stock by Attributes but I cannot find an uninstall.sql anywhere...I have been searching for a long time tonight.

Please help me.

Thank you,
Tom

[dancingbay]

I have not installed this add-on yet, because i don't know if it will fit what I need.

What I need is some logic with my attributes. I have a drop down with 3 choices for personalization. Then I have a drop down 5 possible fonts below that. If the customer selects "Single Initial", then I only want fonts 1-3 to show up in the font drop down. If they select "3 Initials" I want fonts 1-4 to show up, and if they choose "Text", I want fonts 1, 3, and 5 to show up in the font drop down.

Will this add-on do that. If not, do you know if there's an add-on that will? This seems like it would be a common need, so am hoping that there is one.

Thanks,
Alisa

[DivaVocals]

I have not installed this add-on yet, because i don't know if it will fit what I need.

What I need is some logic with my attributes. I have a drop down with 3 choices for personalization. Then I have a drop down 5 possible fonts below that. If the customer selects "Single Initial", then I only want fonts 1-3 to show up in the font drop down. If they select "3 Initials" I want fonts 1-4 to show up, and if they choose "Text", I want fonts 1, 3, and 5 to show up in the font drop down.

Will this add-on do that. If not, do you know if there's an add-on that will? This seems like it would be a common need, so am hoping that there is one.

Thanks,
Alisa

If you want to know more about this mod, I suggest reading through the support thread to see if your question is answered.. I don't sue this mod because it leaves much to be desired IMHO.. For you it might be different..

[mattys]

Agreed, this mod is definitely problematic.

Basically, via stock by attribute and DDDs, if you have a size drop down, e.g. s, m, l, and a colour drop down, e.g. red, blue green, if you choose 'small', it will then display all the colours that have stock in small, but not the ones that don't.

Matt

[dancingbay]

If you want to know more about this mod, I suggest reading through the support thread to see if your question is answered.. I don't sue this mod because it leaves much to be desired IMHO.. For you it might be different..

Why is there not any documentation telling what this mod will do. I have found so far that Zen Cart is close to what I need, but finding the additional add-ons that I need and installing them and actually getting them to run correctly is a super big pain.

[DivaVocals]

Why is there not any documentation telling what this mod will do. I have found so far that Zen Cart is close to what I need, but finding the additional add-ons that I need and installing them and actually getting them to run correctly is a super big pain.

This isn't commercial software.. Add-ons are shared for free by community volunteers.. Most contain some documentation, and there's o reason why you can't download the add-on to view the documentation.. So to answer your question, I don't know "Why is there not any documentation telling what this mod will do". I don't know that there ISN'T any such documentation. The add-on description and/or the readme that comes with the add-on are the usual places to get this info..