Database error when running migration 1000Date20260309120000 for app profile_fields Index name "oc_profile_fields_definitions"."profile_fields_def_active_order_idx" is too long.

[Kupers]

Now another error
"version": "32.0.8.2",
"exception": {
"Exception": "InvalidArgumentException",
"Message": "Index name "oc_profile_fields_definitions"."profile_fields_def_active_order_idx" is too long.",
"Code": 0,
"Trace": [

[vitormattos]

@Kupers could you test again with newest release?

[Sjoerd001]

Some her for me:
Latest version 1.0.2 on Nextcloud 32.0.8.2

{
  "reqId": "ad5IESfYyMLDpVqKdBWoKAAATgI",
  "level": 3,
  "time": "April 14, 2026 15:58:45",
  "remoteAddr": "x::x",
  "user": "x",
  "app": "settings",
  "method": "POST",
  "url": "/index.php/settings/apps/enable",
  "scriptName": "/index.php",
  "message": "could not enable apps",
  "userAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36",
  "version": "32.0.8.2",
  "exception": {
    "Exception": "InvalidArgumentException",
    "Message": "Primary index name on \"oc_profile_fields_definitions\" is too long.",
    "Code": 0,
    "Trace": [
      {
        "file": "/usr/share/nextcloud/lib/private/DB/MigrationService.php",
        "line": 436,
        "function": "ensureOracleConstraints",
        "class": "OC\\DB\\MigrationService",
        "type": "->"
      },
      {
        "file": "/usr/share/nextcloud/lib/private/DB/MigrationService.php",
        "line": 391,
        "function": "migrateSchemaOnly",
        "class": "OC\\DB\\MigrationService",
        "type": "->"
      },
      {
        "file": "/usr/share/nextcloud/lib/private/Installer.php",
        "line": 545,
        "function": "migrate",
        "class": "OC\\DB\\MigrationService",
        "type": "->"
      },
      {
        "file": "/usr/share/nextcloud/lib/private/Installer.php",
        "line": 93,
        "function": "installAppLastSteps",
        "class": "OC\\Installer",
        "type": "->"
      },
      {
        "file": "/usr/share/nextcloud/apps/settings/lib/Controller/AppSettingsController.php",
        "line": 581,
        "function": "installApp",
        "class": "OC\\Installer",
        "type": "->"
      },
      {
        "file": "/usr/share/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
        "line": 204,
        "function": "enableApps",
        "class": "OCA\\Settings\\Controller\\AppSettingsController",
        "type": "->"
      },
      {
        "file": "/usr/share/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
        "line": 118,
        "function": "executeController",
        "class": "OC\\AppFramework\\Http\\Dispatcher",
        "type": "->"
      },
      {
        "file": "/usr/share/nextcloud/lib/private/AppFramework/App.php",
        "line": 153,
        "function": "dispatch",
        "class": "OC\\AppFramework\\Http\\Dispatcher",
        "type": "->"
      },
      {
        "file": "/usr/share/nextcloud/lib/private/Route/Router.php",
        "line": 321,
        "function": "main",
        "class": "OC\\AppFramework\\App",
        "type": "::"
      },
      {
        "file": "/usr/share/nextcloud/lib/base.php",
        "line": 1091,
        "function": "match",
        "class": "OC\\Route\\Router",
        "type": "->"
      },
      {
        "file": "/usr/share/nextcloud/index.php",
        "line": 25,
        "function": "handleRequest",
        "class": "OC",
        "type": "::"
      }
    ],
    "File": "/usr/share/nextcloud/lib/private/DB/MigrationService.php",
    "Line": 632,
    "message": "could not enable apps",
    "exception": {},
    "CustomMessage": "could not enable apps"
  }
}

[vitormattos]

@Sjoerd001 what's your database system, MySQL, MaiaDB, PostgreSQL, SQLite, Oracle? And what's the version of your database system?

[Sjoerd001]

Sorry forgot to mention:

• System
  OS: Linux 6.18.13-200.fc43.x86_64 x86_64
  processor: Intel(R) Core(TM) i7 CPU 965 @ 3.20GHz (8 Threads)
  web server: Apache/2.4.66 (Fedora Linux) OpenSSL/3.5.4 mod_auth_gssapi/1.6.5 mod_fcgid/2.3.9 SVN/1.14.5 mod_wsgi/5.0.2 Python/3.14 mod_perl/2.0.13 Perl/v5.42.0 - without reverse proxy

• database
  Servertype: MariaDB
  Serververbinding: SSL wordt niet gebruikt Documentatie
  Serverversie: 10.11.16-MariaDB-log - MariaDB Server
  Protocolversie: 10
  Karakterset van server: UTF-8 Unicode (utf8mb4)

• PHP
  version: 8.4.18
  memory limit: 4 GB
  max execution time: 3600
  max upload size: 10G
  opcache freq: 2
  extensions:

apcu, bcmath, bz2, calendar, cgi-fcgi, Core, ctype, curl, date, dom, enchant, exif, fileinfo, filter, ftp, gd, geoip, gettext, gmp, guestfs_php, hash, http, iconv, igbinary, imagick, inotify, intl, json, krb5, ldap, libsmbclient, libvirt, libxml, lzf, mailparse, mbstring, mcrypt, memcache, memcached, msgpack, mysqli, mysqlnd, OAuth, odbc, openssl, pcre, PDO, pdo_mysql, PDO_ODBC, pdo_pgsql, pdo_sqlite, pgsql, Phar, phpiredis, posix, random, raphf, redis, Reflection, rpminfo, session, shmop, SimpleXML, smbclient, snmp, soap, sockets, sodium, SPL, sqlite3, ssh2, standard, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, uuid, xml, xmlreader, xmlrpc, xmlwriter, xsl, yaml, Zend OPcache, zip, zlib, zstd

[Sjoerd001]

Aplied #65 to v1.0.2 and app can now be installed and enabled. Thanks you for your quick response.

[vitormattos]

Hey! Glad to see this was fixed for you @Sjoerd001 🙂

Just as a note, improvements like this are only possible thanks to community support. If this (or LibreSign in general) is bringing value to you, consider supporting the project with a recurring sponsor.

It helps us keep improving not only LibreSign, but also related tools like this one.

By the way, we’d love to hear how this app is helping your workflow, whether at home or in your organization.

If you have a moment, giving a star here and on the LibreSign repository, or leaving a review on the Nextcloud app store, also helps us a lot. And if you haven’t checked LibreSign yet, it might be worth a look 🙂

Thanks again for your feedback and support!

[Sjoerd001]

Running v1.0.3 occ maintenance:repair errors out
(Create a new issue for this?)

• Repair orphaned profile field values
  An unhandled exception has been thrown:
  Error: Call to undefined method OC\DB\ResultAdapter::fetchFirstColumn() in /var/lib/nextcloud/apps/profile_fields/lib/Db/FieldValueMapper.php:101
  Stack trace:
  #0 /var/lib/nextcloud/apps/profile_fields/lib/Service/OrphanedFieldValueCleanupService.php(38): OCA\ProfileFields\Db\FieldValueMapper->findDistinctUserUids()
  chore(deps): Bump shivammathur/setup-php from 2.36.0 to 2.37.0 #1 /var/lib/nextcloud/apps/profile_fields/lib/Repair/OrphanedFieldValueRepairStep.php(29): OCA\ProfileFields\Service\OrphanedFieldValueCleanupService->repairOrphanedValues()
  chore(deps): Bump @nextcloud/vue from 9.5.0 to 9.6.0 #2 /usr/share/nextcloud/lib/private/Repair.php(107): OCA\ProfileFields\Repair\OrphanedFieldValueRepairStep->run()
  chore(deps): Bump dorny/paths-filter from 3.0.2 to 4.0.1 #3 /usr/share/nextcloud/core/Command/Maintenance/Repair.php(99): OC\Repair->run()
  chore(deps): Bump fsfe/reuse-action from 5 to 6 #4 /usr/share/nextcloud/3rdparty/symfony/console/Command/Command.php(326): OC\Core\Command\Maintenance\Repair->execute()
  feat: add versioned import contract foundation #5 /usr/share/nextcloud/3rdparty/symfony/console/Application.php(1083): Symfony\Component\Console\Command\Command->run()
  chore: organize code #6 /usr/share/nextcloud/3rdparty/symfony/console/Application.php(324): Symfony\Component\Console\Application->doRunCommand()
  chore: reduce command dize #7 /usr/share/nextcloud/3rdparty/symfony/console/Application.php(175): Symfony\Component\Console\Application->doRun()
  feat: f4a admin search #8 /usr/share/nextcloud/lib/private/Console/Application.php(187): Symfony\Component\Console\Application->run()
  build(deps): Bump svenstaro/upload-release-action from 2.11.4 to 2.11.5 #9 /usr/share/nextcloud/console.php(90): OC\Console\Application->run()
  build(deps-dev): Bump vimeo/psalm from 6.15.1 to 6.16.0 in /vendor-bin/psalm #10 /usr/share/nextcloud/occ(33): require_once('...')

[Sjoerd001]

Seems to be fixed now with v1.0.4

• Repair orphaned profile field values
  • Profile fields: removed 0 orphaned values across 0 missing users after checking 2 user IDs.