GX-Entwicklung

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.