Add column fails

[kozmotronik]

Steps to reproduce

1. Just add a new column for any table

Expected behavior

Should create columns

Actual behavior

Can't create columns. and shows failure notification as in the image:

Translation:

Unfortunately an error occured

Couldn't add column. Unknown issue

Tables app version

1.0.1

Browser

Firefox 145

Client operating system

CachyOS Linux

Operating system

Debian 12

Web server

Nginx

PHP engine version

PHP 8.3

Database

MySQL

Additional info

Nextcloud Version: 31.0.11. This issue was reported before in #1881. It fails almost for all types: text, number, date and others. Here is the raw log error message:

Show error message

{
   "app": "tables",
   "exception": {
      "Code": 0,
      "CustomMessage": "An internal error or exception occurred: OCA\\Tables\\Service\\ColumnService - create: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'text_unique' in 'INSERT INTO'",
      "exception": [],
      "Exception": "OCA\\Tables\\Errors\\InternalError",
      "File": "/var/www/nextcloud/apps/tables/lib/Service/ColumnService.php",
      "Line": 249,
      "message": "An internal error or exception occurred: OCA\\Tables\\Service\\ColumnService - create: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'text_unique' in 'INSERT INTO'",
      "Message": "OCA\\Tables\\Service\\ColumnService - create: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'text_unique' in 'INSERT INTO'",
      "Trace": [
         {
            "args": [
               "*** sensitive parameters replaced ***"
            ],
            "class": "OCA\\Tables\\Service\\ColumnService",
            "file": "/var/www/nextcloud/apps/tables/lib/Controller/Api1Controller.php",
            "function": "create",
            "line": 884,
            "type": "->"
         },
         {
            "args": [
               "*** sensitive parameters replaced ***"
            ],
            "class": "OCA\\Tables\\Controller\\Api1Controller",
            "file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
            "function": "createColumn",
            "line": 200,
            "type": "->"
         },
         {
            "class": "OC\\AppFramework\\Http\\Dispatcher",
            "file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
            "function": "executeController",
            "line": 114,
            "type": "->"
         },
         {
            "class": "OC\\AppFramework\\Http\\Dispatcher",
            "file": "/var/www/nextcloud/lib/private/AppFramework/App.php",
            "function": "dispatch",
            "line": 161,
            "type": "->"
         },
         {
            "class": "OC\\AppFramework\\App",
            "file": "/var/www/nextcloud/lib/private/Route/Router.php",
            "function": "main",
            "line": 315,
            "type": "::"
         },
         {
            "class": "OC\\Route\\Router",
            "file": "/var/www/nextcloud/lib/base.php",
            "function": "match",
            "line": 1063,
            "type": "->"
         },
         {
            "class": "OC",
            "file": "/var/www/nextcloud/index.php",
            "function": "handleRequest",
            "line": 24,
            "type": "::"
         }
      ]
   },
   "id": "6926c6b785200",
   "level": 3,
   "message": "An internal error or exception occurred: OCA\\Tables\\Service\\ColumnService - create: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'text_unique' in 'INSERT INTO'",
   "method": "POST",
   "remoteAddr": "212.253.8.111",
   "reqId": "8yK694fMgb0KAiLPI0QI",
   "time": "2025-11-26T09:17:26+00:00",
   "url": "/apps/tables/api/1/columns",
   "user": "ismail",
   "userAgent": "Mozilla/5.0 (X11; Linux x86_64; rv:145.0) Gecko/20100101 Firefox/145.0",
   "version": "31.0.11.2"
}

[AIlkiv]

@kozmotronik I don't know why this happened. It also caught it locally.
You need to re-run the migration Version000920Date20250422000000 (or just add a text_unique bool column to the tables_columns table in the database).

[kozmotronik]

You need to re-run the migration Version000920Date20250422000000

Hey @AIlkiv, thanks for your response. Could you elaborate on this a bit? What command should I run to re-run the migration? Can I do it using one of the occ commands?

[AIlkiv]

This is how I solved the problem:

1. Delete information about this migration from the database SELECT * FROM public.oc_migrations
   WHERE version = ‘000920Date20250422000000’
2. Next, go to tables/appinfo/info.xml and change the version to 1.0.1.1
3. sudo -u www-data php occ app:update

[enjeck]

This is how I solved the problem:

1. Delete information about this migration from the database SELECT * FROM public.oc_migrations
   WHERE version = ‘000920Date20250422000000’
2. Next, go to tables/appinfo/info.xml and change the version to 1.0.1.1
3. sudo -u www-data php occ app:update

There should be an easier way to just run the migration file directly, but I forgot. @blizzz help please