The Support Forums will be in read-only mode for a scheduled maintenance window on 01 September 2016 14:00 UTC - 20:00 UTC. More information.

[resolved] Error on ms_posts in database (5 posts)

  1. xrun
    Posted 4 years ago #

    Hi, and happy new year.

    Seems like there's an error in the database in my WP 3.3 multisite installation. The errorcode is as follows:

    #1356 - View '5kon-main.wp_ms_posts' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them.

    When trying to repair or optimize, this is the error shown. This table(s) also seems to be empty when looking at the contents.
    Any tips on how to proceed and do something about this? What would the expert tip be, to remove this table?

  2. That is not a default multisite table. You probably had a plugin that did this and then later removed the plugin.

    Moving to the multisite forum as well.

  3. xrun
    Posted 4 years ago #

    Ok, I'll make another backup and then remove the table to see if that clears it up. Thanks :)

  4. xrun
    Posted 4 years ago #

    A codesearch for "ms_posts" in the wp-contents folder turned up this inactive plugin as the only result:
    Removed the plugin and table, no issues.

    Its functions in our setup was already replaced with another plugin:

  5. pxjenkins
    Posted 4 years ago #

    I had a very similar issue - only I found that although I deleted the plugin the 'wp_ms_posts' table stayed behind in my WPMS database, now requiring my host to delete it since I don't have root access...

Topic Closed

This topic has been closed to new replies.

About this Topic