We recently updated our self hosted version of fogbugz and kiln to the latest and greatest and our kiln pushes are no longer creating relationships between cases and commits.
We are having the same problem described in this case: http://kiln.stackexchange.com/questions/2473/auto-linking-kiln-changeset-to-fogbugz-case-not-working
The text in the commit message links correctly, but you cannot view the case and see the commit the way we used to be able to.
There is also an error when trying to add the kiln changesets to the fogbugz list view. This may or may not be related.
Wasabi.Runtime.WasabiException (0x80004005): Invalid column name 'nCheckins'.
SQL: SELECT TOP 200 Bug.ixBug as ixBug, Bug.fOpen as fOpen, Bug.sTitle as sTitle, Bug.sOriginalTitle as sOriginalTitle, Bug.ixBugEventLatest as ixBugEventLatest, Bug.ixBugEventLatestText as ixBugEventLatestText, Bug.sLatestTextSummary as sLatestTextSummary, BugEvent.dt as dtLastUpdated, BugEvent.fExternal as bExternalEvt, BugEvent.ixPerson as ixPersonEvt, BugEvent.sVerb as sVerb, BugEvent.ixPersonAssignedTo as ixPersonAssignedToEvt, BugEvent.sStatus as sStatusEvt, Bug.dtDue as dtDue, Bug.ixPriority as ixPriority, Bug.sComputer as sComputer, Bug.sVersion as sVersion, Priority.sPriority as sPriority, Bug.ixPersonAssignedTo as ixPersonAssignedTo, PersonAssignedTo.sFullName as sPersonAssignedTo, PersonAssignedTo.sPhone as sPhoneAssignedTo, PersonAssignedTo.sEmail as sEmailAssignedTo, Bug.ixPersonResolvedBy as ixPersonResolvedBy, PersonResolvedBy.sFullName as sPersonResolvedBy, PersonResolvedBy.sPhone as sPhoneResolvedBy, PersonResolvedBy.sEmail as sEmailResolvedBy, Bug.ixPersonClosedBy as ixPersonClosedBy, PersonClosedBy.sFullName as sPersonClosedBy, PersonClosedBy.sPhone as sPhoneClosedBy, PersonClosedBy.sEmail as sEmailClosedBy, Bug.ixPersonLastEditedBy as ixPersonLastEditedBy, PersonLastEditedBy.sFullName as sPersonLastEditedBy, PersonLastEditedBy.sPhone as sPhoneLastEditedBy, PersonLastEditedBy.sEmail as sEmailLastEditedBy, Project.sProject as sProject, Bug.ixProject as ixProject, Project.fDeleted as fDeletedProject, Bug.ixStatus as ixStatus, Status.sStatus as sStatus, Status.fResolved AS fResolved, PersonOpenedBy.sFullName as sFullNameOpenedBy, PersonOpenedBy.sPhone as sPhoneOpenedBy, PersonOpenedBy.sEmail as sEmailOpenedBy, Bug.ixPersonOpenedBy as ixPersonOpenedBy, PersonCommunityOpenedBy.sFullName as sFullNameCommunityOpenedBy, PersonCommunityOpenedBy.sPhone as sPhoneCommunityOpenedBy, PersonCommunityOpenedBy.sEmail as sEmailCommunityOpenedBy, Bug.ixPersonCommunityOpenedBy as ixPersonCommunityOpenedBy, Bug.ixPersonEstimator as ixPersonEstimator, Bug.ixFixFor as ixFixFor, Area.sArea as sArea, Bug.ixArea as ixArea, Area.fDeleted as fDeletedArea, Bug.dtOpened as dtOpened, Bug.dtResolved as dtResolved, Bug.dtClosed as dtClosed, (Bug.hrsCurrEst-Bug.hrsElapsed) as hrsRemaining, Bug.hrsElapsed as hrsElapsed, Bug.hrsElapsedExtra as hrsElapsedExtra, Bug.c as c, Bug.sCustomerEmail as sCustomerEmail, Bug.ixMailbox as ixMailbox, Bug.ixCategory as ixCategory, FixFor.sFixFor as sFixFor, FixFor.dt as dtFixFor, FixFor.fDeleted as fDeletedFixFor, Bug.hrsOrigEst as hrsOrigEst, Bug.hrsCurrEst as hrsCurrEst, Bug.fEstLocked as fEstLocked, PersonAssignedTo.fNotify as fNotify, Bug.fTrained as fTrained, Bug.fReplied as fReplied, Bug.fForwarded as fForwarded, Bug.ixOriginalPrediction as ixOriginalPrediction, Bug.nStatType as nStatType, Bug.ixDiscussTopic as ixDiscussTopic, Bug.sTicket as sTicket, Bug.sReleaseNotes as sReleaseNotes, Area.nType as nType, BugView.ixBugEvent as ixBugEventLastView, BugView.dt as dtLastView, Bug.ixBugEmail as ixBugEmail, TagEvent.sTags as sTags, Bug.ixTagEventLatest as ixTagEventLatest, ((100000 * (2 - Bug.fOpen)) + Bug.ixStatus) as nStatusSort, Bug.ixBugParent AS ixBugParent, Bug.ixBugRoot AS ixBugRoot, Bug.iSetLeft AS iSetLeft, Bug.iSetRight AS iSetRight, nCheckins, Bug.ixBug AS ixBugNested FROM ((((((((((((( Bug INNER JOIN FixFor AS FixFor ON ( Bug.ixFixFor = FixFor.ixFixFor ) ) INNER JOIN Status AS Status ON ( Bug.ixStatus = Status.ixStatus ) ) INNER JOIN Priority AS Priority ON ( Bug.ixPriority = Priority.ixPriority ) ) INNER JOIN Project AS Project ON ( Bug.ixProject = Project.ixProject ) ) INNER JOIN Person AS PersonAssignedTo ON ( Bug.ixPersonAssignedTo = PersonAssignedTo.ixPerson ) ) LEFT JOIN Person AS PersonResolvedBy ON ( Bug.ixPersonResolvedBy = PersonResolvedBy.ixPerson ) ) LEFT JOIN Person AS PersonClosedBy ON ( Bug.ixPersonClosedBy = PersonClosedBy.ixPerson ) ) LEFT JOIN Person AS PersonLastEditedBy ON ( Bug.ixPersonLastEditedBy = PersonLastEditedBy.ixPerson ) ) INNER JOIN Person AS PersonOpenedBy ON ( Bug.ixPersonOpenedBy = PersonOpenedBy.ixPerson ) ) LEFT JOIN Person AS PersonCommunityOpenedBy ON ( Bug.ixPersonCommunityOpenedBy = PersonCommunityOpenedBy.ixPerson ) ) INNER JOIN Area AS Area ON ( Bug.ixArea = Area.ixArea ) ) INNER JOIN BugEvent AS BugEvent ON ( Bug.ixBugEventLatest = BugEvent.ixBugEvent ) ) LEFT JOIN TagEvent AS TagEvent ON ( Bug.ixTagEventLatest = TagEvent.ixTagEvent ) ) LEFT JOIN BugView AS BugView ON ( Bug.ixBug = BugView.ixBug AND BugView.ixPerson = ? ) WHERE ( Project.ixProject = Area.ixProject ) AND ( Area.nType <> ? ) AND ( Bug.fOpen = 1 ) ORDER BY Bug.ixBug DESC, CASE WHEN FixFor.ixFixFor = 1 THEN 0 ELSE 1 END ASC, CASE WHEN FixFor.dt IS NULL THEN 0 ELSE 1 END ASC, FixFor.dt ASC, FixFor.sFixFor ASC, Project.sProject ASC
Params: II
1: 2
2: 3
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at Wasabi.Runtime.ADO.Command.Execute(Object ignored1, Object ignored2, Nullable`1 Options) in c:\code\release\build\fogbugz\8.3.42\Wasabi\Wasabi.Runtime\ADO\Command.cs:line 73
at FogCreek.FogBugz.CCmd.InternalExecute(String& sError) in c:\code\release\build\fogbugz\8.3.42\FogBugz\distribution\src-Website\CCmd.was:line 192
at Wasabi.Runtime.Error.RaiseException(Int32 number, String source, String description, String helpfile, Nullable`1 helpcontext) in c:\code\release\build\fogbugz\8.3.42\Wasabi\Wasabi.Runtime\Error.cs:line 71
at FogCreek.FogBugz.CCmd.Execute(Nullable`1 nCacheClearLevel) in c:\code\release\build\fogbugz\8.3.42\FogBugz\distribution\src-Website\CCmd.was:line 231
at FogCreek.FogBugz.CBugOutlineQuery.GetCommand() in c:\code\release\build\fogbugz\8.3.42\FogBugz\distribution\src-Website\CBugOutlineQuery.was:line 180
at FogCreek.FogBugz.__Global.CreateBugOutline(ListDetails oDetails) in c:\code\release\build\fogbugz\8.3.42\FogBugz\distribution\src-Website\list.was:line 1502
at Wasabi.Runtime.Web.Response.PictureOf[T1](Sub`1 sub, T1 a) in c:\code\release\build\fogbugz\8.3.42\Wasabi\Wasabi.Runtime\ResponseGenerator.cs:line 28
at FogCreek.FogBugz.__Global.GetListDetails(Boolean fGridView, Boolean fIgnoreMax, Int32 ixPageNum, CGridColumn[] rgGridColumns, Boolean fSearch, String sSearchOverride, CFilter filterOverride) in c:\code\release\build\fogbugz\8.3.42\FogBugz\distribution\src-Website\list.was:line 1630
Edit: Additional Info
FogBugz Version 8.3.42 (DB 778, Build 1)
Kiln Version 2.3.29.0 (DB 98)
I have no errors on the plugin page, and it's showing a kiln plugin version of 2.3.29.0.
