jOpenSimWorld

Grid Status: Online
Total Regions: 23
Visitors (30 Days): 8
Total Residents: 491
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

12 years 4 weeks 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.

12 years 3 weeks 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.

12 years 3 weeks 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.

12 years 3 weeks 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.

12 years 3 weeks 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.

12 years 3 weeks 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.

12 years 3 weeks 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.088 seconds