8.0 RC1: re-sync problem?
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=18925
Printed Date: 12 April 2026 at 2:22pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: 8.0 RC1: re-sync problem?
Posted By: ask023
Subject: 8.0 RC1: re-sync problem?
Date Posted: 24 March 2006 at 6:45pm
|
Hello,
I experimented a lot with topics creation/deletion, still got rare errors like:
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 Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. It happen rarely when we add new topic with several pictures inserted - when some pictures uploaded, but not inserted...etc. I can't describe reproduce way yet
After experiments, I see 3 topics count in Forum (not subforum), but actually we have only one topic inside. When I tried to re-sync counts through Admin panel - nothing happened
Probably there others ways to re-sync counters?
Thanks!
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 27 March 2006 at 11:26am
|
Because for database performance the field that holds the names of uploaded files and images can only hold 255 characters it means that if files/images uploaded with long file names only 6 can be uploaded in any one post. There should be code to prevent the error, but would mean that not all images/files would be included in the post. It was decided that 6 image/file uploads would be sufficient for 99% of posts that had file/image uploads. |
Posted By: ask023
Date Posted: 27 March 2006 at 9:39pm
|
Thank you Bruce. I think errors happened with 2 files only, each 20-30 chars length
What do you think about re-sync issue? Is there method to force automatic sync or perform manual sync?
Thanks!
|
Posted By: WebWiz-Bruce
Date Posted: 28 March 2006 at 10:48am
| Not in RC1, but there will be in the next version by using the Topic Admin button. |
Posted By: ask023
Date Posted: 30 March 2006 at 3:41pm
|
Thanks! It will be great to re-sync by topics...
But what we can do if re-sync don't work now? It's not a problem to run re-sync against whole board, but it don't work in specific case...
Probably we may fix it in DB manually?
Thanks!
|
Posted By: WebWiz-Bruce
Date Posted: 31 March 2006 at 8:52am
| You could do but if you have lots of topics it would take along time to do |
Posted By: ask023
Date Posted: 31 March 2006 at 9:48am
|
Thanks!
Long time is not a problem, but standard method (re-sync all through admin menu) don't res-sync counters
And I try to find ways to troubleshoot the problem...
|
Posted By: WebWiz-Bruce
Date Posted: 31 March 2006 at 12:12pm
| The function in the admin section will only work for the forum index, not for individual topics. |
Posted By: ask023
Date Posted: 31 March 2006 at 1:41pm
|
Thank you!
Not in RC1, but there will be in the next version by using the Topic Admin button.
You mean 8.0 release or 8.x?
 |
Posted By: WebWiz-Bruce
Date Posted: 31 March 2006 at 2:47pm
| This will be in version 8.0 when the full version is released |