GX-Task #69885
offen
Reduce exceptions caused by database with corrupted product options data
0%
Beschreibung
Multiple reports were received about the inability to access additional product options (product attributes) and raised exception
CRITICAL: The option value ID must be a positive integer. Got: 0
This occurs when getting data by ProductOptionReader link with null information from the table products_options_values left join.
Example of support ticket reported with the problem https://ticketsystem.gambio-support.de/index.php/tickets/view/101404591
A screenshot of an example of corrupted database results is provided.
One suggested solution is to add a condition to the join to prevent querying option values with no records in the joined table. Such change should be discussed to figure out the effects of suppressing exceptions that could be used to inform shop owners about their damaged databases.
Dateien
| Screenshot from 2022-07-21 10-12-03.png (107 KB) Screenshot from 2022-07-21 10-12-03.png | example with corrupted database results |
Von Patrick Bayer vor etwa 2 Jahren aktualisiert
- Status wurde von Gemeldet zu Anerkannt geändert