wpDataTables backend error: No data fetched! Rendered query: SELECT * FROM Eyal-002 LIMIT 10 MySQL said: 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 '-002 LIMIT 10' at line 1 This usually happens when the MySQL query returns an empty result or is broken. Please check the results of the query in some DB manager (e.g. PHPMyAdmin)
I try to run the same query via PHP admin and manage to display the table content.
Hello all
Cannot create new table type – MySql query
The table name is Eyal-002
The query syntax is - SELECT * FROM `Eyal-002`
The error that I get is
wpDataTables backend error: No data fetched! Rendered query: SELECT * FROM Eyal-002 LIMIT 10 MySQL said: 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 '-002 LIMIT 10' at line 1 This usually happens when the MySQL query returns an empty result or is broken. Please check the results of the query in some DB manager (e.g. PHPMyAdmin)
I try to run the same query via PHP admin and manage to display the table content.
The table structure us very simple
id age name home
1 age4 name4 home4
2 age5 name5 home5
My test website address is http://doctoroffice365.com
If you want I can send you admin username + password
i attach a link to a screenshot
https://www.dropbox.com/s/94kr1pgruiz0d1q/q2.docx?dl=0
Best regards
Eyal
Hi Eyal,
Thank you for the purchase.
Can you try not to use backticks ` in the query and to change the table name so it wouldn't contain hypen, so we can see does it cause this issue?
yes , i will do si and update you