<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Unfortunately, that does not solve the problem.<br>
<br>
I created the database using the latin1 character set:<br>
<blockquote>mysql> create database `mosgroups` character set
latin1;<br>
Query OK, 1 row affected (0.01 sec)<br>
<br>
mysql> use mosgroups;<br>
Database changed<br>
</blockquote>
When I then attempted to create the table using the original
definition, I got the same error:<br>
<blockquote>mysql> CREATE TABLE `osgroupinvite` (<br>
-> `InviteID` varchar(128) NOT NULL default '',<br>
-> `GroupID` varchar(128) NOT NULL default '',<br>
-> `RoleID` varchar(128) NOT NULL default '',<br>
-> `AgentID` varchar(128) NOT NULL default '',<br>
-> `TMStamp` timestamp(14) NOT NULL,<br>
-> PRIMARY KEY (`InviteID`),<br>
-> UNIQUE KEY `GroupID` (`GroupID`,`RoleID`,`AgentID`)<br>
-> ) ENGINE=MyISAM;<br>
ERROR 1064 (42000): You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the
right syntax to use near '(14) NOT NULL,<br>
PRIMARY KEY (`InviteID`),<br>
UNIQUE KEY `GroupID` (`GroupID`,`R' at line 6<br>
</blockquote>
If I tried specifying the latin1 character set in the first set of
directives, I get the same error, but pointing to a different line:<br>
<blockquote>mysql> CREATE TABLE `osgroupinvite` CHARACTER SET
latin1 (<br>
-> `InviteID` varchar(128) NOT NULL default '',<br>
-> `GroupID` varchar(128) NOT NULL default '',<br>
-> `RoleID` varchar(128) NOT NULL default '',<br>
-> `AgentID` varchar(128) NOT NULL default '',<br>
-> `TMStamp` timestamp(14) NOT NULL,<br>
-> PRIMARY KEY (`InviteID`),<br>
-> UNIQUE KEY `GroupID` (`GroupID`,`RoleID`,`AgentID`)<br>
-> ) ENGINE=MyISAM CHARACTER SET latin1;<br>
ERROR 1064 (42000): You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the
right syntax to use near '`InviteID` varchar(128) NOT NULL default
'',<br>
`GroupID` varchar(128) NOT NULL d' at line 2<br>
</blockquote>
These errors occur even if I do not specify the character set when
creating the database.<br>
<br>
Any other ideas or suggestions?<br>
<br>
Thanks<br>
Kurt<br>
<br>
On 10/21/2011 1:34 AM, Volker Gaessler wrote:
<blockquote cite="mid:000d01cc8fb3$2a62fcb0$7f28f610$@ch"
type="cite">
<pre wrap="">Hello Kurt, I had this same problem this week.
It is a character set problem. Your database has been created with utf8
character set. This charset uses 3 bytes per character. With 128 character
keys you get a problem in the combined key consisting in the three IDs
because MySQL only supports 1000 bytes max for keys.
The solution is to create the database with character set latin1 or each of
the groups tables. latin1 uses only 1 byte per character:
CREATE DATABASE `opensim` CHARACTER SET latin1;
or
CREATE TABLE `osgroupinvite` CHARACTER SET latin1 (
:
) ENGINE=MyISAM CHARACTER SET latin1;
and so on for each table.
Cheers
Volker
-----Original Message-----
From: <a class="moz-txt-link-abbreviated" href="mailto:opensim-users-bounces@lists.berlios.de">opensim-users-bounces@lists.berlios.de</a>
[<a class="moz-txt-link-freetext" href="mailto:opensim-users-bounces@lists.berlios.de">mailto:opensim-users-bounces@lists.berlios.de</a>] On Behalf Of Kurt Reisler
Sent: Donnerstag, 20. Oktober 2011 17:43
To: <a class="moz-txt-link-abbreviated" href="mailto:opensim-users@lists.berlios.de">opensim-users@lists.berlios.de</a>
Subject: [Opensim-users] Problems creating MySQL tables for
XmlRpcGroupsServer
Using Server version: 5.5.16 MySQL Community Server (GPL) under Windows
2008 server
Attempting to build XmlRpcGroupsServer from mcortez-flotsam-963d99e.zip
dated 10/18/2010 on my local server.
Seems that there have been changes made to MySQL. Had to change "TYPE"
to "ENGINE" in all the other table build command strings. All of them
worked except when trying to create the osgroupinvite table:
mysql> CREATE TABLE `osgroupinvite` (
-> `InviteID` varchar(128) NOT NULL default '',
-> `GroupID` varchar(128) NOT NULL default '',
-> `RoleID` varchar(128) NOT NULL default '',
-> `AgentID` varchar(128) NOT NULL default '',
-> `TMStamp` timestamp(14) NOT NULL,
-> PRIMARY KEY (`InviteID`),
-> UNIQUE KEY `GroupID` (`GroupID`,`RoleID`,`AgentID`)
-> ) ENGINE=MyISAM;
Which throws the following error:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near '(14) NOT NULL,
PRIMARY KEY (`InviteID`),
UNIQUE KEY `GroupID` (`GroupID`,`R' at line 6
I am at a loss here. Has anyone run into this before and are there any
suggestions as to how to get around it? I can not make use of the public
server at osflotsam.org for a variety of reasons.
Thanks in advance
Kurt
_______________________________________________
Opensim-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Opensim-users@lists.berlios.de">Opensim-users@lists.berlios.de</a>
<a class="moz-txt-link-freetext" href="https://lists.berlios.de/mailman/listinfo/opensim-users">https://lists.berlios.de/mailman/listinfo/opensim-users</a>
</pre>
</blockquote>
</body>
</html>