Where to go from version 2.1.60809.935

rated by 0 users

Reply

|

Contact

By: JohnnieMiami

Posted: Wed, Dec 26 2007 6:05 PM In reply to

Ok...I think I just hosed myself.  I downloaded Service Pack 3 and installed it as described in the REadme.  However, my current version now reports as 2.1.20423.1.  Did I go backwards somehow?

• Post Points: 20 |

rated by 0 users

Reply

|

Contact

By: Devin L. Ganger

Posted: Thu, Mar 6 2008 2:58 AM In reply to

I just did the same upgrade (from 2.1 SP2) and am getting the same results -- the version number now reports as 2.1.20423.1. However, in my case, SP3 didn't apply cleanly; I got the following errors when running the SQL script (... represents section of the messages I snipped for brevity):

Creating...cs_Schema_Patch_2.1.00
Schema Patch v2.1.0 was already applied on Aug 12 2006  2:16PM
...
Schema Patch v2.1.30 was already applied on Mar  5 2008 11:37PM
Creating...cs_vw_EveryOne_Role
...
Creating...cs_Folder_AddFolder
Msg 137, Level 15, State 2, Procedure cs_Folder_AddFolder, Line 21
Must declare the scalar variable "@UserId".
Msg 15151, Level 16, State 1, Line 2
Cannot find the object 'cs_Folder_AddFolder', because it does not exist or you do not have permission.
Creating...cs_Folder_DeleteFolder
...
Creating...cs_PostCategories_Parents_RebuildIndex
Msg 207, Level 16, State 1, Procedure cs_PostCategories_Parents_RebuildIndex, Line 78
Invalid column name 'UplevelID'.
Msg 15151, Level 16, State 1, Line 2
Cannot find the object 'cs_PostCategories_Parents_RebuildIndex', because it does not exist or you do not have permission.
Creating...cs_PostCategory_CreateUpdateDelete
...
Creating...cs_Roller_GetPosts
Msg 137, Level 15, State 2, Procedure cs_Roller_GetPosts, Line 38
Must declare the scalar variable "@UserId".
Msg 137, Level 15, State 2, Procedure cs_Roller_GetPosts, Line 72
Must declare the scalar variable "@UserId".
Msg 15151, Level 16, State 1, Line 2
Cannot find the object 'cs_Roller_GetPosts', because it does not exist or you do not have permission.
Creating...cs_Roller_GetUnaggregatedFeeds
Msg 137, Level 15, State 2, Procedure cs_Roller_GetUnaggregatedFeeds, Line 22
Must declare the scalar variable "@UserId".
Msg 15151, Level 16, State 1, Line 2
Cannot find the object 'cs_Roller_GetUnaggregatedFeeds', because it does not exist or you do not have permission.
Creating...cs_SearchBarrel_Search
...
Creating...cs_system_DeletePostAndAdoptChildren
Msg 137, Level 15, State 2, Procedure cs_system_DeletePostAndAdoptChildren, Line 55
Must declare the scalar variable "@parentid".
Msg 15151, Level 16, State 1, Line 3
Cannot find the object 'cs_system_DeletePostAndAdoptChildren', because it does not exist or you do not have permission.
Creating...cs_system_DeletePostAndChildren
...
Creating...cs_UserFeed_DeleteFeed
Msg 137, Level 15, State 2, Procedure cs_UserFeed_DeleteFeed, Line 25
Must declare the scalar variable "@FeedID".
Msg 137, Level 15, State 2, Procedure cs_UserFeed_DeleteFeed, Line 27
Must declare the scalar variable "@FeedID".
Msg 15151, Level 16, State 1, Line 2
Cannot find the object 'cs_UserFeed_DeleteFeed', because it does not exist or you do not have permission.
Creating...cs_UserHasPostsAwaitingModeration
...
Creating...spam_GetRecentPostCountFromIP

Are these normal, and if not, what can I do to fix them?

• Post Points: 5 |