Title: error message – sort by create on
Last modified: October 4, 2019

---

# error message – sort by create on

 *  Resolved [jayjelee](https://wordpress.org/support/users/jayjelee/)
 * (@jayjelee)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/error-message-sort-by-create-on/)
 * I have error message when I use Store locator
 * The error happened in the Manage Stores section. Store locator> Manage Stores
   
   You see a table with all of the added stores. When you click on a column heading(
   Created On) in the table, it should sort that column. It does not sort and gives
   that error message.
 * Error message –
    “DataTables warning: table id=tbl_stores – 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 ‘asc LIMIT 0, 10’ at line 1”
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Ferror-message-sort-by-create-on%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Plugin Author [Agile Logix](https://wordpress.org/support/users/agilelogix/)
 * (@agilelogix)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/error-message-sort-by-create-on/#post-11996931)
 * Yes, thanks for reporting it, we will upload a fix for it by Monday.
 * Thank you
    -  This reply was modified 6 years, 6 months ago by [Agile Logix](https://wordpress.org/support/users/agilelogix/).
 *  Thread Starter [jayjelee](https://wordpress.org/support/users/jayjelee/)
 * (@jayjelee)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/error-message-sort-by-create-on/#post-12015467)
 * I have been waiting … keep checking out.. Is this already fixed and uploaded ?
   
   will you send me URL for downloading it or will you update plugin?
 *  Plugin Author [Agile Logix](https://wordpress.org/support/users/agilelogix/)
 * (@agilelogix)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/error-message-sort-by-create-on/#post-12016115)
 * Hi, sorry it will be up by tomorrow, which version you are using?
 * Thank you
 *  Plugin Author [Agile Logix](https://wordpress.org/support/users/agilelogix/)
 * (@agilelogix)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/error-message-sort-by-create-on/#post-12016546)
 * Hi, it is resolved, please download.
 * Thanks

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

The topic ‘error message – sort by create on’ is closed to new replies.

 * ![](https://ps.w.org/agile-store-locator/assets/icon-128x128.png?rev=2780478)
 * [Store Locator WordPress](https://wordpress.org/plugins/agile-store-locator/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/agile-store-locator/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/agile-store-locator/)
 * [Active Topics](https://wordpress.org/support/plugin/agile-store-locator/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/agile-store-locator/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/agile-store-locator/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [Agile Logix](https://wordpress.org/support/users/agilelogix/)
 * Last activity: [6 years, 6 months ago](https://wordpress.org/support/topic/error-message-sort-by-create-on/#post-12016546)
 * Status: resolved