Forum

Thread tagged as: Shop

generating variants does not work

I am trying to generating variants but it does not work. debug log shows below.

SELECT * FROM content_shop_products WHERE productID=1 AND productDeleted IS NULL LIMIT 1
[2] SELECT o.* FROM content_shop_options o, content_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=1 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID=1 AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
Invalid query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'localdb.perch2_shop_product_option_values' doesn't exist
SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID=1 AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
Invalid query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'localdb.perch2_shop_product_option_values' doesn't exist

I don't know why it is trying to search for "perch2_" prefix. I am using custom prefix, so I am guessing somewhere "perch2" is hardcoded.

sawan ruparel

sawan ruparel 0 points

  • 5 years ago

found hard coding, in this file

addons/apps/perch_shop/lib/PerchShop_OptionValues.class.php

line 70 should have PERCH_DB_PREFIX instead of perch2

Drew McLellan

Drew McLellan 2638 points
Perch Support

Yes, you're right, I've already fixed it, so I hope to get a release out soon.