multiple sites upgrade not working

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.
3/21/2005 2:36:34 AM
Gravatar
Total Posts 58

Re: multiple sites upgrade not working

I get the following error

System.IO.FileNotFoundException: File '/var/www/html/Data/Sites/0/skins' not found.
in <0x00215> System.IO.StreamReader:.ctor (string,System.Text.Encoding,bool,int)
in <0x0001a> System.IO.StreamReader:.ctor (string,System.Text.Encoding)
in <0x00069> (wrapper remoting-invoke-with-check) System.IO.StreamReader:.ctor (string,System.Text.Encoding)
in <0x0003e> System.Web.Compilation.AspGenerator:InitParser (string)
in <0x000f4> System.Web.Compilation.AspGenerator:GetCompiledType ()
in <0x00036> System.Web.UI.UserControlParser:CompileIntoType ()
in <0x00041> System.Web.UI.UserControlParser:GetCompiledType (string,string,System.Web.HttpContext)
in <0x000b4> System.Web.UI.TemplateControl:GetTypeFromControlPath (string)
in <0x0001d> System.Web.UI.TemplateControl:LoadControl (string)
in <0x00094> mojoPortal.Web.MasterPage:BuildMasterPage ()
in <0x0000a> mojoPortal.Web.MasterPage:OnInit (System.EventArgs)
in <0x001da> System.Web.UI.Control:InitRecursive (System.Web.UI.Control)
in <0x001aa> System.Web.UI.Control:InitRecursive (System.Web.UI.Control)
in <0x00060> System.Web.UI.Page:InternalProcessRequest ()
in <0x000c2> System.Web.UI.Page:ProcessRequest (System.Web.HttpContext)
in <0x002eb> ExecuteHandlerState:Execute ()
in <0x00084> StateMachine:ExecuteState (System.Web.HttpApplication/IStateHandler,bool

I installed backed up my data and skins and installed from scratch to see your recent
improvements. I got this error then I copied Data/Sites/1 to Data/Sites/0.. but that
didn't work. There is probably a missing file in there someplace, or maybe r/w security.
Is there something else? Please advise.
3/21/2005 6:03:24 AM
Gravatar
Total Posts 18439

Re: multiple sites upgrade not working

I can't figure why it would be looking for site 0

I would look in the db and see what site id your site has, the lowest should be 1

Also make sure the mp_Sites_ModuleDefinitions table is populated and that there are rows in the mp_Pages table corresponding to the site id in the mp_Sites table

You got this error on a clean install?

3/21/2005 6:12:01 AM
Gravatar
Total Posts 58

Re: multiple sites upgrade not working

yes, it was a clean install on mono/apache/mysql

3/21/2005 6:15:05 AM
Gravatar
Total Posts 18439

Re: multiple sites upgrade not working

It definitely looks more like a data problem to  me. Compare the table creation script to what is in your db from the last version as well as the data creation script.  If you are using the same db as you had from version 20050227 there is an additional table, mp_Sites_ModuleDefinitions which also needs to be populated if it isn't already.

There is also an additional column SiteID on the mp_Users table as well as new columns on mp_Pages

3/21/2005 6:19:32 AM
Gravatar
Total Posts 18439

Re: multiple sites upgrade not working

Hmm, a clean install and you get that error.  I wish I could help more right now but it will be this evening when I get home before I can really investigate thoroughly.  Please don't give up I will resolve this for you as soon as I possibly can.
3/21/2005 6:26:26 AM
Gravatar
Total Posts 18439

Re: multiple sites upgrade not working

I think I may have found the problem in the data creation script for populating the mp_Pages table.

If that table  is empty, try this

INSERT INTO `mp_Pages` VALUES (1,-1,1,1,'Home','All Users;',0,0,'','','','',NULL, 0,'',0,0);
INSERT INTO `mp_Pages` VALUES (2,-1,5,1,'Forums','All Users;',0,0,NULL,NULL,NULL,NULL,NULL, 0,'',0,0);
INSERT INTO `mp_Pages` VALUES (3,-1,11,1,'Admin','Admins;',0,0,NULL,NULL,NULL,NULL,NULL, 0,'',0,0);
INSERT INTO `mp_Pages` VALUES (4,3,9,1,'Add/Edit Pages','Admins;',0,1,'','','','',NULL, 0,'',0,0);
INSERT INTO `mp_Pages` VALUES (5,3,11,1,'Role Administration','Admins;',0,1,'','','','',NULL, 0,'',0,0);
INSERT INTO `mp_Pages` VALUES (6,-1,9,1,'Image Gallery','All Users;',0,0,'','','','',NULL, 0,'',0,0);
INSERT INTO `mp_Pages` VALUES (7,3,15,1,'File Manager','Admins;',0,1,'','','','',NULL,0,'',0,0);
INSERT INTO `mp_Pages` VALUES (8,3,13,1,'Feature Modules','Admins;',0,1,'','','','',NULL, 0,'',0,0);

3/21/2005 6:57:25 AM
Gravatar
Total Posts 58

Re: multiple sites upgrade not working

yep .. that did it.  I also noticed that you included the "powered by mojoPortal" image link in you skins but forgot to put the image in the zip.

http://endor.wfyi.org/Data/SiteImages/poweredbymojoportal.gif is missing in my download.
3/21/2005 7:02:20 AM
Gravatar
Total Posts 18439

Re: multiple sites upgrade not working

Good, glad its working for you. I'll put the image in the zip file tonight. I did add the corrected data script just now.

Let me know if you run into any other issues

3/21/2005 7:48:22 AM
Gravatar
Total Posts 58

Re: multiple sites upgrade not working

I get:
ByteFX.Data.MySqlClient.MySqlException: Unknown column 'ShowChildMenuPages' in 'field list'

when I try to create another site.
Then I get :
System.IO.DirectoryNotFoundException: Directory '/var/www/html/Data/Sites/0' not found.

when I try to view the site from the host name I gave it in admin.
The default site still works from its ip address.
3/21/2005 8:03:35 AM
Gravatar
Total Posts 18439

Re: multiple sites upgrade not working

Man I apologize. I should have done more testing before making the release. I will fix this tonight and post new files.
You must sign in to post in the forums. This thread is closed to new posts.