Jump to content

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


Recommended Posts

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

			, 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 ',':


a.id_product FROM `ps_selstock_product` a


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



Link to comment
Share on other sites

  • 1 year later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...