8.0 RC1: re-sync problem?

Post Reply

Page 12 >

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
ask023 Members Profile Find Members Posts Groupie Joined: 16 February 2003 Status: Offline Points: 130	Post Options Post Reply Quote ask023 Report Post Thanks(0) Quote Reply Topic: 8.0 RC1: re-sync problem? 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! Edited by ask023 - 26 March 2006 at 7:30pm

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.

ask023 Members Profile Find Members Posts Groupie Joined: 16 February 2003 Status: Offline Points: 130	Post Options Post Reply Quote ask023 Report Post Thanks(0) Quote Reply 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!

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 28 March 2006 at 10:48am
	Not in RC1, but there will be in the next version by using the Topic Admin button.

ask023 Members Profile Find Members Posts Groupie Joined: 16 February 2003 Status: Offline Points: 130	Post Options Post Reply Quote ask023 Report Post Thanks(0) Quote Reply 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! Edited by ask023 - 30 March 2006 at 3:41pm

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 31 March 2006 at 8:52am
	You could do but if you have lots of topics it would take along time to do

ask023 Members Profile Find Members Posts Groupie Joined: 16 February 2003 Status: Offline Points: 130	Post Options Post Reply Quote ask023 Report Post Thanks(0) Quote Reply 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...

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 31 March 2006 at 12:12pm
	The function in the admin section will only work for the forum index, not for individual topics.

Post Reply	Page 12 >

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum