Problems with addon: Dynamic Drop Downs for Stock By Attribute

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

Quote:

---

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

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

Quote:

---

Originally Posted by mentose457

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

---

Quote:

---

Originally Posted by Pete_srcs

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! :cool:

Pete

---

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

Quote:

---

Originally Posted by mattys

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..

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

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

Quote:

---

Originally Posted by 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

---

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..

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

Quote:

---

Originally Posted by DivaVocals

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.

Quote:

---

Originally Posted by dancingbay

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..