Friday, May 30, 2008

Upgrade issue: Setting user account status

If you're upgrading from gnizr 2.3.0 to gnizr 2.4.0 M3/M4, you may need to run the following sql command to set the proper user account status for all existing users. This is a temporary fix. In the final release of 2.4.0, we will include this fix in the upgrade scripts.
update user set acct_status="0000000001";
-- kudos to rick --

What's the problem?

After upgrading to gnizr 2.4.0 M3/M4, users are unable to log in. In gnizr 2.4.0 M3, there is a major change in the user registration process. In the new implementation, user accounts are put on hold until their email address are verified -- valid email addresses are required for password recovery.

In the DB record, when an account is on hold, the column 'acct_status' is set to 0.

How to fix the problem?

If you are the admin, and you know that all your users have a valid email on file, then you can execute the SQL command to change the 'acct_status' of all users to 1.

No comments: