Database setup script errors

Apr 9, 2009 at 3:06 PM
Hello,

I'm trying to setup Oxite on my local from source and I got a few errors when I ran the setup database scripts.

1. I ran Setup/Oxite.sql and it went well

2. I got a lot of errors when I try running "Oxite-Update-2009.01.05-to-2009.02.15.sql"

Dropping foreign keys from [dbo].[oxite_CommentMessageRelationship]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.oxite_CommentMessageRelationship" because it does not exist or you do not have permissions.


(1 row(s) affected)
Dropping foreign keys from [dbo].[oxite_CommentRelationship]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.oxite_CommentRelationship" because it does not exist or you do not have permissions.

(1 row(s) affected)
Dropping foreign keys from [dbo].[oxite_MessageTo]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.oxite_MessageTo" because it does not exist or you do not have permissions.

(1 row(s) affected)
Dropping foreign keys from [dbo].[oxite_Message]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.oxite_Message" because it does not exist or you do not have permissions.

(1 row(s) affected)
Dropping foreign keys from [dbo].[oxite_MessageToAnonymous]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.oxite_MessageToAnonymous" because it does not exist or you do not have permissions.

(1 row(s) affected)
Dropping constraints from [dbo].[oxite_BackgroundServiceAction]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.oxite_BackgroundServiceAction" because it does not exist or you do not have permissions.

(1 row(s) affected)
Dropping constraints from [dbo].[oxite_BackgroundServiceAction]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.oxite_BackgroundServiceAction" because it does not exist or you do not have permissions.

(1 row(s) affected)
Dropping constraints from [dbo].[oxite_BackgroundServiceAction]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.oxite_BackgroundServiceAction" because it does not exist or you do not have permissions.

(1 row(s) affected)
Dropping constraints from [dbo].[oxite_BackgroundServiceAction]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.oxite_BackgroundServiceAction" because it does not exist or you do not have permissions.

(1 row(s) affected)
Dropping constraints from [dbo].[oxite_CommentMessageRelationship]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.oxite_CommentMessageRelationship" because it does not exist or you do not have permissions.

(1 row(s) affected)
Dropping constraints from [dbo].[oxite_CommentRelationship]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.oxite_CommentRelationship" because it does not exist or you do not have permissions.

(1 row(s) affected)
Dropping constraints from [dbo].[oxite_Message]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.oxite_Message" because it does not exist or you do not have permissions.

(1 row(s) affected)
Dropping constraints from [dbo].[oxite_Message]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.oxite_Message" because it does not exist or you do not have permissions.

(1 row(s) affected)
Dropping constraints from [dbo].[oxite_Message]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.oxite_Message" because it does not exist or you do not have permissions.

(1 row(s) affected)
Dropping constraints from [dbo].[oxite_MessageTo]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.oxite_MessageTo" because it does not exist or you do not have permissions.

(1 row(s) affected)
Dropping constraints from [dbo].[oxite_MessageToAnonymous]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.oxite_MessageToAnonymous" because it does not exist or you do not have permissions.

(1 row(s) affected)
Dropping [dbo].[oxite_MessageToAnonymous]
Msg 3701, Level 11, State 5, Line 1
Cannot drop the table 'dbo.oxite_MessageToAnonymous', because it does not exist or you do not have permission.

(1 row(s) affected)
Dropping [dbo].[oxite_MessageTo]
Msg 3701, Level 11, State 5, Line 1
Cannot drop the table 'dbo.oxite_MessageTo', because it does not exist or you do not have permission.

(1 row(s) affected)
Dropping [dbo].[oxite_CommentRelationship]
Msg 3701, Level 11, State 5, Line 1
Cannot drop the table 'dbo.oxite_CommentRelationship', because it does not exist or you do not have permission.

(1 row(s) affected)
Dropping [dbo].[oxite_CommentMessageRelationship]
Msg 3701, Level 11, State 5, Line 1
Cannot drop the table 'dbo.oxite_CommentMessageRelationship', because it does not exist or you do not have permission.

(1 row(s) affected)
Dropping [dbo].[oxite_BackgroundServiceAction]
Msg 3701, Level 11, State 5, Line 1
Cannot drop the table 'dbo.oxite_BackgroundServiceAction', because it does not exist or you do not have permission.

(1 row(s) affected)
Dropping [dbo].[oxite_Message]
Msg 3701, Level 11, State 5, Line 1
Cannot drop the table 'dbo.oxite_Message', because it does not exist or you do not have permission.
Creating [dbo].[oxite_Site]
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'oxite_Site' in the database.

(1 row(s) affected)
Creating primary key [PK_oxite_Site] on [dbo].[oxite_Site]
Msg 1779, Level 16, State 0, Line 1
Table 'oxite_Site' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.

(1 row(s) affected)
Msg 515, Level 16, State 2, Line 10
Cannot insert the value NULL into column 'SiteID', table 'Oxite.Database.dbo.oxite_Site'; column does not allow nulls. INSERT fails.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'CommentingDisabled' in table 'dbo.oxite_Post' is specified more than once.

(1 row(s) affected)
Creating index [IX_oxite_Post] on [dbo].[oxite_Post]
Msg 1913, Level 16, State 1, Line 1
The operation failed because an index or statistics with name 'IX_oxite_Post' already exists on table 'dbo.oxite_Post'.

(1 row(s) affected)
Altering [dbo].[oxite_Area]
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'CommentingDisabled' in table 'dbo.oxite_Area' is specified more than once.

(1 row(s) affected)
Msg 4924, Level 16, State 1, Line 1
ALTER TABLE DROP COLUMN failed because column 'Type' does not exist in table 'oxite_Area'.

(1 row(s) affected)
Creating index [IX_oxite_Area] on [dbo].[oxite_Area]
Msg 1913, Level 16, State 1, Line 1
The operation failed because an index or statistics with name 'IX_oxite_Area' already exists on table 'dbo.oxite_Area'.

(1 row(s) affected)
Altering [dbo].[oxite_Comment]
Msg 4924, Level 16, State 1, Line 1
ALTER TABLE DROP COLUMN failed because column 'PublishedDate' does not exist in table 'oxite_Comment'.

(1 row(s) affected)
Creating [dbo].[oxite_Plugin]
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'oxite_Plugin' in the database.

(1 row(s) affected)
Creating primary key [PK_oxite_Plugin] on [dbo].[oxite_Plugin]
Msg 1779, Level 16, State 0, Line 1
Table 'oxite_Plugin' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.

(1 row(s) affected)
Creating [dbo].[oxite_PluginSetting]
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'oxite_PluginSetting' in the database.

(1 row(s) affected)
Creating primary key [PK_oxite_PluginSetting] on [dbo].[oxite_PluginSetting]
Msg 1779, Level 16, State 0, Line 1
Table 'oxite_PluginSetting' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.

(1 row(s) affected)
Altering [dbo].[oxite_PostTagRelationship]
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'TagDisplayName' in table 'dbo.oxite_PostTagRelationship' is specified more than once.

(1 row(s) affected)
Creating [dbo].[oxite_SiteRedirect]
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'oxite_SiteRedirect' in the database.

(1 row(s) affected)
Creating primary key [PK_oxite_SiteRedirect] on [dbo].[oxite_SiteRedirect]
Msg 1779, Level 16, State 0, Line 1
Table 'oxite_SiteRedirect' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.

(1 row(s) affected)
Creating [dbo].[oxite_MessageOutbound]
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'oxite_MessageOutbound' in the database.

(1 row(s) affected)
Creating primary key [PK_oxite_MessageOutbound] on [dbo].[oxite_MessageOutbound]
Msg 1779, Level 16, State 0, Line 1
Table 'oxite_MessageOutbound' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.

(1 row(s) affected)
Creating [dbo].[oxite_TrackbackOutbound]
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'oxite_TrackbackOutbound' in the database.

(1 row(s) affected)
Creating primary key [PK_oxite_TrackbackOutbound] on [dbo].[oxite_TrackbackOutbound]
Msg 1779, Level 16, State 0, Line 1
Table 'oxite_TrackbackOutbound' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.

(1 row(s) affected)
Adding foreign keys to [dbo].[oxite_Area]
Msg 2714, Level 16, State 4, Line 1
There is already an object named 'FK_oxite_Area_oxite_Site' in the database.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.

(1 row(s) affected)
Adding foreign keys to [dbo].[oxite_PostRelationship]
Msg 2714, Level 16, State 4, Line 1
There is already an object named 'FK_oxite_PostRelationship_oxite_Site' in the database.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.

(1 row(s) affected)
Adding foreign keys to [dbo].[oxite_Plugin]
Msg 2714, Level 16, State 4, Line 1
There is already an object named 'FK_oxite_Plugin_oxite_Site' in the database.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.

(1 row(s) affected)
Adding foreign keys to [dbo].[oxite_PluginSetting]
Msg 2714, Level 16, State 4, Line 1
There is already an object named 'FK_oxite_PluginSetting_oxite_Plugin' in the database.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.

(1 row(s) affected)
Adding foreign keys to [dbo].[oxite_SiteRedirect]
Msg 2714, Level 16, State 4, Line 1
There is already an object named 'FK_oxite_SiteRedirect_oxite_Site' in the database.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.


I made sure that I'm running as 'SA' account so there shouldn't be a problem with permission. Am I missing something here? Am I running the scripts in the right order?

Thank you very much, I appreciate your help.

Teera
Coordinator
Apr 9, 2009 at 3:22 PM
There is no need to run that second script, that is only for people who already had a database using the schema from the January 5th release and need to update. The Oxite.sql is all you need for the most recent release.