Database Knowledge Base

Fixing Errant Variations Or Addons

After upgrading to 1.2, you may find that all products with variations and addons have these respective features turned off. Toggling them back on should fix the issue, but doing this product by product can be very painful. This SQL should allow you to fix the problem rapidly, but you MUST exercise discretion. If you…

MySQL Strict Mode Issues

Summary Some hosts or servers may run MySQL with strict mode enabled which will cause query failures in Shopp. Cause MySQL strict mode enforces very explicit restrictions on the data and format of data that goes into the table columns. Some scenarios in Shopp will not format data because there is no data to format.…

No Table Specified for SELECT Query

No table specified for SELECT query.

© Ingenesis Limited. Shopp™ is a registered trademark of Ingenesis Limited.