Forums (Obsolete)

Old Forums

Installation and deployment

Version 7.x > Installation and deployment > SQL Errors Upgrade from v6 - v7

View modes:

Member

Peter - 1/3/2013 10:21:02 PM

SQL Errors Upgrade from v6 - v7

Hi,
we are having some troubles with the update . Currently on version 6, upgrading to version 7.

It seems to me there are some columns missing.

Any ideas?

-->
(74 row(s) affected)
Msg 207, Level 16, State 1, Line 41
Invalid column name 'UserPosition'.

(0 row(s) affected)
Msg 207, Level 16, State 1, Procedure View_CMS_User, Line 3
Invalid column name 'UserPosition'.
Msg 207, Level 16, State 1, Procedure View_CMS_User, Line 3
Invalid column name 'UserWebPartToolbarEnabled'.
Msg 207, Level 16, State 1, Procedure View_CMS_User, Line 3
Invalid column name 'UserWebPartToolbarPosition'.
Msg 207, Level 16, State 1, Procedure View_CMS_User, Line 3
Invalid column name 'UserInvalidLogOnAttempts'.
Msg 207, Level 16, State 1, Procedure View_CMS_User, Line 3
Invalid column name 'UserInvalidLogOnAttemptsHash'.
Msg 207, Level 16, State 1, Procedure View_CMS_User, Line 3
Invalid column name 'UserAvatarType'.
Msg 207, Level 16, State 1, Procedure View_CMS_User, Line 3
Invalid column name 'UserAccountLockReason'.
Msg 207, Level 16, State 1, Procedure View_CMS_User, Line 3
Invalid column name 'UserPasswordLastChanged'.
Msg 207, Level 16, State 1, Procedure View_Community_Member, Line 3
Invalid column name 'UserPosition'.
Msg 207, Level 16, State 1, Procedure View_Community_Member, Line 3
Invalid column name 'UserWebPartToolbarEnabled'.
Msg 207, Level 16, State 1, Procedure View_Community_Member, Line 3
Invalid column name 'UserWebPartToolbarPosition'.
Msg 207, Level 16, State 1, Procedure View_Community_Member, Line 3
Invalid column name 'UserInvalidLogOnAttempts'.
Msg 207, Level 16, State 1, Procedure View_Community_Member, Line 3
Invalid column name 'UserInvalidLogOnAttemptsHash'.
Msg 207, Level 16, State 1, Procedure View_Community_Member, Line 3
Invalid column name 'UserAvatarType'.
Msg 207, Level 16, State 1, Procedure View_Community_Member, Line 3
Invalid column name 'UserAccountLockReason'.
Msg 207, Level 16, State 1, Procedure View_Community_Member, Line 3
Invalid column name 'UserPasswordLastChanged'.
Msg 207, Level 16, State 1, Procedure View_Messaging_ContactList, Line 6
Invalid column name 'UserAccountLockReason'.


Kentico Support	kentico_jurajo - 1/4/2013 1:07:04 AM RE:SQL Errors Upgrade from v6 - v7 Hi, Are you sure you are upgrading version 6 database? Were there any previous upgrades? The UserPosition column was introduced in version 5.5R2. So, one option is that you are upgrading v5.5 database or, second option is that the upgrade from 5.5 to 5.5R2 was not OK. Best regards, Juraj Ondrus

Top