WordPress Multisite Cannot Add Users

Keywords: WordPress Multisite - AWS - Technical issue - Other
bnsupport ID: 68713707-d30f-a883-29a0-44c176d32758
Description:
Hi there, our website currently cannot add users manually or via front-end registration on WordPress multisite. When a user is added by the backend, WordPress says it cannot add user, and using the activation system plugin is not helping.

This error is happening on ng.ehubber.com

Kindly respond.

Hi @apexzy

Thanks for using Bitnami WordPress!

It seems you are trying to turn a regular Bitnami WordPress stack into a Multisite one. Let me mention that, while this is possible, you may encounter a series of errors as this is not a straightforward process. Instead, we highly recommend the pre-packaged, already-tested Bitnami WordPress Multisite stack instead:

https://bitnami.com/stack/wordpress-multisite

Having said that, the bnsupport-tool reports the following:

[Apache]

Found recent Pagespeed related error messages in the Apache error log:

[Sun Jun 06 18:05:32.785575 2021] [pagespeed:error] [pid 2859:tid 140016546055936] [mod_pagespeed 1.13.35.2-0 @2859] PageSpeed Serf fetch failure rate extremely high; only 0 of 326 recent fetches fully successful; is fetching working?

We suggest disabling pagespeed and check if that improves the behavior. Please check the following guide to disable Pagespeed:

https://docs.bitnami.com/general/apps/wordpress/administration/use-pagespeed/#disable-pagespeed

Found recent error or warning messages in the Apache error log.

...
 [Sun Jun 06 18:07:36.153419 2021] [proxy_fcgi:error] [pid 2859:tid 140016982411008] [client 141.101.76.191:65438] AH01071: Got error 'PHP message: WordPress database error Unknown column 'spam' in 'field list' for query UPDATE `wp_users` SET `user_pass` ...

I have commented some of the output, as it contained sensitive information. Basically, there is some missing column in the DB (more likely related to the conversion from a regular WP stack to a multisite one). I have found a similar post on the internet that mentions the same error on the same process, you may give it a try:

https://mklasen.com/fix-for-missing-spam-column-in-wp_users/

Best regards,
Jose Antonio Carmona


Was my answer helpful? Click on :heart:

Hello @jcarmona

The first option did not work.

However, I’m opting for the second option, how do I add that command to WP CLI?

Thanks for your response and if we decided to switch to the Bitnami Multisite Stack, can we restore our backups from Updrafts?

However, I’m opting for the second option, how do I add that command to WP CLI?

The second option does require to execute the command on the DB, not with the WP CLI utility. In order to do that, please follow:

https://docs.bitnami.com/aws/apps/wordpress/get-started/connect-mariadb/

Thanks for your response and if we decided to switch to the Bitnami Multisite Stack, can we restore our backups from Updrafts?

I am unfamiliar with how Updrafts works, but I’d say that it should work straightaway. Nevertheless, do not delete the original instance until you make sure that the new one works & you have a working back up copy of your previous files :slightly_smiling_face:

Best regards,
Jose Antonio Carmona


Was my answer helpful? Click on :heart:

I did that, tried logging in to the database and even the application password, yet, it tells me an error that I can’t log in to the database.

If I install a multisite stack, how do I install and configure the SSL, most of your stacks (previous versions of multisite) are frustrating?

You guys should try and help me, I’m frustrated. I installed a new instance on AWS using multisite stack and ran sub domain configuration, the issue of new users not being registered did not happen, but now, when I tried to restore the database in the running website to the new instance, it tells me the database of the new instance mulsite stack is not compatible wit the older site.

What is all these?

I’m tired.

I did that, tried logging in to the database and even the application password, yet, it tells me an error that I can’t log in to the database.

If you can’t log in to the DB it most likely means that you have changed the default password for it. We have guides that cover how to reset the administrator password if that is something you’re interested in.

If I install a multisite stack, how do I install and configure the SSL

We also have guides that cover how to set up the SSL configuration using Let’s Encrypt:
https://docs.bitnami.com/google/apps/wordpress-pro/administration/generate-configure-certificate-letsencrypt/

You guys should try and help me, I’m frustrated.

We run this community forum where we try to help all the users with Bitnami solutions. I understand this is important for you, but we are happy to help!

but now, when I tried to restore the database in the running website to the new instance, it tells me the database of the new instance mulsite stack is not compatible wit the older site.

Could you please share here the process you are following and the output of the commands? With the exact output, I might be able to give you further directions.

Best regards,
Jose Antonio Carmona


Was my answer helpful? Click on :heart:

Using a new instance (here), I installed Updrafts Pro, and included my setup from past installation, I was able to restore my plugin, uploads and themes. However, when I selected database restoration, this is what I get

, some sort of compatibility issue with the database.

Secondly, when I run the bitnami cert too, this is what I get:

Warning: The domain 'ehubber.com' resolves to a different IP address than the
one detected for this machine, which is '44.193.62.172'. Please fix its DNS
entries or remove it. For more info see:
https://docs.bitnami.com/general/faq/configuration/configure-custom-domain/
Press [Enter] to continue:

At this point I have followed all guidelines and more, yet this seems to be the only issue. Generating SSL is the major issue here and even when I changed my current ehubber.com IP to the new instance elastic IP, it says the same thing. Even checked my DNS setup and it’s alright.

This [article](https://lightsail.aws.amazon.com/ls/docs/en_us/articles/amazon-lightsail-using-lets-encrypt-certificates-with-wordpress) helped on normal WP installation, is there an article like that for multisite?

However, when I selected database restoration, this is what I get
, some sort of compatibility issue with the database.

It seems that your previous instance used a different codification for the database. I don’t know how the Updrafts Pro plugin works (maybe it supports chartset conversion on-the-fly), but you could give the import a try and check if it works :slightly_smiling_face:

Secondly, when I run the bitnami cert too, this is what I get
At this point I have followed all guidelines and more, yet this seems to be the only issue. Generating SSL is the major issue here and …

For the bncert-tool to work, it needs to make sure that the DNS name resolves to the current IP of your instance. At the end of the day, this is required in order to prove the ownership of the domain. I have just checked this now using the online tool https://dnschecker.org/#A/ehubber.com, and indeed it seems the domain does not resolve to that IP:

even when I changed my current ehubber.com IP to the new instance elastic IP, it says the same thing. Even checked my DNS setup and it’s alright.

Sometimes, even if you perform the changes in your DNS provider it does take some time to propagate to the rest of the servers. You can use an online tool like the one I mentioned to verify that all the changes are successfully propagated.

helped on normal WP installation, is there an article like that for multisite?

The article you provided does not belong to the official Bitnami documentation, but you can find the set of articles related to the Bitnami WordPress Multisite stack here:

https://docs.bitnami.com/google/apps/wordpress-multisite/

Best regards,
Jose Antonio Carmona


Was my answer helpful? Click on :heart: