GX-Bug #69319
closedError in Gambio Updater when no properties are present
0%
Die Optionsmigration wird nicht ausgeführt, wenn beim Aktualisieren des Shops keine Eigenschaften vorhanden sind.
Description
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
Updated by Timo Backhaus about 2 years ago
- Subject changed from Error in Gambio Updater when no properties and attributes are present to Error in Gambio Updater when no properties are present
- Description updated (diff)
Updated by Alexandre Ataides about 2 years ago
- Status changed from Gemeldet to In Prüfung
- Assignee set to Alexandre Ataides
Updated by Alexandre Ataides about 2 years ago
- Status changed from In Prüfung to In Bearbeitung
Updated by Alexandre Ataides about 2 years ago
- Status changed from In Bearbeitung to Testing
- Assignee deleted (
Alexandre Ataides) - Release Notes Langtext updated (diff)
Updated by Ahmed Hamouda about 2 years ago
- Status changed from Testing to Erledigt