kdtbzvn
  •  kdtbzvn
  • 50.2% (Neutral)
  • YAF Lover Topic Starter
2012-12-10T04:40:36Z
Below is a snapshot of my error.Please give me the best advice.Thank you.
kdtbzvn attached the following image(s):

Sponsor
jpweber
2012-12-10T05:06:11Z
Despite the Vietnamese, I see the browser message; the error indicates an object is null.

For future reference, if ever needed, MSDN Object Null Information 

Regardless, it appears your db.config not setup correctly. Please make sure the information in that file is correct.

So open up your YAF ---> db.config with notepad or whatever, and edit this:

<add name="yafnet" connectionString="Data Source=sql2k805.XXXXXXXXXXXXXXXXXXXXXX;User ID=SQL2008R2_XXXXXXXXX_USER;Password=YOURPASSWORD"
providerName="System.Data.SqlClient" />

Make sure all that information is correct and is the proper information for your database. If you're using a shared host, go into your host's control panel and get the database information from there.

Upload the edited db.config and replace the old one and refresh your browser or clear the cache, and things should work properly.

Also, when you're logged in as the administrator, click Admin, then Settings in the left column, then File Extensions. Add file extensions as you wish or need -- .jpg, .jpeg, .gif, .bmp, .png, .doc, .docx, etc., etc. ....
Jason Weber
USS Vision YAF 
"Money is better than poverty, if only for financial reasons"
tha_watcha
2012-12-11T11:42:07Z
Quote:

Regardless, it appears your db.config not setup correctly. Please make sure the information in that file is correct.



No this has nothing to do with the db.config!

Quote:

Below is a snapshot of my error.Please give me the best advice.Thank you.



Can you take a look at the Event Log there should be an entry with the full error. Please Post the Full Error Message here.
UserPostedImage
kdtbzvn
  •  kdtbzvn
  • 50.2% (Neutral)
  • YAF Lover Topic Starter
2012-12-11T16:52:41Z
Thank you for replying, tha_watcha. Can you please explain to me how I can obtain my event log, so maybe you can understand this problem better?
jpweber
2012-12-11T18:17:51Z
My apologies, watcha ....

I just thought I had seen this issue before a few times, and thought it was his db.config. Indeed, he did have both <add name= things in his db.config -- including the one for SQL Express, which he deleted.

I'm not sure if he'd know how to access his event log, though.
Jason Weber
USS Vision YAF 
"Money is better than poverty, if only for financial reasons"
tha_watcha
2012-12-11T22:26:37Z
Originally Posted by: kdtbzvn 

Thank you for replying, tha_watcha. Can you please explain to me how I can obtain my event log, so maybe you can understand this problem better?




You find the Event log in the Admin Area under Admin -> Maintenance -> event log or you access the site via

http://www.yoursite.com/admin_eventlog.aspx  (replace the URL with your real URL).
UserPostedImage
kdtbzvn
  •  kdtbzvn
  • 50.2% (Neutral)
  • YAF Lover Topic Starter
2012-12-12T02:37:04Z

Horrible, just over a day, I have found more than 40 sites listed error.
But only two different types.
1. System 12/11/2012 6:59:34 AM (source) Unknown (Show)
SendMailThread Failed for the 2nd time.
This error is not much.
2. And this happens in all the rest. Source: ASP.pages_posts_ascx

System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
at System.Data.SqlTypes.SqlDateTime.FromTimeSpan(TimeSpan value)
at System.Data.SqlTypes.SqlDateTime.FromDateTime(DateTime value)
at System.Data.SqlClient.MetaType.FromDateTime(DateTime dateTime, Byte cb)
at System.Data.SqlClient.TdsParser.WriteValue(Object value, MetaType type, Byte scale, Int32 actualLength, Int32 encodingByteSize, Int32 offset, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
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.MsSqlDbAccess.GetDatasetBasic(IDbCommand cmd, Boolean transaction) in E:\YAF-v1.9.6-RC1-SRC\YAF-v1.9.6-RC1-SRC\123nhanh\YAF.Classes\YAF.Classes.Data\mssql\MsSqlDbAccess.cs:line 644
at YAF.Classes.Data.MsSqlDbAccess.GetData(IDbCommand cmd, Boolean transaction) in E:\YAF-v1.9.6-RC1-SRC\YAF-v1.9.6-RC1-SRC\123nhanh\YAF.Classes\YAF.Classes.Data\mssql\MsSqlDbAccess.cs:line 538
at YAF.Types.Interfaces.IDbAccessExtensions.GetData(IDbAccess dbAccess, IDbCommand cmd) in E:\YAF-v1.9.6-RC1-SRC\YAF-v1.9.6-RC1-SRC\123nhanh\YAF.Types\Interfaces\Extensions\IDbAccessExtensions.cs:line 87
at YAF.Classes.Data.LegacyDb.message_findunread(Object topicID, Object messageId, Object lastRead, Object showDeleted, Object authorUserID) in E:\YAF-v1.9.6-RC1-SRC\YAF-v1.9.6-RC1-SRC\123nhanh\YAF.Classes\YAF.Classes.Data\mssql\LegacyDb.cs:line 5230
at YAF.Pages.posts.GetFindMessageId(Boolean showDeleted, Int32 userId, Int32& messagePosition)
tha_watcha
2012-12-12T14:24:01Z
Quote:

Horrible, just over a day, I have found more than 40 sites listed error.



Thats odd there definitely should be an log entry when try to upload files.

Simply try to Attach a file again and then the log entry should be pop up on the first page.

PS: The Second Error you posted is a known Bug and is fixed in the next upcoming release.
UserPostedImage
kdtbzvn
  •  kdtbzvn
  • 50.2% (Neutral)
  • YAF Lover Topic Starter
2012-12-13T16:18:28Z
"Hello Watcha. I did what you told me to do, and here is the new event log"

System.NullReferenceException: Object reference not set to an instance of an object.
at YAF.Pages.attachments.CheckValidFile(HtmlInputFile uploadedFile)
at YAF.Pages.attachments.Upload_Click(Object sender, EventArgs e)

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