WordPress.org

Forums

Edit Any Table
[resolved] Can read tables but no results found (11 posts)

  1. Flanna
    Member
    Posted 11 months ago #

    I can see tables and even add records but "find" never finds anything, always returns "no results found"

    https://wordpress.org/plugins/edit-any-table/

  2. redeyedmonster
    Member
    Plugin Author

    Posted 11 months ago #

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

  3. Flanna
    Member
    Posted 11 months ago #

    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".

  4. redeyedmonster
    Member
    Plugin Author

    Posted 11 months ago #

    Strange - can you post the table schema?

  5. Flanna
    Member
    Posted 11 months ago #

    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".

  6. redeyedmonster
    Member
    Plugin Author

    Posted 11 months ago #

    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.

  7. Flanna
    Member
    Posted 11 months ago #

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

  8. redeyedmonster
    Member
    Plugin Author

    Posted 11 months ago #

    Other plug-ins?

  9. Flanna
    Member
    Posted 11 months ago #

    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?

  10. redeyedmonster
    Member
    Plugin Author

    Posted 11 months ago #

    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.

  11. redeyedmonster
    Member
    Plugin Author

    Posted 7 months ago #

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

Reply

You must log in to post.

About this Plugin

  • Edit Any Table
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic