Bug - SqlCe - 2.3.5.5 - The column name is not valid

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.
12/1/2010 10:35:29 AM
Gravatar
Total Posts 57

Bug - SqlCe - 2.3.5.5 - The column name is not valid

Hi

In the security settings tab when you want to define a single user to be able to edit the content and as soon as you click the down arrow button the following error happens:

The column name is not valid. [ Node name (if any) = u2,Column name = UserID ]

which logs:

2010-12-01 19:21:39,424 ERROR mojoPortal.Web.Global - 127.0.0.1-en-US - /Services/UserDropDownXml.aspx?query=
System.Data.SqlServerCe.SqlCeException: The column name is not valid. [ Node name (if any) = u2,Column name = UserID ]
at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan()
at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) in C:\Users\User\Desktop\mojoportal_5749af767008\mojoPortal.Data.SqlCe\SqlHelper.cs:line 177
at mojoPortal.Data.DBSiteUser.GetSmartDropDownData(Int32 siteId, String query, Int32 rowsToGet) in C:\Users\User\Desktop\mojoportal_5749af767008\mojoPortal.Data.SqlCe\DBSiteUser.cs:line 127
at mojoPortal.Business.SiteUser.GetSmartDropDownData(Int32 siteId, String query, Int32 rowsToGet) in C:\Users\User\Desktop\mojoportal_5749af767008\mojoPortal.Business\SiteUser.cs:line 2494
at mojoPortal.Web.Services.UserDropDownXml.Page_Load(Object sender, EventArgs e) in C:\Users\User\Desktop\mojoportal_5749af767008\Web\Services\UserDropDownXml.aspx.cs:line 40
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Regards
Malkom

12/1/2010 12:58:45 PM
Gravatar
Total Posts 18439

Re: Bug - SqlCe - 2.3.5.5 - The column name is not valid

Hi Malkom,

Thanks for the bug report. This is now fixed in the source code repository and will be fixed in the next release.

Best,

Joe

12/1/2010 1:58:40 PM
Gravatar
Total Posts 57

Re: Bug - SqlCe - 2.3.5.5 - The column name is not valid

Thanks

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