all-in-aigc/sorafm

error: relation "videos" does not exist

ozbillwang opened this issue · 4 comments

ozbillwang commented

got the error when deploy to vercel

error: relation "videos" does not exist

image

duplicated the issue when run locally

image

image

ozbillwang commented

ok, fixed with this command

psql "postgres://USER:PASSWORD@HOST/DB" -f data/install.sql
joostshao commented

suck

Bloomingg commented

I encountered the same problem, can you tell me how to solve it? I didn't find where to enter the instructions when deploying on vercel

ozbillwang commented

I encountered the same problem, can you tell me how to solve it? I didn't find where to enter the instructions when deploying on vercel

In the readme,

image

After create the postgresql database, we need Initialize the database. The sql file is in the source code at data/install.sql

if you familar the psql command, the simpliest way is

psql "postgres://USER:PASSWORD@HOST/DB" -f data/install.sql

the part of "postgres://USER:PASSWORD@HOST/DB" is the psql connection string when you created the postgresql.

If you don't have the psql command, you need install it first, please refer Postgresql official document for help.