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.
When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:
Os: Win2003 Server
Release: mojoPortal 2.2.2.8 Released
DB: MySql
I got the following error message when trying to edit user properties via the Member list
*********************************
Server Error in '/' Application. -------------------------------------------------------------------------------- #42S22Unknown column 'u.SiteID' in 'where clause' Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: MySql.Data.MySqlClient.MySqlException: #42S22Unknown column 'u.SiteID' in 'where clause' Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [MySqlException: #42S22Unknown column 'u.SiteID' in 'where clause'] MySql.Data.MySqlClient.PacketReader.CheckForError() +91 MySql.Data.MySqlClient.PacketReader.ReadHeader() +229 MySql.Data.MySqlClient.PacketReader.OpenPacket() +119 MySql.Data.MySqlClient.NativeDriver.ReadResult(Int64& affectedRows, Int64& lastInsertId) +17 MySql.Data.MySqlClient.CommandResult.ReadNextResult(Boolean isFirst) +67 MySql.Data.MySqlClient.NativeDriver.SendQuery(Byte[] bytes, Int32 length, Boolean consume) +130 MySql.Data.MySqlClient.MySqlCommand.GetNextResultSet(MySqlDataReader reader) +391 MySql.Data.MySqlClient.MySqlDataReader.NextResult() +270 MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +163 MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(MySqlConnection connection, MySqlTransaction transaction, String commandText, MySqlParameter[] commandParameters, Boolean ExternalConn) +158 MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(String connectionString, String commandText, MySqlParameter[] commandParameters) +85 mojoPortal.Data.dbPortal.Role_GetRolesUserIsNotIn(Int32 siteID, Int32 userID) +386 mojoPortal.Business.Role.GetRolesUserIsNotIn(Int32 siteID, Int32 userID) +5 mojoPortal.Web.AdminUI.ManageUsers.PopulateControls() +2357 mojoPortal.Web.AdminUI.ManageUsers.Page_Load(Object sender, EventArgs e) +423 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061 Regards //Anders Ahlin
Hi Anders,
Thanks for the bug report. I have just uploaded a new set of files for the MySql data layer.
Can you back up your mojoPortal.Data.dll from your bin folder and try the new dll of the same name?
Thanks,
Joe
Thanks Joe!
It´s working just fine now.
//Anders Ahlin