Re: 4createdata.sql mysql bug in svn 2.0
This error was also in the release 2.0 version of the MySQL Data Layer for mojoPortal.
There is an updated file version 2.0.1 (1/24/2006) on the download page of this site.
Sorry for any inconvenience to the MySQL users out there.
The only file that has changed is 4CreateData.sql so this will only work for a new clean install
Alternatively you could just run these sql statements if you already ran the create data s cript once.
INSERT INTO `mp_Modules` VALUES (12,10,1,999,'ContentPane','Unpublished Article',0,1,0,'Admins');
INSERT INTO `mp_Modules` VALUES (13,11,16,999,'ContentPane','Friendly Url Manager',0,1,0,'Admins');
INSERT INTO `mp_Sites` VALUES (1,'p_default','mojoPortal','subblue','mojotonguesmall.gif','',1,0,0,0,0,'mojoPortal, mono, linux, gnu, Joe Audette, .NET, Developer, Architect','A site of interest to .NET developers wanting to deploy ASP.NET on GNU/Linux',' ',' ',1,1,1, 'PageNameWithDotASPX', 'normal', 0, 1,1, 0, 1, '', 389, '', '');
as these are the only statement that were broken in the previous file.