Project

General

Profile

GX-Bug #69319

Error in Gambio Updater when no properties are present

Added by Timo Backhaus about 1 year ago. Updated 10 months ago.

Status:
Erledigt
Priority:
Normal
Assignee:
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

History

#1

Updated by Timo Backhaus about 1 year 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)
#2

Updated by Lennard Kläfker about 1 year ago

  • Tags set to 4.5.1.0_Final
#3

Updated by Alexandre Ataides about 1 year ago

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

Updated by Alexandre Ataides about 1 year ago

  • Description updated (diff)
#5

Updated by Alexandre Ataides about 1 year ago

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

Updated by Alexandre Ataides about 1 year ago

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

Updated by Marvin Muxfeld about 1 year ago

  • Assignee set to Marvin Muxfeld
#9

Updated by Marvin Muxfeld about 1 year ago

  • Assignee deleted (Marvin Muxfeld)
#10

Updated by Ahmed Hamouda about 1 year ago

  • Assignee set to Ahmed Hamouda
#11

Updated by Ahmed Hamouda about 1 year ago

  • Target version set to 4.5.1.0
#12

Updated by Ahmed Hamouda about 1 year ago

  • Status changed from Testing to Erledigt
#13

Updated by Daniel Wu 10 months ago

  • Tags deleted (4.5.1.0_Final)

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 5 MB)