Errant data in SQLite database file...

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.
9/4/2009 1:03:24 AM
dn.hernandez
Gravatar
Total Posts 16
View Posts

Errant data in SQLite database file...

Joe,

I am trying to setup some sandbox sites on our Win2k3 shared hosting using SQLite. When the sites finish setup I am getting the following error:

 I have confirmed that the mp_IndexingQueue table in the SQLite file has a record that contains:  D:\__projects\mojoportal\joe\Web\Data\Sites\1\index\.

Please let me know what I should change the record to or how to fix this.  Thanks, David

 

2009-09-04 01:43:37,566 ERROR mojoPortal.Business.WebHelpers.IndexWriterTask - System.IO.DirectoryNotFoundException: Could not find a part of the path 'D:\__projects\mojoportal\joe\Web\Data\Sites\1\index\'.

at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)

at System.IO.Directory.InternalCreateDirectory(String fullPath, String path, DirectorySecurity dirSecurity)

at System.IO.Directory.CreateDirectory(String path, DirectorySecurity directorySecurity)

at mojoPortal.Business.WebHelpers.IndexWriterTask.ProcessIndexingQueue()

2009-09-04 01:43:45,973 ERROR mojoPortal.Web.mojoBasePage - 24.16.234.35-en-US - /sandbox1/Default.aspx

System.MissingMethodException: Method not found: 'Void System.Web.UI.HtmlControls.HtmlForm.set_Action(System.String)'.

at mojoPortal.Web.UI.mojoRating.Page_Load(Object sender, EventArgs e)

at System.Web.UI.Control.OnLoad(EventArgs e)

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

2009-09-04 01:43:45,988 ERROR mojoPortal.Web.Global - 24.16.234.35-en-US - /sandbox1/Default.aspx

System.MissingMethodException: Method not found: 'Void System.Web.UI.HtmlControls.HtmlForm.set_Action(System.String)'.

at mojoPortal.Web.UI.mojoRating.Page_Load(Object sender, EventArgs e)

at System.Web.UI.Control.OnLoad(EventArgs e)

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

 

9/4/2009 5:17:42 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Errant data in SQLite database file...

Hi,

It looks like there must have been unprocessed rows in the mp_IndexingQueue table in the SQLite db I shipped I will fix that for the next release. You could connect using the sqlite.exe at the command prompt and run a query to purge that table. Or you could create a new empty SQLite db as described in the documentation. Probably easiest configuration is to rename the existing mojo.db.config and then create a new one with the same name so you don't have to touch the connection string. Then visit setup again to run the scripts.

The second error about HtmlForm.set_Action is not related to sqlite, its caused because you are missing SP 1 for .NET 3.5., installing 3.5 SP1 is the only way to solve it.

Hope it helps,

Joe

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