Title: wpDataTables Automatic ‘LIMIT 10’ Syntax Error
Last modified: September 19, 2022

---

# wpDataTables Automatic ‘LIMIT 10’ Syntax Error

 *  Resolved [sandjd14](https://wordpress.org/support/users/sandjd14/)
 * (@sandjd14)
 * [3 years, 7 months ago](https://wordpress.org/support/topic/wpdatatables-automatic-limit-10-syntax-error/)
 * I’m creating a data table via SQL query and am getting the following error:
 * ‘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 ‘LIMIT 10′ at line
   91’
 * However, I’m not including a LIMIT function anywhere in my query – it looks like
   the limit is being automatically added. Below is the end of the SQL script that
   wpDataTables returns to me as part of the error
 * ‘; LIMIT 10’
 * How can i stop wp from adding this limit to my query that causes a syntax error

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Author [wpDataTables](https://wordpress.org/support/users/wpdatatables/)
 * (@wpdatatables)
 * [3 years, 7 months ago](https://wordpress.org/support/topic/wpdatatables-automatic-limit-10-syntax-error/#post-16023405)
 * Hi, sandjd14.
    – Since you’re using the Premium version of the plugin, please
   open a ticket on our [official support platform](https://tmsplugins.ticksy.com/),
   and we’ll gladly help you there.
 * Commercial products are [not supported in these forums](https://wordpress.org/support/guidelines/#do-not-post-about-commercial-products),
   as per [this comment](https://wordpress.org/support/topic/error-when-not-logged-into-wordpress-backend/#post-15050671)
   by WordPress.org moderators.
 * Thank you for understanding.
 *  Moderator [Jan Dembowski](https://wordpress.org/support/users/jdembowski/)
 * (@jdembowski)
 * Forum Moderator and Brute Squad
 * [3 years, 7 months ago](https://wordpress.org/support/topic/wpdatatables-automatic-limit-10-syntax-error/#post-16023450)
 * Good reply.
 * For pro or commercial product support please contact the developer directly on
   their site. This includes any pre-sales topics as well.
 * As the developer is aware, commercial products are [not supported in these forums](https://wordpress.org/support/guidelines/#do-not-post-about-commercial-products).
   I am sure they will have no problem supporting you there.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘wpDataTables Automatic ‘LIMIT 10’ Syntax Error’ is closed to new replies.

 * ![](https://ps.w.org/wpdatatables/assets/icon-128x128.gif?rev=3010404)
 * [wpDataTables - WordPress Data Table, Dynamic Tables & Table Charts Plugin](https://wordpress.org/plugins/wpdatatables/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wpdatatables/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wpdatatables/)
 * [Active Topics](https://wordpress.org/support/plugin/wpdatatables/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wpdatatables/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wpdatatables/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Jan Dembowski](https://wordpress.org/support/users/jdembowski/)
 * Last activity: [3 years, 7 months ago](https://wordpress.org/support/topic/wpdatatables-automatic-limit-10-syntax-error/#post-16023450)
 * Status: resolved