Unknown column ‘ ‘ in ‘where clause’

  • Resolved nikhildusane

    (@nikhildusane)


    1 year, 6 months ago

    After the recent plugin update, upon clicking in the search box in an app, this error shows up:

    Unknown column ‘ ‘ in ‘where clause’

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

    (@kimmyx)

    1 year, 6 months ago

    Hi @nikhildusane,

    Do you have any entries in the Default Where field in your table?

    See here: Default where | WP Data Access

    If the table is public, please send us a link so we can check it.

    You can also send us a message via Contact | WP Data Access if you want to share more information privately.

    We’ll wait for your message!

    Thread Starter nikhildusane

    (@nikhildusane)

    1 year, 6 months ago

    Hi Kim,

    Thanks for your reply. There is no “Default Where” clause in the App. I am just doing a select * from a view that is built in PHPmyAdmin. The search used to work earlier, but after the recent plugin update, the search is failing.

    Plugin Contributor Kim L

    (@kimmyx)

    1 year, 6 months ago

    Hi @nikhildusane,

    Thanks for the response.

    Are you using the old legacy table? Is there a link for us to view this table?

    You can also send us a ticket via Contact | WP Data Access if you want us to take a closer look.

    We’ll wait for your email!

    Thread Starter nikhildusane

    (@nikhildusane)

    1 year, 6 months ago

    Hi @kimmyx , I have created a ticket. The table’s data is not public. I created a test app with a simple table, and the search option still shows the same error.

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

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