MichalKleiner

ok, what columns you’re trying to search? you may need to add indexes in your data objects to support the search module

MichalKleiner

and I think you lack a space before the ENGINE=MyISAM, not it will not separate the table name from that

MichalKleiner

that query only gives you a list of ALTER statements and you will need to run them

MichalKleiner

also the files are no longer necessarily stored in /assets/, it’s abstracted

firesphere

huh? Files are definitely in the assets folder. But the path in the database does not necessarily mean the file path on disk anymore.

MichalKleiner

really? what if you use e.g. S3 bucket as the actual storage?

MichalKleiner

on top of that, one can change ASSETS_PATH constant to anything

firesphere

Well, yeah, but that's by decision. I meant by default 😛

MichalKleiner

you can turn on legacy_filenames mode though which removes the hash from the published version, so they will be fixed again