a little confused…  if its not networked activated, just visit the dashboard of each network site and update…

where did you copy the ‘old’ version?  if still in plugins, its likely causing a conflict since wp still loads part of it…

there should be more info on the invalid db query in the forum – toolbox – error log admin panel…

might be worth trying forum – toolbox – houskeeping and try clearing the auths cache…

I did do the update on the subsites – that is what seemed to cause the trouble.

Yes, I had moved the old simple-press folder out of the plugins directory.

I tried clearing the auths cache – no effect.

I’ve attached the top of the error log.

I tried a few things – I can create a post and I can delete that post. But I cannot view it.

Let’s find out what the DB error is. That is probably enough to stop the posts display from populating and thus giving the impression that access is not allowed.

Go to the forum admin on one of the sites. Select Toolbox > Error Log. Ignore what is there and scroll down to the bottom and clear it out.

Run a forum page so that you see the ‘Invalid Database Query’ message. Back to the error log. Copy and paste the contents here so we can take a look at the problem.

I cleared the error log and immediately got three error notices. After trying to access a post, I got the rest. (see error log below)

The “where clause” error appears after opening the forum. The “field list” one occurs after trying to open a post and getting the “Access Denied …” notice.

Note that in addition to not gaining access to the posts, the list of SP users does not display in the dashboard, although an SP user will display when searched for. (see screenshot below).

 Error log follows:

Apologies for taking so long to get back to you. i had to go out.

We are only really interested in the actual error here (the first one). The rest are just annoying notices and suggest some admin panels that have never been visited or saved. Not really an issue.

I think you will find that while you have updated WP and the SP core – you have SP plugins that have NOT been updated and need to be. Like the uploader for example. Can you please update any that state they need it and then try running the forums again.

OK. But there is no option in WP either in the subsite or in the network admin to auto-update any of the plugins. I will have to manually update each one. Is the best way to ftp up to the server then unzip into the plugin’s specific directory?

correct, no network upgrade of plugins…  not sure its needed…  just upgrade the plugins on the main site (where the plugins are loaded) through the main wp dashboard updates and they will be updated for all network sites…  well, at least the files… on first visit to admin in network sites, any db upgrades will occur…

actually, might be a fair point on network upgrades…  some things in db may have issues until the admin is visited… gonna have to think on this some more… network upgrades are a nightmare – and will be more so if something needed in plugins…

Thanks so much for your help. I manually uploaded and unzipped each plugin file and things seem to be back to normal now…

It does look like WP 4.0 messes up the auto-updates for SP and plugins, though… Have others reported this?

No, we have had many thousands of upgrades via wp updates of core, plugins and themes since the release of 4.0…  doesnt mean there isnt a something locally going on for you, but it is generally working…

does the wp update page fully load?  just no sp plugins listed?  this is on the main site wp updates panel – not any of the network sites…

Still have not recovered fully from the 5.5.1. upgrade into WP 4.0 Multisite (folders not subdomains)

When I go to Network Admin/Updates, there are no options to update Simple Press, even when the subsite knows it needs updating. When I click on the update link, it just takes me to the Network Admin/Updates page and there is nothing there to update…

I have manually upgraded to 5.5.2, and upgraded all the plugins and themes, but still quirky behaviour on some subsites, e.g.

• All except one subsite will not display the glyphs in the forum editor, although they display in the WP blog.
• One subsite that will display the list of forums, but clicking on any forum gives a 404, even though the forum permalink is OK. I can display the forum by setting “do not display group if there is only one forum”, but if I click on the actual link to the forum, I still get a 404. I tried renaming the forum slug, but it made no difference.

Key question: I’m wondering if I can uninstall SP from one subsite without uninstalling it from the entire site. I got nervous as it said it would delete the entire database if I uninstalled it. Note that this is a folder-based multisite, not a subdomain based one. Does that make a big difference? I want to try uninstalling, then reinstalling the forum, but there is one subsite with heavy usage that is for some reason working fine, and I don’t want to delete that! (Many of the other subsites have not started using it yet, so a reinstall is possible without loss of data there.)

If that is not a viable approach, do you have other suggestions?

Cheers,

Bruce

Hey Bruce,

Unfortunately I have absolutely no experience with multisite and I don’t think Yellow Swordfish has had much luck with ms in the past, so will probably have to wait until Mr Papa is around I’m afraid.

you previously asked this in another topic where I answered it (https://simple-press.com/support-forum/sp5-general-topics/user-and-sp-update-problems-ongoing-since-wp-4-0-update/#p146702)…

each install is standalone, so you should be able to uninstall each one independently…

of course, I would play it safe and make a db backup before hand…  I would also not select the option to remove any files too…