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]

Revisions and Commits

Restricted Differential Revision

Event Timeline

joshuaspence assigned this task to epriestley.
joshuaspence raised the priority of this task from to Needs Triage.
joshuaspence updated the task description. (Show Details)
joshuaspence added a project: Maniphest.
joshuaspence added a subscriber: joshuaspence.
epriestley added a revision: Restricted Differential Revision.Jul 21 2014, 1:18 PM
epriestley added a commit: Restricted Diffusion Commit.

Closed by commit rP9d64beeaa345.