Fix error in Opencart e-commerce
Budget: $10 – $30 USD
if i add product on opencart, it will take other product name "Peruskone 1"
Maybe it is because product takes wrong ID from MySql????
After i edit that product it gives error:
"Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /var/www/datastoppi/system/library/db/mysqli.php on line 19Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT DISTINCT *, TRIM(LEADING '0' FROM p.ean), (SELECT keyword FROM oc_url_alias WHERE query = 'product_id=113') AS keyword FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '113' AND pd.language_id = '1' in /var/www/datastoppi/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/datastoppi/vqmod/vqcache/vq2-system_storage_modification_admin_model_catalog_product.php on line 648Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /var/www/datastoppi/system/library/db/mysqli.php on line 19Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT DISTINCT *, TRIM(LEADING '0' FROM p.ean), (SELECT keyword FROM oc_url_alias WHERE query = 'product_id=113') AS keyword FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '113' AND pd.language_id = '1' in /var/www/datastoppi/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/datastoppi/vqmod/vqcache/vq2-system_storage_modification_admin_model_catalog_product.php on line 648"
Can someone help me for this problem?
Maybe it is because product takes wrong ID from MySql????
After i edit that product it gives error:
"Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /var/www/datastoppi/system/library/db/mysqli.php on line 19Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT DISTINCT *, TRIM(LEADING '0' FROM p.ean), (SELECT keyword FROM oc_url_alias WHERE query = 'product_id=113') AS keyword FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '113' AND pd.language_id = '1' in /var/www/datastoppi/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/datastoppi/vqmod/vqcache/vq2-system_storage_modification_admin_model_catalog_product.php on line 648Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /var/www/datastoppi/system/library/db/mysqli.php on line 19Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT DISTINCT *, TRIM(LEADING '0' FROM p.ean), (SELECT keyword FROM oc_url_alias WHERE query = 'product_id=113') AS keyword FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '113' AND pd.language_id = '1' in /var/www/datastoppi/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/datastoppi/vqmod/vqcache/vq2-system_storage_modification_admin_model_catalog_product.php on line 648"
Can someone help me for this problem?