Errors on Dolibarr 17.0.2 / PHP 8.1 Postgres DB

Installing my Dolibarr
,
1

We upgraded a Dolibarr/Postgres database from 16.0.4 / PHP 7.4 to Dolibarr 17.0.2 / PHP 8.1

$dolibarr_main_db_host=‘localhost’;
$dolibarr_main_db_port=‘5432’;
//$dolibarr_main_db_name=‘**';
$dolibarr_main_db_name='doli17’;
$dolibarr_main_db_prefix=‘llxas_’;
$dolibarr_main_db_user=‘user’;
$dolibarr_main_db_pass='’;
$dolibarr_main_db_type=‘pgsql’;

But we had several errors on the Upgrade Wizard:

Screenshot 2023-07-21 140704
Screenshot 2023-07-21 1407041314×556 22 KB

Attached complete list of errors.
upgrade_errors.txt (68.3 KB)

Dolibarr documentation confirms the PHP 8.1 on Dolibarr 17.0.2 and is not indicating errors on POSTGRES:
Releases - Dolibarr ERP CRM Wiki

Do you have any idea on this topic?

2

Hi,
could you explain why your db_name is doli17?
I was the meaning when upgrading it would use the same db_name as of version 16?
It could be helpfull if we know how you upraded.

Jason.

3

I apologize, it was a fat finger error. The database name is doli16.

4

Hi,
all INSERT operations fail because some AUTO_INCREMENT fields are not set automatically and remain NULL.
Difficult to understand what is happening, but it seems to me a database setting problem