Question

Photo of Jeremy Turgeon

0

Unavailable Groups after 4.0 Update

1

There were a number of people in our database that, when clicking on a group that they were in, caused an exception to come up. The issue existed with anyone who had a NULL value in their ConnectioStatusValueId.

Thanks to Bronson Witting for finding the problem and the solution.

Running the following SQL should fix any records with this issue:

UPDATE [Person]

SET [ConnectionStatusValueId] = 3 (the value of a Visitor)

WHERE [ConnectionStatusValueId] IS NULL

  • Photo of Jeremy Turgeon

    0

    See above for the solution. Remember to always backup your install before doing anything, especially in SQL.

    • Jim Michael

      Jim Michael

      Any idea how/why some people end up with NULLed connection status? Is this due to importing people from other systems, or a bug?

      • Jeremy Turgeon

        Jeremy Turgeon

        Looks like it might have been people who created their own account from the external website Login page back when Rock was in v1.0 or there about.