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