nextcloud / nextcloud/fulltextsearch

Problems reinstalling

Open
#880 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

0. Needs triage bug
Dominant language
PHP
Stars
234
Forks
64
Avg merge
6h 18m
Merged PRs (30d)
10

Description

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"
}
}

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing the failure with the reported PostgreSQL setup and the fulltextsearch:test command, checking why oc_fulltextsearch_ticks was not created during reinstall. Trace the installation or migration entry point responsible for that table; done means a clean reinstall creates the table and the test completes successfully.

Written by the indexing model from the issue text.

Assessment

Tech stack
elasticsearch, php, postgresql
Domain
backend, database
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.