- Posts: 865
- Karma: 24
- Thank you received: 117
Grid Status: | Online |
Total Regions: | 23 |
Visitors (30 Days): | 11 |
Total Residents: | 491 |
Online Now: | 0 |
Hypergriders online: | 0 |
Array
(
[_os_db] => JDatabaseMySQL::__set_state(array(
\'name\' => \'mysql\',
\'_nullDate\' => \'0000-00-00 00:00:00\',
\'_nameQuote\' => \'`\',
\'_sql\' => \'SET sql_mode = \\\'MYSQL40\\\'\',
\'_errorNum\' => 0,
\'_errorMsg\' => \'\',
\'_table_prefix\' => \'\',
\'_resource\' => NULL,
\'_cursor\' => true,
\'_debug\' => 0,
\'_limit\' => 0,
\'_offset\' => 0,
\'_ticker\' => 0,
\'_log\' =>
array (
),
\'_utf\' => true,
\'_quoted\' =>
array (
),
\'_hasQuoted\' => false,
\'_errors\' =>
array (
),
))
[userquery] => 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,
IF(`GridUser`.`Online` = \'True\',\'1\',\'0\') AS online,
FROM_UNIXTIME(GridUser.Login,\'%Y-%m-%d %H:%i:%s\') AS last_login,
FROM_UNIXTIME(GridUser.Logout,\'%Y-%m-%d %H:%i:%s\') AS last_logout
FROM
UserAccounts LEFT JOIN GridUser ON UserAccounts.PrincipalID COLLATE utf8_general_ci = GridUser.UserID COLLATE utf8_general_ci
ORDER BY
Created DESC
[_this_total] =>
)
ERROR 1253 (42000) at line 1: COLLATION \'utf8_general_ci\' is not valid for CHARACTER SET \'latin1\'
Please Log in to join the conversation.
Please Log in to join the conversation.
UserAccounts | CREATE TABLE `UserAccounts` (
`PrincipalID` char(36) NOT NULL,
`ScopeID` char(36) NOT NULL,
`FirstName` varchar(64) NOT NULL,
`LastName` varchar(64) NOT NULL,
`Email` varchar(64) default NULL,
`ServiceURLs` text,
`Created` int(11) default NULL,
`UserLevel` int(11) NOT NULL default \'0\',
`UserFlags` int(11) NOT NULL default \'0\',
`UserTitle` varchar(64) NOT NULL default \'\',
UNIQUE KEY `PrincipalID` (`PrincipalID`),
KEY `Email` (`Email`),
KEY `FirstName` (`FirstName`),
KEY `LastName` (`LastName`),
KEY `Name` (`FirstName`,`LastName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
| GridUser | CREATE TABLE `GridUser` (
`UserID` varchar(255) NOT NULL,
`HomeRegionID` char(36) NOT NULL default \'00000000-0000-0000-0000-000000000000\',
`HomePosition` char(64) NOT NULL default \'<0,0,0>\',
`HomeLookAt` char(64) NOT NULL default \'<0,0,0>\',
`LastRegionID` char(36) NOT NULL default \'00000000-0000-0000-0000-000000000000\',
`LastPosition` char(64) NOT NULL default \'<0,0,0>\',
`LastLookAt` char(64) NOT NULL default \'<0,0,0>\',
`Online` char(5) NOT NULL default \'false\',
`Login` char(16) NOT NULL default \'0\',
`Logout` char(16) NOT NULL default \'0\',
PRIMARY KEY (`UserID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
Please Log in to join the conversation.
--- /home/special/os72mygrid/www/tmp/com_opensim/site/includes/opensim.class.php 2010-10-01 14:56:38.000000000 -0500
+++ opensim.class.php 2010-10-03 22:11:03.000000000 -0500
@@ -152,7 +152,7 @@
FROM_UNIXTIME(%7\\$s.%10\\$s,\'%%Y-%%m-%%d %%H:%%i:%%s\') AS last_login,
FROM_UNIXTIME(%7\\$s.%11\\$s,\'%%Y-%%m-%%d %%H:%%i:%%s\') AS last_logout
FROM
- %1\\$s LEFT JOIN %7\\$s ON %1\\$s.%2\\$s COLLATE utf8_general_ci = %7\\$s.%8\\$s COLLATE utf8_general_ci
+ %1\\$s LEFT JOIN %7\\$s ON CONVERT(%1\\$s.%2\\$s USING utf8) = CONVERT(%7\\$s.%8\\$s USING utf8)
%14\\$s
ORDER BY
%12\\$s %13\\$s\",
@@ -184,7 +184,7 @@
FROM_UNIXTIME(%7\\$s.%10\\$s,\'%%Y-%%m-%%d %%H:%%i:%%s\') AS last_logout,
%11\\$s.%13\\$s AS passwordSalt
FROM
- %1\\$s LEFT JOIN %7\\$s ON %1\\$s.%2\\$s COLLATE utf8_general_ci = %7\\$s.%8\\$s COLLATE utf8_general_ci,
+ %1\\$s LEFT JOIN %7\\$s ON CONVERT(%1\\$s.%2\\$s USING utf8) = CONVERT(%7\\$s.%8\\$s USING utf8),
%11\\$s
WHERE
%1\\$s.%2\\$s = \'%14\\$s\'
@@ -213,7 +213,7 @@
FROM
%5\\$s,
%1\\$s
- LEFT JOIN %9\\$s ON %1\\$s.%2\\$s COLLATE utf8_general_ci = %9\\$s.%10\\$s COLLATE utf8_general_ci
+ LEFT JOIN %9\\$s ON CONVERT(%1\\$s.%2\\$s USING utf8) = CONVERT(%9\\$s.%10\\$s USING utf8)
WHERE
%5\\$s.%2\\$s = \'%12\\$s\'
AND
@@ -483,4 +483,4 @@
}
Please Log in to join the conversation.
This is an interesting aproach, I\'ll definately have to check this out a little closer.\Kristen Mynx\:juawrgu6 wrote: CONVERT(%1\\$s.%2\\$s USING utf8) = CONVERT(%9\\$s.%10\\$s USING utf8)
Please Log in to join the conversation.