Resync tool

Post Reply

Page <1 23

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
javi712 Members Profile Find Members Posts Senior Member Joined: 22 May 2003 Location: United States Status: Offline Points: 488	Post Options Post Reply Quote javi712 Report Post Thanks(0) Quote Reply Posted: 26 July 2007 at 6:43pm
	Nick, I have the same configuration as you on my DB where it is not the same as what is on the mssql server setup file. I did however go back and change all the smalldatetime data types to just datatime and now I'm able to synch and batch delete and move threads. Borg, I'm still getting duplicate topics though even after synching the forum. the weird thing is that from the admin section, I only see one forum topic, but once i'm on the forums, i can see both.

javi712 Members Profile Find Members Posts Senior Member Joined: 22 May 2003 Location: United States Status: Offline Points: 488	Post Options Post Reply Quote javi712 Report Post Thanks(0) Quote Reply Posted: 26 July 2007 at 7:23pm
	Nevermind, I found a workaround. I just created a new forum with a different name, moved all the topics to the new forum, deleted the old forum and renamed the new forum. That seems to have worked. (Hopefully!)

Nick-V Members Profile Find Members Posts Senior Member Joined: 26 October 2002 Location: United Kingdom Status: Offline Points: 319	Post Options Post Reply Quote Nick-V Report Post Thanks(0) Quote Reply Posted: 07 August 2007 at 9:52am
	Borg, I held off on this topic because you have probably been very busy recently. When you get some space would you please consider the database issues I listed in my posting dated 26 July 2007 at 3:41pm. I actually started on V6 not 7 as stated...I thought it would be useful to identify differences in the database now (thru upgrades) versus what you intend (thru the install) - some of these look important... ...it would be good to have a list of the "approved" differences so that others can make appropriate corrections.

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: 07 August 2007 at 10:07am
	All database changes are listed in the version history file, the field name, data type, and if they have a default value. You can also look in the database setup file for the database type you are using and see all the tables, fields, data types, etc.
	Web Wiz Forums Hosting ASP.NET Web Hosting

Nick-V Members Profile Find Members Posts Senior Member Joined: 26 October 2002 Location: United Kingdom Status: Offline Points: 319	Post Options Post Reply Quote Nick-V Report Post Thanks(0) Quote Reply Posted: 07 August 2007 at 10:16am
	As you can see I have gone thru the files in some detail to identify potential problems. The upgrades have not kept the database consistent with the latest database setup file (and there may be other issues too). If you don't want to review these discrepencies then at least there is a record here for when other users encounter an issue...

Post Reply	Page <1 23

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