Global Search is not working after updating from 2.2.1 to 2.3.2
On my live site you can see here that you can search the table. http://www.thecouponingcouple.com/coupon-database-mobile-friendly/
I updated the plugin in my staging area and the data populates but you can not search: http://couponingcpl.staging.wpengine.com/coupon-database-mobile-friendly/
This query is using a view and I been using for a long time with no problems until I tried the update.
Any help would be appreciated.
Yes we need all tables that you are using in this view, so we can try to reproduce same issue.
Check out our new Support Help Center!
Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin - promo price for launch period!
I am glad that now searching is working fine.
If you have any more issues or questions feel free to open a new ticket, we will gladly help.
We'd greatly appreciate it if you could take a minute and leave a Review on CodeCanyon on this link. Thanks!
can i ask what the solution was? how was the problem solved?
Can you please tell me do you use accent grave (`) in that queries like:
SELECT * FROM `your_table_name`
If that is the case please remove it and searching will work.
From version 2.3 we implement feature that you can use multiply separate db connections for (MySQL,MSSQL and PostgreSQL) and for MySQL engine we are dynamically adding accent grave (`).
About the future question:
When you are posting on ticket that are not yours or have questions or issues which are not related to the title of the active ticket can you please open a new one, and we will help you there. In that way, issues and questions which are related to different subjects will be in different tickets so other customers or our support agents can find it easily. Our policy is to have one issue or question per ticket because of the reasons that is described already.
Thank you for understanding.