I’ve been running Dolibarr in a container on a synology NAS for more than a year in version 17.0.2 flawlessly. I’ve tried to update to to 19.0 and I seem to be in a loop I can’t fix.
Whenever I hit “Démarrer” = Start in french, to upgrade it just shows a white pages and nothing on it, no error nothing. Here are the log in the container :
[INIT] => update PHP Config ...
[INIT] => update ownership for file in Dolibarr Config ...
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.23.0.2. Set the 'ServerName' directive globally to suppress this message
[INIT] => update ownership for files in /var/www/documents ...
Current Version is : 17.0.2
Last installed Version is : 17.0.2
Schema update is not required ... Enjoy !!
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.23.0.2. Set the 'ServerName' directive globally to suppress this message
[Tue Feb 27 17:26:14.905102 2024] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.38 (Debian) PHP/8.2.7 configured -- resuming normal operations
[Tue Feb 27 17:26:14.905155 2024] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'
172.23.0.1 - - [27/Feb/2024:17:26:22 +0000] "GET / HTTP/1.1" 302 318 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0"
172.23.0.1 - - [27/Feb/2024:17:26:22 +0000] "GET /install/index.php HTTP/1.1" 200 695 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0"
172.23.0.1 - - [27/Feb/2024:17:26:34 +0000] "GET /install/index.php HTTP/1.1" 302 210 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0"
172.23.0.1 - - [27/Feb/2024:17:26:34 +0000] "GET /install/check.php?testget=ok HTTP/1.1" 200 3282 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0"
172.23.0.1 - - [27/Feb/2024:17:26:38 +0000] "GET /install/upgrade.php?action=upgrade_18.0.0&selectlang=fr_FR&versionfrom=17.0.0&versionto=18.0.0 HTTP/1.1" 200 27098 "URLOFMYNAS/install/check.php?testget=ok" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0"
172.23.0.1 - - [27/Feb/2024:17:30:43 +0000] "GET /install/upgrade.php?action=upgrade_18.0.0&selectlang=fr_FR&versionfrom=17.0.0&versionto=18.0.0 HTTP/1.1" 200 27061 "URLOFMYNAS/install/check.php?testget=ok" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0"
172.23.0.1 - - [27/Feb/2024:17:33:17 +0000] "GET /install/check.php?testget=ok HTTP/1.1" 200 3282 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0"
172.23.0.1 - - [27/Feb/2024:17:33:19 +0000] "GET /install/check.php?testget=ok HTTP/1.1" 200 3283 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0"
172.23.0.1 - - [27/Feb/2024:17:31:34 +0000] "GET /install/upgrade.php?action=upgrade_18.0.0&selectlang=fr_FR&versionfrom=17.0.0&versionto=18.0.0 HTTP/1.1" 200 27062 "URLOFMYNAS:5001/install/check.php?testget=ok" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0"
172.23.0.1 - - [27/Feb/2024:17:34:56 +0000] "GET / HTTP/1.1" 302 318 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0"
172.23.0.1 - - [27/Feb/2024:17:34:57 +0000] "GET /install/index.php HTTP/1.1" 302 210 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0"
172.23.0.1 - - [27/Feb/2024:17:34:57 +0000] "GET /install/check.php?testget=ok HTTP/1.1" 200 3282 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0"
172.23.0.1 - - [27/Feb/2024:17:34:57 +0000] "GET /install/default.css HTTP/1.1" 200 3303 "URLOFMYNAS/install/check.php?testget=ok" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0"
172.23.0.1 - - [27/Feb/2024:17:34:57 +0000] "GET /includes/jquery/css/base/jquery-ui.min.css HTTP/1.1" 200 7874 "URLOFMYNAS/install/check.php?testget=ok" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0"
172.23.0.1 - - [27/Feb/2024:17:34:58 +0000] "GET /install/upgrade.php?action=upgrade_18.0.0&selectlang=fr_FR&versionfrom=17.0.0&versionto=18.0.0 HTTP/1.1" 200 27032 "URLOFMYNAS/install/check.php?testget=ok" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0"
172.23.0.1 - - [27/Feb/2024:17:36:29 +0000] "GET / HTTP/1.1" 302 318 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0"
172.23.0.1 - - [27/Feb/2024:17:36:29 +0000] "GET /install/index.php HTTP/1.1" 302 210 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0"
172.23.0.1 - - [27/Feb/2024:17:36:29 +0000] "GET /install/check.php?testget=ok HTTP/1.1" 200 3282 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0"
Is it normal that I can’t select Démarrer on version 19? I believe it’s the one I’ve pulled on docker which is the latest
How can I get the environnement back and running?
Thanks a lot for your help it’s very much appreciated
White page = PHP Error => What does the logs says ?
To get back your environment, you can always restore your backup in V17.0.2.
But I think you change something, because your PHP Version seems to be V8.2, and Dolibarr V17.0.2 is not at all compatible with that…
Log doesn’t show more than shared on my OP, or maybe there is a specific php log file I can find somewhere?
I agree it seemed to be on 8.2. I’ve restored to 17.0.2 and working again but would really like to move to 19.0.
How should I proceed? The php in 8.2.7 was the right version for 19.0 but it was greyed out and as you mentioned had an error explained by the white page, what should I be looking for?
Logs from the container of Dolibarr are the same than posted above.
Here are the logs from mariadb:
2024-01-24 14:05:42+01:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.11.3+maria~ubu2204 started.
2024-01-24 14:05:48+01:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-01-24 14:05:48+01:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.11.3+maria~ubu2204 started.
2024-01-24 14:05:49+01:00 [Note] [Entrypoint]: MariaDB upgrade information missing, assuming required
2024-01-24 14:05:49+01:00 [Note] [Entrypoint]: MariaDB upgrade (mariadb-upgrade) required, but skipped due to $MARIADB_AUTO_UPGRADE setting
2024-01-24 14:05:49 0 [Note] Starting MariaDB 11.0.2-MariaDB-1:11.0.2+maria~ubu2204 source revision 0005f2f06c8e1aea4915887decad67885108a929 as process 1
2024-01-24 14:05:49 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-01-24 14:05:49 0 [Note] InnoDB: Number of transaction pools: 1
2024-01-24 14:05:49 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-01-24 14:05:49 0 [Warning] mariadbd: io_uring_queue_init() failed with ENOSYS: check seccomp filters, and the kernel version (newer than 5.1 required)
2024-01-24 14:05:49 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
2024-01-24 14:05:49 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2024-01-24 14:05:49 0 [Note] InnoDB: Completed initialization of buffer pool
2024-01-24 14:05:49 0 [Note] InnoDB: Resetting space id's in the doublewrite buffer
2024-01-24 14:05:55 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2024-01-24 14:05:56 0 [Note] InnoDB: Opened 3 undo tablespaces
2024-01-24 14:05:56 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2024-01-24 14:05:56 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2024-01-24 14:05:56 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2024-01-24 14:05:56 0 [Note] InnoDB: log sequence number 41548388; transaction id 59139
2024-01-24 14:05:56 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2024-01-24 14:05:56 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-24 14:05:56 0 [Note] Plugin 'wsrep-provider' is disabled.
2024-01-24 14:05:56 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-01-24 14:05:56 0 [Note] Server socket created on IP: '::'.
2024-01-24 14:05:59 0 [Note] InnoDB: Buffer pool(s) load completed at 240124 14:05:59
2024-01-24 14:06:01 0 [Note] mariadbd: ready for connections.
Version: '11.0.2-MariaDB-1:11.0.2+maria~ubu2204' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
2024-02-27 17:47:53 3218 [ERROR] Found index uk_commande_fournisseur_ref whose column info does not match that of MariaDB.
2024-02-27 17:47:53 3218 [ERROR] InnoDB indexes are inconsistent with what defined in .frm for table ./dolibarr/llx_commande_fournisseur
2024-02-27 17:47:53 3218 [ERROR] Index uk_commande_fournisseur_ref of dolibarr/llx_commande_fournisseur has 2 columns unique inside InnoDB, but server is asking statistics for 3 columns. Have you mixed up .frm files from different installations? Please refer to https://mariadb.com/kb/en/innodb-troubleshooting/ for how to resolve the issue.
2024-02-27 17:47:53 3218 [ERROR] Found index idx_payment_salary_datep whose column info does not match that of MariaDB.
2024-02-27 17:47:53 3218 [ERROR] InnoDB indexes are inconsistent with what defined in .frm for table ./dolibarr/llx_payment_salary
Could it be because the conf.php file is not editable? I’ve ls into the container root in var/www/htdocs/conf/conf.php but can only find conf.php.example…