search

LycheeOrg / Lychee-Docker

Docker image for Lychee
https://lycheeorg.github.io/
167 stars 55 forks source link

DB Error on upgrade #173

Closed wildeyedskies closed 10 months ago

wildeyedskies commented 10 months ago

After updating my lychee instance is getting the following error

lychee_db | 2023-12-27 16:14:03 10 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type' at position 9 to have type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB'), found type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB').

DB is mariadb

ildyria commented 10 months ago

I am 100% sure this is not the correct Lychee you are talking about.

ildyria commented 10 months ago

I may have been a bit too quick to trigger that one.

I get the feeling this might be because your DB engine version is too old.

wildeyedskies commented 10 months ago

It's mariadb 10, should I upgrade that?

wildeyedskies commented 10 months ago

Upgraded to mariadb 11 and the issue seems to be fixed