Hallo zusammen,
ich reihe mich in die zahlreichen kleinen Fehler ein, die nach einem Update auftauchen können wie es aussieht.
Ich betreibe seit einiger Zeit die containerisierte Version von Dolibarr mit Docker Compose. Nun habe ich bei dem Versuch meinen Webshop einzubinden bemerkt, dass die Tuxgasy Docker Version schon ein Jahr keine Updates mehr erhält. Deshalb habe ich umgestellt und dolibarr/dolibarr als Quelle angegeben und damit auf 23.0.2 aktualisiert. Dabei habe ich den Install Lock gelöscht und dann mit die Datenbank angepasst. Als Quelle diente mit dolibarr/dolibarr - Docker Image
Leider bekomme ich seit dem Update beim Anmelden in Firefox folgenden Fehler:
Unknown column 'u.accountancy_code_user_general' in 'SELECT'
Die Docker logs sind ziemlich ereignislos
web-1 | docker-run.sh started
web-1 | [INIT] => update PHP Config …
web-1 | [INIT] => update Dolibarr Config …
web-1 | mkdir: cannot create directory ‚/var/www/html/conf‘: File exists
web-1 | [INIT] => update Dolibarr Config with instance unique id …
web-1 | [INIT] => update ownership for file in Dolibarr Config …
web-1 | Current Version of files is : 23.0.2
web-1 | DOLI_INSTALL_AUTO is on, so we check to initialize or upgrade mariadb database
web-1 | Waiting that SQL database is up …
web-1 | Waiting that SQL database is up …
mariadb-1 | 2026-06-11 12:58:21+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:12.3.2+maria~ubu2404 started.
mariadb-1 | 2026-06-11 12:58:22+00:00 [Warn] [Entrypoint]: /sys/fs/cgroup///memory.pressure not writable, functionality unavailable to MariaDB
mariadb-1 | 2026-06-11 12:58:22+00:00 [Note] [Entrypoint]: Switching to dedicated user ‚mysql‘
mariadb-1 | 2026-06-11 12:58:22+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:12.3.2+maria~ubu2404 started.
mariadb-1 | 2026-06-11 12:58:22+00:00 [Note] [Entrypoint]: MariaDB upgrade (mariadb-upgrade or creating healthcheck users) required, but skipped due to $MARIADB_AUTO_UPGRADE setting
mariadb-1 | 2026-06-11 12:58:22 0 [Note] Starting MariaDB 12.3.2-MariaDB-ubu2404 source revision 9f98f82b14a9b939834281672b6d0cf965db69a3 server_uid eEd9ii5YAGIwKFnunO3BCnpZ4xg= as process 1
mariadb-1 | 2026-06-11 12:58:22 0 [Note] InnoDB: Compressed tables use zlib 1.3
mariadb-1 | 2026-06-11 12:58:22 0 [Note] InnoDB: Number of transaction pools: 1
mariadb-1 | 2026-06-11 12:58:22 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
mariadb-1 | 2026-06-11 12:58:22 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
mariadb-1 | 2026-06-11 12:58:22 0 [Warning] mariadbd: io_uring_queue_init() failed with EPERM: sysctl kernel.io_uring_disabled has the value 2, or 1 and the user of the process is not a member of sysctl kernel.io_uring_group. (see man 2 io_uring_setup).
mariadb-1 | create_uring failed: falling back to libaio
mariadb-1 | 2026-06-11 12:58:22 0 [Note] InnoDB: Using Linux native AIO
mariadb-1 | 2026-06-11 12:58:22 0 [Note] InnoDB: innodb_buffer_pool_size_max=8388608m, innodb_buffer_pool_size=128m
mariadb-1 | 2026-06-11 12:58:22 0 [Note] InnoDB: Completed initialization of buffer pool
mariadb-1 | 2026-06-11 12:58:22 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
mariadb-1 | 2026-06-11 12:58:22 0 [Note] InnoDB: End of log at LSN=23898822
mariadb-1 | 2026-06-11 12:58:22 0 [Note] InnoDB: Opened 3 undo tablespaces
mariadb-1 | 2026-06-11 12:58:22 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
mariadb-1 | 2026-06-11 12:58:22 0 [Note] InnoDB: Setting file ‚./ibtmp1‘ size to 12.000MiB. Physically writing the file full; Please wait …
mariadb-1 | 2026-06-11 12:58:22 0 [Note] InnoDB: File ‚./ibtmp1‘ size is now 12.000MiB.
mariadb-1 | 2026-06-11 12:58:22 0 [Note] InnoDB: log sequence number 23898822; transaction id 25794
mariadb-1 | 2026-06-11 12:58:22 0 [Note] Plugin ‚FEEDBACK‘ is disabled.
mariadb-1 | 2026-06-11 12:58:22 0 [Note] Plugin ‚wsrep-provider‘ is disabled.
mariadb-1 | 2026-06-11 12:58:22 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
mariadb-1 | 2026-06-11 12:58:22 0 [Note] InnoDB: Buffer pool(s) load completed at 260611 12:58:22
mariadb-1 | 2026-06-11 12:58:24 0 [Note] Server socket created on IP: ‚0.0.0.0‘, port: ‚3306‘.
mariadb-1 | 2026-06-11 12:58:24 0 [Note] Server socket created on IP: ‚::‘, port: ‚3306‘.
mariadb-1 | 2026-06-11 12:58:24 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
mariadb-1 | 2026-06-11 12:58:24 0 [Note] mariadbd: ready for connections.
mariadb-1 | Version: ‚12.3.2-MariaDB-ubu2404‘ socket: ‚/run/mysqld/mysqld.sock‘ port: 3306 ``mariadb.org`` binary distribution
web-1 | DB Exists is : dolibarr
web-1 | Install.lock Exists is : no
web-1 | Database Version is : 23.0.2
web-1 | Files Version are : 23.0.2
web-1 | Schema update is not required … Enjoy !
web-1 | usermod: no changes
web-1 | Update ownership for files in /var/www/documents …
web-1 |
web-1 | *** You can connect to the docker Mariadb with:
web-1 | sudo docker exec -it nameofwebcontainer-mariadb-1 bash
web-1 | mariadb -uroot -p’MYSQL_ROOT_PASSWORD’ -h localhost
web-1 | or
web-1 | mariadb -uxxx -p’yyy’ -h mariadb with xxx in /run/secrets/mysql-user and yyy in /run/secrets/mysql-password if these files were used in docker-compose.yml
web-1 | ls /var/lib/mysql
web-1 |
web-1 | *** You can connect to the docker Dolibarr with:
web-1 | sudo docker exec -it nameofwebcontainer-web-1 bash
web-1 | ls /var/www/documents
web-1 | ls /var/www/html
web-1 |
web-1 | *** You can access persistent directory from the host with:
web-1 | ls /home/dolibarr_mariadb_latest
web-1 | ls /home/dolibarr_documents_latest
web-1 | ls /home/dolibarr_custom_latest
web-1 |
web-1 | *** You can connect to the running Dolibarr web application with:
web-1 | ``http://127.0.0.1``:port
web-1 |
web-1 | AH00558: apache2: Could not reliably determine the server’s fully qualified domain name, using 172.23.0.3. Set the ‚ServerName‘ directive globally to suppress this message
web-1 | AH00558: apache2: Could not reliably determine the server’s fully qualified domain name, using 172.23.0.3. Set the ‚ServerName‘ directive globally to suppress this message
web-1 | [Thu Jun 11 12:58:26.644461 2026] [mpm_prefork:notice] [pid 1:tid 1] AH00163: Apache/2.4.67 (Debian) configured – resuming normal operations
web-1 | [Thu Jun 11 12:58:26.644626 2026] [core:notice] [pid 1:tid 1] AH00094: Command line: ‚apache2 -D FOREGROUND‘
web-1 | 172.18.0.10 - - [11/Jun/2026:12:59:46 +0000] „GET /index.php?mainmenu=home HTTP/1.1“ 200 3010 „``https://erp``./" „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:12:59:46 +0000] „GET /theme/dolibarr_logo.svg HTTP/1.1“ 200 4970 "``https://erp``./index.php?mainmenu=home“ „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:12:59:46 +0000] „GET /theme/eldy/style.css.php?lang=de_DE&theme=eldy&entity=1&layout=classic&version=23.0.2&revision=41 HTTP/1.1“ 202 307368 „``https://erp``./index.php?mainmenu=home" „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:12:59:47 +0000] „GET /theme/apple-touch-icon.png HTTP/1.1“ 200 1408 "``https://erp``./index.php?mainmenu=home“ „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:12:59:47 +0000] „GET /viewimage.php?cache=1&modulepart=mycompany&file=logos%2Fthumbs%2FKraftw3rk-Logo_quadrat_mini.png HTTP/1.1“ 200 5150 „``https://erp``./index.php?mainmenu=home" „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:12:59:50 +0000] „POST /index.php?mainmenu=home HTTP/1.1“ 302 422 "``https://erp``./index.php?mainmenu=home“ „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:12:59:51 +0000] „GET /index.php?mainmenu=home HTTP/1.1“ 200 3050 „``https://erp``./index.php?mainmenu=home" „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:12:59:51 +0000] „GET /theme/eldy/style.css.php?lang=de_DE&theme=eldy&entity=1&layout=classic&version=23.0.2&revision=41 HTTP/1.1“ 202 307368 "``https://erp``./index.php?mainmenu=home“ „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:14:39:27 +0000] „GET / HTTP/1.1“ 200 3016 „-“ „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:14:39:28 +0000] „GET /includes/jquery/plugins/jnotify/jquery.jnotify-alt.min.css?layout=classic&version=23.0.2 HTTP/1.1“ 200 935 „``https://erp``./" „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:14:39:28 +0000] „GET /includes/jquery/plugins/jnotify/jquery.jnotify.min.js?layout=classic&version=23.0.2 HTTP/1.1“ 200 1722 "``https://erp``./“ „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:14:39:28 +0000] „GET /includes/jquery/plugins/select2/dist/css/select2.css?layout=classic&version=23.0.2 HTTP/1.1“ 200 2535 „``https://erp``./" „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:14:39:28 +0000] „GET /includes/jquery/plugins/multiselect/jquery.multi-select.js?layout=classic&version=23.0.2 HTTP/1.1“ 200 2909 "``https://erp``./“ „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:14:39:28 +0000] „GET /theme/common/fontawesome-5/css/all.min.css?layout=classic&version=23.0.2 HTTP/1.1“ 200 13146 „``https://erp``./" „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:14:39:28 +0000] „GET /includes/jquery/plugins/select2/dist/js/select2.full.min.js?layout=classic&version=23.0.2 HTTP/1.1“ 200 22326 "``https://erp``./“ „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:14:39:28 +0000] „GET /core/js/dst.js?lang=de_DE HTTP/1.1“ 200 2534 „``https://erp``./" „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:14:39:28 +0000] „GET /theme/dolibarr_logo.svg HTTP/1.1“ 200 4970 "``https://erp``./“ „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:14:39:28 +0000] „GET /includes/jquery/css/base/jquery-ui.css?layout=classic&version=23.0.2 HTTP/1.1“ 200 8663 „``https://erp``./" „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:14:39:28 +0000] „GET /includes/jquery/js/jquery.min.js?layout=classic&version=23.0.2 HTTP/1.1“ 200 31337 "``https://erp``./“ „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:14:39:28 +0000] „GET /includes/jquery/js/jquery-ui.min.js?layout=classic&version=23.0.2 HTTP/1.1“ 200 68293 „``https://erp``./" „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:14:39:28 +0000] „GET /theme/eldy/style.css.php?lang=de_DE&theme=eldy&entity=1&layout=classic&version=23.0.2&revision=41 HTTP/1.1“ 202 307368 "``https://erp``./“ „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:14:39:28 +0000] „GET /core/js/lib_head.js.php?lang=de_DE&layout=classic&version=23.0.2 HTTP/1.1“ 200 16395 „``https://erp``./" „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:14:39:28 +0000] „GET /theme/common/fontawesome-5/webfonts/fa-solid-900.woff2 HTTP/1.1“ 200 78505 "``https://erp``./theme/common/fontawesome-5/css/all.min.css?layout=classic&version=23.0.2“ „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:14:39:28 +0000] „GET /theme/apple-touch-icon.png HTTP/1.1“ 200 1408 „``https://erp``./" „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:14:39:28 +0000] „GET /viewimage.php?cache=1&modulepart=mycompany&file=logos%2Fthumbs%2FKraftw3rk-Logo_quadrat_mini.png HTTP/1.1“ 200 5150 "``https://erp``./“ „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:14:40:40 +0000] „POST /index.php?mainmenu=home HTTP/1.1“ 302 422 „``https://erp``./" „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:14:40:40 +0000] „GET /index.php?mainmenu=home HTTP/1.1“ 200 3052 "``https://erp``./“ „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:14:40:40 +0000] „GET /theme/eldy/style.css.php?lang=de_DE&theme=eldy&entity=1&layout=classic&version=23.0.2&revision=41 HTTP/1.1“ 202 307368 „``https://erp``./index.php?mainmenu=home" „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:14:43:48 +0000] „POST /index.php?mainmenu=home HTTP/1.1“ 302 422 "``https://erp``./index.php?mainmenu=home“ „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:14:43:48 +0000] „GET /index.php?mainmenu=home HTTP/1.1“ 200 3053 „``https://erp``./index.php?mainmenu=home" „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
web-1 | 172.18.0.10 - - [11/Jun/2026:14:43:48 +0000] „GET /theme/eldy/style.css.php?lang=de_DE&theme=eldy&entity=1&layout=classic&version=23.0.2&revision=41 HTTP/1.1“ 202 307368 "``https://erp``./index.php?mainmenu=home“ „Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0“
Meine Compose File ist ebenfalls nichts besonderes (ja, Nutzer und Passwörter haben verschiedene Namen, sind aber identisch in der .env datei):
services:
mariadb:
image: mariadb:latest
env_file: .env
environment:
MYSQL_ROOT_PASSWORD: ${MYSQL_ROOT_PASSWORD}
MYSQL_DATABASE: ${MYSQL_DATABASE}
volumes:
- dolibarr_mariadb:/var/lib/mysql
restart: unless-stopped
networks:
- internal
web:
# image: tuxgasy/dolibarr
image: dolibarr/dolibarr
environment:
DOLI_ADMIN_PASSWORD: ${DOLI_ADMIN_PASSWORD}
DOLI_ADMIN_LOGIN: ${DOLI_ADMIN_LOGIN}
DOLI_DB_HOST: ${DOLI_DB_HOST}
DOLI_DB_USER: ${DOLI_DB_USER}
DOLI_DB_PASSWORD: ${DOLI_DB_PASSWORD}
DOLI_DB_NAME: ${DOLI_DB_NAME}
DOLI_URL_ROOT: ${DOLI_URL_ROOT}
PHP_INI_DATE_TIMEZONE: 'Europe/Berlin'
DOLI_INSTALL_AUTO: 1
ports:
- "7080:80"
depends_on:
- mariadb
restart: unless-stopped
networks:
- default
- internal
networks:
default:
external: true
name: ***
internal:
external: false
name: dolibarr
volumes:
dolibarr_mariadb:
Da es sich zum Glück nur um eine Instanz handelte die ich für meinen im Aufbau befindlichen Webshop zum Testen benutze waren keine wichtigen Daten drauf. Dennoch wäre es natürlich toll wenn ich das Problem finde und lösen könnte damit andere Instanzen nicht das gleiche Schicksal ereilt wenn ich sie dann update.
Besten Dank im Voraus.
Alex
Edit: Ich habe jetzt mal die conf datei bearbeitet und prod auf 0 gestellt und “passwort vergessen” geklickt, worauf eine etwas hilfreichere Meldung erscheint:
Das System hat einen technischen Fehler festgestellt.
Diese Informationen können für Diagnosezwecke nützlich sein (Sie können die Option $dolibarr_main_prod auf '1' setzen, um sensible Informationen auszublenden):
Datum: 20260611181022
Dolibarr: 23.0.2 - https://www.dolibarr.org
Funktionslevel: 0
Benutzername:
PHP: 8.2.31
Server: Apache
OS: Linux 979dab0594b2 6.1.0-49-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.174-1 (2026-05-26) x86_64
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:151.0) Gecko/20100101 Firefox/151.0
Angefragte URL: /user/passwordforgotten.php
Referer: https://erp.kraftw3rk.de/index.php?mainmenu=home
Menüverwaltung: eldy_menu.php
Module/Anwendungen: api, syslog, user, contrat, supplier_proposal, reception, incoterm, tax, prelevement, product, comptabilite, stock, productbatch, propal, projet, expedition, categorie, knowledgemanagement, agenda, banque, fckeditor, barcode, commande, ecm, eventorganization, facture, fournisseur, ficheinter, margin, partnership, paypal, recruitment, resource, service, societe, stripe, ticket, takepos, variants, website, paymentbybanktransfer, notification
Datenbank Type Manager: mysqli
Letzter Fehlerhafter Datenbankzugriff: SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.prefix, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position, m.showtopmenuinframe FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.type DESC, m.position, m.rowid
Rückgabewert des letzten fehlerhaften Datenbankzugriff: DB_ERROR_NOSUCHFIELD
Information zum letzten fehlerhaften Datenbankzugriff: Unknown column 'm.showtopmenuinframe' in 'SELECT'
Es scheint mir also dass schlicht datenbanspalten fehlen. Ich gehe vorsichtig davon aus dass der sprung von 19.0.2 auf 23.0.2 keine besonders gute Idee war. Best practice ist allerdings eine Warnung zu schreiben, wie der Benutzer hier vorgehen muss. Also immer eine Major Version nach der anderen oder falls spezielle indizes oder dergleichen angepasst werden müssen wäre ein kumulatives update gut.
Gibts es jemanden der mir erklären kann wie ich das fixen oder zumindest bei zwei anderen Instanzen verhindern kann? Ich nehme an sql export (hab ich hier leider vergessen) update, import, im zweifel.
Gruß
