ginuno
  •  ginuno
  • 51.8% (Neutral)
  • YAF Forumling Topic Starter
2010-02-25T04:31:53Z
Hi,

after several hours I give in, unable to handle this error:

System.ApplicationException was unhandled by user code
Message="Sql Exception with error number 50000 (Tries=0)"
Source="YAF.Classes.Data"
StackTrace:
em YAF.Classes.Data.DB.pageload(Object sessionID, Object boardID, Object userKey, Object ip, Object location, Object browser, Object platform, Object categoryID, Object forumID, Object topicID, Object messageID, Object donttrack)
em YAF.Classes.Core.UserPageBase.InitUserAndPage()
em YAF.Classes.Core.UserPageBase.get_Page()
em YAF.Classes.Core.UserPageBase.PageValueAsInt(String field)
em YAF.Classes.Core.UserPageBase.get_PageUserID()
em YAF.Forum.Forum_Load(Object sender, EventArgs e) em c:\Forum\App_Code\YAF\Forum.cs:line 340
em System.Web.UI.Control.OnLoad(EventArgs e)
em System.Web.UI.Control.LoadRecursive()
em System.Web.UI.Control.LoadRecursive()
em System.Web.UI.Control.LoadRecursive()
em System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
InnerException: System.Data.SqlClient.SqlException
Message="Found 0 possible guest users. There should be one and only one user marked as guest."
Source=".Net SqlClient Data Provider"
ErrorCode=-2146232060
Class=16
LineNumber=30
Number=50000
Procedure="yaf_pageload"
Server="\\\\.\\pipe\\B279E175-8E52-47\\tsql\\query"
State=1
StackTrace:
em System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
em System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
em System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
em System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
em System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
em System.Data.SqlClient.SqlDataReader.get_MetaData()
em System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
em System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
em System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
em System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
em System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
em System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
em System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
em System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
em System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
em System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
em YAF.Classes.Data.YafDBAccess.GetDatasetBasic(SqlCommand cmd, Boolean transaction)
em YAF.Classes.Data.YafDBAccess.GetData(SqlCommand cmd, Boolean transaction)
em YAF.Classes.Data.YafDBAccess.GetData(SqlCommand cmd)
em YAF.Classes.Data.DB.pageload(Object sessionID, Object boardID, Object userKey, Object ip, Object location, Object browser, Object platform, Object categoryID, Object forumID, Object topicID, Object messageID, Object donttrack)
InnerException:


I´m using YAF-v1.9.4-RC1-BIN.zip, in c:\Forum, and made this procedures steps;
1- renamed "recomended web config" to web.config
2- Created an sql database in App_Data called "aspnetdb.mdf"
3- Changed the connection string to "<add name="yafnet" connectionString="Data Source=http://localhost:1729/Forum/App_Data/; Initial Catalog=aspnetdb.mdf;Integrated Security=SSPI;" />"
4- Configured mail.config
5- Run /install/default.aspx

The code breaks after configuring a new user (admin)

I really need help with this one. Don´t have much experience on asp.net

Thanks in advance,

Nuno Couto
Sponsor
bbobb
  •  bbobb
  • 100% (Exalted)
  • YAF Developer
2010-02-25T06:28:16Z
Find in yaf_User table a row with Name=Guest and
post BoardID and Flags values. Is it a unique row with Name=Guest in the table?

Sheer telepathy­čśü
Update. Sorry, I see the version.
Did you try and recreate the database?


ginuno
  •  ginuno
  • 51.8% (Neutral)
  • YAF Forumling Topic Starter
2010-02-25T07:32:31Z
I´m using VS2008, so i added an SQL db to the project. The YAF install made the rest. This is the second time i make the project and this error insist to appear.

yaf_User table has only one row with null in all the fields.
bbobb
  •  bbobb
  • 100% (Exalted)
  • YAF Developer
2010-02-25T08:00:26Z
Post DB.system_initialized parameters values(put a breakpoint somewhere inside it) It is in YAF.Classes.Data.DB.system_initialized().
ginuno
  •  ginuno
  • 51.8% (Neutral)
  • YAF Forumling Topic Starter
2010-02-25T16:15:43Z
Sorry my ignorance. I introduced a break point in /bin/YAF.Classes.Data.XML -->

M:YAF.Classes.Data.DB.system_initialize(System.String,System.String,System.String,System.String,System.String,System.String,System.Object)">


But i don´t khown where i can see the parameters you asked.

Can you help me out in this too?:?

Thanks
bbobb
  •  bbobb
  • 100% (Exalted)
  • YAF Developer
2010-02-26T01:24:58Z
I'm sorry, but in the case you are on your own.
As no one has problem like this, I can suppose that you have configuration problems, maybe db permissions.

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