4createdata.sql mysql bug in svn 2.0

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum.
This thread is closed to new posts. You must sign in to post in the forums.
1/24/2006 9:55:46 AM
Aaron King
Gravatar
Total Posts 58
View Posts

Re: 4createdata.sql mysql bug in svn 2.0

The 4createdata.sql mysql script is a little off. I got a column number mismatch error when I ran it the first time. I added a column where you added the new ldap settings and it worked.  This is from the 2.0 source downloaded one hour ago thru svn
1/24/2006 10:03:50 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: 4createdata.sql mysql bug in svn 2.0

Thanks Aaron,

I'll fix that but fyi, nothing has changed much on 2.0 branch since 2.0 release.

If you want to work with the latest stuff that is using the new MasterPages, Themes, Menu, etc, you should get /branches/2.1 from svn, but be aware this branch is under heavy development and chagning rapidly so best to test a copy before updating any sites.

Cheers,

Joe
1/24/2006 2:40:41 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

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.

Joe
You must sign in to post in the forums. This thread is closed to new posts.