[Bug Report] 1064 SQL Syntax Error in hsuikit-0-9-7-beta (Joomla 6.1 / PHP 8.5)

Description: After updating to hsuikit-0-9-7-beta.zip, I encountered a "1064 You have an error in your SQL syntax" error on HikaShop product listing pages. The error disappears when the "System - HS UIKit Override" plugin is disabled.

The issue seems to be related to the plugin passing an empty or invalid query to the database driver, possibly due to compatibility issues with the current environment's database handling.

Environment:

• Joomla version: 6.1.0 Stable

• PHP version: 8.5.5

• Database: MariaDB 10.5.22

• HikaShop version: 6.4.1

• YOOtheme Pro version: 5.0.32

• HS UIKit version: 0.9.7 Beta

Error Details:

• Error Message: 1064 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 1

• Location: JROOT/plugins/system/hsuikit_override/dynamic/Source/TemplateListener6.php:159

Call Stack snippet:

1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138
2 mysqli->prepare() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138
...
5 Joomla\Database\DatabaseDriver->setQuery() JROOT/plugins/system/hsuikit_override/dynamic/Source/TemplateListener6.php:159
6 JPHSDynmic\Source\TemplateListener6->handle() JROOT/templates/yootheme/packages/container/src/Container.php:229

Steps to reproduce:

1. Use the environment mentioned above.

2. Install/Enable hsuikit-0-9-7-beta.

3. Navigate to a HikaShop product listing page using YOOtheme dynamic content.

Please investigate why setQuery() is receiving an invalid SQL string at line 159 of TemplateListener6.php in this specific setup.

We fixed the sql error due to empty product_id in the product listing query and updated the package file attached, so kindly check and confirm. Thank you