WordPress.org

Ready to get started?Download WordPress

Forums

Plugin Organizer
[resolved] Database Tables (9 posts)

  1. ccolotti
    Member
    Posted 1 year ago #

    Jeff,

    I moved my site and I think the old DB tables were removed in my cleanup. What tables are supposed to exist with the latest version if any?

    I uploaded a new plugin and it showed a warning of a PO_XXX table missing and I was not sure if that is yours.

    Is there a way to re-create them? I installed the latest version clean and activated it from stratch but did not see tables get created.

    http://wordpress.org/plugins/plugin-organizer/

  2. ccolotti
    Member
    Posted 1 year ago #

    This is the error:

    WordPress database error: [Table 'vfit_prod_wordpress.wp_PO_post_plugins' doesn't exist]
    DELETE FROM wp_PO_post_plugins WHERE post_id = 12232

    This is ONLY on a plugin that is manually uploaded but not ones downloaded directly

    Cheers!

  3. Jeff Sterup
    Member
    Plugin Author

    Posted 1 year ago #

    The custom database tables were all removed in version 3.0. Everything is now stored in the standard wordpress tables. If you get an error like that the old code is still being executed but the tables no longer exist. Are you trying to run the old version of the plugin? If so you will need to restore the database tables from a backup.

  4. ccolotti
    Member
    Posted 1 year ago #

    anyway to find the old code execution on the upload plugin operations? no idea how to find that.

  5. Jeff Sterup
    Member
    Plugin Author

    Posted 1 year ago #

    Deactivate the plugin and delete the plugin-organizer directory from your plugins directory. Then download and install a fresh copy.

  6. kisshomaru
    Member
    Posted 1 year ago #

    I saw this a number of times and I do not believe it to be related to PO per say. It all depends on the exact error, but for me in particular, I noticed that WP revisions of pages/posts are also keeping records of the modification made to the old PO table. So if you restore, modify, delete a revision, compare or otherwise tinker with an older revision, an error will be thrown that that table does not exist.
    Jeff can probably confirm that.

  7. ccolotti
    Member
    Posted 1 year ago #

    Actually I just saw that on a post revision. I have installed the plugin completely clean on this server after I cleaned up the DB tables which is why I am asking. When I move the site I removed the plugin removed the old DB tables then re-installed the plugin so there is a hook somewhere else leftover as the previous user mentioned.

  8. Jeff Sterup
    Member
    Plugin Author

    Posted 1 year ago #

    Found it. The function to delete the plugins from the custom tables was still in the plugin organizer class. I did a search for wpdb and I don't see any other queries to the old custom tables. You guys are turning out to be great testers. ;) Sorry I'm putting you through all this. Version 3.2.3 gets rid of that.

  9. ccolotti
    Member
    Posted 1 year ago #

    LOL hey I'm just glad you are a response person to help with these things! :)

    Let's just keep it stable. You do need to go back and look at my Order of operations issue on the other thread. I can start a new one but the Filters are getting jacked up if you save a post after the filter is applied it stops working.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.