Page MenuHomePhabricator

Column 'dateCreated' in where clause is ambiguous
Closed, ResolvedPublic

Description

The following exception seems to occur if searching Maniphest for tickets belonging to a project and created after a specified date.

[21-Jul-2014 04:32:35 UTC] [2014-07-21 14:32:35] EXCEPTION: (AphrontQueryException) #1052: Column 'dateCreated' in where clause is ambiguous at [<phutil>/src/aphront/storage/connection/mysql/AphrontMySQLDatabaseConnectionBase.php:308]
[21-Jul-2014 04:32:35 UTC]   #0 AphrontMySQLDatabaseConnectionBase::throwQueryCodeException(integer, string) called at [<phutil>/src/aphront/storage/connection/mysql/AphrontMySQLDatabaseConnectionBase.php:275]
[21-Jul-2014 04:32:35 UTC]   #1 AphrontMySQLDatabaseConnectionBase::throwQueryException(mysqli) called at [<phutil>/src/aphront/storage/connection/mysql/AphrontMySQLDatabaseConnectionBase.php:181]
[21-Jul-2014 04:32:35 UTC]   #2 AphrontMySQLDatabaseConnectionBase::executeRawQuery(string) called at [<phutil>/src/xsprintf/queryfx.php:6]
[21-Jul-2014 04:32:35 UTC]   #3 queryfx(AphrontMySQLiDatabaseConnection, string, string, string, string, string, string, string, string, string, string)
[21-Jul-2014 04:32:35 UTC]   #4 call_user_func_array(string, array) called at [<phutil>/src/xsprintf/queryfx.php:16]
[21-Jul-2014 04:32:35 UTC]   #5 queryfx_all(AphrontMySQLiDatabaseConnection, string, string, string, string, string, string, string, string, string, string) called at [<phabricator>/src/applications/maniphest/query/ManiphestTaskQuery.php:280]
[21-Jul-2014 04:32:35 UTC]   #6 ManiphestTaskQuery::loadPage() called at [<phabricator>/src/infrastructure/query/policy/PhabricatorPolicyAwareQuery.php:219]
[21-Jul-2014 04:32:35 UTC]   #7 PhabricatorPolicyAwareQuery::execute() called at [<phabricator>/src/infrastructure/query/policy/PhabricatorCursorPagedPolicyAwareQuery.php:165]
[21-Jul-2014 04:32:35 UTC]   #8 PhabricatorCursorPagedPolicyAwareQuery::executeWithCursorPager(AphrontCursorPagerView) called at [<phabricator>/src/applications/search/engine/PhabricatorApplicationSearchEngine.php:622]
[21-Jul-2014 04:32:35 UTC]   #9 PhabricatorApplicationSearchEngine::executeQuery(ManiphestTaskQuery, AphrontCursorPagerView) called at [<phabricator>/src/applications/search/controller/PhabricatorApplicationSearchController.php:217]
[21-Jul-2014 04:32:35 UTC]   #10 PhabricatorApplicationSearchController::processSearchRequest() called at [<phabricator>/src/applications/search/controller/PhabricatorApplicationSearchController.php:80]
[21-Jul-2014 04:32:35 UTC]   #11 PhabricatorApplicationSearchController::processRequest() called at [<phabricator>/src/aphront/AphrontController.php:49]
[21-Jul-2014 04:32:35 UTC]   #12 AphrontController::delegateToController(PhabricatorApplicationSearchController) called at [<phabricator>/src/applications/maniphest/controller/ManiphestTaskListController.php:25]
[21-Jul-2014 04:32:35 UTC]   #13 ManiphestTaskListController::processRequest() called at [<phabricator>/webroot/index.php:95]