Repository navigation
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. #65
Description
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": [
Activity
vitormattos commentedon Apr 13, 2026
@Kupers could you test again with newest release?
Sjoerd001 commentedon Apr 14, 2026
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 commentedon Apr 14, 2026
@Sjoerd001 what's your database system, MySQL, MaiaDB, PostgreSQL, SQLite, Oracle? And what's the version of your database system?
fix(migration): set explicit primary key and index names for Oracle c…
Sjoerd001 commentedon Apr 14, 2026
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 commentedon Apr 14, 2026
Aplied #65 to v1.0.2 and app can now be installed and enabled. Thanks you for your quick response.
vitormattos commentedon Apr 14, 2026
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 commentedon Apr 14, 2026
Running v1.0.3
occ maintenance:repairerrors out(Create a new issue for this?)
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 commentedon Apr 15, 2026
Seems to be fixed now with v1.0.4