Oc 2.3.0.2
in admin when I want to edit some product I get this error. It happen only on some products. What I can see that there are more than 1 row for that product id, but when I make SQL query I get only one. Anyone can help?
Code: Select all
Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /data/web/virtuals/104382/virtual/www/system/library/db/mysqli.php on line 18
Fatal error: Uncaught exception 'Exception' with message 'Error: Subquery returns more than 1 row<br />Error No: 1242<br />SELECT DISTINCT *, (SELECT keyword FROM url_alias WHERE query = 'product_id=1754') AS keyword FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '1754' AND pd.language_id = '2'' in /data/web/virtuals/104382/virtual/www/system/library/db/mysqli.php:40 Stack trace: #0 /data/web/virtuals/104382/virtual/www/system/library/db.php(16): DB\MySQLi->query('SELECT DISTINCT...', Array) #1 /data/web/virtuals/104382/virtual/www/system/storage/modification/admin/model/catalog/product.php(366): DB->query('SELECT DISTINCT...') #2 [internal function]: ModelCatalogProduct->getProduct('1754') #3 /data/web/virtuals/104382/virtual/www/vqmod/vqcache/vq2-system_storage_modification_system_engine_loader.php(189): call_user_func_array(Array, Array) #4 [internal function]: Loader->{closure}(Array, Array) #5 /data/web/virtuals/104382/virtual/www/system/engine/proxy.php(25): ca in /data/web/virtuals/104382/virtual/www/system/library/db/mysqli.php on line 40