Fails on initial dev/build, but works subsequently

[lerni]

DB isn't ready when PublicAssetAdapter_HTAccess.ss asks for $list("SilverStripe\Assets\Folder").filter("ShowInSearch", 0) so we get

<[Emergency] Uncaught SilverStripe\ORM\Connect\DatabaseException: Couldn't run query: SELECT CASE WHEN EXISTS SELECT * FROM "File" WHERE ("File"."ClassName" IN (?))) THEN 1 ELSE 0 END Table 'ss_ssvanilla.file' doesn't exist

Happens on fresh projects with this module installed. The template for assets/.htaccess is generated early in the course of a first/initial request but than, still DB isn't generated and so querying it errors. It's a bit of a chicken egg situation, AssetAdapter should probable be tweaked to completely bail out generating assets/.htaccess if tables aren't generated yet?

[digitall-it]

One solution may be not to query the database at all during .htaccess generation, by mantaining the necessary data in sync in a separate folderindex.json file.

[lerni]

fixed with #892da10 ? See also: silverstripe/silverstripe-framework#10332