Web Wiz Support and Community Forums : Updating up to version 8.0 bug https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 00:09:38 +0000 Thu, 23 Mar 2006 10:45:07 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=18825 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Updating up to version 8.0 bug : Cool, thanks for letting me know ...]]> https://forums.webwiz.net/updating-up-to-version-8-0-bug_topic18825_post102132.html#102132 Author: WebWiz-Bruce
Subject: 18825
Posted: 23 March 2006 at 10:45am

Cool, thanks for letting me know]]> Thu, 23 Mar 2006 10:45:07 +0000 https://forums.webwiz.net/updating-up-to-version-8-0-bug_topic18825_post102132.html#102132 <![CDATA[Updating up to version 8.0 bug : Many thanks! All works! ]]> https://forums.webwiz.net/updating-up-to-version-8-0-bug_topic18825_post102075.html#102075 Author: Ritchie
Subject: 18825
Posted: 22 March 2006 at 7:00pm

Many thanks! All works!Thumbs Up

]]> Wed, 22 Mar 2006 19:00:39 +0000 https://forums.webwiz.net/updating-up-to-version-8-0-bug_topic18825_post102075.html#102075 <![CDATA[Updating up to version 8.0 bug : I have updated the upgrade tool...]]> https://forums.webwiz.net/updating-up-to-version-8-0-bug_topic18825_post101986.html#101986 Author: WebWiz-Bruce
Subject: 18825
Posted: 22 March 2006 at 11:17am

I have updated the upgrade tool with the corrections to it to hopefully fix this problem.]]> Wed, 22 Mar 2006 11:17:29 +0000 https://forums.webwiz.net/updating-up-to-version-8-0-bug_topic18825_post101986.html#101986 <![CDATA[Updating up to version 8.0 bug : I see the problem, the SQL query...]]> https://forums.webwiz.net/updating-up-to-version-8-0-bug_topic18825_post101985.html#101985 Author: WebWiz-Bruce
Subject: 18825
Posted: 22 March 2006 at 11:14am

I see the problem, the SQL query in the beta upgrade tool should be:-

strSQL = "SELECT " & strDbTable & "Permissions.Group_ID " & _
     "FROM " & strDbTable & "Permissions " & _
     "WHERE" & strDbTable & "Permissions.Group_ID = " &CLng(iaryGroupID(0,lngPermissionsLoopCounter)) & " " & _
      "AND " & strDbTable & "Permissions.Forum_ID = " & CLng(iarryForumID(0,intForumLoopCounter)) & ";"

I'll make the corrections to the upgrade tool
]]> Wed, 22 Mar 2006 11:14:04 +0000 https://forums.webwiz.net/updating-up-to-version-8-0-bug_topic18825_post101985.html#101985 <![CDATA[Updating up to version 8.0 bug : I used version MSSQL 7.96. Tested...]]> https://forums.webwiz.net/updating-up-to-version-8-0-bug_topic18825_post101976.html#101976 Author: Ritchie
Subject: 18825
Posted: 22 March 2006 at 7:59am

I used version MSSQL 7.96. Tested on a local computer, therefore the link I can not give. A problem that the following code adds in the table tblPermission data who are duplicated.

   'Loop through each forum
   Do While intForumLoopCounter <= Ubound(iarryForumID,2)
   
    'Reset permissions loop counter
    lngPermissionsLoopCounter = 0
   
    'Loop through topics and to populate the topics table
    Do While lngPermissionsLoopCounter <= Ubound(iaryGroupID,2)
    
     'Get the gorup ID
    
     'See if a record exists for this group in the permissions table
     strSQL = "SELECT " & strDbTable & "Permissions.Group_ID " & _
     "FROM " & strDbTable & "Permissions " & _
     "WHERE " & strDbTable & "Permissions.Group_ID = " & CLng(iaryGroupID(0,lngPermissionsLoopCounter)) & " " & _
      "AND " & strDbTable & "Permissions.Group_ID = " & CLng(iarryForumID(0,intForumLoopCounter)) & ";"
     
     'Query the database
     rsCommon.Open strSQL, adoCon
     
     'If no record is returned insert a new record in the database
     If rsCommon.EOF Then
     
      blnRead = strDBTrue
      If CLng(iaryGroupID(0,lngPermissionsLoopCounter)) = 2 Then blnPost = strDBFalse Else blnPost = strDBTrue 'not guest
      If CLng(iaryGroupID(0,lngPermissionsLoopCounter)) = 2 Then blnReply = strDBFalse Else blnReply = strDBTrue 'not guest
      If CLng(iaryGroupID(0,lngPermissionsLoopCounter)) = 2 Then blnEdit = strDBFalse Else blnEdit = strDBTrue 'not guest
      If CLng(iaryGroupID(0,lngPermissionsLoopCounter)) = 2 Then blnDelete = strDBFalse Else blnDelete = strDBTrue 'not guest
      If CLng(iaryGroupID(0,lngPermissionsLoopCounter)) = 1 Then blnPriority = strDBTrue Else blnPriority = strDBFalse 'Admin only
      blnPollCreate = strDBFalse
      blnVote = strDBFalse
      blnAttachments = strDBFalse
      blnImageUpload = strDBFalse
      blnCheckFirst = strDBFalse
      blnEvents = strDBFalse
      blnModerator = strDBFalse
      
      'Insert values into database
      strSQL = "INSERT INTO [" & strDbTable & "Permissions] ( "
      strSQL = strSQL & "[Group_ID], "
      strSQL = strSQL & "[Forum_ID], "
      strSQL = strSQL & "[View_Forum], "
      strSQL = strSQL & "[Post], "
      strSQL = strSQL & "[Reply_posts], "
      strSQL = strSQL & "[Edit_posts], "
      strSQL = strSQL & "[Delete_posts], "
      strSQL = strSQL & "[Priority_posts], "
      strSQL = strSQL & "[Poll_create], "
      strSQL = strSQL & "[Vote], "
      strSQL = strSQL & "[Attachments], "
      strSQL = strSQL & "[Image_upload], "
      strSQL = strSQL & "[Moderate]"
      strSQL = strSQL & ") VALUES ("
      strSQL = strSQL & CLng(iaryGroupID(0,lngPermissionsLoopCounter)) & ", "   
      strSQL = strSQL & CLng(iarryForumID(0,intForumLoopCounter)) & ","
      strSQL = strSQL & blnRead & ","
      strSQL = strSQL & blnPost & ","
      strSQL = strSQL & blnReply & ","
      strSQL = strSQL & blnEdit & ","
      strSQL = strSQL & blnDelete & ","
      strSQL = strSQL & blnPriority & ","
      strSQL = strSQL & blnPollCreate & ","
      strSQL = strSQL & blnVote & ","
      strSQL = strSQL & blnAttachments & ","
      strSQL = strSQL & blnImageUpload & ","
      strSQL = strSQL & blnModerator & ")"
      
      'Write to the database
      adoCon.Execute(strSQL)
     End If
     
     'Close recordset
     rsCommon.Close
    
     'Move to next record
     lngPermissionsLoopCounter = lngPermissionsLoopCounter + 1
    Loop
    
    'Move to the next record
                   intForumLoopCounter = intForumLoopCounter + 1
   Loop
  End If 
 
 
Accordingly the inquiry in lines default.asp 138-144 files superfluous data.
 
 
 
 
The code in lines of a file msSQL_server_update.asp works incorrectly. After performance of updating the total of records tblPermission in my database became 749. Before their updating there was 584!
 
 
 
 
 
 


Edited by Ritchie - 22 March 2006 at 8:12am]]> Wed, 22 Mar 2006 07:59:45 +0000 https://forums.webwiz.net/updating-up-to-version-8-0-bug_topic18825_post101976.html#101976 <![CDATA[Updating up to version 8.0 bug : You have not mentioned what database...]]> https://forums.webwiz.net/updating-up-to-version-8-0-bug_topic18825_post101874.html#101874 Author: WebWiz-Bruce
Subject: 18825
Posted: 21 March 2006 at 1:48pm

You have not mentioned what database version you are using?

Also, are the number of forums correct, a sit looks like you have picked up extra forums from somewhere.

Another trick is to try posting in some of the forums and see if that corrects the forum statistics.

Do you have a URL to this so that I can have a look?
]]> Tue, 21 Mar 2006 13:48:23 +0000 https://forums.webwiz.net/updating-up-to-version-8-0-bug_topic18825_post101874.html#101874 <![CDATA[Updating up to version 8.0 bug : Greetings, Borg! After updating...]]> https://forums.webwiz.net/updating-up-to-version-8-0-bug_topic18825_post101872.html#101872 Author: Ritchie
Subject: 18825
Posted: 21 March 2006 at 1:43pm

Greetings, Borg! After updating a database of a forum from version 7.96 to version 8.0 has found out a mistake. The statistics of a forum is incorrectly displayed:
 
Was before updating:
 
Posts:188449
Topics: 15309
Forums: 19
 
 
 
Became after updating:
 
Posts:367013
Topics: 30144
Forums: 33
 
]]> Tue, 21 Mar 2006 13:43:42 +0000 https://forums.webwiz.net/updating-up-to-version-8-0-bug_topic18825_post101872.html#101872