decentralized-identity / decentralized-identity/dwn-server
code: 'ER_BLOB_KEY_WITHOUT_LENGTH', when using MySql for persistent storage config
- Dominant language
- TypeScript
- Stars
- 41
- Forks
- 43
- PR merge metrics
- No merged PRs in 30d
Description
When updating the persistent storage config to use MySQL and run the server for the first time, it does it's migration and fails when creating the registeredTenants table.
code: 'ER_BLOB_KEY_WITHOUT_LENGTH',
errno: 1170,
sqlState: '42000',
sqlMessage: "BLOB/TEXT column 'did' used in key specification without a key length",
sql: 'create table if not exists `registeredTenants` (`did` text primary key, `termsOfServiceHash` text)'
Solution was to create the table manual and let the rest of the migration run:
CREATE TABLE IF NOT EXISTS `registeredTenants` (
`did` VARCHAR(255) PRIMARY KEY,
`termsOfServiceHash` TEXT
);
Contributor guide
Assessment
This issue has not been assessed yet.