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?
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.
Ok, I'll make another backup and then remove the table to see if that clears it up. Thanks :)
A codesearch for "ms_posts" in the wp-contents folder turned up this inactive plugin as the only result:
http://wordpress.org/extend/plugins/multisite-latest-posts-widget/
Removed the plugin and table, no issues.
Its functions in our setup was already replaced with another plugin:
http://wordpress.org/extend/plugins/diamond-multisite-widgets/
pxjenkins
Member
Posted 4 months 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...
xrun
