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
I have just installed your plugin and it works fine with the csv file but I need it to connect to the table I put in my WP database. I have run the query in myphpadmin with success a few times then copied it in to the plugin and get this error.
wpDataTables backend error:
No data fetched!
Rendered query: select * from TABLE 2 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 'TABLE 2 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)
Hi californiasteve,
Thank you for your purchase.
Please try to remove LIMIT 10 from your query because our plugin is adding it to query.
Here is the query I use, I didn't append the "Limit 10"
SELECT * FROM `TABLE 2`
Changed table name to same prefix as WP database and it works fine now.
Hi californiasteve,
I am glad that you have resolved your issue.