Stock by Attribute v4.0 addon for v1.3.5-1.3.9

[Zoloworld]

[13-Sep-2017 13:41:24 America/Phoenix] PHP Fatal error: 1146:Table '.zen_zen_products_with_attributes_stock' doesn't exist :: select quantity from zen_zen_products_with_attributes_stock where products_id = '67' AND quantity > 0 in /home/content/84/2009684/html/underworld/includes/classes/db/mysql/query_factory.php on line 101

[mc12345678]

[13-Sep-2017 13:41:24 America/Phoenix] PHP Fatal error: 1146:Table '.zen_zen_products_with_attributes_stock' doesn't exist :: select quantity from zen_zen_products_with_attributes_stock where products_id = '67' AND quantity > 0 in /home/content/84/2009684/html/underworld/includes/classes/db/mysql/query_factory.php on line 101

Yeah, that's problem number one with the version of Dynamic Dropdowns available for download from this site (corrected in the incorporation referenced in my last post). There are a number of other issues, such as the install requires that all product that have an attribute to be tracked by SBA (not the case with the way it is implemented) and if I remember correctly every product had to have attributes as well... been a few years since I've looked at how it was implemented.

My suggestion would be to download the version from github (not yet posted to the ZC website because the instructions need a major overhaul to reflect the full capability and ways to implement) and replace/incorporate the files from that install... you will be much more satisfied. Can look back over the last couple of pages of this thread for install "sequence".

[Zoloworld]

[13-Sep-2017 13:41:24 America/Phoenix] PHP Fatal error: 1146:Table '.zen_zen_products_with_attributes_stock' doesn't exist :: select quantity from zen_zen_products_with_attributes_stock where products_id = '67' AND quantity > 0 in /home/content/84/2009684/html/underworld/includes/classes/db/mysql/query_factory.php on line 101

This is also where I downloaded the file https://www.zen-cart.com/showthread....r-v1-3-5-1-3-9 i used as it was from Zen 1.5.0

[Zoloworld]

Yeah, that's problem number one with the version of Dynamic Dropdowns available for download from this site (corrected in the incorporation referenced in my last post). There are a number of other issues, such as the install requires that all product that have an attribute to be tracked by SBA (not the case with the way it is implemented) and if I remember correctly every product had to have attributes as well... been a few years since I've looked at how it was implemented.

My suggestion would be to download the version from github (not yet posted to the ZC website because the instructions need a major overhaul to reflect the full capability and ways to implement) and replace/incorporate the files from that install... you will be much more satisfied. Can look back over the last couple of pages of this thread for install "sequence".

Thank you so much for the advice. I will use the one you linked.

[mc12345678]

Thank you so much for the advice. I will use the one you linked.

While there are some minor differences between ZC 1.5.1 and 1.5.0 in the areas touched by the plugin, I would expect that the changes made to support SBA in the 1.5.1 files could be applied to 1.5.0, but haven't tried going back that far. I do not expect any php related problems just that some logic in some areas may have been written slightly differently between the two versions.

[Zoloworld]

While there are some minor differences between ZC 1.5.1 and 1.5.0 in the areas touched by the plugin, I would expect that the changes made to support SBA in the 1.5.1 files could be applied to 1.5.0, but haven't tried going back that far. I do not expect any php related problems just that some logic in some areas may have been written slightly differently between the two versions.

I went ahead and loaded the files. I am noticing the same error. I am curious if there is any SQL lines I need to add.

[mc12345678]

I went ahead and loaded the files. I am noticing the same error. I am curious if there is any SQL lines I need to add.

I really should know the real filename, but I didn't come up with it and haven't changed it because there is so much "history" already. There is a file in the root of your admin, something like stock_by_attr_install.php. Once you login to your admin, point your browser to that file within your admin directory. Perform the install/upgrade. This will execute the sql needed for the plugin. Your existing database table for SBA will remain "untouched" (not be deleted or cleared), but settings for SBA (which includes Dynamic Dropdowns) will be reset to their default values. Still want to modify that behavior, but...

For others, in a fresh install of SBA, the files can be placed and will not interfere with normal operation and not be "obvious" that SBA is installed until that install file is accessed and the install/upgrade performed.

[Zoloworld]

Thank you so much!! It works now! And yes, It can work with 1.5.0!

[Zoloworld]

mc12345678,

I think I am getting close with my SBA implementation, but I currently don't see attributes on some products in the shopping cart page and I wonder if you have some insights. I have other mods that may be affecting this page as well.

Products with zero or two option names associated seem fine, but products with one option name show up in the cart without their attributes listed. For example this product: https://www.tokyopenshop.com/shop2/m...cil-p-624.html

I believe this "if" is failing in the tpl_shopping_cart_default.php file in my template

  if (isset($product['attributes']) && is_array($product['attributes'])) {

Here are my current settings that I think might be relevant to SBA:

Attachment 17260Attachment 17259

Thanks in advance for any help!

I cannot find this information on the left. I downloaded the info and cannot find it.

[mc12345678]

I cannot find this information on the left. I downloaded the info and cannot find it.

If this is something you are trying to resolve about your install could you please provide some more information? Last that I spoke with fbroz about his install once the default settings for stock (as modified by SBA) and Dynamic Dropdowns (located either one above or one below the configuration->stock option. Trust me when I say it seems almost invisible even when it is blindly there.

There may be an issue though as a result of having installed the original version of it followed by how SBA follows up, I'm not sure. If it isn't there (seriously look really hard and carefully) then we'll talk about what is needed to resolve.