We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #998979
MYSQL Query Error
Closed

Comments

  • californiasteve started the conversation
    December 23, 2016 at 6:15pm

    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)

  • [deleted] replied
    December 23, 2016 at 6:47pm

    Hi californiasteve,
    Thank you for your purchase.

    Please try to remove LIMIT 10 from your query because our plugin is adding it to query.

  • californiasteve replied
    December 23, 2016 at 8:25pm

    Here is the query I use, I didn't append the "Limit 10" 

    SELECT * FROM `TABLE 2`

  • californiasteve replied
    December 23, 2016 at 9:38pm

    Changed table name to same prefix as WP database and it works fine now.

  • [deleted] replied
    December 25, 2016 at 4:58pm

    Hi californiasteve,

    I am glad that you have resolved your issue.