Speedclinic asked 5 years ago
Hello,
I am currently testing grid4php. Looks really nice. I have placed it inside joomla with regularlabs.
When I try to sort a column, I am getting an error. Same when I try to execute directly on my mysql database.
Couldn’t execute query. 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 ‘AND ( `store_myproject_data_upload__id_user` LIKE ‘%30%’ )) pg_tmp’ at line 7 – SELECT count(*) as c FROM ( SELECT store_myproject_data_upload__id, store_myproject_data_upload__id_user FROM store_myproject_data_upload AND ( `store_myproject_data_upload__id_user` LIKE ‘%30%’ )) pg_tmp
columns come from database. Both are int value.
Query looks ok to me, but could not be executed.
Abu Ghufran Staff answered 5 years ago
The query is incorrect. It should have a WHERE clause after “FROM store_myproject_data_upload”
If you can share full code, i can help further.
Attach code here and paste link in question.
