decentralized-identity / decentralized-identity/dwn-server

code: 'ER_BLOB_KEY_WITHOUT_LENGTH', when using MySql for persistent storage config

Open
#152 0 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.