Okay
  Public Ticket #998979
MYSQL Query Error
Closed

Comments

  • californiasteve started the conversation

    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

    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

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

    SELECT * FROM `TABLE 2`

  • californiasteve replied

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

  • [deleted] replied

    Hi californiasteve,

    I am glad that you have resolved your issue.