ThorHammer

fran330: I have the similar problem and I have been tearing my hair off trying to identify the problem … I have an API-key to Aksimet, but am I supposed to use this key on ALL the blogs in the multisite?? (I thought each blow owner had to get their own API Key??)

If the answere is that easy I am going for a beer. Now.

… huge loads of buddypress settings is inside all user_roles settings in all my OPTIONS tables…

Thank you so much!

Now I am really excited to see what this novel is all about ??

The oddest of odd things is that some of the blogs allow comments as they should.

Perhaps some of he rows in some of the tables still contain some microscopic but still deadly posion from role scoper, groups or multisite user management or buddypress.

I guess my only option is trying to figure out how to decode the data values inside each row in each table and then edit them, starting with the main blog so all new blogs hopefully doesn’t inherit the plutonium poison from the ghostly plugin remains.

Anyone with any idea where to find information about learning how to understand data values inside table rows in WordPress?

No, it simply cannot be Akismet. Something must be messed up with wp default roles, and perhaps the different blog owners are not seen as subscribers to the different blogs? Right now each blogs visible users are only the blogs administrator and me (superadmin) as subscriber, and no other useres are visible.

For me it is totally impossible to decode and understand the data inside the different users option tables.
Perhaps I should re-try multisite user management, og perhaps this trick, which you have made, could do the trick:
https://halfelf.org/2012/more-multisite-registration/
Speaking about that: you are referring to mu-plugins. I don’t have any folder called mu-plugins. What is that good for?

Well… I really don’t need akismet since we are not supposed to have any external comments at all.. It just feels anti-evolutionary to deactivate and uninstall akismet. It’s against all common laws in the universe…

Wait just a second ….

In the OPTION table for the main blog, I noticed:
akismet_show_user_comments_approved with the value: false

Could it be… If I uninstall Akismet … perhaps the comments will come through, then? Actaully, since user registration is disallowed and since it is meant that only registered users (blog owners on the multisite) are supposed to comment on each other blog posts … then I don’t need Akismet.

Could it be that easy??!

Yes, but the different blog owners are all manually set as administrator on their own blog – only, and I have removed everyone from the other blogs, since the default role is subscriber on the other blogs (which is enough to let them comment on other posts in the multisite install). When RS was installed, all users were still added to each other blogs as subscribers, only.
Do I have to manually edit all values in “user role” inside each option table? And where is it possible to find the value which make each user administrator to their own blog and subscriber (default) to all the other blogs?

I agree with the screaming.
I have re-checked my different wp_options tables.
The only odd thing now is a row called “group_options” inside the main options and th main blogs wp_options_table. The value for this is set to:
a:1:{s:7:"general";a:1:{s:22:"read_post_capabilities";a:1:{i:0;s:16:"groups_read_post";}}}
And that really tells me nothing, except that this might be a surviving element from the “groups” plugin which I unfortunately installed long ago. It left traces everywhere.

In the wp_options are “default_role” set to “subscriber”.
“reguire_name_email”, “comment_moderation” and “moderation_notify” and “moderation_keys” have all blank values, while “comment_registration” is set to “1”, i.e.: All logged-in and registered blog owners are supposed to comment without moderation.

All the other rows in the different wp_options tables are pure and clean. So it simply cannot be there.

Now I have cleaned my database for ALL traces from role scoper and other pests. Dumped tables and deleted rows, but still the comment moderation issue is there. Perhaps this is a bug in WP 3.5 – multisite?

…and it was hard to find them, but I did, and I deleted them all. With success.

I did it. Dropped all the tables and deleted all rows with strange prefixes.

And everything went fine.

In case you are trying soemthing similar: remember to always backup DB before doing anything. And backup during the different stages as well.

I solved my problems.

I dumped them all and exterminated every row with groupX in the tables where I found them, and everythign went fine.

Thanks, bcworkz. Just as I thought, the “groups_X”-tables doesn’t belong here.
And the data inside options does not have any rows under _bbpXXX

I suspect that all these data must be leftovers from Buddypress. I think it is on time to drop some tables and some huge amounts of rows now…

Oh, be sure, actually, I am backing up my database and all config settings and htaccess every day ….

But, really, are there noone here who knows WP-databases? I really would love to know if any of the tables and rows mentioned are “pure” wordpress or not.