As previously announced via banners and our newsletters, support is no longer available through this platform.
For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.
You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.
Paid customers: Please log in to your store account for support.
Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com
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