Page MenuHomePhabricator

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

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.