Recreating fulltextsearch Database Tables

While trying to migrate from a local to remote elasticsearch instance, I deleted the oc_fulltextsearch_ticks and oc_fulltextsearch_indexes tables from the nextcloud database.

How can I recreate them? I would greatly prefer not to have to recreate the full database from scratch.

Nextcloud version (eg, 18.0.2): 21.0.0
Operating system and version (eg, Ubuntu 20.04): CentOS 8 w/ Kernel 4.18
Apache or nginx version (eg, Apache 2.4.25): Apache 2.4
PHP version (eg, 7.1): 8.0.3

fulltextsearch app version: 21

Edit I resolved this by running:
DELETE FROM oc_migrations WHERE app='fulltextsearch';
DELETE FROM oc_preferences WHERE appid='fulltextsearch';

in mysql. Anytime app tables are dropped from the nextcloud database, it seems they must also be removed from these two tables, else they can’t recreate the tables when they are reinstalled.

Now I’ve got a separate issue whereby occ fulltextsearch:index doesn’t seem to index any of my files.
Thanks so much,

1 Like