Uncaught mysqli_sql_exception: Data truncated for column 'locked' at row 1

Hello,

have a similar error like
https://forum.howtoforge.com/thread...ted-for-column-warnvirusrecip-at-row-1.90116/
running a multiserver setup
The last action was to add new Website, FTP User and Database and so on on the slave server


If I running

PHP:

 /usr/local/ispconfig/server/server.sh


PHP:

 WARNING - There is already a lockfile set, but no process running with this pid (7077). Continuing.
PHP Fatal error:  Uncaught mysqli_sql_exception: Data truncated for column 'locked' at row 1 in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php:302
Stack trace:
#0 /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php(302): mysqli_query()
#1 /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php(339): db->_query()
#2 /usr/local/ispconfig/server/lib/classes/modules.inc.php(171): db->query()
#3 /usr/local/ispconfig/server/server.php(180): modules->processDatalog()
#4 {main}
  thrown in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 302


I looked at the "sys_datalog" table at the master server.
But I have no idea how to fix this
Thank you for your support

 

this is a good point
I also tested WHCMS
And yes, first I added a new Client

 

I added the new client with ISPConfig and not with WHMCS

 

OK, at the master and the slave the value "updated" is incremented by 1 and at both server the value is identical now

 

But still no syncing and still the same error message when I running the
/usr/local/ispconfig/server/server.sh

 

It still does not work.
The table "server" at the ispconfig database
At Master Server
Master server_id=1 value "updated"=323
affected slave server_id=3 value "updated"=323

 

Thank you, now it is working!
I increased the value to the same value as the other servers.
Thank you