Title: Unknown column ‘ ‘ in ‘WHERE’
Last modified: November 25, 2024

---

# Unknown column ‘ ‘ in ‘WHERE’

 *  Resolved [dougschofield](https://wordpress.org/support/users/dougschofield/)
 * (@dougschofield)
 * [1 year, 5 months ago](https://wordpress.org/support/topic/unknown-column-in-where/)
 * 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](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Funknown-column-in-where%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Plugin Contributor [Kim L](https://wordpress.org/support/users/kimmyx/)
 * (@kimmyx)
 * [1 year, 5 months ago](https://wordpress.org/support/topic/unknown-column-in-where/#post-18161284)
 * Hi [@dougschofield](https://wordpress.org/support/users/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](https://wpdataaccess.com/contact/)
   so we can take a closer look.
 * We appreciate your patience. 🙏
 *  Thread Starter [dougschofield](https://wordpress.org/support/users/dougschofield/)
 * (@dougschofield)
 * [1 year, 5 months ago](https://wordpress.org/support/topic/unknown-column-in-where/#post-18173792)
 * 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/](https://staging.upcgroup.net/distributors/)
 * The text is set to: [https://www.alphabaking.com](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](https://wordpress.org/support/users/kimmyx/)
 * (@kimmyx)
 * [1 year, 5 months ago](https://wordpress.org/support/topic/unknown-column-in-where/#post-18177699)
 * Hi [@dougschofield](https://wordpress.org/support/users/dougschofield/),
 * We checked your table and saw the issue you described.
 * Could you send us a message via [Contact | WP Data Access](https://wpdataaccess.com/contact/)?
   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.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Kim L](https://wordpress.org/support/users/kimmyx/)
 * Last activity: [1 year, 5 months ago](https://wordpress.org/support/topic/unknown-column-in-where/#post-18177699)
 * Status: resolved