GX-Bug #69319
geschlossenError in Gambio Updater when no properties are present
0%
Die Optionsmigration wird nicht ausgeführt, wenn beim Aktualisieren des Shops keine Eigenschaften vorhanden sind.
Beschreibung
When no properties are present, the Updater throws following SQL Error:
"MySQL-Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 8
Query:
SELECT
pv.properties_values_id, pv.properties_id, pv.sort_order, pv.value_model, pv.weight,
pv.value_price, pv.display_image, pv.stock_centrally_managed, pv.stock, pv.stock_type,
pvd.properties_values_description_id, pvd.language_id, pvd.values_name, pvd.description
FROM properties_values as pv
INNER JOIN properties_values_description as pvd
ON pv.properties_values_id = pvd.properties_values_id
WHERE pv.properties_id IN ()"
Uncaught Error: Call to a member function fetch_assoc() on bool in /var/www/html/gxshop-4.4.0.3/gambio_updater/updates/v4.5.1.0/product_variants_migration.php:126
Things to be tested:
- Install a v4.4.0.3 shop
- Remove all combis & properties
- Update the shop to v4.5.1.0