Start with this:
{F176877 size=full}
Re-order one column:
{F176879 size=full}
Then drag & drop doesn't work anymore:
{F176881 size=full}
Description
Description
Revisions and Commits
Revisions and Commits
Event Timeline
Comment Actions
Actually I just realized re-order doesn't work at all: after clicking Done, the columns order is the same.
Comment Actions
Well here's the problem:
Request URL:https://phabricator..../project/board/1/reorder/ Request Method:POST Status Code:500 Internal Server Error
Comment Actions
From php-fpm log:
[12-Jul-2014 10:08:35 America/Los_Angeles] [2014-07-12 10:08:35] EXCEPTION: (AphrontQueryDuplicateKeyException) #1062: Duplicate entry 'PHID-PROJ-ek56uvdf2kihdqr6pax5-2' for key 'key_sequence' at [<phutil>/src/aphront/storage/connection/mysql/AphrontMySQLDatabaseConnectionBase.php:296]
[12-Jul-2014 10:08:35 America/Los_Angeles] #0 AphrontMySQLDatabaseConnectionBase::throwQueryCodeException(integer, string) called at [<phutil>/src/aphront/storage/connection/mysql/AphrontMySQLDatabaseConnectionBase.php:275]
[12-Jul-2014 10:08:35 America/Los_Angeles] #1 AphrontMySQLDatabaseConnectionBase::throwQueryException(mysqli) called at [<phutil>/src/aphront/storage/connection/mysql/AphrontMySQLDatabaseConnectionBase.php:181]
[12-Jul-2014 10:08:35 America/Los_Angeles] #2 AphrontMySQLDatabaseConnectionBase::executeRawQuery(string) called at [<phutil>/src/xsprintf/queryfx.php:6]
[12-Jul-2014 10:08:35 America/Los_Angeles] #3 queryfx(AphrontMySQLiDatabaseConnection, string, string, string, string, string)
[12-Jul-2014 10:08:35 America/Los_Angeles] #4 call_user_func_array(string, array) called at [<phutil>/src/aphront/storage/connection/AphrontDatabaseConnection.php:26]
[12-Jul-2014 10:08:35 America/Los_Angeles] #5 AphrontDatabaseConnection::query(string, string, string, string, string) called at [<phabricator>/src/infrastructure/storage/lisk/LiskDAO.php:1172]
[12-Jul-2014 10:08:35 America/Los_Angeles] #6 LiskDAO::update() called at [<phabricator>/src/infrastructure/storage/lisk/LiskDAO.php:1098]
[12-Jul-2014 10:08:35 America/Los_Angeles] #7 LiskDAO::save() called at [<phabricator>/src/applications/project/controller/PhabricatorProjectBoardReorderController.php:91]
[12-Jul-2014 10:08:35 America/Los_Angeles] #8 PhabricatorProjectBoardReorderController::processRequest() called at [<phabricator>/webroot/index.php:95]
[12-Jul-2014 10:08:35 America/Los_Angeles] PHP Fatal error: Uncaught exception 'Exception' with message 'Process exited with an open transaction! The transaction will be implicitly rolled back. Calls to openTransaction() must always be paired with a call to saveTransaction() or killTransaction().' in /mnt/phabricator/phabricator/libphutil/src/aphront/storage/connection/AphrontDatabaseTransactionState.php:69
Stack trace:
#0 [internal function]: AphrontDatabaseTransactionState->__destruct()
#1 {main}
thrown in /mnt/phabricator/phabricator/libphutil/src/aphront/storage/connection/AphrontDatabaseTransactionState.php on line 69Comment Actions
I tried in a different board and got the same problem:
[12-Jul-2014 10:11:54 America/Los_Angeles] [2014-07-12 10:11:54] EXCEPTION: (AphrontQueryDuplicateKeyException) #1062: Duplicate entry 'PHID-PROJ-niecmdpb725ewibs4fol-1' for key 'key_sequence' at [<phutil>/src/aphront/storage/connection/mysql/AphrontMySQLDatabaseConnectionBase.php:296]
[12-Jul-2014 10:11:54 America/Los_Angeles] #0 AphrontMySQLDatabaseConnectionBase::throwQueryCodeException(integer, string) called at [<phutil>/src/aphront/storage/connection/mysql/AphrontMySQLDatabaseConnectionBase.php:275]
[12-Jul-2014 10:11:54 America/Los_Angeles] #1 AphrontMySQLDatabaseConnectionBase::throwQueryException(mysqli) called at [<phutil>/src/aphront/storage/connection/mysql/AphrontMySQLDatabaseConnectionBase.php:181]
[12-Jul-2014 10:11:54 America/Los_Angeles] #2 AphrontMySQLDatabaseConnectionBase::executeRawQuery(string) called at [<phutil>/src/xsprintf/queryfx.php:6]
[12-Jul-2014 10:11:54 America/Los_Angeles] #3 queryfx(AphrontMySQLiDatabaseConnection, string, string, string, string, string)
[12-Jul-2014 10:11:54 America/Los_Angeles] #4 call_user_func_array(string, array) called at [<phutil>/src/aphront/storage/connection/AphrontDatabaseConnection.php:26]
[12-Jul-2014 10:11:54 America/Los_Angeles] #5 AphrontDatabaseConnection::query(string, string, string, string, string) called at [<phabricator>/src/infrastructure/storage/lisk/LiskDAO.php:1172]
[12-Jul-2014 10:11:54 America/Los_Angeles] #6 LiskDAO::update() called at [<phabricator>/src/infrastructure/storage/lisk/LiskDAO.php:1098]
[12-Jul-2014 10:11:54 America/Los_Angeles] #7 LiskDAO::save() called at [<phabricator>/src/applications/project/controller/PhabricatorProjectBoardReorderController.php:91]
[12-Jul-2014 10:11:54 America/Los_Angeles] #8 PhabricatorProjectBoardReorderController::processRequest() called at [<phabricator>/webroot/index.php:95]
[12-Jul-2014 10:11:54 America/Los_Angeles] PHP Fatal error: Uncaught exception 'Exception' with message 'Process exited with an open transaction! The transaction will be implicitly rolled back. Calls to openTransaction() must always be paired with a call to saveTransaction() or killTransaction().' in /mnt/phabricator/phabricator/libphutil/src/aphront/storage/connection/AphrontDatabaseTransactionState.php:69
Stack trace:
#0 [internal function]: AphrontDatabaseTransactionState->__destruct()
#1 {main}
thrown in /mnt/phabricator/phabricator/libphutil/src/aphront/storage/connection/AphrontDatabaseTransactionState.php on line 69