Update loop from 17.0.2 to 19.0

Hello,

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

Hello,

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…

Hello thanks for your help.

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?

Thanks a lot for your help

Hello,

The logs you have shared seems not to be the PHP error log.

I’m not a expert of doker, but according to that :Access php error logs in Docker - Stack Overflow you have to run :

docker logs -f --details containerName

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

Thanks again for your help

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…

which image do you create the container from?

Tuxgasy/dolibarr:latest for version 19

I’ve tried this one as well same result : tuxgasy/dolibarr:18 for version 18

same image as me. I’m still using 18.0.4 though.

Have you enabled dolibarr logging?

Home, Setup, Modules/Applications, search for debug and enable it

But will I be able to see the logs when I encounter the same problem while updating?