Run "SELECT * FROM Roles"
Verify RoleTypeID WHERE RoleID = 1
I'm guessing that RoleID = 1 is also RoleTypeID = 1 (not RoleTypeID = 2), which accounts for your error.
Chad Petrovay | Collections Database Administrator
MIM-Musical Instrument Museum | 4725 E. Mayo Boulevard | Phoenix, AZ 85050
480.478.6000 main | 480.478.6058 direct | 480.471.8690 fax | www.themim.org
Blog: www.petrovay.com/tmsblog
-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Grace Chiu
Sent: Tuesday, July 06, 2010 11:39 AM
To: [log in to unmask]
Subject: Re: TMS SQL Backend Errors
I was just testing it out with really simple inserts.
USE TMS
GO
SET IDENTITY_INSERT dbo.Objects ON
INSERT INTO dbo.Objects (ObjectID, ObjectNumber, SortNumber,
ObjectStatusID, DepartmentID, ClassificationID, LoginID)
VALUES ('33094', 'ht0005191', 'ht 000519 1', 9, 3, 'tmsuser')
SET IDENTITY_INSERT dbo.Objects OFF
GO
--------------------------
USE TMS
GO
SET IDENTITY_INSERT dbo.ObjTitles ON
INSERT INTO dbo.ObjTitles (TitleID, ObjectID, TitleTypeID, Title, Remarks,
Active, LoginID, DisplayOrder, Displayed, LanguageID)
VALUES ('37857', '33094', 2, 'Barnum & Bailey: Managers', NULL, 1, 'tmsuser',
1, 1, 1)
SET IDENTITY_INSERT dbo.ObjTitles OFF
GO
---------------------------
USE TMS
GO
SET IDENTITY_INSERT dbo.Constituents ON
INSERT INTO dbo.Constituents (ConstituentID, ConstituentTypeID, Active,
AlphaSort, LastName, FirstName, Institution, DisplayName, LoginID,
PublicAccess)
VALUES ('6391', 1, 1, 'Unknown', 'Unknown', NULL,
NULL, 'Unknown', 'tmsuser', 'True')
SET IDENTITY_INSERT dbo.Constituents OFF
GO
---------------------------
USE TMS
GO
SET IDENTITY_INSERT dbo.ConXrefs ON
INSERT INTO dbo.ConXrefs (ConXrefID, ID, ConstituentID, RoleID, TableID,
LoginID, DisplayOrder, Displayed, Active, RoleTypeID)
VALUES ('65890', '33094', '6391', '1', '108', 'tmsuser', 1, 1, 1, 2)
SET IDENTITY_INSERT dbo.ConXrefs OFF
GO
|
