[Opensim-users] Problems creating MySQL tables for XmlRpcGroupsServer

[Justin Clark-Casey]

Okay, I patched the code at [1].  The sql now works on mysql 5.5.17 for me (as well as 5.1).

Please note that I do only very minimal maintenance on this code but I'm the only maintainer left.  I probably will 
never fix the extant bugs.  However, patches are welcome.

[1] https://github.com/mcortez/flotsam

On 21/10/11 19:36, Mike Chase wrote:
> On 10/21/2011 02:27 PM, Luisillo Contepomi wrote:
>> I think you have a syntax error.
>>
> The TIMESTAMP(14) syntax is old.
>
>
> Something like:
>
> ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
>
> Should do it. See:
>
> http://dev.mysql.com/doc/refman/5.0/en/timestamp.html
>
> Mike
>
>
>> Copy and paste this
>>
>> 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
>>
>> Regards,
>> Luisillo Contepomi
>>
>>
>> _______________________________________________
>> Opensim-users mailing list
>> Opensim-users at lists.berlios.de
>> https://lists.berlios.de/mailman/listinfo/opensim-users
>
>
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users


-- 
Justin Clark-Casey (justincc)
http://justincc.org/blog
http://twitter.com/justincc