Open Aupajo opened 11 years ago
Ahh... It works fine for me, but I think I know what the problem is: The uploaded_files.filename field is 256 chars, and has a UNIQUE constraint. I think my database is using utf8, so the field will probably take up 256 char max, as long as nobody uploads too many filenames in Chinese :-) However, it sounds like mysql 5.5 defaults to utf8mb4, which I'd guess is a wider encoding, so the size of the field is pushing past some limit on key sizes. Sigh. Some clues here: http://code.google.com/p/sqlalchemy-migrate/issues/detail?id=145
possible cheesy hacks:
I changed the UploadedFile filename
column to an arbitrary 200 chars, and db_tool
ran without errors.
I'd push a change, but I don't know what would make a good default, or if there are any side-effects of introducing that change.
Getting there. I tried seeding the database using
db_tool
, which failed with "Specified key was too long; max key length is 767 bytes".Any tips would be appreciated :)