Error Message in User Manager since Update to 0.26

Since updating to the version I get the following message when trying to list the users in jopensim:

1253: COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'latin1' in /world/httpdocs/administrator/components/com_opensim/models/opensim.php at line 317 (SELECT UserAccounts.PrincipalID AS userid, UserAccounts.FirstName AS firstname, UserAccounts.LastName AS lastname, UserAccounts.Email AS email, FROM_UNIXTIME(UserAccounts.Created,'%Y-%m-%d %H:%i:%s') AS created, GridUser.Login AS last_login, GridUser.Logout AS last_logout, IF(ISNULL(Presence.UserID),'false','true') AS online FROM UserAccounts LEFT JOIN GridUser ON UserAccounts.PrincipalID COLLATE utf8_general_ci = GridUser.UserID COLLATE utf8_general_ci LEFT JOIN Presence ON UserAccounts.PrincipalID COLLATE utf8_general_ci = Presence.UserID COLLATE utf8_general_ci WHERE (UserAccounts.FirstName LIKE '%%' OR UserAccounts.LastName LIKE '%%'))
1253: COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'latin1' in /world/httpdocs/administrator/components/com_opensim/models/user.php at line 75

Also mapview is still working in listview only

Regards,

SilverDay

The same error pops up in the money module

Hi SilverDay

Sorry, a bit busy atm, but I'll post a solution tomorrow in this topic .