jOpenSimWorld

Grid Status: Online
Total Regions: 23
Visitors (30 Days): 9
Total Residents: 476
Online Now: 0
Hypergriders online: 0
× Please dont hesitate to report bugs here as I am always happy to get hints, where I can improve jOpenSim.

Error Message in User Manager since Update to 0.26

11 years 1 month ago #1711 by SilverDay
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

Please Log in or Create an account to join the conversation.

11 years 1 month ago #1712 by SilverDay
The same error pops up in the money module

Please Log in or Create an account to join the conversation.

11 years 3 weeks ago #1715 by foto50
Hi SilverDay

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

Please Log in or Create an account to join the conversation.

Time to create page: 0.082 seconds

Search

Donate jOpenSim

Please consider supporting our efforts.

Amount

Our Regions

Region: Loc X: Loc Y:
Agora 1000 998
BareBad… 997 997
Bohemas 996 998
BoraBor… 1002 999
Crystal… 1001 1000
DeepTho… 1005 998
FoToSan… 999 995
jCity 1001 997
jOpenWe… 1000 999
JuniorT… 1002 1001
Kanadah… 1002 1000
LindaKe… 1000 997
LittleC… 996 997
MonteSc… 1001 1001
Naos 999 999
Pangaea 1005 1003
RiverSi… 999 1000
Sakani 999 998
Snambin 1001 998
Tartola 997 998
ViewerH… 1002 998
WaterWo… 1001 999
WilderK… 1000 1000

jOpenSimWorld

Grid Status: Online
Total Regions: 23
Visitors (30 Days): 9
Total Residents: 476
Online Now: 0
Hypergriders online: 0