PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Database error when sorting filtered entries

Gravity Support Forums » Plugin Support » Gravity Forms

  1. tamlyn
    Member

    When viewing unread or starred form entries, I get a SQL error if I choose to sort on any of the columns:

    WordPress database error: [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 'WHERE status='active' LIMIT 0,20 ) filtered ON filt' at line 26]

    Posted 12 years ago on Friday February 24, 2012 | Permalink

  2. Dana Cobb
    Administrator

    Hi, tamlyn,

    I am able to reproduce this issue. The error was introduced in GF v.1.6.3.1. We will work on getting this fixed.

    Thanks for reporting it!

    Posted 12 years ago on Monday February 27, 2012 | Permalink

  3. Alex Cancado
    Administrator

    Hello tamlyn,
    I was able to pinpoint and fix this issue. It will be included in our next public release, but if you are on a rush to get this resolved, email me to alex@rocketgenius.com and I will send you a version with the fix. Please include a link to this thread.

    Posted 12 years ago on Tuesday February 28, 2012 | Permalink

This topic has been resolved and has been closed to new replies.