| Author |
 Topic Search  Topic Options
|
disrael 
Groupie
Joined: 28 November 2006
Status: Offline
Points: 36
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Error Posting Message
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
|
 |
NShel
Groupie
Joined: 23 September 2006
Location: United States
Status: Offline
Points: 49
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
disrael
Groupie
Joined: 28 November 2006
Status: Offline
Points: 36
|
Post Options
Thanks(0)
Quote Reply
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
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 April 2007 at 8:58am |
|
Isx this happening with a New Topic or a Reply within a Topic?
|
|
|
|
disrael
Groupie
Joined: 28 November 2006
Status: Offline
Points: 36
|
Post Options
Thanks(0)
Quote Reply
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
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
disrael
Groupie
Joined: 28 November 2006
Status: Offline
Points: 36
|
Post Options
Thanks(0)
Quote Reply
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
|
|
