I recently installed a fresh version of Opencart 1.5.6 but uploaded only customers, products and orders from my old opencart 1.5.4.1. Of course, i had to make adjustments to the sql file.
The site seems to be running fine but i found this piled up in the error log over night.
Code: Select all
2014-01-02 8:18:10 - PHP Warning: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Unable to save result set in /home/test/public_html/FRESH-BUILD/system/database/mysql.php on line 22
2014-01-02 8:18:10 - PHP Notice: Error: Subquery returns more than 1 row<br />Error No: 1242<br />SELECT DISTINCT *, (SELECT keyword FROM oc_url_alias WHERE query = 'product_id=702') AS keyword FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '702' AND pd.language_id = '1' in /home/test/public_html/FRESH-BUILD/system/database/mysql.php on line 50
2014-01-02 8:19:51 - PHP Warning: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Unable to save result set in /home/test/public_html/FRESH-BUILD/system/database/mysql.php on line 22
2014-01-02 8:19:51 - PHP Notice: Error: Subquery returns more than 1 row<br />Error No: 1242<br />SELECT DISTINCT *, (SELECT keyword FROM oc_url_alias WHERE query = 'product_id=702') AS keyword FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '702' AND pd.language_id = '1' in /home/test/public_html/FRESH-BUILD/system/database/mysql.php on line 50
2014-01-02 8:21:17 - PHP Warning: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Unable to save result set in /home/test/public_html/FRESH-BUILD/system/database/mysql.php on line 22
2014-01-02 8:21:17 - PHP Notice: Error: Subquery returns more than 1 row<br />Error No: 1242<br />SELECT DISTINCT *, (SELECT keyword FROM oc_url_alias WHERE query = 'product_id=702') AS keyword FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '702' AND pd.language_id = '1' in /home/test/public_html/FRESH-BUILD/system/database/mysql.php on line 50
2014-01-02 8:21:42 - PHP Warning: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Unable to save result set in /home/test/public_html/FRESH-BUILD/system/database/mysql.php on line 22
2014-01-02 8:21:42 - PHP Notice: Error: Subquery returns more than 1 row<br />Error No: 1242<br />SELECT DISTINCT *, (SELECT keyword FROM oc_url_alias WHERE query = 'product_id=702') AS keyword FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '702' AND pd.language_id = '1' in /home/test/public_html/FRESH-BUILD/system/database/mysql.php on line 50
2014-01-02 8:22:39 - PHP Warning: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Unable to save result set in /home/test/public_html/FRESH-BUILD/system/database/mysql.php on line 22
2014-01-02 8:22:39 - PHP Notice: Error: Subquery returns more than 1 row<br />Error No: 1242<br />SELECT DISTINCT *, (SELECT keyword FROM oc_url_alias WHERE query = 'product_id=702') AS keyword FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '702' AND pd.language_id = '1' in /home/test/public_html/FRESH-BUILD/system/database/mysql.php on line 50
2014-01-02 8:25:43 - PHP Warning: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Unable to save result set in /home/test/public_html/FRESH-BUILD/system/database/mysql.php on line 22
2014-01-02 8:25:43 - PHP Notice: Error: Subquery returns more than 1 row<br />Error No: 1242<br />SELECT DISTINCT *, (SELECT keyword FROM oc_url_alias WHERE query = 'product_id=702') AS keyword FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '702' AND pd.language_id = '1' in /home/test/public_html/FRESH-BUILD/system/database/mysql.php on line 50
2014-01-02 8:27:06 - PHP Warning: mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Unable to save result set in /home/test/public_html/FRESH-BUILD/system/database/mysql.php on line 22
2014-01-02 8:27:06 - PHP Notice: Error: Subquery returns more than 1 row<br />Error No: 1242<br />SELECT DISTINCT *, (SELECT keyword FROM oc_url_alias WHERE query = 'product_id=702') AS keyword FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '702' AND pd.language_id = '1' in /home/test/public_html/FRESH-BUILD/system/database/mysql.php on line 50
