Can read tables but no results found

Can you please give me an example of your search term and what yuou would expect to return. Thanks.

I have a table with 1 record. The record has ID, Date and Name. The only record has the Name set to “John”.
I searched with “John” in the Name field box and got “no results found”. I then searched with nothing in the field boxes and also got “no results found”. I expected to find the record for “John”.

Strange – can you post the table schema?

I don’t know where to find the schema. So, I have added the standard wp_posts table. When I search for post_author = 1 I still get “no results found”. If you need to see the schema, it’s the standard one as installed by WordPress. And there is a post_author with ID 1. An empty search of this table also produces “no results found”.

OK thanks. A few more questions.

• Have you just installed Edit-Any-Table or was it working and now it’s stopped? (if you have just installed try uninstalling and then reinstalling)
• What other plugins do you use?
• Can you tell me the versions of PHP and MySql your hosting is using?
• What version of WordPress are you on?

Thanks for your patience, I’m sure we can get to the bottom of this.

WordPress 3.9.1
PHP 5.4.24
I removed Edit Any Table and re-installed it. Exactly the same as before…

Other plug-ins?

Yes there are some other plugins. Including; DBVIEW and Easy Table, both of which are in use.
Are there any that are known to conflict with Edit Any Table?

There doesn’t seem to be an issue with either of these plugins. I will release a new version shortly which may help to unravel this problem.

I have added a debug mode which should help you resolve the problem