jOpenSimWorld

Grid Status:	Offline

Similar problem with database and users aft update

djs2teach
Topic Author
Offline
Junior Boarder

12 years 4 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 to join the conversation.

foto50
Offline
Administrator

12 years 4 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 to join the conversation.

djs2teach
Topic Author
Offline
Junior Boarder

12 years 4 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 to join the conversation.

foto50
Offline
Administrator

12 years 4 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 to join the conversation.

djs2teach
Topic Author
Offline
Junior Boarder

12 years 4 months ago #1744 by djs2teach

Yes that fixed it instantly.

Thank you very much.

Don

Please Log in to join the conversation.

djs2teach
Topic Author
Offline
Junior Boarder

12 years 4 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 to join the conversation.

foto50
Offline
Administrator

12 years 4 months ago #1747 by foto50

Hi djs2teach

Oups, this is an error in the new addon help

The correct url is the one without "administrator" in it. Thanks for pointing me to this.

Greetz
FoTo50

Please Log in to join the conversation.

Time to create page: 0.119 seconds