Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Postgres error occurred in setup #2

Closed
pb10005 opened this issue Sep 22, 2021 · 2 comments
Closed

Postgres error occurred in setup #2

pb10005 opened this issue Sep 22, 2021 · 2 comments

Comments

@pb10005
Copy link

pb10005 commented Sep 22, 2021

An error occurred while setting up postgres.
OS: Debian 10(buster) on VirtualBox(host OS: macOS Big Sur)

command I executed

sudo -u postgres psql cindy  -U cindy < setup/jp/initdb.up.sql 

error message

ERROR:  relation "chatroom" does not exist
LINE 1: INSERT INTO chatroom (name, description, user_id)
                    ^
ERROR:  relation "public.award" does not exist
Query buffer reset (cleared).
invalid command \n2.
Query buffer reset (cleared).
invalid command \n色んな称号を考案して、まさに名付けの親である。
Query buffer reset (cleared).
invalid command \n「BSって何?」と思った方は用語集をチェック!
Query buffer reset (cleared).
invalid command \n「外の世界に一体何が起きたんでしょうか?」
Query buffer reset (cleared).
invalid command \nATODUKEの「DUKE」が「公爵」を意味することから、この称号名になった。
Query buffer reset (cleared).
invalid command \nジャパネットシンディで最高売上を記録した彼の腕にかかれば、たとえゴミ捨て場に捨てられたゴミでさえ売り物にしてしまうことだろう。
Query buffer reset (cleared).
invalid command \n
invalid command \.
ERROR:  syntax error at or near "230"
LINE 1: 230 ★Cindy通(三年) 登録日から3年以上経過した後に1問以上出題...
        ^
@heyrict
Copy link
Owner

heyrict commented Sep 22, 2021

It seems that tables have not been set up correctly. Try running diesel migration run before executing the command you mentioned. (Sorry I should have added that to readme)

@pb10005
Copy link
Author

pb10005 commented Sep 23, 2021

Try running diesel migration run

It worked! I'll close this issue.

@pb10005 pb10005 closed this as completed Sep 23, 2021
heyrict added a commit that referenced this issue Sep 23, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants