Error running migration" error="failed to run migration from 0.2.0 to 0.3.0: failed to run transaction: failed to execute migration 0.2.0 to 0.3.0: Error 1101 (42000): BLOB, TEXT, GEOMETRY or JSON column 'config' can't have a default value"

go-shiori / shiori

Simple bookmark manager built with Go

MIT License

9.58k stars 557 forks source link

Error running migration" error="failed to run migration from 0.2.0 to 0.3.0: failed to run transaction: failed to execute migration 0.2.0 to 0.3.0: Error 1101 (42000): BLOB, TEXT, GEOMETRY or JSON column 'config' can't have a default value" #1009

Open huyangkkk opened 3 weeks ago

huyangkkk commented 3 weeks ago

Data

Shiori version 1.7.1 (build 2315f0da403a2e5dca6841e83f0fac5f52e4a18f)

Describe the bug / actual behavior

databases: mysql version:8.0.36 os:ubuntu

time="2024-11-11T17:31:03+08:00" level=fatal msg="Error running migration" error="failed to run migration from 0.2.0 to 0.3.0: failed to run transaction: failed to execute migration 0.2.0 to 0.3.0: Error 1101 (42000): BLOB, TEXT, GEOMETRY or JSON column 'config' can't have a default value"

Expected behavior

start Shiori

fmartingr commented 2 weeks ago

Which version of the mysql/mariadb server are you using?

huyangkkk commented 2 weeks ago

mysql version:8.0.36