This project is read-only.

Executing masterratingsdatabase.sql errors

Nov 13, 2008 at 5:58 PM
Edited Nov 13, 2008 at 6:14 PM
Can anyone explain these errors when executing MasterRatingsDatabase.sql  before I continue? I know some of the errors can be ignored per install instructions.


DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 7609, Level 17, State 5, Line 34
Full-Text Search is not installed, or a full-text component cannot be loaded.
Msg 7601, Level 16, State 2, Procedure SearchRatingData, Line 16
Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Rating' because it is not full-text indexed.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'DownloadItem' in the database.
Msg 1913, Level 16, State 1, Line 1
The operation failed because an index or statistics with name 'IX_DownloadItemUrl' already exists on table 'dbo.DownloadItem'.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'Downloads' in the database.
Msg 2714, Level 16, State 3, Procedure Downloads_GetAll, Line 21
There is already an object named 'Downloads_GetAll' in the database.
Msg 2714, Level 16, State 3, Procedure RegisterDownload, Line 19
There is already an object named 'RegisterDownload' in the database.
Msg 2714, Level 16, State 3, Procedure Downloads_GetUnique, Line 21
There is already an object named 'Downloads_GetUnique' in the database.
Msg 2714, Level 16, State 4, Line 2
There is already an object named 'FK_Downloads_DownloadItem' in the database.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Nov 13, 2008 at 9:28 PM
 

The first set of errors relates to Full Text not being installed (not required). The second set can be disregarded as they pertain to the environment and the way PKS installs.  You should be fine to continue on.