Hi Guyz,


i was try to upgrade my 1.9.8 forum to 1.9.3 beta and i upgraded my forum but i have some error.

For example

When i try to send any one to pm i take this error

Server Error in '/' Application.
Cannot insert the value NULL into column 'IsRead', table 'database.dbo.yaf_UserPMessage'; column does not allow nulls. INSERT fails.
The statement has been terminated.
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: Cannot insert the value NULL into column 'IsRead', table 'database.dbo.yaf_UserPMessage'; column does not allow nulls. INSERT fails.
The statement has been terminated.

Source Error:

Line 324: messageFlags.IsBBCode = _editor.UsesBBCode;
Line 325:
Line 326: DB.pmessage_save( PageContext.PageUserID, recipientID [i], Subject.Text, body, messageFlags.BitValue );
Line 327:
Line 328: if ( PageContext.BoardSettings.AllowPMEmailNotification )


Source File: c:\inetpub\vhosts\domain.com\httpdocs\pages\pmessage.ascx.cs Line: 326

Stack Trace:

[SqlException (0x80131904): Cannot insert the value NULL into column 'IsRead', table 'database.dbo.yaf_UserPMessage'; column does not allow nulls. INSERT fails.
The statement has been terminated.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857354
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734966
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +149
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +886
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +415
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
YAF.Classes.Data.DBAccess.ExecuteNonQuery(SqlCommand cmd, Boolean transaction) +148
YAF.Classes.Data.DB.pmessage_save(Object fromUserID, Object toUserID, Object subject, Object body, Object Flags) +333
YAF.Pages.pmessage.Save_Click(Object sender, EventArgs e) in c:\inetpub\vhosts\domain.com\httpdocs\pages\pmessage.ascx.cs:326
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102


Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42


I think i must be set ISread table default char to "False" or What i want to do ?


My Other problem is topic viewing, When i try to view with my administrator account i can view all post but my registered users or guest users can't see some topics and they take this error.


Server Error in '/' Application.

---

There is no row at position 1.
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.IndexOutOfRangeException: There is no row at position 1.

Source Error:


Line 360: foreach ( DataRowView delRow in dt )
Line 361: {
Line 362: delRow.Delete();
Line 363: }
Line 364:


Source File: c:\inetpub\vhosts\domain.com\httpdocs\pages\posts.ascx.cs Line: 362

Stack Trace:


[IndexOutOfRangeException: There is no row at position 1.]
System.Data.DataView.GetRecord(Int32 recordIndex) +1737453
System.Data.DataView.GetRow(Int32 index) +34
System.Data.DataView.Delete(Int32 index) +207
System.Data.DataRowView.Delete() +14
YAF.Pages.posts.BindData() in c:\inetpub\vhosts\domain.com\httpdocs\pages\posts.ascx.cs:362
YAF.Pages.posts.Page_Load(Object sender, EventArgs e) in c:\inetpub\vhosts\domain.com\httpdocs\pages\posts.ascx.cs:210
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
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) +1061

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42


i say my administrator account not any problem about post viewing but registered users or guest users can't view same posts

Jaben i try with Mssql Server Management query editor to compile your code but
i take this error


(0 row(s) affected)
Msg 5074, Level 16, State 1, Line 4
The object 'DF__yaf_UserP__IsInO__67152DD3' is dependent on column 'IsInOutbox'.
Msg 4922, Level 16, State 9, Line 4
ALTER TABLE DROP COLUMN IsInOutbox failed because one or more objects access this column.

(0 row(s) affected)
Msg 2705, Level 16, State 5, Line 4
Column names in each table must be unique. Column name 'IsInOutbox' in table 'dbo.yaf_UserPMessage' is specified more than once.



But my pm problem is fixed can you help me about post viewing ?

Object "DF__yaf_UserP__IsInO__67152DD3" is not something that is in the YAF schema, obviously.

"A severe error occurred on the current command. The results, if any, should be discarded." is not something related to YAF either. Here is what others said that issue was:

"The problem was that the user id used to perform the connection to the data store DID NOT have sufficient Windows privileges to perform NET USEs. And that my friends, was the cause of my “SEVERE ERROR”."

Permission problems... good luck.

redLine, can you make a new topic about the Medals question? It's actually Ederon's territory and it does deserve it's own topic.

Thanks.

I founded that in eventlog too, How can i fix that ? Because i take this error always





System.Data.SqlClient.SqlException: A severe error occurred on the current command. The results, if any, should be discarded.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.HasMoreRows()
at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.Read()
at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at YAF.Classes.Data.DBAccess.GetDatasetBasic(SqlCommand cmd, Boolean transaction)
at YAF.Classes.Data.DBAccess.GetData(SqlCommand cmd, Boolean transaction)
at YAF.Classes.Data.DB.forum_listread(Object boardID, Object userID, Object categoryID, Object parentID)
at YAF.Classes.Utils.DBBroker.board_layout(Object boardID, Object userID, Object categoryID, Object parentID)
at YAF.Pages.forum.BindData() in c:\inetpub\vhosts\tith4ck.net\httpdocs\pages\forum.ascx.cs:line 79
at YAF.Pages.forum.Page_Load(Object sender, EventArgs e) in c:\inetpub\vhosts\tith4ck.net\httpdocs\pages\forum.ascx.cs:line 66
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.EventHandler.Invoke(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.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

UP!

i want to help.

That's good to hear.