Comments in multisite and moderation

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?

No, it’s not a bug in pure Multisite (if it was, believe me, people would be screaming ?? )

I suspect that role scoper changed your wp_options tables, but honestly I’m not familiar with it.

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.

I have this vague memory that when you add new roles, it overwrites the old old ones.

Where does Role Scoper store its settings? How can I completely remove it from my database?
Role Scoper creates and uses the following tables: groups_rs, user2group_rs, role_scope_rs, user2role2object_rs. All RS-specific options stored to the WordPress options table have an option name prefixed with “scoper_”.

Due to the potential damage incurred by accidental deletion, no automatic removal is currently available. You can use a SQL editing tool such as phpMyAdmin to drop the tables and delete the scoper options.

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?

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??!

Make a backup and try?

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…

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?

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?

YES!

It WAS Aksimet! I had to enter my good old API-code to every single site in the multiste and – voila!

??