Проблема Unknown column 'houseId' in 'field list'

[Wsquad]

Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
00:44:58.016 | Exception: MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'houseId' in 'field list'
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at System.Data.Common.DbCommand.ExecuteNonQueryAsync(CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
at LinqToDB.Data.DataConnection.ExecuteNonQueryAsync(CancellationToken cancellationToken)
at LinqToDB.Data.DataConnection.QueryRunner.ExecuteScalarAsync(CancellationToken cancellationToken)
at LinqToDB.Linq.QueryRunner.ScalarQueryAsync(Query query, IDataContext dataContext, Expression expression, Object[] ps, Object[] preambles, CancellationToken cancellationToken)
at LinqToDB.Linq.QueryRunner.ScalarQueryAsync(Query query, IDataContext dataContext, Expression expression, Object[] ps, Object[] preambles, CancellationToken cancellationToken)
at LinqToDB.Linq.QueryRunner.InsertWithIdentity`1.QueryAsync(IDataContext dataContext, T obj, InsertColumnFilter`1 columnFilter, String tableName, String serverName, String databaseName, String schemaName, TableOptions tableOptions, CancellationToken token)
at LinqToDB.DataExtensions.InsertWithInt32IdentityAsync[T](IDataContext dataContext, T obj, InsertColumnFilter`1 columnFilter, String tableName, String databaseName, String schemaName, String serverName, TableOptions tableOptions, CancellationToken token)
at NeptuneEvrganizations.Manager.<>c__DisplayClass36_1.<<CreateOrganization>b__1>d.MoveNext() in C:\Perfomant Project\dotnet\resources\NeptuneEvo\Organizations\Manager.cs:line 1517
--- End of stack trace from previous location where exception was thrown ---
at NeptuneEvrganizations.Manager.<>c__DisplayClass36_1.<<CreateOrganization>b__1>d.MoveNext() in C:\Perfomant Project\dotnet\resources\NeptuneEvo\Organizations\Manager.cs:line 1561

при создании организации выдает такую ошибку

 

[Jerry (ChatGPT)]

Looks like there is an issue with the database query related to the 'houseId' column. The error message indicates that the 'houseId' column is not recognized in the field list. This could be due to a typo in the column name, a missing column in the database table, or a misconfiguration in the query.

I recommend checking the database schema to ensure that the 'houseId' column exists in the appropriate table and that it is being referenced correctly in the query when creating an organization.

 

[Inoi]

Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'

 

[Wsquad]

Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'
Unknown column 'houseId' in 'field list'

уже пофиксил извиняюсь туплю очень сильно