[PrestaShopDatabaseException]

Expression #1 of ORDER BY clause is not in SELECT list, references column 'goorgani_live.cs.position' which is not in SELECT list; this is incompatible with DISTINCT

		SELECT DISTINCT c.*, cl.*
		FROM `ps_category` c 
		LEFT JOIN `ps_category_shop` cs ON (c.`id_category`=cs.`id_category` AND cs.`id_shop`=1)
		LEFT JOIN `ps_category_lang` cl ON (cs.`id_category`=cl.`id_category` AND  cl.`id_shop`=cs.`id_shop` AND `id_lang` = 1)
		LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
		WHERE c.`active` = 1 AND cl.`id_shop` IS NOT NULL AND `level_depth` <= 8
		AND cg.`id_group` = 1
		ORDER BY cs.`position` ASC ,`level_depth` ASC

at line 635 in file classes/db/Db.php

629. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
630. 		}
631. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
632. 		{
633. 			if ($sql)
634. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
635. 			throw new PrestaShopDatabaseException($this->getMsgError());
636. 		}
637. 	}
638. 
639. 	/**