Error from Admin\ModuleSettings.aspx

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

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.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
5/5/2006 12:40:47 PM
Bert
Gravatar
Total Posts 15
View Posts

Error from Admin\ModuleSettings.aspx

I am new to web programming, but is trying to setup a mojoPortal hosted on a windows server with access to a MySQL 4.1 server. All seams to work but when I use the administrativ gui i get exceptions. (see below)
What am I doing wrong?

[MySqlException: #42000Access denied for user 'web123'@'%' to database 'web123_mojo'] MySql.Data.MySqlClient.PacketReader.CheckForError() +91 MySql.Data.MySqlClient.PacketReader.ReadHeader() +229 MySql.Data.MySqlClient.PacketReader.OpenPacket() +119 MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) +17 MySql.Data.MySqlClient.CommandResult.ReadNextResult(Boolean isFirst) +71 MySql.Data.MySqlClient.NativeDriver.SendQuery(Byte[] bytes, Int32 length, Boolean consume) +125 MySql.Data.MySqlClient.MySqlCommand.GetNextResultSet(MySqlDataReader reader) +318 MySql.Data.MySqlClient.MySqlDataReader.NextResult() +103 MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +140 MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(MySqlConnection connection, MySqlTransaction transaction, String commandText, MySqlParameter[] commandParameters, Boolean ExternalConn) +160 MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(String connectionString, String commandText, MySqlParameter[] commandParameters) +85 mojoPortal.Data.dbPortal.PageSettings_GetPageTreeReader(Int32 SiteID) +2837 mojoPortal.Business.PageSettings.GetPageTree(Int32 SiteID) in C:\Inetpub\wwwroot\mojoportal\Business\PageSettings.cs:455 mojoPortal.Web.ModuleSettingsPage.PopulateControls() in C:\Inetpub\wwwroot\mojoportal\Web\Admin\ModuleSettings.aspx.cs:158 mojoPortal.Web.ModuleSettingsPage.Page_Load(Object sender, EventArgs e) in C:\Inetpub\wwwroot\mojoportal\Web\Admin\ModuleSettings.aspx.cs:125 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061
5/5/2006 12:47:10 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Error from Admin\ModuleSettings.aspx

Hi Bert,

The problem is that the user in your connection string does not have permission to make temporary tables. He obviously does have permission to connect and do most things but that particular method and a few others use temp tables in order to do paging and sorting efficiently. If you give your user the permission it will fix the problem.

Cheers,

Joe
5/9/2006 6:31:26 AM
Bert
Gravatar
Total Posts 15
View Posts

Re: Error from Admin\ModuleSettings.aspx

Yes!

Create temp tables fixed the problem.

Best regards

Bert 

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