relation "cvterm" does not exist

solgenomics / breedbase_dockerfile

The Dockerfiles for breeDBase

MIT License

8 stars 8 forks source link

relation "cvterm" does not exist #25

Closed billzt closed 3 years ago

billzt commented 3 years ago

I followed the instructions to set a Breedbase instance using composer.

After opening localhost:7080, it shows a message:

Developer message:

DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR:  relation "cvterm" does not exist
LINE 1: SELECT COUNT( * ) FROM cvterm me WHERE ( name = $1 )
                               ^ [for Statement "SELECT COUNT( * ) FROM cvterm me WHERE ( name = ? )" with ParamValues: 1='breeding_program'] at lib/CXGN/BreedersToolbox/Projects.pm line 567

billzt commented 3 years ago

The main reason is that the master branch uses a blank database breedbase/breedbase_pg12.4:v0.5

After changing to https://github.com/solgenomics/breedbase_dockerfile/tree/topic/multiple_compose_files, it has been resolved.

Ural-Yunusbaev commented 2 years ago

I have the same issue. Did you install it on Linux or Windows VB?