Database Error 1067

Maintaining my Dolibarr
1

Hi,
I am upgrading to 11.0.5 from 10.07 and I get the following error

Request 117 sql=‘CREATE TABLE tmp_user as (select * from llx_user);’

Erro DB_ERROR_1067: CREATE TABLE tmp_user as (select * from llx_user);
Invalid default value for ‘tms’

I have upgrading one step at a time from 9.0.4 always without any problem, but now this error happens.

Thank you in advance for any help.

2

Do you have access to the SQL backend? what privilege’s does the user you are using for Dolibarr to the dabase have?

I would assume its not this, but you never know, if not sure, raise the level to database administrator for the Dolibarr container in SQL