woonsan
  •  woonsan
  • 50.6% (Neutral)
  • YAF Forumling Topic Starter
2008-10-10T15:45:39Z
As many people had the case sensitive problems, I had the problem too and I tried to fix that.

I am currently using Case-Insensitive collation for SQL Database. (Windows Server 2003 Enterprise SP 2, IIS 6, .Net Framework 2.0, MS-SQL 2005 Enterprise)
And I am using YetAnotherForum(1.9.3 RC2).

Even if I set the collation of database as case insensitive one(Korean_90_CI_AS), it had an error with its installation (Because of not matching case).
So, I have fixed all not matching cases in procedures.sql and providers/procedures.sql. Finally, my installation has successfully been done and also it worked 'some'.

When I tried to access some sections related to user profile(also administration page), it occurred an error like below:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Server Error in '/' Application.


Invalid column name 'UserId'.
Invalid column name 'IndexId'.
Invalid column name 'IndexId'.
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: System.Data.SqlClient.SqlException: Invalid column name 'UserId'.
Invalid column name 'IndexId'.
Invalid column name 'IndexId'.

Source Error:


Line 31: </td>
Line 32: <td class="post">
Line 33: <%# BBCode.EncodeHTML( PageContext.GetProfile( Eval("UserName").ToString() ).Location ) %>
Line 34: </td>
Line 35: <td class="post">


Source File: c:\Inetpub\paradoxoftcommunity\pages\admin\admin.ascx Line: 33

Stack Trace:


[SqlException (0x80131904): Invalid column name 'UserId'.
Invalid column name 'IndexId'.
Invalid column name 'IndexId'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31
System.Data.SqlClient.SqlDataReader.get_MetaData() +62
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1005
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +7
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +141
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +86
YAF.Classes.Data.DBAccess.GetDatasetBasic(SqlCommand cmd, Boolean transaction) +410
YAF.Classes.Data.DBAccess.GetDataset(SqlCommand cmd, Boolean transaction) +62
YAF.Classes.Data.DBAccess.GetDataset(SqlCommand cmd) +7
YAF.Providers.Profile.DB.GetProfiles(Object appName, Object pageIndex, Object pageSize, Object userNameToMatch, Object inactiveSinceDate) +198
YAF.Providers.Profile.YafProfileProvider.GetPropertyValues(SettingsContext context, SettingsPropertyCollection collection) +607
System.Configuration.SettingsBase.GetPropertiesFromProvider(SettingsProvider provider) +404
System.Configuration.SettingsBase.GetPropertyValueByName(String propertyName) +117
System.Configuration.SettingsBase.get_Item(String propertyName) +89
System.Web.Profile.ProfileBase.GetInternal(String propertyName) +36
System.Web.Profile.ProfileBase.get_Item(String propertyName) +68
YAF.Classes.Utils.YafUserProfile.get_Location() +10
ASP.pages_admin_admin_ascx.__DataBind__control4(Object sender, EventArgs e) in c:\Inetpub\paradoxoftcommunity\pages\admin\admin.ascx:33
System.Web.UI.Control.OnDataBinding(EventArgs e) +99
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +206
System.Web.UI.Control.DataBind() +12
System.Web.UI.Control.DataBindChildren() +204
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +216
System.Web.UI.Control.DataBind() +12
System.Web.UI.WebControls.Repeater.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem) +130
System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource) +454
System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) +53
System.Web.UI.WebControls.Repeater.DataBind() +72
System.Web.UI.Control.DataBindChildren() +204
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +216
System.Web.UI.Control.DataBind() +12
System.Web.UI.Control.DataBindChildren() +204
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +216
System.Web.UI.Control.DataBind() +12
YAF.Pages.Admin.admin.BindData() in c:\Inetpub\paradoxoftcommunity\pages\admin\admin.ascx.cs:127
YAF.Pages.Admin.admin.Page_Load(Object sender, EventArgs e) in c:\Inetpub\paradoxoftcommunity\pages\admin\admin.ascx.cs:50
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33
System.EventHandler.Invoke(Object sender, EventArgs e) +0
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436





Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
This error might be related to Case Sensitive/Insensitive in column name.

But, I am using case insensitive collation for database.
I think that I was wrong from the first time.

Would you let me know what I did wrong?

Thank you for reading my question.
Στήφανος
Sponsor

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved