Okay
  Public Ticket #1787286
Global Search is not working after updating from 2.2.1 to 2.3.2
Closed

Comments

  • Tommy started the conversation

    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.

    Tommy

  •   Milan replied privately
  •   Tommy replied privately
  •  394
    Milan replied

    Hi Tommy,

    Yes we need all tables that you are using in this view, so we can try to reproduce same issue.

    Best regards.

    Check out our documentation for Amelia - WordPress booking plugin on this link.

    Check out our documentation for wpDataTables - WordPress table plugin on this link.

    Kind Regards,
    MIlan Jovanovic
    milan.jovanovic@touchmesoft.net

  •   Tommy replied privately
  •   Milan replied privately
  •   Tommy replied privately
  •  394
    Milan replied

    Hi Tommy,

    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! 

    Best regards.

    Check out our documentation for Amelia - WordPress booking plugin on this link.

    Check out our documentation for wpDataTables - WordPress table plugin on this link.

    Kind Regards,
    MIlan Jovanovic
    milan.jovanovic@touchmesoft.net

  • Larry Kolinek replied

    can i ask what the solution was? how was the problem solved?

    :)

  •  394
    Milan replied

    Hi Larry,

    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.

    Best regards.

    Check out our documentation for Amelia - WordPress booking plugin on this link.

    Check out our documentation for wpDataTables - WordPress table plugin on this link.

    Kind Regards,
    MIlan Jovanovic
    milan.jovanovic@touchmesoft.net