Errors with SQLite mojoPortal v2.2.4.6-b

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/25/2008 7:53:45 PM
shildreth
Gravatar
Total Posts 3
View Posts

Errors with SQLite mojoPortal v2.2.4.6-b

Hi, I am having a bit of trouble getting the MojoPortal package with SQLite working. It is possible I am doing something wrong please review my steps and my error message and advise.

  • I download the 'mojoportal-x-x-x-x-sqlitereleasefiles.zip' file to my desktop
  • I unzip the ZIP file, copy the 'web.mediumtrust.config' to 'web.config'.
  • I edit lines; 174-175, Generate a new Machine key using the DevelopmentNow.com link, edit lines 798-801
  • I upload the entire 'web' folder (including my newly edited web.config file) to my DiscountASP.net FTP account
  • I renamed the uploaded foler from 'web' to 'mp'
  • I use the DiscountASP.net Web application tool and set the 'mp' folder to be an application
  • I then point my browser to domain_name/mp/setup folder and watch the nifty status - no errors
  • I then go to the 'Login' and use 'admin@admin.com' with 'admin' and then click on 'Member List'
  • I then click on the gear beside the 'Admin' account (with intent to reset the password and then setup my account)
  • I get these errors (in the domain_name/mp/Data/currentlog.config file:
  • 2008-01-25 17:41:25,687 [31184] ERROR mojoPortal.Web.mojoBasePage [(null)] - Mono.Data.Sqlite.SqliteException: Sqlite error
    Insufficient parameters supplied to the command
    at Mono.Data.Sqlite.SqliteStatement.BindParameter(Int32 index, SqliteParameter param)
    at Mono.Data.Sqlite.SqliteStatement.BindParameters()
    at Mono.Data.Sqlite.SqliteCommand.BuildNextCommand()
    at Mono.Data.Sqlite.SqliteCommand.GetStatement(Int32 index)
    at Mono.Data.Sqlite.SqliteDataReader.NextResult()
    at Mono.Data.Sqlite.SqliteDataReader..ctor(SqliteCommand cmd, CommandBehavior behave)
    at Mono.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
    at mojoPortal.Data.SqliteHelper.ExecuteReader(IDbConnection connection, SqliteTransaction transaction, String commandText, IDataParameter[] commandParameters, Boolean externalConn)
    at mojoPortal.Data.SqliteHelper.ExecuteReader(String connectionString, String commandText, IDataParameter[] commandParameters)
    at mojoPortal.Data.DBSiteUser.GetSingleUser(Guid userGuid)
    at mojoPortal.Business.SiteUser.GetUser(Guid userGuid)
    at mojoPortal.Business.SiteUser..ctor(SiteSettings settings, Guid userGuid)
    at mojoPortal.Web.ELetterUI.SubscriberPreferencesControl.LoadSettings()
    at mojoPortal.Web.ELetterUI.SubscriberPreferencesControl.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)
    2008-01-25 17:41:25,703 [31184] ERROR mojoPortal.Web.Global [(null)] - 75.23.242.163-en-US - /mp/Admin/ManageUsers.aspx?userid=1
    Mono.Data.Sqlite.SqliteException: Sqlite error
    Insufficient parameters supplied to the command
    at Mono.Data.Sqlite.SqliteStatement.BindParameter(Int32 index, SqliteParameter param)
    at Mono.Data.Sqlite.SqliteStatement.BindParameters()
    at Mono.Data.Sqlite.SqliteCommand.BuildNextCommand()
    at Mono.Data.Sqlite.SqliteCommand.GetStatement(Int32 index)
    at Mono.Data.Sqlite.SqliteDataReader.NextResult()
    at Mono.Data.Sqlite.SqliteDataReader..ctor(SqliteCommand cmd, CommandBehavior behave)
    at Mono.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
    at mojoPortal.Data.SqliteHelper.ExecuteReader(IDbConnection connection, SqliteTransaction transaction, String commandText, IDataParameter[] commandParameters, Boolean externalConn)
    at mojoPortal.Data.SqliteHelper.ExecuteReader(String connectionString, String commandText, IDataParameter[] commandParameters)
    at mojoPortal.Data.DBSiteUser.GetSingleUser(Guid userGuid)
    at mojoPortal.Business.SiteUser.GetUser(Guid userGuid)
    at mojoPortal.Business.SiteUser..ctor(SiteSettings settings, Guid userGuid)
    at mojoPortal.Web.ELetterUI.SubscriberPreferencesControl.LoadSettings()
    at mojoPortal.Web.ELetterUI.SubscriberPreferencesControl.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)

Please advise.

Thanks for your help and all the work put into the mojoPortal project.

Regards,
Steven Hildreth
 

 

 

1/25/2008 8:04:55 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Errors with SQLite mojoPortal v2.2.4.6-b

Hi,

I will look into this bug tomorrow. If I can reproduce it I will provide a new mojoPortal.Data.dll for SQLite and let you test it to confirm the fix.

One question though is why did you configure it for Medium trust? For one thing you can't use SQLite in Medium trust at all because it pinvokes against a native dll and for another DiscoutASP offers full trust so this configuration wasn't needed and takes away some functionality.

I'll follow up tomorrow.

Best Regards,

Joe

1/25/2008 8:30:06 PM
shildreth
Gravatar
Total Posts 3
View Posts

Re: Errors with SQLite mojoPortal v2.2.4.6-b

Hi, I changed and used the 'Web.config' file and retested. I get the same errors when I click on the User Gear next to the 'Admin' account.

Thanks for your help.

 

1/25/2008 8:36:57 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Errors with SQLite mojoPortal v2.2.4.6-b

Hi Steven,

No I didn't think that would fix it but just wanted you to know the medium trust config wasn't needed. By configuring it for medium trust you lose NeatUpload and some other things become more difficult.

I'm pretty sure the error you are seeing is a bug and will be reproducable and also easy to fix. Admittedly better testing happens for MS SQL and MySQL since I have sites running on those. So you get to be the guinea pig and tell me the bugs you encounter but rest assured I'll fix them quickly.

I'd fix it right now but hey its friday night ;-)

Cheers,

Joe

1/26/2008 7:51:33 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Errors with SQLite mojoPortal v2.2.4.6-b

Hi Steven,

I sent you a replacement mojoPortal.Data.dll with this bug fixed.

I've also updated the release download for the SQLite version

Let me know if you encounter any other errors.

Thanks,

Joe

1/26/2008 11:35:28 AM
shildreth
Gravatar
Total Posts 3
View Posts

Re: Errors with SQLite mojoPortal v2.2.4.6-b

So far works great. I have clicked around and found no more errors, woot!

Thanks again.

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