fluentcms / fluentcms/Template

“Failed to initialize the database” error when using PostgreSQL in FluentCMS

Open
#4 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
HTML
Stars
6
Forks
2
PR merge metrics
No merged PRs in 30d

Description

When using PostgreSQL with FluentCMS, the setup process fails during the `/setup` step with the message **“Failed to initialize the database.”** The PostgreSQL connection is successful and `FluentCmsDbContext` is properly initialized, but a `System.InvalidOperationException` occurs afterward.

It appears that the NuGet package **`FluentCMS.Repositories.EFCore.PostgreSQL`** does not include EF Core migration files, and the SQL initialization script (`Setup.sql`) might be missing from the embedded resources. The exception log shows that the file `'FluentCMS.Repositories.EFCore.PostgreSQL.Setup.sql'` cannot be found, suggesting it was not packaged correctly.

Could you please confirm whether the PostgreSQL provider intentionally excludes migration scripts, or if there is a recommended way to initialize the schema (e.g., through a provided SQL script or manual migration process)?

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.