Error Posting Message
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=23113
Printed Date: 07 April 2026 at 7:52pm Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Error Posting Message
Posted By: disrael
Subject: Error Posting Message
Date Posted: 14 April 2007 at 5:42pm
We've been running WWF for a few months now. Lately, we've been getting more and more errors during posting that look like this:
Server Error in Forum Application An error has occured while writing to the database. Please contact the forum administrator.
Support Error Code:- err_SQLServer_save_new_post_data File Name:- new_post.asp
Error details:- Microsoft OLE DB Provider for SQL Server INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'tblThread_FK01'. The conflict occurred in database 'msgboard', table 'tblTopic', column 'Topic_ID'.
Doesn't seem to be any rhyme or reason to it. I'm running off to class now, so I plan on troubleshooting it tonight or tomorrow, but I was wondering if anybody else had this issue and what (precisely) causes it and what I can do to eliminate this... Doesn't happen all the time, but once or twice per week it does.
------------- -D. Israel
|
Replies:
Posted By: NShel
Date Posted: 15 April 2007 at 3:47am
disrael wrote:
We've been running WWF for a few months now. Lately, we've been getting more and more errors during posting that look like this:
Server Error in Forum Application An error has occured while writing to the database. Please contact the forum administrator.
Support Error Code:- err_SQLServer_save_new_post_data File Name:- new_post.asp
Error details:- Microsoft OLE DB Provider for SQL Server INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'tblThread_FK01'. The conflict occurred in database 'msgboard', table 'tblTopic', column 'Topic_ID'.
Doesn't seem to be any rhyme or reason to it. I'm running off to class now, so I plan on troubleshooting it tonight or tomorrow, but I was wondering if anybody else had this issue and what (precisely) causes it and what I can do to eliminate this... Doesn't happen all the time, but once or twice per week it does.
|
YES! Everyone on our forum seems to be getting something pretty similar this after they post or PM.
|
Posted By: disrael
Date Posted: 19 April 2007 at 9:18pm
NShel wrote:
disrael wrote:
We've been running WWF for a few months now. Lately, we've been getting more and more errors during posting that look like this:
Server Error in Forum Application An error has occured while writing to the database. Please contact the forum administrator.
Support Error Code:- err_SQLServer_save_new_post_data File Name:- new_post.asp
Error details:- Microsoft OLE DB Provider for SQL Server INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'tblThread_FK01'. The conflict occurred in database 'msgboard', table 'tblTopic', column 'Topic_ID'.
Doesn't seem to be any rhyme or reason to it. I'm running off to class now, so I plan on troubleshooting it tonight or tomorrow, but I was wondering if anybody else had this issue and what (precisely) causes it and what I can do to eliminate this... Doesn't happen all the time, but once or twice per week it does.
|
YES! Everyone on our forum seems to be getting something pretty similar this after they post or PM.
|
OK, well I seem to have a little more data. When this happens, the variable lngTopicID is 0 (zero).
I have auto-login with the existingMemberAPI rewritten (to access our sites already implemented security). Could going here to login be causing this problem? (or could I have done something wrong implementing my own user/pass authentication?
Thanks.
------------- -D. Israel
|
Posted By: WebWiz-Bruce
Date Posted: 20 April 2007 at 8:58am
Isx this happening with a New Topic or a Reply within a Topic?
------------- 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: disrael
Date Posted: 20 April 2007 at 6:29pm
-boRg- wrote:
Isx this happening with a New Topic or a Reply within a Topic?
|
It's happening on a reply.
------------- -D. Israel
|
Posted By: WebWiz-Bruce
Date Posted: 20 April 2007 at 7:31pm
When a reply is made the Topic ID is paste from the reply form, it souynds like this is not happening.
The only reasons why this would not happen is if you have incorrectly modded the forum or have a corrupted file. You should re-upload the original files again, and make sure you are running the latest version.
------------- 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: disrael
Date Posted: 23 April 2007 at 4:55pm
-boRg- wrote:
When a reply is made the Topic ID is paste from the reply form, it souynds like this is not happening.
The only reasons why this would not happen is if you have incorrectly modded the forum or have a corrupted file. You should re-upload the original files again, and make sure you are running the latest version.
|
I'm using the latest (8.05a). I know this is a hard question to answer, but what could I have done wrong (in a modificiation) that might cause this? I'll have to review my changes, but they are pretty much all in the login/authentication area...
------------- -D. Israel
|
|