| Author |
 Topic Search  Topic Options
|
Steve66 
Newbie
Joined: 10 April 2012
Status: Offline
Points: 6
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Error When Posting New Topics
Posted: 10 April 2012 at 10:04pm |
The forum is getting an error when posting a new created topic with longer content and/or when copying and pasting longer information and then posting it as new topic or a reply to a topic. Short content new topics and short content replies are working fine. The error that appears reads: Server Error in Forum Application An error has occurred while writing to the database.
Please contact the Forum Administrator.
Support Error Code:- err_SQLServer_save_new_post_data
File Name:- new_post.asp
Forum Version:- 10.03
Any help on this matter would be greatly appreciated. Thank you.
Edited by Steve66 - 10 April 2012 at 11:03pm
|
 |
Shaun
Groupie
Joined: 24 February 2006
Status: Offline
Points: 78
|
Post Options
Thanks(1)
Quote Reply
Posted: 11 April 2012 at 2:40am |
|
Hi Steve and a big welcome to the forums.
If you can post the "error details" which should also normally accompany the first part of that error, that will help pinpoint where the problem lies with your database.
Take care,
Shaun
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(1)
Quote Reply
Posted: 11 April 2012 at 9:36am |
Most servers are only able to handle 100kb response sent to the server from the web browser. This 100kb includes all form data, cookies, and browser headers.
If your post is over 100kb long the server would be unable to handle the response and would throw an error.
|
|
|
|
Steve66
Newbie
Joined: 10 April 2012
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 April 2012 at 11:46pm |
 Shaun wrote:
Hi Steve and a big welcome to the forums.
If you can post the "error details" which should also normally accompany the first part of that error, that will help pinpoint where the problem lies with your database.
Take care,
Shaun |
there is nothing more to the error code. What I posted is exactly as it appears.
|
|
Steve66
Newbie
Joined: 10 April 2012
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 April 2012 at 11:50pm |
WebWiz-Bruce wrote:
Most servers are only able to handle 100kb response sent to the server from the web browser. This 100kb includes all form data, cookies, and browser headers.
If your post is over 100kb long the server would be unable to handle the response and would throw an error. |
Our forum has been online for many years, sometimes posts are extremely long, we never had an issue. We upgraded to the newest 10.03 version and it was fine and just days ago this error message began and has not stopped since. When I say long content post, I mean anything posted past 5 or 6 lines of content prompts this error message. If you keep the post extremly short, it works fine without error message. But this is a new problem as this was never happening in the past, on the new 10.03 version or older verisons. We contacted our host provider and after several test they said it is not an issue on their end. Any idea the source of the problem? Any help where we can begin? Thank you.
|
|
Steve66
Newbie
Joined: 10 April 2012
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 April 2012 at 11:59pm |
As of today, no post replies or new topics, short or long are going through and all are being prompted this same error message posted above. Our forum is at a stand still. Any help on this matter would be greatly appreciated. Thank you.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(1)
Quote Reply
Posted: 12 April 2012 at 10:02am |
A couple of things to try:-
1. Turn of detailed error messages from the admin area to give a fuller error message to what is wrong.
2. Check your SQL Server Database is not full. I suspect that your database is full and hence why to get a post accepted it had to get shorter and shorter, till now the database is completely full and can not accept any new data.
|
|
|
|
Steve66
Newbie
Joined: 10 April 2012
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Posted: 12 April 2012 at 8:19pm |
WebWiz-Bruce wrote:
2. Check your SQL Server Database is not full. I suspect that your database is full and hence why to get a post accepted it had to get shorter and shorter, till now the database is completely full and can not accept any new data. |
We believe this is the problem. Our next step is to upgrade the database size. Is there a means to archive topics and posts without deleting them? Where posts and topics are not on our direct database and members can still keep their posts and post counts? Webwiz Forums premium edition is a fantastic product and terrific support forum.  Thank you very much for your help and assistance, it is greatly appreciated.
|
|
