column "threshold_z" of relation "maps" does not exist | error while connecting to the database

[Shyveon]

Hello, I've been trying to use the application but been unable to connect to my postgresql running in a docker container. I'm able to connect and authenticate to the postgresql instance but cs demo manager is unable to properly set up the database and i'm unsure on what to do. Here are the logs generated in the database instance.

2024-06-05 19:32:25.286 UTC [1] LOG:  starting PostgreSQL 16.3 (Debian 16.3-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2024-06-05 19:32:25.298 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2024-06-05 19:32:25.298 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2024-06-05 19:32:25.342 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-06-05 19:32:25.380 UTC [63] LOG:  database system was shut down at 2024-06-05 19:32:25 UTC
2024-06-05 19:32:25.426 UTC [1] LOG:  database system is ready to accept connections
2024-06-05 19:32:58.621 UTC [69] ERROR:  relation "migrations" does not exist at character 49
2024-06-05 19:32:58.621 UTC [69] STATEMENT:  select "schema_version" as "schemaVersion" from "migrations" order by "schema_version" desc
2024-06-05 19:33:03.169 UTC [69] ERROR:  column "threshold_z" of relation "maps" does not exist at character 74
2024-06-05 19:33:03.169 UTC [69] STATEMENT:  insert into "maps" ("name", "game", "position_x", "position_y", "scale", "threshold_z") values ($1, $2, $3, $4, $5, $6), ($7, $8, $9, $10, $11, $12), ($13, $14, $15, $16, $17, $18), ($19, $20, $21, $22, $23, $24), ($25, $26, $27, $28, $29, $30), ($31, $32, $33, $34, $35, $36), ($37, $38, $39, $40, $41, $42), ($43, $44, $45, $46, $47, $48), ($49, $50, $51, $52, $53, $54), ($55, $56, $57, $58, $59, $60), ($61, $62, $63, $64, $65, $66), ($67, $68, $69, $70, $71, $72), ($73, $74, $75, $76, $77, $78), ($79, $80, $81, $82, $83, $84), ($85, $86, $87, $88, $89, $90), ($91, $92, $93, $94, $95, $96), ($97, $98, $99, $100, $101, $102), ($103, $104, $105, $106, $107, $108), ($109, $110, $111, $112, $113, $114), ($115, $116, $117, $118, $119, $120), ($121, $122, $123, $124, $125, $126), ($127, $128, $129, $130, $131, $132), ($133, $134, $135, $136, $137, $138), ($139, $140, $141, $142, $143, $144), ($145, $146, $147, $148, $149, $150), ($151, $152, $153, $154, $155, $156), ($157, $158, $159, $160, $161, $162), ($163, $164, $165, $166, $167, $168), ($169, $170, $171, $172, $173, $174), ($175, $176, $177, $178, $179, $180), ($181, $182, $183, $184, $185, $186), ($187, $188, $189, $190, $191, $192), ($193, $194, $195, $196, $197, $198), ($199, $200, $201, $202, $203, $204), ($205, $206, $207, $208, $209, $210), ($211, $212, $213, $214, $215, $216) on conflict on constraint "maps_name_game_unique" do nothing

[TylerBarlock]

@Shyveon Was getting the same issue, didnt look into it much but switch to the hotfix version down it should work as it did for me.

Link to 3.6.1 - https://github.com/akiver/cs-demo-manager/releases/tag/v3.6.1

@akiver Just a heads up, seems to be an issue when creating a server. I reset my postgres server and the issue started happening within 3.6.2. Checked tables and there was no Map table/ z threshold column.

[akiver]

Thanks for the report, it should be fixed in v3.6.3