I Get Error When I Use $This->_Select In Admincontroller

[zelakioui]

When I extends adminController, and define values to display in $this->_select variable, Prestashop display this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' a.id_product, a.store_name FROM `ps_selstock_product` a LEF' at line 3

			SELECT SQL_CALC_FOUND_ROWS
			
			, a.id_product, a.store_name
			FROM `ps_selstock_product` a
			
			
        LEFT JOIN `ps_product` al ON (al.`id_product` = a.`id_product`)
             
			
			WHERE 1 
			
			
			ORDER BY a.`id_selstock_product` ASC LIMIT 0,50

My $this->_select variable contains:

$this->_select = 'a.id_product, a.store_name';

I know the query should be like this one, deleting ',':

SELECT SQL_CALC_FOUND_ROWS

a.store_name,
a.id_product FROM `ps_selstock_product` a


WHERE 1 

ORDER BY a.`id_selstock_product` ASC LIMIT 0,50

But I don't know how to process because the query is built by prestashop I defined just the attributes to display

 

 

[rafapas22]

I have same error, are you fixed?