Background: I develop my website on my dev. subdomain and when ready and test and clone dev to the live domain. However at the same time my users may change their password or any other profile data, so before I go live with a new version, I need to save the user profiles with J2XML and load them into the dev website. I test everything on the dev site, but as the live site has to be shut down before I save the user data, I usually do this after the in-depth testing.
I got into some trouble. I used to use the J2XML plugin to export and import my Joomla user data when doing site updates. Yesterday I exported my users with a previous version of J2XML and import it with the latest version. Unfortunately the latest version seems to have a bug and does not keep the userIDs even though the setting is on. I would like to avoid going back to an older version of the site and lose user data, so I tried to change manually the id field in the josru_users table, but after that I cannot login with my users:
Warning You can't access the private section of this site.
What else do I need to do to make sure that my users can log in again?
Thanks a lot, W.