Statistics problem (again) when upgrade from v2.1 to v2.4

Home Forums Product Support Forums Ajax Search Pro for WordPress Support Statistics problem (again) when upgrade from v2.1 to v2.4

This topic contains 3 replies, has 2 voices, and was last updated by administrator3 administrator3 10 years, 1 month ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
  • #1416

    Upgraded from v2.1 to 2.4

    Error message when access statistics

    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

    ” at line 1]
    SELECT * FROM wp_nfpp3acw1f_ajaxsearchpro WHERE id= /*

    From [

    page=ajax-search-pro/backend/statistics.php] in


    search-pro/backend/statistics.php:23] */

    *Note, maybe you will remember that there was a

    problem with my v2.1 install that you corrected with a

    direct change to my code on my (former) development

    site [].
    The error appears at the top of the statistics page.

    Is this the same problem as before? If so was the fix

    not included in these more recent releases?

    Ernest Marcinko
    Ernest Marcinko


    Just checked the code, there is indeed an error in the code. Shouldn’t affect the statistics, however I will include the fixed file to this post.
    After unzipping, you should replace the wp-content/plugins/ajax-search-pro/backend/statistics.php with it.

    Hopefully the error will disappear.

    You must be logged in to view attached files.
    Ernest Marcinko

    If you like my products, don't forget to rate them on codecanyon :)



    Thank you. the new statistics.php file corrected the problem.

    Please include this fix in future releases.

    One more minor issue to be aware of: The upgrade lost my search box theme customizations. I had to go in and re-select the grey theme and re-select the search active icon.


    Future feature request: Can you add a list of unsuccessful search terms to the statistics page? It is very helpful to know which terms readers are typing that did not result in a search success so we can add content or add keywords.

    Ken Ziegelbauer


    Ernest, I spoke too soon. The problem was corrected for the ‘Statistics for: All’ case. However the problem remains when you select one of the search bow types. See the image attached.
    Ken Z

    You must be logged in to view attached files.
Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.