“Category Addition Failed”

Do you have this problem on other multi-site instances, or only on this one? Are you able to create locations?

In addition to not being able to create categories, I have discovered I am also not able to create Events on the https://spoke-network.org/courses/worldtech/calendar/ When I attempt to do so, I receive the message “I’m sorry! I couldn’t add that event to the database.”

The problems creating Events and Categories are also occurring on other sites in my network. Oddly, they see to take place only on the sites that do not have a previously published “My Calendar” page with corresponding events and categories.

For those site which have previously existing “My Calendar” pages to which I have already added Events and Categories (Ex: https://spoke-network.org/courses/techcult/calendar) everything is working just fine.

As the event-related error message (see above) seems to suggest this is a database-related issue, I gave thought to uninstalling and deleting the plugin – then re-installing it…but haven’t done so out of fear that would mess things up on those network sites that are functioning properly.

Thanks,

ScP

It sounds like the database tables on those subsites haven’t been created. I can recall this having been a problem I’ve encountered before, but it’s been a very long time, and I don’t remember what it was.

If you’re comfortable with PHP, you could try running the function mc_upgrade_db() in an install that isn’t working; that should set up the database tables. If that works, let me know; I have a couple of ideas what might be happening.

Unfortunately, my php skills are rudimentary, at best – but I’d be happy to try running the function if you don’t mind explaining how/where to insert the precise code.

The easiest way to quickly run some PHP, in my opinion, is by adding a simple custom plugin that executes it on demand. I’ve added a simple testing plugin to my plugin extensions repository that will do this for you:

https://github.com/joedolson/plugin-extensions/blob/master/tester.php

To be clear, this is a plugin you should activate, run, then delete. It’s only intended to exist temporarily, and should not be left in place generally.

It won’t do anything on its own; but while activated, you can visit any admin page and add the parameter ‘debug’ to the URL, e.g. https://yoursite.com/wp-admin/?debug=true, and the code will execute.

If you refresh the page, the code will execute again. In this case, that doesn’t matter, but is something to be aware of. You’d need to do this on each site where there’s a problem (assuming it works.)