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