TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show Text Part by Default
Condense Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Content-Type:
text/plain; charset="iso-8859-1"
Date:
Tue, 6 Jul 2010 18:48:37 +0000
Reply-To:
"The Museum System (TMS) Users" <[log in to unmask]>
Subject:
From:
Chad Petrovay <[log in to unmask]>
MIME-Version:
1.0
In-Reply-To:
Content-Transfer-Encoding:
quoted-printable
Sender:
"The Museum System (TMS) Users" <[log in to unmask]>
Parts/Attachments:
text/plain (88 lines)
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

ATOM RSS1 RSS2