[Opensim-users] Problems creating MySQL tables for XmlRpcGroupsServer

[Kurt Reisler]

Thank you Justin.  That did the trick.  Now onward with getting PHP working.
Thanks again
Kurt

On 10/21/2011 6:05 PM, Justin Clark-Casey wrote:
> 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
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: kreisler.vcf
Type: text/x-vcard
Size: 324 bytes
Desc: not available
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20111024/cf2d2111/attachment.vcf>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2630 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20111024/cf2d2111/attachment.bin>