- March 18, 2014 at 10:35 am #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= /*
*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
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?March 18, 2014 at 10:51 am #1417
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,
Attachments:You must be logged in to view attached files.
If you like my products, don't forget to rate them on codecanyon :)
March 18, 2014 at 11:52 am #1419
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 ZiegelbauerMarch 18, 2014 at 1:42 pm #1420
You must be logged in to reply to this topic.