User Details
User Details
- User Since
- Mar 2 2015, 3:34 PM (507 w, 6 d)
- Availability
- Available
Mar 2 2015
Mar 2 2015
ankitladhania1993 added a comment to T7422: COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'binary' error.
is there any documentation regarding that for Apache. I'm familiar with Nginx not Apache so please bare with me
ankitladhania1993 added a comment to T7422: COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'binary' error.
Yes. It resolved the issue.
ankitladhania1993 added a comment to T7422: COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'binary' error.
Thanks. @epriestley
ankitladhania1993 added a comment to T7422: COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'binary' error.
@epriestley can you tell me when can i expect it to be resolved?
ankitladhania1993 added a comment to T7422: COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'binary' error.
what should i do @epriestley?
ankitladhania1993 updated the task description for T7422: COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'binary' error.
ankitladhania1993 added a comment to T7422: COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'binary' error.
>>> [41] <query> CREATE TABLE `differential_customfieldstringindex` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `objectPHID` varbinary(64) NOT NULL, `indexKey` binary(12) NOT NULL, `indexValue` longtext CHARACTER SET `binary` COLLATE `utf8_general_ci` NOT NULL, PRIMARY KEY (`id`), KEY `key_join` (`objectPHID`,`indexKey`,`indexValue`(64)), KEY `key_find` (`indexKey`,`indexValue`(64)) ) ENGINE=InnoDB DEFAULT CHARSET=`binary` COLLATE=`binary` <<< [41] <query> 180 us [2015-03-02 15:52:01] EXCEPTION: (AphrontQueryException) #1253: COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'binary' at [<phutil>/src/aphront/storage/connection/mysql/AphrontBaseMySQLDatabaseConnection.php:308] arcanist(head=master, ref.master=d8182cf55d50), phabricator(head=master, ref.master=18340d9ceffe), phutil(head=master, ref.master=b6200342f224) #0 AphrontBaseMySQLDatabaseConnection::throwQueryCodeException(integer, string) called at [<phutil>/src/aphront/storage/connection/mysql/AphrontBaseMySQLDatabaseConnection.php:275] #1 AphrontBaseMySQLDatabaseConnection::throwQueryException(mysqli) called at [<phutil>/src/aphront/storage/connection/mysql/AphrontBaseMySQLDatabaseConnection.php:181] #2 AphrontBaseMySQLDatabaseConnection::executeRawQuery(string) called at [<phutil>/src/xsprintf/queryfx.php:6] #3 queryfx(AphrontMySQLiDatabaseConnection, string, string) called at [<phabricator>/src/infrastructure/storage/management/PhabricatorStorageManagementAPI.php:219] #4 PhabricatorStorageManagementAPI::applyPatchSQL(string) called at [<phabricator>/src/infrastructure/storage/management/workflow/PhabricatorStorageManagementUpgradeWorkflow.php:109] #5 PhabricatorStorageManagementUpgradeWorkflow::execute(PhutilArgumentParser) called at [<phutil>/src/parser/argument/PhutilArgumentParser.php:396] #6 PhutilArgumentParser::parseWorkflowsFull(array) called at [<phutil>/src/parser/argument/PhutilArgumentParser.php:292] #7 PhutilArgumentParser::parseWorkflows(array) called at [<phabricator>/scripts/sql/manage_storage.php:171]
ankitladhania1993 added a comment to T7422: COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'binary' error.
>>> [1] <connect> <<< [1] <connect> 1,173 us >>> [2] <query> SELECT 1 <<< [2] <query> 187 us >>> [3] <connect> <<< [3] <connect> 311 us >>> [4] <query> SELECT 1 <<< [4] <query> 150 us >>> [5] <connect> phabricator_meta_data <<< [5] <connect> 756 us Usage Exception: You have not initialized the database yet. You must initialize the database before you can adjust schemata. Run `storage upgrade` to initialize the database.
ankitladhania1993 triaged T7422: COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'binary' error as High priority.