Dependant Attributes - Can I do this?

[dthomas]

As an update, I do have this working now. THANKS!

Hello,

I have a fresh install of 1.3.8 and really need this dynamic drop downs to function before I start really adding content.

I have been getting the error message on the product page

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

I do have both stock_by_attributes and dynamic drop down installed. I have read through these forums but nothing in here seems to help. Tried modifying the "includes/database_tables.php" by adding... define('TABLE_PRODUCTS_STOCK', 'products_with_attributes_stock');

This only resulted in a completely white screen.

How do I get this working?

Many thanks!

[modernm]

Hello,

I have a fresh install of 1.3.8 and really need this dynamic drop downs to function before I start really adding content.

I have been getting the error message on the product page

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

I do have both stock_by_attributes and dynamic drop down installed. I have read through these forums but nothing in here seems to help. Tried modifying the "includes/database_tables.php" by adding... define('TABLE_PRODUCTS_STOCK', 'products_with_attributes_stock');

This only resulted in a completely white screen.

How do I get this working?

Many thanks!

You will need to add the define to database_tables.php. This is what my file looks like...

define('TABLE_PRODUCTS_STOCK', 'products_with_attributes_stock');

[fakdart]

hello,

I have the same problem that dthomas.

I have modified the includes/database_tables.php but to me it continues leaving something similar on the product page info:

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


I have installed Zencart 1,38 with the contributions Stock by Attributes 4-7MULTIADD and Dynamic DropDowns.


Some aid?


thx!

[rufusclc]

Hi - I have other attributes installed on a Cherry-Zen site; will installing this affect those in any way?
Rufusclc

[modernm]

Does "products_with_attributes_stock" exist in your database?


Cal

[rufusclc]

no, I dont see it.

[modernm]

no, I dont see it.

K, I think that suggests that you did not fully install the Stock by Attributes contribution.

[jettrue]

Hi ModernM, I'm hunting you down, LOL.

I've installed the dynamic drop downs for attributes stock.

Do you know why, once installed, the attribute images no longer show up, but only when using the sequenced drop downs?

See here:
http://www.monkeypantskids.com/large...iaper-p-4.html

and then click to go to the next product. One shows the images, one does not.

I want all attribute images to show up at all times, whether or not the attribute option is in stock, but I can't for the life of me get it to happen.

Thanks!

Also, is there a way to add the number in stock next to each drop down item?

[jettrue]

Hi ModernM, I'm hunting you down, LOL.

I've installed the dynamic drop downs for attributes stock.

Do you know why, once installed, the attribute images no longer show up, but only when using the sequenced drop downs?

See here:
http://www.monkeypantskids.com/large...iaper-p-4.html

and then click to go to the next product. One shows the images, one does not.

I want all attribute images to show up at all times, whether or not the attribute option is in stock, but I can't for the life of me get it to happen.

Thanks!

Also, is there a way to add the number in stock next to each drop down item?

I figured it out. Took a while.

in includes/templates/YOUR_TEMPLATE/templates/tpl_modules_attributes.php I changed this:

<?php
if ($options_attributes_image[$i] != '') {
?>
<?php echo $options_attributes_image[$i]; ?>
<?php
}
?>

to this:

<?php
for($i=0;$i<sizeof($options_name);$i++) {
if ($options_attributes_image[$i] != '') {
echo $options_attributes_image[$i]; 
}
}
?>

[bainedyal]

Hello!

How works this Dynamic Drop Downs.

Can You send me an Example!

Thanks