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

[Zoloworld]

I will check on this also, but I have another issue sadly
My cart function does not work when adding the attribute products to it. It works fine when adding normal products. Also, my drop box is showing black in my browser. My text boxes are showing white on the search.

[Zoloworld]

Here is a screen cap of the site backend.

[mc12345678]

Here is a screen cap of the site backend.

Seems like perhaps at one time that you had customer wholesale installed, but didn't remove some of the files that generated $_SESSION['customer_whole']. Though wonder if there is another reason that the above error is occurring/having an effect on adding the product to the cart when if that software wasn't present it should fail on the first of the two checks. That said, the particular query does not seem to appear in the code, so I'm also a little perplexed about the report...

The only place (located by github) that the field pa.options_values_price_w appears is inside the dynamic dropdowns code which presents the options for selection. Specifically the area at which I was looking was line 617 of includes/classes/pad_sba_sequenced_dropdowns.php

The field pa.price_prefix in that line shows up earlier in the query and not just after pa.options_values_price_w as shown in the image. I can't say that I've seen a database engine resequence the fields that were provided in the query as part of the error message...

Because it is a query that is reported there, I would suggest installing the mydebug backtrace plugin (though not sure if will work on ZC 1.5.0 or not) available at: https://www.zen-cart.com/downloads.php?do=file&id=1879. Though really suggest upgrading to a more modern version of ZC overall... 1.5.0 was released some 5+ years ago.

[Zoloworld]

Here is the generated code that had:

[14-Sep-2017 12:03:31 America/Phoenix] Request URI: /index.php?main_page=shopping_cart, IP address: 68.81.65.173
#1 trigger_error() called at [/home/content/84/2009684/html/underworld/includes/classes/db/mysql/query_factory.php:101]
#2 queryFactory->show_error() called at [/home/content/84/2009684/html/underworld/includes/classes/db/mysql/query_factory.php:86]
#3 queryFactory->set_error() called at [/home/content/84/2009684/html/underworld/includes/classes/db/mysql/query_factory.php:208]
#4 queryFactory->Execute() called at [/home/content/84/2009684/html/underworld/includes/modules/pages/shopping_cart/header_phpTWITCH.php:108]
#5 require(/home/content/84/2009684/html/underworld/includes/modules/pages/shopping_cart/header_phpTWITCH.php) called at [/home/content/84/2009684/html/underworld/index.php:36]

[14-Sep-2017 12:03:31 America/Phoenix] PHP Fatal error: 1054:Unknown column 'pa.options_values_price_w' in 'field list' :: SELECT popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.options_values_price_w, pa.price_prefix
FROM zen_products_options popt, zen_products_options_values poval, zen_products_attributes pa
WHERE pa.products_id = 68
AND pa.options_id = 4
AND pa.options_id = popt.products_options_id
AND pa.options_values_id = 14
AND pa.options_values_id = poval.products_options_values_id
AND popt.language_id = 1
AND poval.language_id = 1 ORDER BY LPAD(popt.products_options_sort_order,11,"0") in /home/content/84/2009684/html/underworld/includes/classes/db/mysql/query_factory.php on line 101

[mc12345678]

Here is the generated code that had:

[14-Sep-2017 12:03:31 America/Phoenix] Request URI: /index.php?main_page=shopping_cart, IP address: 68.81.65.173
#1 trigger_error() called at [/home/content/84/2009684/html/underworld/includes/classes/db/mysql/query_factory.php:101]
#2 queryFactory->show_error() called at [/home/content/84/2009684/html/underworld/includes/classes/db/mysql/query_factory.php:86]
#3 queryFactory->set_error() called at [/home/content/84/2009684/html/underworld/includes/classes/db/mysql/query_factory.php:208]
#4 queryFactory->Execute() called at [/home/content/84/2009684/html/underworld/includes/modules/pages/shopping_cart/header_phpTWITCH.php:108]
#5 require(/home/content/84/2009684/html/underworld/includes/modules/pages/shopping_cart/header_phpTWITCH.php) called at [/home/content/84/2009684/html/underworld/index.php:36]

[14-Sep-2017 12:03:31 America/Phoenix] PHP Fatal error: 1054:Unknown column 'pa.options_values_price_w' in 'field list' :: SELECT popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.options_values_price_w, pa.price_prefix
FROM zen_products_options popt, zen_products_options_values poval, zen_products_attributes pa
WHERE pa.products_id = 68
AND pa.options_id = 4
AND pa.options_id = popt.products_options_id
AND pa.options_values_id = 14
AND pa.options_values_id = poval.products_options_values_id
AND popt.language_id = 1
AND poval.language_id = 1 ORDER BY LPAD(popt.products_options_sort_order,11,"0") in /home/content/84/2009684/html/underworld/includes/classes/db/mysql/query_factory.php on line 101

Ok. So that looks like the error is produced in: includes/modules/pages/shopping_cart/header_phpTWITCH.php

Which is unrelated to SBA (directly) but appears to be causing the issue.

Don't know if you need that file for some other plugin that is still installed or what it's contents are, but it does appear to be the source of this issue.

[Zoloworld]

I will see what happens if I move it to my desktop. thank you so much for the support!



THAT WAS IT!!!!!! It works perfect!! You are legendary man!

[mc12345678]

I will see what happens if I move it to my desktop. thank you so much for the support!



THAT WAS IT!!!!!! It works perfect!! You are legendary man!

Excellent. Like said, don't know which application that was intended to support, but it would seem that it was "hard-coded" to expect that field rather than like SBA does it assumes it is there if the session for the functionality is/was set. It could also just be that the "remnants" of that plugin were not removed, which begs the question of what else was not?

Anyways, no thank you. You provided all of the available information without begging and pleading. :) makes diagnosis so much easier. :)

[Zoloworld]

I will continue to tinker with this mod. I am curious if i can have it change the pics above as you use the dropdown. This mod is amazing!

[mc12345678]

I will continue to tinker with this mod. I am curious if i can have it change the pics above as you use the dropdown. This mod is amazing!

It can out-of-the-box for single attribute product. It is also compatible with attribute image swap (https://www.zen-cart.com/downloads.php?do=file&id=699). "Issue" is that with multiple attributes that each change the look, "knowing" what image to display. ie. if there are two option names, one has 2 option values, and one has 3, then when selecting the first one (2 different images) then it has to have 3 additional images for each of the first to give a total of 8 images (or a way to overlay just three images over the original 2 and only need 5 additional images beyond the base image.)

It is something to incorporate in the future, but has not been a priority yet.

[Zoloworld]

It can out-of-the-box for single attribute product. It is also compatible with attribute image swap (https://www.zen-cart.com/downloads.php?do=file&id=699). "Issue" is that with multiple attributes that each change the look, "knowing" what image to display. ie. if there are two option names, one has 2 option values, and one has 3, then when selecting the first one (2 different images) then it has to have 3 additional images for each of the first to give a total of 8 images (or a way to overlay just three images over the original 2 and only need 5 additional images beyond the base image.)

It is something to incorporate in the future, but has not been a priority yet.

I am now seeing this on checkout

[15-Sep-2017 07:56:24 America/Phoenix] PHP Fatal error: require(): Cannot redeclare class order in /home/content/84/2009684/html/underworld/includes/modules/pages/checkout_confirmation/header_phpold.php on line 61