[GH-ISSUE #137] SQLite Error 1: 'no such column: d.VmType'. #57

New issue

Closed

opened 2026-02-26 17:37:03 +03:00 by kerem · 1 comment

kerem commented

2026-02-26 17:37:03 +03:00

Owner

Originally created by @patrykkope on GitHub (Jul 4, 2025).
Original GitHub issue: https://github.com/Corsinvest/cv4pve-admin/issues/137

Bug type

Component

Component name

No response

What happened?

I'm having an issue when i try to access Health->Cluster Usage->Costs tab. When i do this I get error
SQLite Error 1: 'no such column: d.VmType'. - For more information, contact your system administrator

Expected behavior

The tab Health->Cluster Usage->Costs shluld open

Relevant log output

at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements()+MoveNext() at Microsoft.Data.Sqlite.SqliteCommand.GetStatements()+MoveNext() at Microsoft.Data.Sqlite.SqliteDataReader.NextResult() at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) at Ardalis.Specification.EntityFrameworkCore.RepositoryBase`1.ListAsync(CancellationToken cancellationToken) at Corsinvest.ProxmoxVE.Admin.ClusterUsage.Components.Costs.<OnInitializedAsync>b__47_0() in /src/src/Corsinvest.ProxmoxVE.Admin.ClusterUsage/Components/Costs.razor.cs:line 87 at Corsinvest.AppHero.Core.MudBlazorUI.Shared.Components.DataGrid.DataGridManager`1.LoadServerData(GridState`1 state) at MudBlazor.MudDataGrid`1.InvokeServerLoadFunc() at MudBlazor.MudDataGrid`1.OnAfterRenderAsync(Boolean firstRender)

Proxmox VE Version

8.4.1

Version (bug)

1.3.1

Version (working)

No response

What browsers are you seeing the problem on?

Chrome

On what operating system are you experiencing the issue?

Linux

Pull Request

I would like to do a Pull Request

Code of Conduct

I agree to follow this project's Code of Conduct

Originally created by @patrykkope on GitHub (Jul 4, 2025). Original GitHub issue: https://github.com/Corsinvest/cv4pve-admin/issues/137 ### Bug type Component ### Component name _No response_ ### What happened? I'm having an issue when i try to access _Health->Cluster Usage->Costs_ tab. When i do this I get error `SQLite Error 1: 'no such column: d.VmType'. - For more information, contact your system administrator` ### Expected behavior The tab _Health->Cluster Usage->Costs_ shluld open ### Relevant log output ```shell at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements()+MoveNext() at Microsoft.Data.Sqlite.SqliteCommand.GetStatements()+MoveNext() at Microsoft.Data.Sqlite.SqliteDataReader.NextResult() at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.Data.Sqlite.SqliteCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) at Ardalis.Specification.EntityFrameworkCore.RepositoryBase`1.ListAsync(CancellationToken cancellationToken) at Corsinvest.ProxmoxVE.Admin.ClusterUsage.Components.Costs.<OnInitializedAsync>b__47_0() in /src/src/Corsinvest.ProxmoxVE.Admin.ClusterUsage/Components/Costs.razor.cs:line 87 at Corsinvest.AppHero.Core.MudBlazorUI.Shared.Components.DataGrid.DataGridManager`1.LoadServerData(GridState`1 state) at MudBlazor.MudDataGrid`1.InvokeServerLoadFunc() at MudBlazor.MudDataGrid`1.OnAfterRenderAsync(Boolean firstRender) ``` ### Proxmox VE Version 8.4.1 ### Version (bug) 1.3.1 ### Version (working) _No response_ ### What browsers are you seeing the problem on? Chrome ### On what operating system are you experiencing the issue? Linux ### Pull Request - [ ] I would like to do a Pull Request ### Code of Conduct - [x] I agree to follow this project's Code of Conduct