Dependant Attributes - Can I do this?

[modernm]

Hi, this feature is great. I tried installed it in my testing store which was runing with stock by attributes well. After installation, this message appear after the product description, and do not show the product attributes:

1146 Table 'lessuvco_store.TABLE_PRODUCTS_STOCK' doesn't exist
in:
[select quantity from TABLE_PRODUCTS_STOCK where products_id = '1' AND quantity > 0]

any idea on this?

Thanks.

Add the following line to includes/database_tables.php

define('TABLE_PRODUCTS_STOCK', 'products_with_attributes_stock');

Cal

[kuroi]

Add the following line to includes/database_tables.php

define('TABLE_PRODUCTS_STOCK', 'products_with_attributes_stock');

Cal

I was hoping that it would turn out to be something straightforward like this ... though rather than editing a core and non-overwriteable file, it would be better to change the pad_sequenced_dropdowns.php class to select from TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK instead of TABLE_PRODUCTS_STOCK.

[modernm]

Hi, this feature is great. I tried installed it in my testing store which was runing with stock by attributes well. After installation, this message appear after the product description, and do not show the product attributes:

1146 Table 'lessuvco_store.TABLE_PRODUCTS_STOCK' doesn't exist
in:
[select quantity from TABLE_PRODUCTS_STOCK where products_id = '1' AND quantity > 0]

any idea on this?

Thanks.

I was hoping that it would turn out to be something straightforward like this ... though rather than editing a core and non-overwriteable file, it would be better to change the pad_sequenced_dropdowns.php class to select from TABLE_PRODUCTS_WITH_ATTRIBUTES_STOCK instead of TABLE_PRODUCTS_STOCK.

Your absolutely right. When I free this week I will do some clean up of the contrib and update it.

Cal

[snakehips]

Cal, you should be kissed! I can't wait to see this mod! It's been driving me beserk for the last three weeks...

[VCSharpin]

I've installed this mod and have the following error:

1146 Table 'multiplayeru.products_with_attributes_stock' doesn't exist in: [select quantity from products_with_attributes_stock where products_id='182' AND quantity > 0]

Thanks in advance!

[kuroi]

I've installed this mod and have the following error:

1146 Table 'multiplayeru.products_with_attributes_stock' doesn't exist in: [select quantity from products_with_attributes_stock where products_id='182' AND quantity > 0]

It sounds as though you have a problem with your Stock by Attributes installation. Recheck that you have followed the step for installing the SQL patch.

[Jan51]

Is the second dropdown box dependent on the first one? For example, can size small in the first drop-down box have one set of colors in the second box and size 5XL have a second set of colors? Or are the values in the second box the same regardless of what is chosen in the first box? If these are TRULY dependent dropdown boxes, I have been waiting for this for years! I haven't been able to use Zen Cart because the only workaround I've been able to live with is to use stock levels to control color choices for different sizes. I was only able to do it with some special mods I got for CubeCart. If dependent attributes are available in Zen, I will definitely switch!

[VCSharpin]

It sounds as though you have a problem with your Stock by Attributes installation. Recheck that you have followed the step for installing the SQL patch.

Double checked and received notification that I was doing duplicate entries on the database. In looking at the SQL, I'm not seeing anything referencing 'products_with_attributes_stock' - only the instruction to change the database_tables.php file, which I did.

Here's the link to my page if you want to see the error in action:
http://www.multiplayeru.com/index.ph...roducts_id=182

Thanks in advance!

[VCSharpin]

Double checked and received notification that I was doing duplicate entries on the database. In looking at the SQL, I'm not seeing anything referencing 'products_with_attributes_stock' - only the instruction to change the database_tables.php file, which I did.

Here's the link to my page if you want to see the error in action:
http://www.multiplayeru.com/index.ph...roducts_id=182

Thanks in advance!

I still need assistance with this. I reinstalled everything, same error. I backed everything out so going to my site won't show the error any longer. If I can't get this to work I may have to change ecommerce solutions, and I really don't want to do that since I use zen for my other site.

Thanks!

[kuroi]

Double checked and received notification that I was doing duplicate entries on the database. In looking at the SQL, I'm not seeing anything referencing 'products_with_attributes_stock' - only the instruction to change the database_tables.php file, which I did.

The products_with_attributes_stock table is inserted by the SQL for stock_by_attributes. If you can't see it in your database, that means a problem with your stock_by_attributes installation. This problem would need to be resolved before you can get any further with dependant attributes. Did you run the stock_by_attributes SQL? Did it give you any errors? Did you run it though a database management tool, phpMyAdmin or the install SQL patch function in the Admin?