YAFLogo

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.
[URL="http://relam.vn"]mua sắm[/url]|[URL="http://tbz.vn"]rao vat[/URL] | [URL="http://dienhoatructuyen.com.vn"]Dien hoa[/URL]
Sponsor
jpweber
  • jpweber
  • 94.4% (Exalted)
  • YAF Commander
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:

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
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.1
2012-12-11T11:42:07Z
引用:

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!

引用:

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?
[URL="http://relam.vn"]mua sắm[/url]|[URL="http://tbz.vn"]rao vat[/URL] | [URL="http://dienhoatructuyen.com.vn"]Dien hoa[/URL]
jpweber
  • jpweber
  • 94.4% (Exalted)
  • YAF Commander
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

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
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.1
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)


[URL="http://relam.vn"]mua sắm[/url]|[URL="http://tbz.vn"]rao vat[/URL] | [URL="http://dienhoatructuyen.com.vn"]Dien hoa[/URL]
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.1
2012-12-12T14:24:01Z
引用:

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)


[URL="http://relam.vn"]mua sắm[/url]|[URL="http://tbz.vn"]rao vat[/URL] | [URL="http://dienhoatructuyen.com.vn"]Dien hoa[/URL]