Hi,
It can be dodgy changing password format, if the application recycles during the process it may not complete. It is best to choose a format in the beginning when there are only a few users and then stick with it. Definitely a good idea to backup the database before trying to make such a change so you have a way to restore it if something goes wrong.
To solve it you first need to asses the problem by looking in the mp_Users table in the Pwd field.
Are any of the rows encrypted?
How many users are we talking about?
You could get back to clear text if there are only a few users it will be easier.
1. UPDATE mp_Sites SET PasswordFormat = 0 -- optionally a WHERE SiteID = yoursiteid
2. UPDATE mp_Users SET Pwd = 'ChangeMe'
3. Touch Web.config to clear the cache and reload site settings
4. Now you are back to clear text, have your users sign in immediately and change their passwords from 'changeme'
5. Backup your database
6. clear the mojoportal log
7. try the password format change again, if you continue to have trouble check the mojoportal log for related errors.
Hope it helps,
Joe