Am adding users in the backend and have taken site from live environment and put into localhost (development environment), but I have noticed a few things on localhost (not sure if these problems also exist on the live environment) after setting it up.
Unable to add Users, either in the backend or through the front-end. The user gets added in the wp_users table, but with an ID of 0. This is very strange, and since id = 0, there is no way to login, and it does not get shown in users table in admin.
Unable to update Wordpress, as I get this error message: Another Update is already in progress. However, the online help for this does not help since I can not find
auto_updater.lockname anywhere in
wp_optionstable. It simply does not exist.
Have downloaded Wordpress 4.8 (had 4.7.5) and copied all files (OVERWRITING) into the root of my local environment, and yet I am still not able to create a new user. The same behavior still exists.
Have disabled all plugins, and activated the default theme in Wordpress, and still no dice on creating a new User.
All New Users get id of 0 in wp_users table. What else can be done here to find out where this problem is happening and how to fix it?
Is there a reason why the
wp_users table does not use a PRIMARY AUTO INCREMENTED KEY on
ID column? It would just seem like this would be more appropriate than whatever it is currently doing during inserting a new user.