Unknown column ‘ ‘ in ‘WHERE’

  • Resolved dougschofield

    (@dougschofield)


    1 year, 5 months ago

    Hello there!

    I created simple table and a Database App with App Builder. I copied and pasted shortcode on a page and done. I can see the data fine, but the Search feature does not work. I cannot find anything for configuring the search button. I did find a place for Default Where, but I would think I would not want a default search. Note: When I type a letter like “a” I see it working for a split second before it errors out.

    Please explain how I should fix this. You would think right out of the box this should work.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    1 year, 5 months ago

    Hi @dougschofield,

    Thanks for the post! Are you currently using the free version?

    We found that this issue only appears on the free version but not on the premium. Once it’s been fixed, we’ll push an update as soon as we can!

    If you’re using the premium version instead, please send us a ticket via Contact | WP Data Access so we can take a closer look.

    We appreciate your patience. 🙏

    Thread Starter dougschofield

    (@dougschofield)

    1 year, 5 months ago

    Thanks! I see you fixed it and pushed update. The search feature is working now.

    However, I found a new problem. I made 1 column be a hyperlink on this page: https://staging.upcgroup.net/distributors/

    The text is set to: https://www.alphabaking.com in plain text.

    I changed the Table setting from “Preformatted JSON” to “Plain Text”. I can’t really read the error but I think it say “media: check connection”.

    Can you take a look?

    Thanks,

    Doug

    Plugin Contributor Kim L

    (@kimmyx)

    1 year, 5 months ago

    Hi @dougschofield,

    We checked your table and saw the issue you described.

    Could you send us a message via Contact | WP Data Access? We might need to take a closer look at your staging site.

    We’ll wait for your email!

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Unknown column ‘ ‘ in ‘WHERE’’ is closed to new replies.