jOpenSimWorld

Grid Status: Online
Total Regions: 23
Visitors (30 Days): 12
Total Residents: 485
Online Now: 0
Hypergriders online: 0
  1. Forum
  3. jOpenSim component
  5. jOpenSim
  7. Similar problem with database and users aft update

Similar problem with database and users aft update

11 years 8 months ago #1739 by djs2teach
I also installed the update 0.26 with the following error in user:


1253: COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'latin1' in /var/www/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 /var/www/administrator/components/com_opensim/models/user.php at line 75

I did the fix you suggested for luigitarallo but I did not have the same luck he did. I am working off of opensim 0.7.5 and Joomla 2.5 and modules 0.2.6.3

Please help and thank you for all your support.
Don

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

11 years 8 months ago #1740 by foto50
Hi djs2teach

Could you please execute following queries (e.g. with phpMyAdmin) in your OpenSim database and paste the results here?
SHOW FULL COLUMNS FROM UserAccounts;
SHOW FULL COLUMNS FROM GridUser;
SHOW FULL COLUMNS FROM Presence;

Greetz
FoTo50

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

11 years 8 months ago #1741 by djs2teach
I did each qquery seperately and attached a text file with the reponses. I have back down to previous version until solved.

Thank you

Don
Attachments:

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

11 years 8 months ago #1743 by foto50
Hi djs2teach

This shows me that you did not execute the first of the ALTER-queries in the other post . Here once again for you:
ALTER TABLE `GridUser`
MODIFY COLUMN `UserID`  varchar(255) CHARACTER SET utf8 NOT NULL FIRST ,
MODIFY COLUMN `HomeRegionID`  char(36) CHARACTER SET utf8 NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000' AFTER `UserID`,
MODIFY COLUMN `HomePosition`  char(64) CHARACTER SET utf8 NOT NULL DEFAULT '<0,0,0>' AFTER `HomeRegionID`,
MODIFY COLUMN `HomeLookAt`  char(64) CHARACTER SET utf8 NOT NULL DEFAULT '<0,0,0>' AFTER `HomePosition`,
MODIFY COLUMN `LastRegionID`  char(36) CHARACTER SET utf8 NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000' AFTER `HomeLookAt`,
MODIFY COLUMN `LastPosition`  char(64) CHARACTER SET utf8 NOT NULL DEFAULT '<0,0,0>' AFTER `LastRegionID`,
MODIFY COLUMN `LastLookAt`  char(64) CHARACTER SET utf8 NOT NULL DEFAULT '<0,0,0>' AFTER `LastPosition`,
MODIFY COLUMN `Online`  char(5) CHARACTER SET utf8 NOT NULL DEFAULT 'false' AFTER `LastLookAt`,
MODIFY COLUMN `Login`  char(16) CHARACTER SET utf8 NOT NULL DEFAULT '0' AFTER `Online`,
MODIFY COLUMN `Logout`  char(16) CHARACTER SET utf8 NOT NULL DEFAULT '0' AFTER `Login`,
DEFAULT CHARACTER SET=utf8;

This should solve your issue. I hope I soon find a better way to avoid those collation problems in the future :)

Greetz
FoTo50

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

11 years 8 months ago #1744 by djs2teach
Yes that fixed it instantly.

Thank you very much.

Don

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

11 years 8 months ago #1745 by djs2teach
One last thing please... Should I follow the Addon Help on my actual site under the config or the pdf in the download. they seem to be different.

ie: links to offline messaging on my site under the addon help says:
iteach3d.com/administrator/components/com_opensim/interface.php

The one on the PDF instructions says:
iteach3d.com/components/com_opensim/interface.php

Which is correct??

Don

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

11 years 8 months ago #1747 by foto50
Hi djs2teach

Oups, this is an error in the new addon help :blush: The correct url is the one without "administrator" in it. Thanks for pointing me to this.

Greetz
FoTo50

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

  1. Forum
  3. jOpenSim component
  5. jOpenSim
  7. Similar problem with database and users aft update
Time to create page: 0.118 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): 12
Total Residents: 485
Online Now: 0
Hypergriders online: 0