Fröling: [ANNOUNCE] p4d - Visualisierung und Einstellung der S-3200 via COM1

$ systemctl status systemd-timesyncd.service
Warning: The unit file, source configuration file or drop-ins of systemd-timesyncd.service changed on disk. Run 'systemctl daemon-reload' to reload units.
● systemd-timesyncd.service - Network Time Synchronization
   Loaded: loaded (/lib/systemd/system/systemd-timesyncd.service; enabled; vendor preset: enabled)
  Drop-In: /lib/systemd/system/systemd-timesyncd.service.d
           └─disable-with-time-daemon.conf
   Active: active (running) since Sat 2020-10-24 01:32:22 CEST; 2 days ago
     Docs: man:systemd-timesyncd.service(8)
 Main PID: 325 (systemd-timesyn)
   Status: "Synchronized to time server for the first time 131.188.3.222:123 (ntp2.fau.de)."
    Tasks: 2 (limit: 4915)
   CGroup: /system.slice/systemd-timesyncd.service
           └─325 /lib/systemd/systemd-timesyncd


Okt 24 01:32:21 raspi82 systemd[1]: Starting Network Time Synchronization...
Okt 24 01:32:22 raspi82 systemd[1]: Started Network Time Synchronization.
Okt 24 01:33:11 raspi82 systemd-timesyncd[325]: Synchronized to time server for the first time 131.188.3.222:123 (ntp2.fau.de).

Read 8 option from /etc/p4d/p4d.conf
Info: Calling mysql_library_init()
Dictionary '/etc/p4d/p4d.dat' loaded
Try conneting to database
Checking database connection ...
Calling mysql_init(19704)
SQL client character now 'utf8'
Checking table structure and indices ...
Checking table 'config'
Checking table 'errors'
Checking table 'groups'
Checking table 'hmsysvars'
Checking table 'jobs'
Checking table 'menu'
Checking table 'peaks'
Checking table 'samples'
Checking table 'schemaconf'
  Info: Definition of field 'schemaconf.KIND' modified, try to alter table
Execute [alter table schemaconf modify column kind INT(1) comment 'kind of display' ]
SQL-Error in 'alter table schemaconf modify column kind INT(1) comment 'kind of display' ' - Incorrect integer value: 'value' for column 'kind' at row 1 (1366)
SQL-Error in 'alterAddField()' - Incorrect integer value: 'value' for column 'kind' at row 1 (1366) '' [alter table schemaconf modify column kind INT(1) comment 'kind of display' ]
Checking table 'scripts'
Checking table 'sensoralert'
Checking table 'timeranges'
Checking table 'users'
Checking table 'valuefacts'
Closing mysql connection and calling mysql_thread_end(19704)
Checking table structure and indices succeeded
Calling mysql_init(19704)
SQL-Error in 'prepare(stmt_prepare)' - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'p4.samples.address' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (1055) 'Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'p4.samples.address' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by' [select address, type, date_format(time, '%Y-%m-%dT%H:%i'), avg(value), max(value) from samples where address = ? and type = ? and time >= ? and time <= ? group by date(time), ((60/5) * hour(time) + floor(minute(time)/5)) order by time]
SQL-Error in 'prepare(stmt_prepare)' - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'p4.samples.address' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (1055) 'Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'p4.samples.address' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by' [select address, type, date_format(time, '%Y-%m-%dT%H:%i'), avg(value), max(value) from samples where address = ? and type = ? and time >= ? and time <= ? group by date(time), ((60/60) * hour(time) + floor(minute(time)/60)) order by time]
Closing mysql connection and calling mysql_thread_end(19704)
Initialization failed, see syslog for details
Info: Released the last usage of mysql_lib, calling mysql_library_end() now

Oct 28 09:36:36 kathi-1000H runp4d: restarting p4d
Oct 28 09:36:37 kathi-1000H p4d: Read 8 option from /etc/p4d/p4d.conf
Oct 28 09:36:37 kathi-1000H p4d: Info: Calling mysql_library_init()
Oct 28 09:36:37 kathi-1000H p4d: Dictionary '/etc/p4d/p4d.dat' loaded
Oct 28 09:36:37 kathi-1000H p4d: Try conneting to database
Oct 28 09:36:37 kathi-1000H p4d: Checking database connection ...
Oct 28 09:36:37 kathi-1000H p4d: Calling mysql_init(25544)
Oct 28 09:36:37 kathi-1000H p4d: SQL client character now 'utf8'
Oct 28 09:36:37 kathi-1000H p4d: Checking table structure and indices ...
Oct 28 09:36:37 kathi-1000H p4d: Checking table 'config'
Oct 28 09:36:37 kathi-1000H p4d: Checking table 'errors'
Oct 28 09:36:37 kathi-1000H p4d: Checking table 'groups'
Oct 28 09:36:37 kathi-1000H p4d: Checking table 'hmsysvars'
Oct 28 09:36:37 kathi-1000H p4d: Checking table 'jobs'
Oct 28 09:36:37 kathi-1000H p4d: Checking table 'menu'
Oct 28 09:36:37 kathi-1000H p4d: Checking table 'peaks'
Oct 28 09:36:37 kathi-1000H p4d: Checking table 'samples'
Oct 28 09:36:37 kathi-1000H p4d: Checking table 'schemaconf'
Oct 28 09:36:37 kathi-1000H p4d: Checking table 'scripts'
Oct 28 09:36:37 kathi-1000H p4d: Checking table 'sensoralert'
Oct 28 09:36:37 kathi-1000H p4d: Checking table 'timeranges'
Oct 28 09:36:37 kathi-1000H p4d: Checking table 'users'
Oct 28 09:36:37 kathi-1000H p4d: Checking table 'valuefacts'
Oct 28 09:36:37 kathi-1000H p4d: Closing mysql connection and calling mysql_thread_end(25544)
Oct 28 09:36:37 kathi-1000H p4d: Checking table structure and indices succeeded
Oct 28 09:36:37 kathi-1000H p4d: Calling mysql_init(25544)
Oct 28 09:36:37 kathi-1000H p4d: SQL-Error in 'prepare(stmt_prepare)' - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'p4.samples.address' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (1055) 'Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'p4.samples.address' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by' [select address, type, date_format(time, '%Y-%m-%dT%H:%i'), avg(value), max(value) from samples where address = ? and type = ? and time >= ? and time <= ? group by date(time), ((60/5) * hour(time) + floor(minute(time)/5)) order by time]
Oct 28 09:36:37 kathi-1000H p4d: SQL-Error in 'prepare(stmt_prepare)' - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'p4.samples.address' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (1055) 'Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'p4.samples.address' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by' [select address, type, date_format(time, '%Y-%m-%dT%H:%i'), avg(value), max(value) from samples where address = ? and type = ? and time >= ? and time <= ? group by date(time), ((60/60) * hour(time) + floor(minute(time)/60)) order by time]