Codeigniter-DataTables icon indicating copy to clipboard operation
Codeigniter-DataTables copied to clipboard

Error when table is empty

Open jnar opened this issue 8 years ago • 2 comments

Hi, first of all thanks for sharing this nice library works great. How do I prevent this error when table has no records?

Error Number:

ERROR: syntax error near «)» LINE 3: WHERE () IS NULL ^ SELECT s.id FROM "items" "s" WHERE () IS NULL Filename: D:/www/myapp/system/database/DB_driver.php

Line Number: 691

jnar avatar Feb 12 '17 12:02 jnar

Could you provide a gist or a paste with the sample code? I had a similar problem and wasn't the table was a problem on syntax.

josefig avatar Feb 24 '17 00:02 josefig

something is wrong, "where () is null" ? what is "()"?

leandroruel avatar Mar 28 '17 18:03 leandroruel