stevenleeg / gobb

A simple and fast bulletin board written in Go.
Other
130 stars 26 forks source link

ERROR: relation "goose_db_version" does not exist #31

Open th4n4t0sss opened 3 months ago

th4n4t0sss commented 3 months ago

`2024-07-03 18:13:37.864 +04 [14151] ERROR: relation "goose_db_version" does not exist at character 36 2024-07-03 18:13:37.864 +04 [14151] STATEMENT: SELECT version_id, is_applied from goose_db_version ORDER BY id DESC 2024-07-03 18:13:37.864 +04 [14151] ERROR: permission denied for schema public at character 14 2024-07-03 18:13:37.864 +04 [14151] STATEMENT: CREATE TABLE goose_db_version ( id serial NOT NULL, version_id bigint NOT NULL, is_applied boolean NOT NULL, tstamp timestamp NULL default now(), PRIMARY KEY(id) ); 2024-07-03 18:13:37.866 +04 [14151] ERROR: relation "settings" does not exist at character 27 2024-07-03 18:13:37.866 +04 [14151] STATEMENT: select "key","value" from "settings" where "key"=$1; 2024-07-03 18:18:31.840 +04 [14117] LOG: checkpoint starting: time 2024-07-03 18:18:32.194 +04 [14117] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.108 s, total=0.355 s; sync files=2, longest=0.058 s, average=0.054 s; distance=0 kB, estimate=0 kB; lsn=0/1972B60, redo lsn=0/1972B28 2024-07-03 18:54:41.767 +04 [14151] ERROR: relation "boards" does not exist at character 88 2024-07-03 18:54:41.767 +04 [14151] STATEMENT: SELECT boards.*, views.time AS viewed_on FROM boards LEFT OUTER JOIN views ON views.post_id=(SELECT id FROM posts WHERE board_id=boards.id AND parent_id IS NULL ORDER BY latest_reply DESC LIMIT 1) AND views.user_id=$1 ORDER BY ordering ASC

2024-07-03 18:54:41.768 +04 [14151] ERROR: relation "users" does not exist at character 22 2024-07-03 18:54:41.768 +04 [14151] STATEMENT: SELECT COUNT() FROM users 2024-07-03 18:54:41.768 +04 [14151] ERROR: relation "users" does not exist at character 15 2024-07-03 18:54:41.768 +04 [14151] STATEMENT: SELECT FROM users ORDER BY created_on DESC LIMIT 1 2024-07-03 18:54:41.768 +04 [14151] ERROR: relation "posts" does not exist at character 22 2024-07-03 18:54:41.768 +04 [14151] STATEMENT: SELECT COUNT() FROM posts 2024-07-03 18:54:41.768 +04 [14151] ERROR: relation "users" does not exist at character 15 2024-07-03 18:54:41.768 +04 [14151] STATEMENT: SELECT FROM users WHERE last_seen > current_timestamp - interval '5 minutes' AND hide_online != true 2024-07-03 18:54:41.768 +04 [14151] ERROR: relation "settings" does not exist at character 27 2024-07-03 18:54:41.768 +04 [14151] STATEMENT: select "key","value" from "settings" where "key"=$1; 2024-07-03 18:54:41.769 +04 [14151] ERROR: relation "settings" does not exist at character 27 2024-07-03 18:54:41.769 +04 [14151] STATEMENT: select "key","value" from "settings" where "key"=$1; 2024-07-03 18:54:41.769 +04 [14151] ERROR: relation "settings" does not exist at character 27 2024-07-03 18:54:41.769 +04 [14151] STATEMENT: select "key","value" from "settings" where "key"=$1;

` here is the log of postgres