Question

Greetings,

I'm running into an error on Fogbugz 8 that didn't appear in 7. I'm not sure if it's my doing, or if there might be a bug in Fogbugz, but when I do a table join with the Person table, and then try to view Fogbugz groups while my plugin is enabled, I get the following error message:

---

Column 'ixPerson' in where clause is ambiguous SQL: SELECT Person.ixPerson AS ixPerson, Person.sFullName AS sFullName, Person.sEmail AS sEmail, Person.fNotify AS fNotify, Person.fEscalationReport AS fEscalationReport, Person.sVersion AS sVersion, Person.sComputer AS sComputer, Person.sPhone AS sPhone, Person.fExpert AS fExpert, Person.fAdministrator AS fAdministrator, Person.fDeleted AS fDeleted, Person.sFrom AS sFrom, Person.fGridView AS fGridView, Person.ixArea AS ixArea, Person.ixBugWorkingOn AS ixBugWorkingOn, Person.sVersionSeen AS sVersionSeen, Person.sVersionSeenKiln AS sVersionSeenKiln, Person.sContractSeen AS sContractSeen, Person.sPasswordVersion AS sPasswordVersion, Person.sSnippetKey AS sSnippetKey, Person.sLDAPUid AS sLDAPUid, Person.fMostRecentEventFirst AS fMostRecentEventFirst, Person.fCommunity AS fCommunity, Person.fConfirmed AS fConfirmed, Person.fVirtual AS fVirtual, Person.sHomepage AS sHomepage, Person.dtRegistered AS dtRegistered, Person.sLocale AS sLocale, Person.sLanguage AS sLanguage, Person.sTimeZoneKey AS sTimeZoneKey, Person.dtLastDailyTask As dtLastDailyTask, Person.dtLastScheduleMaint As dtLastScheduleMaint, Person.dtLastActivity As dtLastActivity, Person.bfHelpTips As bfHelpTips, Person.fRecurseBugChildren AS fRecurseBugChildren, Person.fPaletteExpanded AS fPaletteExpanded, Person.fPaletteModified AS fPaletteModified, Plugin_87_User_Organization.ixPerson AS Plugin_87_User_Organization_ixPerson, Plugin_87_User_Organization.ixOrg AS Plugin_87_User_Organization_ixOrg FROM Person LEFT JOIN Plugin_87_User_Organization AS Plugin_87_User_Organization ON ( Plugin_87_User_Organization.ixPerson = Person.ixPerson ) WHERE ( Person.fCommunity = 0 ) AND ( Person.fDeleted = 0 ) AND ( Person.fVirtual = 0 ) AND ( NOT (ixPerson IN (44,311)) ) AND ( Person.ixPerson IN (1,3,4,ect, ect...,1,-1) ) AND ( Person.ixPerson > 1 ) AND ( Person.fDeleted = 0 ) ORDER BY Person.sFullName Params:

at MySql.Data.MySqlClient.MySqlStream.OpenPacket () [0x00000] at MySql.Data.MySqlClient.NativeDriver.ReadResult (System.UInt64& affectedRows, System.Int64& lastInsertId) [0x00000] at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet () [0x00000] at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x00000]

---

I notice a segment of the where clause:

) AND ( NOT (ixPerson IN (44,311)) ) AND (

and I'm guessing it should be Person.ixPerson instead of just ixPerson, because the table in my plugin also has an ixPerson column (for joining).

Is there something I can do to fix this from the plugin API? Thank you for any help or feedback :)

Answer 1

Sorry about this, it's 100% our fault and I have just checked in a fix. If you need to get this working on a local install and can't wait for the next build of FogBugz, you can patch GroupEditor.was as follows and run build.bat. Thanks!

--- a/src-Website/GroupEditor.was       Fri Nov 12 16:21:02 2010 -0500
+++ b/src-Website/GroupEditor.was       Mon Nov 15 10:08:23 2010 -0500
@@ -663,7 +663,7 @@
                query.AddWhere "Person.fVirtual = 0"
                query.AddOrderBy "Person.sFullName"
                Dim rgixPerson = Arrays.MapCPersonToString(permgroup.rgpersonMember, Lambda(person) person.ixPerson)
-               If UBound(rgixPerson) <> -1 Then query.AddWhere FormatString("NOT (ixPerson IN ({0}))", Join(rgixPerson, ","))
+               If UBound(rgixPerson) <> -1 Then query.AddWhere FormatString("NOT (Person.ixPerson IN ({0}))", Join(rgixPerson, ","))
                Return query.ListUnsafe
        End Function