I apologize in advance for this one being kinda useless, but I figure it's worth reporting lest other people run into it and search.
STR:
- Be me.
- Go to https://secure.phabricator.com/conpherence/search/query/advanced/.
- Enter epriestley in the Participants input.
- Click Execute Query
Expected:
Search results containing 2 rooms: Z1336 General Chat and Z6 epriestley
Actual:
Unhandled Exception ("AphrontQueryException")
#1052: Column 'id' in where clause is ambiguousMy theory is that this is from Z6 being a very old room created from the now-gone Send Message profile action, and it's gotten broken in a migration at some point.
I attempted to repro this with several other usernames with no luck.
I attempted to create a new room with the same name as the single other participant and search for them, also worked fine.
Interestingly, Z6 also Hovercard's for me as Z6: Private Room
I'm happy for Phacility High Command to break into my account here to test this if fixing it is worthwhile.
The query in question:
SELECT conpherence_thread.* FROM `conpherence_thread` conpherence_thread JOIN `conpherence_participant` p ON p.conpherencePHID = conpherence_thread.phid WHERE ((`id` < 367)) AND (p.participantPHID IN ('PHID-USER-ba8aeea1b3fe2853d6bb')) GROUP BY conpherence_thread.id ORDER BY `id` DESC LIMIT 98Stack Trace:
AphrontBaseMySQLDatabaseConnection::throwQueryCodeException called at [/core/lib/libphutil/src/aphront/storage/connection/mysql/AphrontBaseMySQLDatabaseConnection.php:289] AphrontBaseMySQLDatabaseConnection::throwQueryException called at [/core/lib/libphutil/src/aphront/storage/connection/mysql/AphrontBaseMySQLDatabaseConnection.php:185] AphrontBaseMySQLDatabaseConnection::executeRawQuery called at [/core/lib/libphutil/src/xsprintf/queryfx.php:6] queryfx call_user_func_array called at [/core/lib/libphutil/src/xsprintf/queryfx.php:11] queryfx_all called at [/core/lib/phabricator/src/applications/conpherence/query/ConpherenceThreadQuery.php:109] ConpherenceThreadQuery::loadPage called at [/core/lib/phabricator/src/infrastructure/query/policy/PhabricatorPolicyAwareQuery.php:227] PhabricatorPolicyAwareQuery::execute called at [/core/lib/phabricator/src/infrastructure/query/policy/PhabricatorCursorPagedPolicyAwareQuery.php:170] PhabricatorCursorPagedPolicyAwareQuery::executeWithCursorPager called at [/core/lib/phabricator/src/applications/search/engine/PhabricatorApplicationSearchEngine.php:1031] PhabricatorApplicationSearchEngine::executeQuery called at [/core/lib/phabricator/src/applications/search/controller/PhabricatorApplicationSearchController.php:230] PhabricatorApplicationSearchController::processSearchRequest called at [/core/lib/phabricator/src/applications/search/controller/PhabricatorApplicationSearchController.php:73] PhabricatorApplicationSearchController::processRequest called at [/core/lib/phabricator/src/aphront/AphrontController.php:29] AphrontController::handleRequest called at [/core/lib/phabricator/src/aphront/AphrontController.php:71] AphrontController::delegateToController called at [/core/lib/phabricator/src/applications/conpherence/controller/ConpherenceRoomListController.php:18] ConpherenceRoomListController::handleRequest called at [/core/lib/phabricator/src/aphront/configuration/AphrontApplicationConfiguration.php:237] phlog called at [/core/lib/phabricator/src/aphront/handler/PhabricatorDefaultRequestExceptionHandler.php:32] PhabricatorDefaultRequestExceptionHandler::handleRequestException called at [/core/lib/phabricator/src/aphront/configuration/AphrontApplicationConfiguration.php:644] AphrontApplicationConfiguration::handleException called at [/core/lib/phabricator/src/aphront/configuration/AphrontApplicationConfiguration.php:242] AphrontApplicationConfiguration::processRequest called at [/core/lib/phabricator/src/aphront/configuration/AphrontApplicationConfiguration.php:149] AphrontApplicationConfiguration::runHTTPRequest called at [/core/lib/phabricator/webroot/index.php:17]