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 MikeCopy 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 [email protected] https://lists.berlios.de/mailman/listinfo/opensim-users_______________________________________________ Opensim-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-users
<<attachment: kreisler.vcf>>
smime.p7s
Description: S/MIME Cryptographic Signature
_______________________________________________ Opensim-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-users
