YAFLogo

redLine
  • redLine
  • 74.8% (Friendly)
  • YAF MVP Topic Starter
13 years ago
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

Sponsor

Jaben
  • Jaben
  • 100% (Exalted)
  • YAF Developer
13 years ago
Looking at it redLine, the SQL upgrade code was wrong and I've committed the fix.

The problem is that the new code will only fix NEW upgrades -- this upgrade is already messed up.

Here is some SQL code you can run that might fix the problem:


update [dbo].[yaf_UserPMessage] set Flags = IsRead
GO

-- drop the old column
alter table [dbo].[yaf_UserPMessage] drop column [IsRead]
alter table [dbo].[yaf_UserPMessage] drop column [IsInOutbox]
alter table [dbo].[yaf_UserPMessage] drop column [IsArchived]
GO

-- Verify flags isn't NULL
update [dbo].[yaf_UserPMessage] set Flags = 1 WHERE Flags IS NULL
GO

-- add new calculated columns	
alter table [dbo].[yaf_UserPMessage] ADD [IsRead] AS (CONVERT([bit],sign([Flags]&(1)),(0)))
alter table [dbo].[yaf_UserPMessage] ADD [IsInOutbox] AS (CONVERT([bit],sign([Flags]&(2)),(0)))
alter table [dbo].[yaf_UserPMessage] ADD [IsArchived] AS (CONVERT([bit],sign([Flags]&(4)),(0)))
GO
redLine
  • redLine
  • 74.8% (Friendly)
  • YAF MVP Topic Starter
13 years ago
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 ?

redLine
  • redLine
  • 74.8% (Friendly)
  • YAF MVP Topic Starter
13 years ago
Server Error in '/' Application.

A severe error occurred on the current command. The results, if any, should be discarded.

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: A severe error occurred on the current command. The results, if any, should be discarded.

Source Error:

Line 77: private void BindData()

Line 78: {

Line 79: DataSet ds = YAF.Classes.Utils.DBBroker.board_layout( PageContext.PageBoardID, PageContext.PageUserID, PageContext.PageCategoryID, null );

Line 80: CategoryList.DataSource = ds.Tables [DBAccess.GetObjectName("Category")];

Line 81:

Source File: c:\inetpub\vhosts\domain.com\httpdocs\pages\forum.ascx.cs Line: 79

Stack Trace:

[SqlException (0x80131904): A severe error occurred on the current command. The results, if any, should be discarded.]

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.SqlDataReader.HasMoreRows() +150

System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) +214

System.Data.SqlClient.SqlDataReader.Read() +9

System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) +156

System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) +153

System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +172

System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +175

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) +407

YAF.Classes.Data.DBAccess.GetData(SqlCommand cmd, Boolean transaction) +63

YAF.Classes.Data.DB.forum_listread(Object boardID, Object userID, Object categoryID, Object parentID) +305

YAF.Classes.Utils.DBBroker.board_layout(Object boardID, Object userID, Object categoryID, Object parentID) +1500

YAF.Pages.forum.BindData() in c:\inetpub\vhosts\domain.com\httpdocs\pages\forum.ascx.cs:79

YAF.Pages.forum.Page_Load(Object sender, EventArgs e) in c:\inetpub\vhosts\domain.com\httpdocs\pages\forum.ascx.cs:66

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

Some times i take this error too,

Jaben
  • Jaben
  • 100% (Exalted)
  • YAF Developer
13 years ago
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
  • redLine
  • 74.8% (Friendly)
  • YAF MVP Topic Starter
13 years ago
Thanks Jaben i want to ask that.

When i add any user to medals, Medals showing under users avartar but we can't click to medals and we can't learn why this medals gived or what medals mean is this right ? How can we change that.

Jaben
  • Jaben
  • 100% (Exalted)
  • YAF Developer
13 years ago
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.

redLine
  • redLine
  • 74.8% (Friendly)
  • YAF MVP Topic Starter
13 years ago
Server Error in '/' Application.

A severe error occurred on the current command. The results, if any, should be discarded.

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: A severe error occurred on the current command. The results, if any, should be discarded.

Source Error:

Line 77: private void BindData()

Line 78: {

Line 79: DataSet ds = YAF.Classes.Utils.DBBroker.board_layout( PageContext.PageBoardID, PageContext.PageUserID, PageContext.PageCategoryID, null );

Line 80: CategoryList.DataSource = ds.Tables [DBAccess.GetObjectName("Category")];

Line 81:

Source File: c:\inetpub\vhosts\domain.com\httpdocs\pages\forum.ascx.cs Line: 79

Stack Trace:

[SqlException (0x80131904): A severe error occurred on the current command. The results, if any, should be discarded.]

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.SqlDataReader.HasMoreRows() +150

System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) +214

System.Data.SqlClient.SqlDataReader.Read() +9

System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) +156

System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) +153

System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +172

System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +175

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) +407

YAF.Classes.Data.DBAccess.GetData(SqlCommand cmd, Boolean transaction) +63

YAF.Classes.Data.DB.forum_listread(Object boardID, Object userID, Object categoryID, Object parentID) +305

YAF.Classes.Utils.DBBroker.board_layout(Object boardID, Object userID, Object categoryID, Object parentID) +1500

YAF.Pages.forum.BindData() in c:\inetpub\vhosts\domain.com\httpdocs\pages\forum.ascx.cs:79

YAF.Pages.forum.Page_Load(Object sender, EventArgs e) in c:\inetpub\vhosts\domain.com\httpdocs\pages\forum.ascx.cs:66

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

Jaben i always take this error what about that ?

redLine
  • redLine
  • 74.8% (Friendly)
  • YAF MVP Topic Starter
13 years ago
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)

redLine
  • redLine
  • 74.8% (Friendly)
  • YAF MVP Topic Starter
13 years ago
redLine
  • redLine
  • 74.8% (Friendly)
  • YAF MVP Topic Starter
13 years ago
UP!

i want to help.

redLine
  • redLine
  • 74.8% (Friendly)
  • YAF MVP Topic Starter
13 years ago
I founded and fixed my problem.

I think Problem about nvarchar and Mssql 2000.

I upgraded to my mssql 2005 and now i dont take any error. If i take any error i will be come back.

Thanks All!

Ederon
  • Ederon
  • 100% (Exalted)
  • YAF Developer
13 years ago
That's good to hear. 🙂
When I post FP:Ederon in a topic, I'm leaving my footprint there so I can track it once I get into coding/supporting.