Print Page | Close Window

Revisit error

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=24803
Printed Date: 06 April 2026 at 10:20am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Revisit error
Posted By: Chiraphat
Subject: Revisit error
Date Posted: 11 November 2007 at 11:47am
Error message when revisit the forum
 
Server Error in Forum Application
An error has occurred while executing SQL query on database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_UnreadPosts()
File Name:- functions_common.asp

Error details:-
Microsoft OLE DB Provider for SQL Server
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
 
 
Server : Windows Server 2003 R2
Database : MSSQL 2000
 
User must delete cookie every time to access the forum. Does anyone know how to fix this?
 
*Edit
I found an error when create a forum.
 
Microsoft OLE DB Provider for SQL Server error '80004005'

Invalid date format

/forum/admin_forum_details.asp, line 224

I think both of this error come from incorrect date format, but I don't know how to fix it.  Can anyone help, please?




Replies:
Posted By: WebWiz-Bruce
Date Posted: 11 November 2007 at 12:25pm
It looks like either your database is incorrectly setup or you have a corrupted file.

First try reuploading the files again, if that doesn't fix the issue then it looks like a datetime field in your database has been altered to a character field coursing these types of errors.

If it is a new forum you should delete the database and reinstall the software again.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: Chiraphat
Date Posted: 11 November 2007 at 12:43pm
Originally posted by -boRg- -boRg- wrote:

It looks like either your database is incorrectly setup or you have a corrupted file.

First try reuploading the files again, if that doesn't fix the issue then it looks like a datetime field in your database has been altered to a character field coursing these types of errors.

If it is a new forum you should delete the database and reinstall the software again.
 
This is a new forum on a new server. I tried all of them but it still have the problem. 
Access version work correctly.
 
*Edit
I found the mistake. I set wrong regional setting in the server.  Now every things work fine.
Thanks.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net