search

ned-kelly / docker-multicontainer-libretime

A multi-container deployment of the Libretime Radio Broadcast Server, PostgreSQL, Icecast2 & RabbitMQ, all based on Ubuntu Xenial & Alpine Linux!
56 stars 22 forks source link

Postgres error #15

Closed NobilisNC closed 5 years ago

NobilisNC commented 5 years ago

Hello,

I tried to run docker-compose up -d but I have this error.

libretime-postgres    | ERROR:  relation "cc_pref" does not exist at character 72
libretime-postgres    | STATEMENT:  SELECT cc_pref.id, cc_pref.subjid, cc_pref.keystr, cc_pref.valstr FROM cc_pref WHERE cc_pref.keystr=$1 LIMIT 1
frecuencialibre commented 5 years ago

did this happen upon fresh container creation or on subsequent iterations?

I've seen errors like this too, which I've guessed are caused by the Libretime database tables etc. not existing due to the install script not having run. I haven't yet taken the time troubleshoot, but in my case docker was re-creating containers from existing caches, and also I'd touched the postgresql folder on the host machine where the libretime-postgres container stores data.

ned-kelly commented 5 years ago

If this is a new install - and you don't mind losing your old files, try blowing away your working directly and then re-cloning this project and re-installing ... otherwise, you can manually remove the postgresql - you will lose all references to any media you've uploaded and libretime configurations however.

falcon03 commented 5 years ago

@ned-kelly having the same issue on a fresh installation, any ideas on what might be causing the problem?

funkeeflow commented 5 years ago

Hi Guys, having the same issue, any hints any this?

ballPointPenguin commented 4 years ago

same issue on fresh installation. Is there a database migration script that needs to be run?

ballPointPenguin commented 4 years ago

Looking at the libretime database in pgAdmin, it appears to have no tables. Somewhere a step to create the db tables is being skipped? I'm not sure where/when that is supposed to happen.

paqstd-dev commented 3 years ago

@ned-kelly I have the same problem. I deleted the entire folder several times. Need to help

crudexec commented 3 years ago

same issue any help here @ned-kelly

newuser0109 commented 3 years ago

same issue with fresh intall is there any older docker image that works