|
Previous
·
Next
|
xootom
|
Date: 4/10/2008 6:10 am · Subject: New users have null status and can't be searched · Rating: 0
We found that we couldn't search for most recently created users. Looking at the users table, it appears that users created in version 7.5.9 have the status as NULL.
|
| Back to Top |
Rate [ | ]
|
| |
Graham
|
Date: 4/10/2008 2:48 pm · Subject: Re: New users have null status and can't be searched · Rating: 0
I can't reproduce this. How werethe users created?
|
| Back to Top |
Rate [ | ]
|
| |
xootom
|
Date: 4/11/2008 5:48 am · Subject: Re: New users have null status and can't be searched · Rating: 0
Through the normal user registration screen. Though that had a bug that was just fixed, that upon saving your new account, the screen just went blank - so maybe this is fixed for 7.5.10 too.
I'll see if it's fixed when I upgrade to 7.5.10.
|
| Back to Top |
Rate [ | ]
|
| |
Graham
|
Date: 4/11/2008 9:44 am · Subject: Re: New users have null status and can't be searched · Rating: 0
The issue with the blank screen after user registration has been fixed.
|
| Back to Top |
Rate [ | ]
|
| |
xootom
|
Date: 4/14/2008 6:12 am · Subject: Re: New users have null status and can't be searched · Rating: 0
I have upgraded to 7.5.10, and can confirm that the blank screen after registration is fixed. However, new users' status and friendsGroup are NULL so the user isn't found in the user manager.
|
| Back to Top |
Rate [ | ]
|
| |
Graham
|
Date: 4/14/2008 10:52 am · Subject: Re: New users have null status and can't be searched · Rating: 0
Can you duplicate this on a demo site and give exact instructions on how to do so? I still can't reproduce this.
|
| Back to Top |
Rate [ | ]
|
| |
xootom
|
Date: 4/14/2008 1:02 pm · Subject: Re: New users have null status and can't be searched · Rating: 0
I've found the problem, dbcharsetrepair.pl is removing the default values "Active" for users.status and "WebGUI" for users.authMethod. These two are never set by WebGUI, and use the database default (unless you use email verification, where WebGUI explicitly sets status=Deactivated and Active upon confirming the email link.)
I reinstated these defaults and re-ran dbcharsetrepair and the defaults were reset to NULL.
|
| Back to Top |
Rate [ | ]
|
| |
