Problems reinstalling

[valdearg]

How to use GitHub

• Please use the 👍 reaction to show that you are affected by the same issue.
• Please don't comment if you have no relevant information to add. It's just extra noise for everyone subscribed to this issue.
• Subscribe to receive notifications on status change and new comments.

---

Been having some trouble with the extension, I previously had this installed a number of years back, but I removed it as there was an issue with the ES VM, so I disabled and removed the plugin.

I've decided to try this again by re-installing it. When I reinstalled the app, I ran the test, it ran successfully. I then ran the index and it just loaded and then closed.

I've seen some comments about completely removing the apps and setting it up again. I've dropped the two database tables, I saw there was a lot of settings in the oc_appconfig table, so removed those also.

I then re-installed all the apps once more, just grabbing from the store, then setup with the details.

However the test fails as it doesn't seem to have created the tables in the database.

Expected behaviour

Tables should be created.

Actual behaviour

Fails on the oc_fulltextsearch_ticks table.

Testing your current setup:
Creating mocked content provider. ok
Testing mocked provider: get indexable documents. (2 items) ok
Loading search platform. (Elasticsearch) ok
Testing search platform. ok
Locking process fail
In ExceptionConverter.php line 71:

  An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "oc_fulltextsearch_ticks" does not exist
  LINE 1: ...ick", "t"."tick", "t"."status", "t"."action" FROM "oc_fullte...
                                                               ^
In Exception.php line 28:

  SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "oc_fulltextsearch_ticks" does not exist
  LINE 1: ...ick", "t"."tick", "t"."status", "t"."action" FROM "oc_fullte...
                                                               ^
In Statement.php line 130:

  SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "oc_fulltextsearch_ticks" does not exist
  LINE 1: ...ick", "t"."tick", "t"."status", "t"."action" FROM "oc_fullte...
                                                               ^
fulltextsearch:test [--output [OUTPUT]] [-j|--json] [-d|--platform_delay PLATFORM_DELAY]

Server configuration

Web server: Apache

Database: PostgreSQL

PHP version: 8.2

Nextcloud version: 29.0.5

List of activated apps

If you have access to your command line run e.g.:
sudo -u www-data php occ app:list
from within your Nextcloud installation folder

Enabled:
  - activity: 2.21.1
  - app_api: 3.1.0
  - cloud_federation_api: 1.12.0
  - comments: 1.19.0
  - dav: 1.30.1
  - extract: 1.3.7
  - federatedfilesharing: 1.19.0
  - federation: 1.19.0
  - files: 2.1.1
  - files_archive: 1.2.3
  - files_downloadlimit: 2.0.0
  - files_external: 1.21.0
  - files_fulltextsearch: 29.0.1
  - files_pdfviewer: 2.10.0
  - files_reminders: 1.2.0
  - files_sharing: 1.21.0
  - files_trashbin: 1.19.0
  - files_versions: 1.22.0
  - firstrunwizard: 2.18.0
  - fulltextsearch: 29.0.1
  - fulltextsearch_elasticsearch: 29.0.1
  - logreader: 2.14.0
  - lookup_server_connector: 1.17.0
  - nextcloud_announcements: 1.18.0
  - notifications: 2.17.0
  - oauth2: 1.17.0
  - password_policy: 1.19.0
  - photos: 2.5.0
  - privacy: 1.13.0
  - provisioning_api: 1.19.0
  - recommendations: 2.1.0
  - related_resources: 1.4.0
  - serverinfo: 1.19.0
  - settings: 1.12.0
  - sharebymail: 1.19.0
  - support: 1.12.0
  - survey_client: 1.17.0
  - systemtags: 1.19.0
  - text: 3.10.1
  - theming: 2.4.0
  - twofactor_backupcodes: 1.18.0
  - twofactor_totp: 11.0.0-dev
  - unroundedcorners: 1.1.3
  - updatenotification: 1.19.1
  - user_saml: 6.2.0
  - viewer: 2.3.0
  - webhooks: 0.4.3
  - workflow_media_converter: 1.11.7
  - workflow_script: 1.14.1
  - workflowengine: 2.11.0
Disabled:
  - admin_audit: 1.19.0
  - bruteforcesettings: 2.9.0
  - circles: 29.0.0-dev (installed 22.0.0)
  - contactsinteraction: 1.10.0 (installed 1.2.0)
  - dashboard: 7.9.0 (installed 7.0.0)
  - encryption: 2.17.0
  - files_rightclick: 0.15.1 (installed 1.6.0)
  - files_zip: 1.6.0 (installed 1.6.0)
  - sociallogin: 5.6.6 (installed 5.6.6)
  - suspicious_login: 7.0.0
  - user_ldap: 1.20.0
  - user_status: 1.9.0 (installed 1.1.1)
  - weather_status: 1.9.0 (installed 1.1.0)

Nextcloud configuration

If you have access to your command line run e.g.:
sudo -u www-data php occ config:list system
from within your Nextcloud installation folder

{
"system": {
"instanceid": "REMOVED SENSITIVE VALUE",
"passwordsalt": "REMOVED SENSITIVE VALUE",
"secret": "REMOVED SENSITIVE VALUE",
"trusted_domains": [
"blair.neko.network",
"cloud.neko.network"
],
"datadirectory": "REMOVED SENSITIVE VALUE",
"dbtype": "pgsql",
"version": "29.0.5.1",
"overwrite.cli.url": "https://cloud.neko.network",
"dbname": "REMOVED SENSITIVE VALUE",
"dbhost": "REMOVED SENSITIVE VALUE",
"dbport": "",
"dbtableprefix": "oc_",
"mysql.utf8mb4": true,
"dbuser": "REMOVED SENSITIVE VALUE",
"dbpassword": "REMOVED SENSITIVE VALUE",
"installed": true,
"maintenance": false,
"theme": "",
"htaccess.RewriteBase": "/",
"memcache.local": "\OC\Memcache\APCu",
"redis": {
"host": "REMOVED SENSITIVE VALUE",
"port": 6379
},
"memcache.locking": "\OC\Memcache\Redis",
"memcache.distributed": "\OC\Memcache\Redis",
"mail_from_address": "REMOVED SENSITIVE VALUE",
"mail_smtpmode": "smtp",
"mail_sendmailmode": "smtp",
"mail_domain": "REMOVED SENSITIVE VALUE",
"mail_smtpauthtype": "LOGIN",
"mail_smtpauth": 1,
"mail_smtphost": "REMOVED SENSITIVE VALUE",
"mail_smtpport": "587",
"mail_smtpname": "REMOVED SENSITIVE VALUE",
"mail_smtppassword": "REMOVED SENSITIVE VALUE",
"updater.release.channel": "stable",
"check_data_directory_permissions": false,
"log_rotate_size": 104857600,
"app_install_overwrite": [
"files_reader",
"breezedark",
"fulltextsearch",
"fulltextsearch_elasticsearch",
"files_fulltextsearch",
"occweb",
"metadata",
"twofactor_totp",
"extract",
"podcast",
"webhooks",
"workflow_script",
"previewgenerator",
"files_archive",
"bookmarks_fulltextsearch",
"memories"
],
"enable_previews": true,
"enabledPreviewProviders": [
"OC\Preview\MP3",
"OC\Preview\TXT",
"OC\Preview\MarkDown",
"OC\Preview\OpenDocument",
"OC\Preview\Krita",
"OC\Preview\Movie",
"OC\Preview\Imaginary"
],
"preview_imaginary_url": "REMOVED SENSITIVE VALUE",
"default_phone_region": "ISO 3166-2:GB",
"loglevel": 2,
"log_type": "file",
"logfile": "/home/valdearg/nextcloud_data/nextcloud.log",
"log_type_audit": "file",
"logfile_audit": "audit.log",
"preview_max_memory": -1,
"memories.exiftool": "/var/www/nextcloud/apps/memories/bin-ext/exiftool-amd64-glibc",
"bulkupload.enabled": false,
"memories.vod.path": "/var/www/nextcloud/apps/memories/bin-ext/go-vod-amd64",
"memories.vod.ffmpeg": "/usr/bin/ffmpeg",
"memories.vod.ffprobe": "/usr/bin/ffprobe",
"ALLOW_SELF_SIGNED_CERT": "true",
"preview_ffmpeg_path": "/usr/bin/ffmpeg",
"memories.gis_type": 2,
"preview_concurrency_new": "8",
"preview_concurrency_all": "16"
}
}