YAFLogo

AllenHarkleroad
8 years ago
I've tried several times to upgrade to 2.0 from 1.9.6 and each time I get errors like this.

FILE:

mssql/constraints.sql

ERROR:

The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_yaf_ReputationVote_yaf_User_To". The conflict occurred in database "PoserWorldCommunity", table "dbo.yaf_User", column 'UserID'.

STATEMENT:

if not exists (select top 1 1 from sys.objects where name='FK_yaf_ReputationVote_yaf_User_To' and parent_object_id=object_id('[dbo].[yaf_ReputationVote]') and type in (N'F'))

alter table [dbo].[yaf_ReputationVote] add constraint [FK_yaf_ReputationVote_yaf_User_To] foreign key (ReputationToUserID) references [dbo].[yaf_User](UserID)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: FILE:

mssql/constraints.sql

ERROR:

The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_yaf_ReputationVote_yaf_User_To". The conflict occurred in database "PoserWorldCommunity", table "dbo.yaf_User", column 'UserID'.

STATEMENT:

if not exists (select top 1 1 from sys.objects where name='FK_yaf_ReputationVote_yaf_User_To' and parent_object_id=object_id('[dbo].[yaf_ReputationVote]') and type in (N'F'))

alter table [dbo].[yaf_ReputationVote] add constraint [FK_yaf_ReputationVote_yaf_User_To] foreign key (ReputationToUserID) references [dbo].[yaf_User](UserID)

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[Exception: FILE:

mssql/constraints.sql

ERROR:

The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_yaf_ReputationVote_yaf_User_To". The conflict occurred in database "PoserWorldCommunity", table "dbo.yaf_User", column 'UserID'.

STATEMENT:

if not exists (select top 1 1 from sys.objects where name='FK_yaf_ReputationVote_yaf_User_To' and parent_object_id=object_id('[dbo].[yaf_ReputationVote]') and type in (N'F'))

alter table [dbo].[yaf_ReputationVote] add constraint [FK_yaf_ReputationVote_yaf_User_To] foreign key (ReputationToUserID) references [dbo].[yaf_User](UserID)]

YAF.Classes.Data.LegacyDb.system_initialize_executescripts(String script, String scriptFile, Boolean useTransactions) +602

YAF.Core.Services.InstallUpgradeService.ExecuteScript(String scriptFile, Boolean useTransactions) +259

YAF.Core.Services.InstallUpgradeService.UpgradeDatabase(Boolean fullText, Boolean upgradeExtensions) +122

YAF.Install._default.Wizard_NextButtonClick(Object sender, WizardNavigationEventArgs e) +1329

System.Web.UI.WebControls.Wizard.OnNextButtonClick(WizardNavigationEventArgs e) +115

System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) +413

System.Web.UI.WebControls.WizardChildTable.OnBubbleEvent(Object source, EventArgs args) +19

System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37

System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +125

System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +167

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10

System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13

System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563

Sponsor
sirmaelstrom
8 years ago
I had a similar issue when upgrading - it was due to the fact that new key constraints are violated by data already in your database. Check your PoserWorldCommunity table to see if you have any records for user ids which no longer exist in your system. If this is the case, then the problem is that the database update scripts need to include referential checks for new keys that are being added before they attempt to add the keys and to either just clean up that data or preserve it somewhere else if necessary.

Hope that helps!

AllenHarkleroad
8 years ago
Nor sure how to go about doing what you said...

Originally Posted by: sirmaelstrom 

I had a similar issue when upgrading - it was due to the fact that new key constraints are violated by data already in your database. Check your PoserWorldCommunity table to see if you have any records for user ids which no longer exist in your system. If this is the case, then the problem is that the database update scripts need to include referential checks for new keys that are being added before they attempt to add the keys and to either just clean up that data or preserve it somewhere else if necessary.

Hope that helps!

sirmaelstrom
8 years ago
Sorry .. so in your database "PoserWorldCommunity" you have a yaf_ReputationVote table and a yaf_User table. The sql that is failing to run is creating a constraint saying that the "ReputationToUserID" field in the "RepuationVote" table must line up to a valid user in the "User" table.

So you can run a quick query to see if you have any records in this table that would violate that constraint:

SELECT * FROM dbo.yaf_ReputationVote

WHERE ReputationToUserID NOT IN (SELECT userID FROM dbo.yaf_User)

If you do, those records need to be removed before the constraint can be added to the table so that those sorts of issues with referential integrity will not be allowed by the database.

AllenHarkleroad
8 years ago
I deleted the 5 records and re-checked. The Contraints.sql query still gives errors. With or without it, the forum seems to run properly without any errors in the log.

Msg 102, Level 15, State 1, Line 4

Incorrect syntax near '{'.

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near '{'.

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near '{'.

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near '{'.

Msg 4902, Level 16, State 1, Line 9

Cannot find the object "{databaseOwner}.{objectQualifier}BannedIP" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Buddy" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Category" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}CheckEmail" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Choice" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Forum" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}ForumAccess" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}MessageReported" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Group" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}GroupMedal" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}ForumReadTracking" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}TopicReadTracking" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}UserMedal" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Mail" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}UserProfile" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Message" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}PMessage" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}PollGroupCluster" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Poll" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Smiley" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Topic" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}FavoriteTopic" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}User" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}WatchForum" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}WatchTopic" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}UserGroup" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}Rank" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}NntpServer" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}NntpForum" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}NntpTopic" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}AccessMask" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}UserForum" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}Board" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}Active" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}UserPMessage" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Attachment" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Active" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}PollVote" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}IgnoreUser" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}ShoutboxMessage" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Thanks" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}MessageHistory" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}ActiveAccess" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}ReputationVote" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}AdminPageUserAccess" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}EventLogGroupAccess" because it does not exist or you do not have permissions.

Msg 102, Level 15, State 1, Line 7

Incorrect syntax near '{'.

Msg 102, Level 15, State 1, Line 4

Incorrect syntax near '{'.

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near '{'.

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near '{'.

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near '{'.

Msg 102, Level 15, State 1, Line 4

Incorrect syntax near '{'.

Msg 102, Level 15, State 1, Line 4

Incorrect syntax near '{'.

Msg 102, Level 15, State 1, Line 4

Incorrect syntax near '{'.

Msg 102, Level 15, State 1, Line 4

Incorrect syntax near '{'.

Msg 102, Level 15, State 1, Line 4

Incorrect syntax near '{'.

Msg 102, Level 15, State 1, Line 4

Incorrect syntax near '{'.

Msg 102, Level 15, State 1, Line 4

Incorrect syntax near '{'.

Msg 102, Level 15, State 1, Line 4

Incorrect syntax near '{'.

Msg 102, Level 15, State 1, Line 9

Incorrect syntax near '{'.

Msg 102, Level 15, State 1, Line 4

Incorrect syntax near '{'.

Msg 102, Level 15, State 1, Line 4

Incorrect syntax near '{'.

Msg 102, Level 15, State 1, Line 4

Incorrect syntax near '{'.

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near '{'.

Msg 4902, Level 16, State 1, Line 8

Cannot find the object "{databaseOwner}.{objectQualifier}Active" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}Active" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}Active" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}CheckEmail" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}Choice" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}FavoriteTopic" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}FavoriteTopic" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}UserProfile" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Forum" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}Forum" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}Forum" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}Forum" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}ForumAccess" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}ForumAccess" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}Message" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}Message" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}PMessage" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}Topic" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}Topic" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Topic" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}Topic" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}Topic" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}WatchForum" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}WatchForum" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}WatchTopic" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}WatchTopic" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}Attachment" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}UserGroup" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}UserGroup" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}Attachment" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}NntpForum" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}NntpForum" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}NntpTopic" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}NntpTopic" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}ForumAccess" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}UserAlbumImage" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}UserForum" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}UserForum" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}UserForum" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}Category" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}AccessMask" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}Active" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}BannedIP" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}Group" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 9

Cannot find the object "{databaseOwner}.{objectQualifier}GroupMedal" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}GroupMedal" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}UserMedal" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}UserMedal" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}UserProfile" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}MessageReportedAudit" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}NntpServer" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}Rank" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}Smiley" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}User" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 4

Cannot find the object "{databaseOwner}.{objectQualifier}User" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Forum" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Message" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}UserPMessage" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}UserPMessage" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Registry" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}PollVote" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Poll" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Topic" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Extension" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}BBCode" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Buddy" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Thanks" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}MessageHistory" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}ForumReadTracking" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}TopicReadTracking" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}TopicReadTracking" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}ReputationVote" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}ReputationVote" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}AdminPageUserAccess" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}EventLogGroupAccess" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Message" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Rank" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Group" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}User" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}EventLog" because it does not exist or you do not have permissions.

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near '}'.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}ActiveAccess" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}EventLog" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}Extension" because it does not exist or you do not have permissions.

Msg 4902, Level 16, State 1, Line 3

Cannot find the object "{databaseOwner}.{objectQualifier}ActiveAccess" because it does not exist or you do not have permissions.

Msg 102, Level 15, State 1, Line 8

Incorrect syntax near '>'.

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near '>'.

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near '>'.

AllenHarkleroad
8 years ago
However, if I run the upgrade / install via the web browser rather than a straight query it completes properly now.

So I guess this issue is solved.

Allen

sirmaelstrom
8 years ago
Indeed, after clearing out those records you should then be able to run the install/upgrade scripts properly which should get your database into the correct state for the new version.

Cheers!

AllenHarkleroad
8 years ago
Yes that worked. Thanks for the quick help. ;-)

Allen

Originally Posted by: sirmaelstrom 

Indeed, after clearing out those records you should then be able to run the install/upgrade scripts properly which should get your database into the correct state for the new version.

Cheers!

tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.3
8 years ago
In YAF 2.1 this issue is fixed, when deleting a user the reputationtouserid will be correctly deleted to prevent this issue.
AllenHarkleroad
8 years ago
Cool and thanks.