Error: Error: Subquery returns more than 1 row
Error No: 1242
SELECT pvs.*,(SELECT CONCAT(c.firstname, ' ', c.lastname) FROM oc_customer c WHERE c.customer_id = pvs.seller_id) AS seller,(SELECT co.name FROM oc_country_description co WHERE co.country_id = pvs.store_country) AS seller_country FROM oc_purpletree_vendor_stores pvs RIGHT JOIN oc_customer c ON (pvs.seller_id = c.customer_id) WHERE FIND_IN_SET('0',pvs.multi_store_id) AND pvs.store_status='1'ORDER BY LCASE(pvs.store_name) ASC LIMIT 0,20 File: D:\websites\cho24h_oc\upload\system\library\db\mysqli.php Line: 122 Backtrace: 0 File: D:\websites\cho24h_oc\upload\system\library\db.php Line: 54 Class: Opencart\System\Library\DB\MySQLi Function: query Backtrace: 1 File: D:\websites\cho24h_oc\upload\extension\purpletree_multivendor\catalog\model\multivendor\sellers.php Line: 129 Class: Opencart\System\Library\DB Function: query Backtrace: 2 File: D:\websites\cho24h_oc\upload\system\engine\loader.php Line: 343 Class: Opencart\Catalog\Model\Extension\PurpletreeMultivendor\Multivendor\Sellers Function: getSellers Backtrace: 3 File: D:\websites\cho24h_oc\upload\system\engine\proxy.php Line: 87 Class: Opencart\System\Engine\Loader Function: Opencart\System\Engine\{closure} Backtrace: 4 File: D:\websites\cho24h_oc\upload\extension\purpletree_multivendor\catalog\controller\multivendor\sellers.php Line: 84 Class: Opencart\System\Engine\Proxy Function: __call Backtrace: 5 File: D:\websites\cho24h_oc\upload\system\engine\action.php Line: 96 Class: Opencart\Catalog\Controller\Extension\PurpletreeMultivendor\Multivendor\Sellers Function: index Backtrace: 6 File: D:\websites\cho24h_oc\upload\system\framework.php Line: 259 Class: Opencart\System\Engine\Action Function: execute Backtrace: 7 File: D:\websites\cho24h_oc\upload\index.php Line: 20 Function: require_once