"Column 'status' in where clause is ambiguous" error when attempting to search for unblocked tasks
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	mpalmer
	Mar 2 2015, 8:26 AM

Description

I've just upgraded to phabricator rev 18340d9 (to test out the fix recently committed for T7392), and now when searching for "Show Tasks Not Blocked By Other Tasks", I get the error

Unhandled Exception ("AphrontQueryException")
#1052: Column 'status' in where clause is ambiguous

The error log doesn't appear to be particularly useful, although I'll include it just in case:

PHP message: [2015-03-02 19:14:44] EXCEPTION: (AphrontQueryException) #1052: Column 'status' in where clause is ambiguous at [<phutil>/src/aphront/storage/connection/mysql/AphrontBaseMySQLDatabaseConnection.php:308]
PHP message: arcanist(head=master, ref.master=d8182cf55d50), phabricator(head=master, ref.master=18340d9ceffe), phutil(head=master, ref.master=b6200342f224)
PHP message:   #0 AphrontBaseMySQLDatabaseConnection::throwQueryCodeException(integer, string) called at [<phutil>/src/aphront/storage/connection/mysql/AphrontBaseMySQLDatabaseConnection.php:275]
PHP message:   #1 AphrontBaseMySQLDatabaseConnection::throwQueryException(mysqli) called at [<phutil>/src/aphront/storage/connection/mysql/AphrontBaseMySQLDatabaseConnection.php:181]
PHP message:   #2 AphrontBaseMySQLDatabaseConnection::executeRawQuery(string) called at [<phutil>/src/xsprintf/queryfx.php:6]
PHP message:   #3 queryfx(AphrontMySQLiDatabaseConnection, string, string, string, string, string, string, string, string, string, string)
PHP message:   #4 call_user_func_array(string, array) called at [<phutil>/src/xsprintf/queryfx.php:16]
PHP message:   #5 queryfx_all(AphrontMySQLiDatabaseConnection, string, string, string, string, string, string, string, string, string, string) called at [<phabricator>/src/applications/maniphest/query/ManiphestTaskQuery.php:348]
PHP message:   #6 ManiphestTaskQuery::loadPage() called at [<phabricator>/src/infrastructure/query/policy/PhabricatorPolicyAwareQuery.php:227]
PHP message:   #7 PhabricatorPolicyAwareQuery::execute() called at [<phabricator>/src/infrastructure/query/policy/PhabricatorCursorPagedPolicyAwareQuery.php:166]
PHP message:   #8 PhabricatorCursorPagedPolicyAwareQuery::executeWithCursorPager(AphrontCursorPagerView) called at [<phabricator>/src/applications/search/engine/PhabricatorApplicationSearchEngine.php:624]
PHP message:   #9 PhabricatorApplicationSearchEngine::executeQuery(ManiphestTaskQuery, AphrontCursorPagerView) called

Looking at D11911, there's nothing that stands out as being egregiously wrong, so I'll leave the diagnosis to you pros. Let me know if I can provide any further diagnostic data, testing, or whatever will help.