Database error: "zerver_realmfilter does not exist at character 146"

[zulip]

Database error: "zerver_realmfilter does not exist at character 146"

[galexrt]

@decker502 Could you provide the image id?
I think this happens, because of a "failed" Zulip database migration. When I have the image id, I can give you more help.

[galexrt]

@decker502 I updated the wiki page for ssl configuration.
The error you are having isn't related to the ssl certs.
The error is seems to be an problem with the tables in the database.
Can you try to clear all volume folders from zulip and the database and start it up again.

BTW I'm currently on the IRC.

[decker502]

@galexrt The images id is 4986116b2c48.

Can you try to clear all volume folders from zulip and the database and start it up again

I have tried it first time when I met the error.
If I clear all volume folders it works well. But if I clear all folders expect certs folder , I will get error.

Because I am tring to use myself certs files.

[galexrt]

@decker502 Have you checked the updated wiki page for it? I added how the certificate file names have to be.

Could you run the container with docker-compose and stop it after it started and do a find /opt/docker/zulip/zulip (replace /opt/docker/zulip/zulip with your actual host volume path and then please post the output here.

[decker502]

@galexrt

the output:

[root@localhost docker-zulip]# find /home/app/zulip/zulip
/home/app/zulip/zulip
/home/app/zulip/zulip/uploads
/home/app/zulip/zulip/uploads/uploads
/home/app/zulip/zulip/certs
/home/app/zulip/zulip/certs/zulip.combined-chain.crt
/home/app/zulip/zulip/certs/zulip.key
/home/app/zulip/zulip/zulip-settings.py
/home/app/zulip/zulip/.zulip-1.3.7
/home/app/zulip/zulip/.initiated
/home/app/zulip/zulip/zulip-secrets.conf

[galexrt]

Issue resolved in IRC.
Database error seems to come from problems in Zulips database migration.

[shilov]

Got the same problem. Would love to know how to fix this.

[galexrt]

@shilov Please create a new ticket with your logs, so I can look at it. Thanks.