Project

General

Profile

Actions

GX-Bug #69319

closed

Error in Gambio Updater when no properties are present

Added by Timo Backhaus about 2 years ago. Updated over 1 year ago.

Status:
Erledigt
Priority:
Normal
Assignee:
Ahmed Hamouda
Category:
Updater
Target version:
% Done:

0%

Estimated time:
Steps to reproduce:
Betroffene Versionen:
4.5.1.0 RC1
Release Notes Langtext:

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

Actions #1

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)
Actions #2

Updated by Lennard Kläfker about 2 years ago

  • Tags set to 4.5.1.0_Final
Actions #3

Updated by Alexandre Ataides about 2 years ago

  • Status changed from Gemeldet to In Prüfung
  • Assignee set to Alexandre Ataides
Actions #4

Updated by Alexandre Ataides about 2 years ago

  • Description updated (diff)
Actions #5

Updated by Alexandre Ataides about 2 years ago

  • Status changed from In Prüfung to In Bearbeitung
Actions #6

Updated by Alexandre Ataides about 2 years ago

  • Status changed from In Bearbeitung to Testing
  • Assignee deleted (Alexandre Ataides)
  • Release Notes Langtext updated (diff)
Actions #8

Updated by Marvin Muxfeld about 2 years ago

  • Assignee set to Marvin Muxfeld
Actions #9

Updated by Marvin Muxfeld about 2 years ago

  • Assignee deleted (Marvin Muxfeld)
Actions #10

Updated by Ahmed Hamouda about 2 years ago

  • Assignee set to Ahmed Hamouda
Actions #11

Updated by Ahmed Hamouda about 2 years ago

  • Target version set to 4.5.1.0
Actions #12

Updated by Ahmed Hamouda about 2 years ago

  • Status changed from Testing to Erledigt
Actions #13

Updated by Daniel Wu over 1 year ago

  • Tags deleted (4.5.1.0_Final)
Actions

Also available in: Atom PDF