Web Wiz Support and Community Forums : Resync tool

Web Wiz Support and Community Forums : Resync tool https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 00:52:01 +0000 Tue, 07 Aug 2007 10:16:54 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=23905 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Resync tool : As you can see I have gone thru...]]> https://forums.webwiz.net/resync-tool_topic23905_post126169.html#126169 Author: Nick-V
Subject: 23905
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...

]]> Tue, 07 Aug 2007 10:16:54 +0000 https://forums.webwiz.net/resync-tool_topic23905_post126169.html#126169 <![CDATA[Resync tool : All database changes are listed...]]> https://forums.webwiz.net/resync-tool_topic23905_post126168.html#126168 Author: WebWiz-Bruce
Subject: 23905
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.
]]> Tue, 07 Aug 2007 10:07:21 +0000 https://forums.webwiz.net/resync-tool_topic23905_post126168.html#126168 <![CDATA[Resync tool : Borg, I held off on this topic...]]> https://forums.webwiz.net/resync-tool_topic23905_post126166.html#126166 Author: Nick-V
Subject: 23905
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.

]]> Tue, 07 Aug 2007 09:52:13 +0000 https://forums.webwiz.net/resync-tool_topic23905_post126166.html#126166 <![CDATA[Resync tool : Nevermind, I found a workaround....]]> https://forums.webwiz.net/resync-tool_topic23905_post125552.html#125552 Author: javi712
Subject: 23905
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!)]]> Thu, 26 Jul 2007 19:23:19 +0000 https://forums.webwiz.net/resync-tool_topic23905_post125552.html#125552 <![CDATA[Resync tool : Nick, I have the same configuration...]]> https://forums.webwiz.net/resync-tool_topic23905_post125546.html#125546 Author: javi712
Subject: 23905
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.]]> Thu, 26 Jul 2007 18:43:48 +0000 https://forums.webwiz.net/resync-tool_topic23905_post125546.html#125546 <![CDATA[Resync tool : Borg, please clarify: This...]]> https://forums.webwiz.net/resync-tool_topic23905_post125516.html#125516 Author: Nick-V
Subject: 23905
Posted: 26 July 2007 at 3:41pm

Borg, please clarify:

This post got longer than I first thought but might serve as a useful list of how an old database now differs from a new one...

1) In my database (upgraded from 7 to 8 then 8 to 9) the following fields are 'bit' whereas in msSQL_server_setup.asp they are defined in a new database as 'smallint'. Is the upgrade correct or the msSQL_server_setup.asp?

tblConfiguration

A_code

NewsPad

2) The following field is ntext whereas in msSQL_server_setup.asp it is nvarchar(255):

tblAuthor

Signature

3) The following field is nvarchar(50) whereas in msSQL_server_setup.asp it is nvarchar(100):

tblConfiguration

NewsPad_URL

4) The following field does not allow NULL whereas in msSQL_server_setup.asp it does:

tblConfiguration

PM_Flood

5) The following field is nvarchar(70) whereas in msSQL_server_setup.asp it is nvarchar(90):

tblPoll

Poll_question

6) The following field is nvarchar(70) whereas in msSQL_server_setup.asp it is nvarchar(80):

tblPollChoice

Choice

7) In msSQL_server_setup.asp, replace the comment 'Create the Thread Table' with 'Create the Session Table'.

8) In msSQL_server_setup.asp, shouldn't all PRIMARY indexes be created as UNIQUE (they probably are anyway). The reason I am checking indexes is that there seem to be duplicates, the Primary indexes you created on the ID and auto-named indexes probably created by SQL Server.

9) Are both of these indexes necessary (also CAT_ID). I'm not sure the relationships need the key defined twice:

strSQL = "CREATE INDEX [Group_ID] ON [" & strDBO & "].[" & strDbTable & "Author]([Group_ID]) ON [PRIMARY]"

strSQL = "CREATE INDEX [" & strDbTable & "Group" & strDbTable & "Author] ON [" & strDBO & "].[" & strDbTable & "Author]([Group_ID]) ON [PRIMARY]"

10) The following indexes were missing (not added in upgrades?):

strSQL = "CREATE INDEX [Sub_ID] ON [" & strDBO & "].[" & strDbTable & "Forum]([Sub_ID]) ON [PRIMARY]"

strSQL = "CREATE INDEX [Moved_ID] ON [" & strDBO & "].[" & strDbTable & "Topic]([Moved_ID]) ON [PRIMARY]"

11) Are the names of these two indexes reversed deliberately:

strSQL = "CREATE INDEX [Author_ID] ON [" & strDBO & "].[" & strDbTable & "BuddyList]([Buddy_ID]) ON [PRIMARY]"

strSQL = "CREATE INDEX [Buddy_ID] ON [" & strDBO & "].[" & strDbTable & "BuddyList]([Author_ID]) ON [PRIMARY]"

12) tblPermissions does not appear to have a primary key, neither does tblPollVote - is this OK?

13) Some Primary Keys are not right. I'm not an SQL expert but should "ON [PRIMARY]" be included against all key definitions in msSQL_server_setup.asp?

The primary key of Configuration is website_name - should it be ID.

The primary key of DateTimeFormat is date_format - should it be ID.

14) The following field is indexed whereas in msSQL_server_setup.asp it is not:

tblForum

Forum_code

15) The following field has a default of (null) whereas in msSQL_server_setup.asp it does not:

tblAuthor

Author_email

16) tblConfiguration and tblDateTimeFormat have constraints (defaults) where the same tables in the V9 database have none.

17) In addition to 16), the following fields in the old database have constraints (defaults) where the same fields in the V9 database have none:

tblForum

Last_post_date

tblPermissions

Calendar_event

Display_post

View_Forum

18) In addition to 16) and 17), the following fields in the V9 database have constraints (defaults) where the same fields in the old database have none:

tblTopic

Poll_ID

19) tblPollVote has no indexes (in V9 and old database) - does this degrade performance when checking if a member has voted?

20) tblSmut is only indexed on ID and not keyword (in V9 and old database). Perhaps this table is held in memory so it doesn't matter.

21) I read a recent post that the following field should have a default of 1 instead of 0 as defined in msSQL_server_setup.asp:

tblAuthor

Newsletter

Edited by Nick-V - 31 July 2007 at 10:57am]]> Thu, 26 Jul 2007 15:41:40 +0000 https://forums.webwiz.net/resync-tool_topic23905_post125516.html#125516 <![CDATA[Resync tool : Those fields listed by nick-V...]]> https://forums.webwiz.net/resync-tool_topic23905_post125511.html#125511 Author: WebWiz-Bruce
Subject: 23905
Posted: 26 July 2007 at 3:15pm

Those fields listed by nick-V should actually be smallint as they contain very low numbers.

Changing these to int won't have much effect, but a smallint is used as it is the correct datatype for small numbers under 32,000 (or there abouts)

If you have a look in the msSQL_server_setup.asp file you can see all the fields listed in the code and their correct datatypes.

Edited by -boRg- - 26 July 2007 at 3:16pm]]> Thu, 26 Jul 2007 15:15:04 +0000 https://forums.webwiz.net/resync-tool_topic23905_post125511.html#125511 <![CDATA[Resync tool : Thanks Nick! It may seem that...]]> https://forums.webwiz.net/resync-tool_topic23905_post125509.html#125509 Author: javi712
Subject: 23905
Posted: 26 July 2007 at 2:49pm

Thanks Nick!

It may seem that none of those fields require the larger int, but they shouldn't be using the smallint either though. I'll keep poking around my db and see what else needs changing. Thanks for the info!]]> Thu, 26 Jul 2007 14:49:35 +0000 https://forums.webwiz.net/resync-tool_topic23905_post125509.html#125509 <![CDATA[Resync tool : EDIT: DO NOT MAKE THESE CHANGES...]]> https://forums.webwiz.net/resync-tool_topic23905_post125507.html#125507 Author: Nick-V
Subject: 23905
Posted: 26 July 2007 at 2:29pm

EDIT: DO NOT MAKE THESE CHANGES - See Borg's reply below, Nick-V.

I first started on version 7 and went through an automated upgrade to version 8 then version 9. The "small" fields in my SQL Server database (now changed) are:

tblForum

Last_post_author_ID (discussed above)

tblAuthor

Time_offset_hours

tblCategory

Cat_ID - this modified other tables on edit

Cat_order

tblConfiguration

Topics_per_page

Hot_views

Hot_replies

No_of_priavte_msg

Threads_per_page

Spam_seconds

Spam_minutes

Vote_choices

Upload_img_size

Upload_files_size

Upload_avatar_size

PM_Flood

Upload_allocation

tblDateTimeFormat

Time_format

Time_offset_hours

tblForum

Forum_Order

Show_topics

Sub_ID

tblTopic

Priority

All of these fields were smallInt and there were no smallDateTime fields present.

It seems to me that none of these fields urgently requires the larger Int field so I don't think there is an immediate issue here.

Edited by Nick-V - 26 July 2007 at 3:29pm]]> Thu, 26 Jul 2007 14:29:16 +0000 https://forums.webwiz.net/resync-tool_topic23905_post125507.html#125507 <![CDATA[Resync tool : I'll change those back to...]]> https://forums.webwiz.net/resync-tool_topic23905_post125504.html#125504 Author: javi712
Subject: 23905
Posted: 26 July 2007 at 1:13pm

I'll change those back to just datetime and repor back. Thanks for pointing me in the right direction!]]> Thu, 26 Jul 2007 13:13:51 +0000 https://forums.webwiz.net/resync-tool_topic23905_post125504.html#125504