This topic contains 3 replies, has 2 voices, and was last updated by 
- Posts
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 [klc.staging.wpengine.com/wp-admin/admin.php?
page=ajax-search-pro/backend/statistics.php] in
[/nas/wp/www/staging/klc/wp-content/plugins/ajax-
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 [197.b80.myftpupload.com].
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?
Hi!
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.
Best,
Ernest Marcinko
If you like my products, don't forget to rate them on codecanyon :)
Ernest,
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 reply to this topic.