Missing table pubsub_state in ejabberd

Question

I have ejabberd working well but my logs are filling up with references to a missing table pubsub_state. I have a bunch of other tables with that prefix but not that one. Where can I find the definition so that I can add it?

I am using PostgreSQL as my back end.

score 1 · Accepted Answer · answered Dec 26 '19 at 16:08

1

The definition is in pg.sql but it's strange it wasn't created when you created the other tables... https://github.com/processone/ejabberd/blob/master/sql/pg.sql#L243

answered Dec 26 '19 at 16:08

Badlop

3,840
1
8
9

That was it. Thanks. – D'Arcy Mar 02 '20 at 15:55
As I was adding the definition in I noticed there was an empty table named pubsu_state. Very odd. – D'Arcy Mar 02 '20 at 15:56

Missing table pubsub_state in ejabberd

1 Answers1