telethon-session-sqlalchemy icon indicating copy to clipboard operation
telethon-session-sqlalchemy copied to clipboard

Published 20 hours ago • verified publisher icon tulir

BLOB/TEXT column 'md5_digest' used in key specification without a key length

Open Soberia opened this issue 5 years ago • 1 comments

OperationalError rasies when try to a create a container with AlchemySessionContainer() with MySQL database:

sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (1170, "BLOB/TEXT column 'md5_digest' used in key specification without a key length")

[SQL: CREATE TABLE sent_files ( session_id VARCHAR(255) NOT NULL, md5_digest BLOB NOT NULL, file_size INTEGER NOT NULL, type INTEGER NOT NULL, id BIGINT, hash BIGINT, PRIMARY KEY (session_id, md5_digest, file_size, type)

Telethon v1.10.6 SQLAlchemy v1.3.10 (Dialect = MySQL v8.0.18, Driver = mysqlclient v1.4.4) telethon-session-sqlalchemy v0.2.15

Soberia avatar Oct 21 '19 10:10 Soberia

Can reproduce this issue too. Telethon 1.14.0, SQLAlchemy 1.3.11, telethon-session-sqlalchemy 0.2.15

Can be solved by manually creating tables and passing manage_tables=False to AlchemySessionContainer.

kolayne avatar Jun 22 '20 20:06 kolayne