SQL Manager Error : "The LIMIT clause must contain numeric arguments"

[USB83]

Hello,

I'm trying to use the SQL Manager to list user details (first/last name, email and their country) but i would like the query to only return a certain amount of users.

But when i include the LIMIT clause, i get this error message : "The LIMIT clause must contain numeric arguments"

This is what my query looks like :

SELECT firstname, lastname, email, FROM ps_customer LIMIT 150

Any help is welcome

 

 

[NemoPS]

It might need two, did you try LIMIT 0,150 ?

[zoombamboom]

I encountered the same problem. The LIMIT 0,150 does not solve it.

Managed to get it working doing

ORDER BY firstname DESC LIMIT 0,150

replace firstname by what you prefer here.

[PrestaHeroes USA]

 

there are several github mentions for this issue

https://www.google.com/search?q="The+LIMIT+clause+must+contain+numeric+arguments"&oq="The+LIMIT+clause+must+contain+numeric+arguments"&aqs=chrome..69i57j69i60&sourceid=chrome&ie=UTF-8