As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #1789286
Search not working - issues creating a "View"
Closed

Comments

  • Komplexideas started the conversation
    November 19, 2018 at 6:30pm

    I've created a Custom Post Type which I want to make a table of. When I do so, the Search function doesn't work. I realize I have to create a view. However, when doing so, I receive the error "The SELECT statement cannot contain a subquery in the FROM clause." Assistance with a work around would be greatly appreciated. Thanks.

  •  472
    Isidora replied
    November 20, 2018 at 11:38am

    Hi Komplexideas,
    Thank you for your purchase.

    As MySQL documentation on create view statement says:

    A view definition is subject to the following restrictions:
    Before MySQL 5.7.7, the SELECT statement cannot contain a subquery in the FROM clause.

    This means, that choosing a MySQL v5.7.7 or newer or upgrading the existing MySQL instance to such a version, would remove this restriction on views completely.

    However, if you have a current production MySQL version that is earlier than v5.7.7, then the removal of this restriction on views should only be one of the criteria being assessed while making a decision as to upgrade or not. Using the workaround techniques described in the other answers may be a more viable solution.

    On website stackoverflow.com you can find a lot of useful examples how you can solve this issue changing your query that is used in that view.

    Best regards.

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter |  Amelia demo sites | Docs

    You can try our wpDataTables add-ons before purchase on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables