POLLER: Poller[0] Maximum runtime of 298 seconds exceeded.

[plasky12]

Hi ,

I did a mysql database restart due to some space issues in our server.
After restarting apache, we can see that the graphs are not plotting. looks like a poller issue
But i am not sure how to resolve it.
Here are the logs below.

2022-05-23 21:12:02 - SPINE: Poller[1] PID[23899] Device[906] Hostname[94.105.27.116] NOTICE: HOST EVENT: Device Returned from DOWN State
2022-05-23 21:12:01 - SYSTEM MONITOR STATS: Time:0.0929 Reboots:0 DownDevices:0 Notifications:0 Purges:1
2022-05-23 21:12:01 - SYSTEM STATS: Time:1.0057 Method:spine Processes:8 Threads:50 Hosts:5357 HostsPerProcess:670 DataSources:21644 RRDsProcessed:0
2022-05-23 21:12:01 - SYSTEM WARNING: Primary Admin account notifications disabled! Unable to send administrative Email.
2022-05-23 21:12:01 - POLLER: Poller[1] PID[5908] Maximum runtime of 298 seconds exceeded. Exiting.
2022-05-23 21:12:00 - SPINE: Poller[1] PID[23899] ERROR: SQL Failed! Error:'1292', Message:'Incorrect datetime value: '0000-00-00 00:00:00' for column 'end_time' at row 1', SQL Fragment:'INSERT INTO poller_time (poller_id, pid, start_time, end_time) VALUES (1, 23899, NOW(), '0000-00-00 00:00:00')'
2022-05-23 21:12:00 - SPINE: Poller[1] PID[23801] ERROR: SQL Failed! Error:'1292', Message:'Incorrect datetime value: '0000-00-00 00:00:00' for column 'end_time' at row 1', SQL Fragment:'INSERT INTO poller_time (poller_id, pid, start_time, end_time) VALUES (1, 23801, NOW(), '0000-00-00 00:00:00')'
2022-05-23 21:11:01 - SYSTEM MONITOR STATS: Time:0.0934 Reboots:0 DownDevices:0 Notifications:0 Purges:1
2022-05-23 21:11:01 - SYSTEM STATS: Time:0.9201 Method:spine Processes:8 Threads:50 Hosts:5357 HostsPerProcess:670 DataSources:21679 RRDsProcessed:0
2022-05-23 21:11:01 - SYSTEM WARNING: Primary Admin account notifications disabled! Unable to send administrative Email.
2022-05-23 21:11:01 - POLLER: Poller[1] PID[5908] Maximum runtime of 298 seconds exceeded. Exiting.
2022-05-23 21:11:00 - SPINE: Poller[1] PID[22400] ERROR: SQL Failed! Error:'1292', Message:'Incorrect datetime value: '0000-00-00 00:00:00' for column 'end_time' at row 1', SQL Fragment:'INSERT INTO poller_time (poller_id, pid, start_time, end_time) VALUES (1, 22400, NOW(), '0000-00-00 00:00:00')'
2022-05-23 21:11:00 - SPINE: Poller[1] PID[22301] ERROR: SQL Failed! Error:'1292', Message:'Incorrect datetime value: '0000-00-00 00:00:00' for column 'end_time' at row 1', SQL Fragment:'INSERT INTO poller_time (poller_id, pid, start_time, end_time) VALUES (1, 22301, NOW(), '0000-00-00 00:00:00')'
2022-05-23 21:10:02 - SPINE: Poller[1] PID[19312] Device[603] Hostname[94.105.8.230] ERROR: HOST EVENT: Device is DOWN Message: Device did not respond to SNMP
2022-05-23 21:10:01 - SYSTEM MONITOR STATS: Time:0.0877 Reboots:0 DownDevices:0 Notifications:0 Purges:0
2022-05-23 21:10:01 - SYSTEM WARNING: Primary Admin account notifications disabled! Unable to send administrative Email.
2022-05-23 21:10:01 - POLLER: Poller[1] PID[19776] WARNING: Poller Output Table not Empty. Issues: 128, DS[1254, 1358, 1358, 1406, 1406, 1445, 1445, 1472, 1472, 1478, 1478, 1487, 1487, 2030, 2036, 2088, 2098, 2106, 2125, 2184], Additional Issues Remain. Only showing first 20
2022-05-23 21:10:01 - SYSTEM STATS: Time:0.9163 Method:spine Processes:8 Threads:50 Hosts:5357 HostsPerProcess:670 DataSources:21619 RRDsProcessed:0
2022-05-23 21:10:01 - SYSTEM WARNING: Primary Admin account notifications disabled! Unable to send administrative Email.
2022-05-23 21:10:01 - POLLER: Poller[1] PID[5908] Maximum runtime of 298 seconds exceeded. Exiting.
2022-05-23 21:10:00 - SPINE: Poller[1] PID[19413] ERROR: SQL Failed! Error:'1292', Message:'Incorrect datetime value: '0000-00-00 00:00:00' for column 'end_time' at row 1', SQL Fragment:'INSERT INTO poller_time (poller_id, pid, start_time, end_time) VALUES (1, 19413, NOW(), '0000-00-00 00:00:00')'
2022-05-23 21:10:00 - SPINE: Poller[1] PID[19312] ERROR: SQL Failed! Error:'1292', Message:'Incorrect datetime value: '0000-00-00 00:00:00' for column 'end_time' at row 1', SQL Fragment:'INSERT INTO poller_time (poller_id, pid, start_time, end_time) VALUES (1, 19312, NOW(), '0000-00-00 00:00:00')'
2022-05-23 21:10:00 - SYSTEM STATS: Time:298.7678 Method:spine Processes:8 Threads:50 Hosts:5357 HostsPerProcess:670 DataSources:21543 RRDsProcessed:0
2022-05-23 21:10:00 - SYSTEM WARNING: Primary Admin account notifications disabled! Unable to send administrative Email.
2022-05-23 21:10:00 - POLLER: Poller[1] PID[5908] Maximum runtime of 298 seconds exceeded. Exiting.
2022-05-23 21:08:01 - SPINE: Poller[1] PID[17737] Device[906] Hostname[94.105.27.116] ERROR: HOST EVENT: Device is DOWN Message: Device did not respond to SNMP
2022-05-23 21:08:01 - SYSTEM MONITOR STATS: Time:0.0894 Reboots:0 DownDevices:0 Notifications:0 Purges:1
2022-05-23 21:08:01 - SYSTEM STATS: Time:1.0738 Method:spine Processes:8 Threads:50 Hosts:5357 HostsPerProcess:670 DataSources:21653 RRDsProcessed:0
2022-05-23 21:08:01 - SYSTEM WARNING: Primary Admin account notifications disabled! Unable to send administrative Email.
2022-05-23 21:08:01 - POLLER: Poller[1] PID[30029] Maximum runtime of 298 seconds exceeded. Exiting.
2022-05-23 21:08:00 - SPINE: Poller[1] PID[17737] ERROR: SQL Failed! Error:'1292', Message:'Incorrect datetime value: '0000-00-00 00:00:00' for column 'end_time' at row 1', SQL Fragment:'INSERT INTO poller_time (poller_id, pid, start_time, end_time) VALUES (1, 17737, NOW(), '0000-00-00 00:00:00')'
2022-05-23 21:08:00 - SPINE: Poller[1] PID[17641] ERROR: SQL Failed! Error:'1292', Message:'Incorrect datetime value: '0000-00-00 00:00:00' for column 'end_time' at row 1', SQL Fragment:'INSERT INTO poller_time (poller_id, pid, start_time, end_time) VALUES (1, 17641, NOW(), '0000-00-00 00:00:00')'
2022-05-23 21:07:01 - SYSTEM MONITOR STATS: Time:0.089 Reboots:0 DownDevices:0 Notifications:0 Purges:0
2022-05-23 21:07:01 - SYSTEM STATS: Time:1.0450 Method:spine Processes:8 Threads:50 Hosts:5357 HostsPerProcess:670 DataSources:21574 RRDsProcessed:0
2022-05-23 21:07:01 - SYSTEM WARNING: Primary Admin account notifications disabled! Unable to send administrative Email.

This was after the database restart.

2022-05-23 18:43:01 - POLLER: Poller[1] PID[24844] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: /var/www/html/cacti-1.2.18/poller_boost.php --child=15 --debug]
2022-05-23 18:43:01 - BOOST CHILD DEBUG: Processing 1 of 3 for Boost Process 8
2022-05-23 18:43:01 - BOOST CHILD DEBUG: Processing 1 of 2 for Boost Process 3
2022-05-23 18:43:01 - BOOST CHILD DEBUG: Processes:3, TotalRows:2782
2022-05-23 18:43:01 - BOOST CHILD DEBUG: Processes:8, TotalRows:5348
2022-05-23 18:43:01 - BOOST CHILD DEBUG: Processing RRRtool Output for Boost Process 3
2022-05-23 18:43:01 - BOOST CHILD DEBUG: Processing RRRtool Output for Boost Process 8
2022-05-23 18:43:01 - BOOST CHILD DEBUG: Processing 1 of 1 for Boost Process 7
2022-05-23 18:43:01 - BOOST CHILD DEBUG: Processes:7, TotalRows:1256
2022-05-23 18:43:01 - BOOST CHILD DEBUG: Processing RRRtool Output for Boost Process 7
2022-05-23 18:43:01 - BOOST CHILD DEBUG: Processing 1 of 2 for Boost Process 4
2022-05-23 18:43:01 - BOOST CHILD DEBUG: Processes:4, TotalRows:2140
2022-05-23 18:43:01 - BOOST CHILD DEBUG: Processing RRRtool Output for Boost Process 4
2022-05-23 18:43:01 - POLLER: Poller[1] PID[24844] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: /var/www/html/cacti-1.2.18/poller_boost.php --child=14 --debug]
2022-05-23 18:43:01 - POLLER: Poller[1] PID[24844] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: /var/www/html/cacti-1.2.18/poller_boost.php --child=13 --debug]
2022-05-23 18:43:01 - POLLER: Poller[1] PID[24844] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: /var/www/html/cacti-1.2.18/poller_boost.php --child=12 --debug]
2022-05-23 18:43:01 - POLLER: Poller[1] PID[24844] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: /var/www/html/cacti-1.2.18/poller_boost.php --child=11 --debug]
2022-05-23 18:43:01 - POLLER: Poller[1] PID[24844] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: /var/www/html/cacti-1.2.18/poller_boost.php --child=10 --debug]
2022-05-23 18:43:01 - POLLER: Poller[1] PID[24844] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: /var/www/html/cacti-1.2.18/poller_boost.php --child=9 --debug]
2022-05-23 18:43:01 - POLLER: Poller[1] PID[24844] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: /var/www/html/cacti-1.2.18/poller_boost.php --child=8 --debug]
2022-05-23 18:43:01 - POLLER: Poller[1] PID[24844] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: /var/www/html/cacti-1.2.18/poller_boost.php --child=7 --debug]
2022-05-23 18:43:01 - POLLER: Poller[1] PID[24844] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: /var/www/html/cacti-1.2.18/poller_boost.php --child=6 --debug]
2022-05-23 18:43:01 - POLLER: Poller[1] PID[24844] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: /var/www/html/cacti-1.2.18/poller_boost.php --child=5 --debug]
2022-05-23 18:43:01 - POLLER: Poller[1] PID[24844] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: /var/www/html/cacti-1.2.18/poller_boost.php --child=4 --debug]
2022-05-23 18:43:01 - POLLER: Poller[1] PID[24844] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: /var/www/html/cacti-1.2.18/poller_boost.php --child=3 --debug]
2022-05-23 18:43:01 - POLLER: Poller[1] PID[24844] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: /var/www/html/cacti-1.2.18/poller_boost.php --child=2 --debug]
2022-05-23 18:43:01 - POLLER: Poller[1] PID[24844] DEBUG: About to Spawn a Remote Process [CMD: /usr/bin/php, ARGS: /var/www/html/cacti-1.2.18/poller_boost.php --child=1 --debug]
2022-05-23 18:43:01 - SYSTEM MONITOR STATS: Time:0.0938 Reboots:0 DownDevices:0 Notifications:0 Purges:1
2022-05-23 18:43:00 - SYSTEM STATS: Time:0.9350 Method:spine Processes:8 Threads:50 Hosts:5357 HostsPerProcess:670 DataSources:21676 RRDsProcessed:0
2022-05-23 18:43:00 - SYSTEM WARNING: Primary Admin account notifications disabled! Unable to send administrative Email.
2022-05-23 18:43:00 - POLLER: Poller[1] PID[13772] Maximum runtime of 298 seconds exceeded. Exiting.
2022-05-23 18:43:00 - SPINE: Poller[1] PID[24393] ERROR: SQL Failed! Error:'1292', Message:'Incorrect datetime value: '0000-00-00 00:00:00' for column 'end_time' at row 1', SQL Fragment:'INSERT INTO poller_time (poller_id, pid, start_time, end_time) VALUES (1, 24393, NOW(), '0000-00-00 00:00:00')'
2022-05-23 18:43:00 - SPINE: Poller[1] PID[24297] ERROR: SQL Failed! Error:'1292', Message:'Incorrect datetime value: '0000-00-00 00:00:00' for column 'end_time' at row 1', SQL Fragment:'INSERT INTO poller_time (poller_id, pid, start_time, end_time) VALUES (1, 24297, NOW(), '0000-00-00 00:00:00')'
2022-05-23 18:42:04 - SPINE: Poller[1] PID[22866] Device[603] Hostname[94.105.8.230] NOTICE: HOST EVENT: Device Returned from DOWN State
2022-05-23 18:42:01 - SYSTEM MONITOR STATS: Time:0.093 Reboots:0 DownDevices:0 Notifications:0 Purges:0
2022-05-23 18:42:00 - SYSTEM STATS: Time:0.9303 Method:spine Processes:8 Threads:50 Hosts:5357 HostsPerProcess:670 DataSources:21594 RRDsProcessed:0
2022-05-23 18:42:00 - SYSTEM WARNING: Primary Admin account notifications disabled! Unable to send administrative Email.
2022-05-23 18:42:00 - POLLER: Poller[1] PID[13772] Maximum runtime of 298 seconds exceeded. Exiting.
2022-05-23 18:42:00 - SPINE: Poller[1] PID[22866] ERROR: SQL Failed! Error:'1292', Message:'Incorrect datetime value: '0000-00-00 00:00:00' for column 'end_time' at row 1', SQL Fragment:'INSERT INTO poller_time (poller_id, pid, start_time, end_time) VALUES (1, 22866, NOW(), '0000-00-00 00:00:00')'
2022-05-23 18:42:00 - SPINE: Poller[1] PID[22769] ERROR: SQL Failed! Error:'1292', Message:'Incorrect datetime value: '0000-00-00 00:00:00' for column 'end_time' at row 1', SQL Fragment:'INSERT INTO poller_time (poller_id, pid, start_time, end_time) VALUES (1, 22769, NOW(), '0000-00-00 00:00:00')'
2022-05-23 18:41:01 - SYSTEM MONITOR STATS: Time:0.0993 Reboots:0 DownDevices:0 Notifications:0 Purges:0
2022-05-23 18:41:00 - SYSTEM STATS: Time:0.9108 Method:spine Processes:8 Threads:50 Hosts:5357 HostsPerProcess:670 DataSources:21735 RRDsProcessed:0
2022-05-23 18:41:00 - SYSTEM WARNING: Primary Admin account notifications disabled! Unable to send administrative Email.
2022-05-23 18:41:00 - POLLER: Poller[1] PID[13772] Maximum runtime of 298 seconds exceeded. Exiting.
2022-05-23 18:41:00 - SPINE: Poller[1] PID[21306] ERROR: SQL Failed! Error:'1292', Message:'Incorrect datetime value: '0000-00-00 00:00:00' for column 'end_time' at row 1', SQL Fragment:'INSERT INTO poller_time (poller_id, pid, start_time, end_time) VALUES (1, 21306, NOW(), '0000-00-00 00:00:00')'
2022-05-23 18:41:00 - SPINE: Poller[1] PID[21210] ERROR: SQL Failed! Error:'1292', Message:'Incorrect datetime value: '0000-00-00 00:00:00' for column 'end_time' at row 1', SQL Fragment:'INSERT INTO poller_time (poller_id, pid, start_time, end_time) VALUES (1, 21210, NOW(), '0000-00-00 00:00:00')'
2022-05-23 18:40:02 - SPINE: Poller[1] PID[18777] ERROR: SQL Failed! Error:'1292', Message:'Incorrect datetime value: '0000-00-00 00:00:00' for column 'end_time' at row 1', SQL Fragment:'INSERT INTO poller_time (poller_id, pid, start_time, end_time) VALUES (1, 18777, NOW(), '0000-00-00 00:00:00')'
2022-05-23 18:40:01 - SYSTEM WARNING: Primary Admin account notifications disabled! Unable to send administrative Email.
2022-05-23 18:40:01 - POLLER: Poller[1] PID[18036] WARNING: Poller Output Table not Empty. Issues: 624, DS[1238, 1261, 1267, 1352, 1352, 1358, 1358, 1361, 1361, 1370, 1370, 1376, 1376, 1382, 1382, 1397, 1397, 1400, 1400, 1406], Additional Issues Remain. Only showing first 20
2022-05-23 18:40:01 - SYSTEM MONITOR STATS: Time:0.0898 Reboots:0 DownDevices:0 Notifications:0 Purges:3
2022-05-23 18:40:00 - SYSTEM STATS: Time:0.9219 Method:spine Processes:8 Threads:50 Hosts:5357 HostsPerProcess:670 DataSources:21767 RRDsProcessed:0
2022-05-23 18:40:00 - SYSTEM WARNING: Primary Admin account notifications disabled! Unable to send administrative Email.
2022-05-23 18:40:00 - POLLER: Poller[1] PID[13772] Maximum runtime of 298 seconds exceeded. Exiting.
2022-05-23 18:40:00 - SPINE: Poller[1] PID[17531] ERROR: SQL Failed! Error:'1292', Message:'Incorrect datetime value: '0000-00-00 00:00:00' for column 'end_time' at row 1', SQL Fragment:'INSERT INTO poller_time (poller_id, pid, start_time, end_time) VALUES (1, 17531, NOW(), '0000-00-00 00:00:00')'
2022-05-23 18:40:00 - SPINE: Poller[1] PID[17432] ERROR: SQL Failed! Error:'1292', Message:'Incorrect datetime value: '0000-00-00 00:00:00' for column 'end_time' at row 1', SQL Fragment:'INSERT INTO poller_time (poller_id, pid, start_time, end_time) VALUES (1, 17432, NOW(), '0000-00-00 00:00:00')'
2022-05-23 18:40:00 - SYSTEM STATS: Time:298.3143 Method:spine Processes:8 Threads:50 Hosts:5357 HostsPerProcess:670 DataSources:21711 RRDsProcessed:0
2022-05-23 18:40:00 - SYSTEM WARNING: Primary Admin account notifications disabled! Unable to send administrative Email.
2022-05-23 18:40:00 - POLLER: Poller[1] PID[13772] Maximum runtime of 298 seconds exceeded. Exiting.
2022-05-23 18:39:54 - AUTH LOGIN: User 'admin' Authenticated
2022-05-23 18:36:31 - WEBUI WARNING: Attempt to use GET method for POST operations from IP 172.19.26.159
2022-05-23 18:35:04 - SPINE: Poller[1] PID[14331] Device[1500] Hostname[94.105.18.21] NOTICE: HOST EVENT: Device Returned from DOWN State
2022-05-23 18:35:01 - SPINE: Poller[1] PID[14331] ERROR: SQL Failed! Error:'1292', Message:'Incorrect datetime value: '0000-00-00 00:00:00' for column 'end_time' at row 1', SQL Fragment:'INSERT INTO poller_time (poller_id, pid, start_time, end_time) VALUES (1, 14331, NOW(), '0000-00-00 00:00:00')'
2022-05-23 18:35:01 - SPINE: Poller[1] PID[14219] ERROR: SQL Failed! Error:'1292', Message:'Incorrect datetime value: '0000-00-00 00:00:00' for column 'end_time' at row 1', SQL Fragment:'INSERT INTO poller_time (poller_id, pid, start_time, end_time) VALUES (1, 14219, NOW(), '0000-00-00 00:00:00')'
2022-05-23 18:35:00 - SYSTEM MONITOR STATS: Time:0.1412 Reboots:0 DownDevices:0 Notifications:0 Purges:1
2022-05-23 18:35:00 - CMDPHP SQL Backtrace: (/poller.php[818]:bad_index_check(), /poller.php[838]:db_fetch_cell(), /lib/database.php[411]:db_fetch_cell_prepared(), /lib/database.php[427]:db_execute_prepared())
2022-05-23 18:35:00 - CMDPHP ERROR: A DB Cell Failed!, Error: MySQL server has gone away
2022-05-23 18:35:00 - CMDPHP SQL Backtrace: (/poller.php[812]:dsdebug_poller_bottom(), /lib/dsdebug.php[152]:db_fetch_assoc(), /lib/database.php[501]:db_fetch_assoc_prepared(), /lib/database.php[515]:db_execute_prepared())
2022-05-23 18:35:00 - CMDPHP ERROR: A DB Row Failed!, Error: MySQL server has gone away
2022-05-23 18:35:00 - CMDPHP SQL Backtrace: (/poller.php[810]:boost_poller_bottom(), /lib/boost.php[1250]:boost_update_snmp_statistics(), /lib/boost.php[1328]:MibCache->set(), /lib/mib_cache.php[172]:db_execute_prepared())
2022-05-23 18:35:00 - CMDPHP ERROR: A DB Exec Failed!, Error: MySQL server has gone away
2022-05-23 18:35:00 - CMDPHP SQL Backtrace: (/poller.php[810]:boost_poller_bottom(), /lib/boost.php[1250]:boost_update_snmp_statistics(), /lib/boost.php[1326]:MibCache->set(), /lib/mib_cache.php[172]:db_execute_prepared())
2022-05-23 18:35:00 - CMDPHP ERROR: A DB Exec Failed!, Error: MySQL server has gone away
2022-05-23 18:35:00 - CMDPHP SQL Backtrace: (/poller.php[810]:boost_poller_bottom(), /lib/boost.php[1250]:boost_update_snmp_statistics(), /lib/boost.php[1325]:MibCache->set(), /lib/mib_cache.php[172]:db_execute_prepared())
2022-05-23 18:35:00 - CMDPHP ERROR: A DB Exec Failed!, Error: MySQL server has gone away
2022-05-23 18:35:00 - CMDPHP SQL Backtrace: (/poller.php[810]:boost_poller_bottom(), /lib/boost.php[1250]:boost_update_snmp_statistics(), /lib/boost.php[1324]:MibCache->set(), /lib/mib_cache.php[172]:db_execute_prepared())

Could you let me know how i can go about resolving them? I tried to stop the poller cron and reset it again after 15 mins but the graphs are not populating
Thanks

[macan]

Show result of query:
SELECT @@sql_mode

These modes you shold disable:
'STRICT_TRANS_TABLES',
'STRICT_ALL_TABLES',
'TRADITIONAL',
'NO_ZERO_DATE',
'NO_ZERO_IN_DATE',
'ONLY_FULL_GROUP_BY',
'NO_AUTO_VALUE_ON_ZERO'

[plasky12]

Hi,

Result of this query.
-----------------------------------------------------------------------------------------------------------------------------------------------+
| @@sql_mode |
+------------------------------------------------------------------------------------------------------------------------------------------------------+
| STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

Can you let me know what needs to be done here?

[macan]

https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
https://mariadb.com/kb/en/sql-mode/

You have to set correct sql_mode in my.cnf (my.ini it depends on your db/os)

[plasky12]

Many thanks for your suggestions.
Modified the sql mode and the system is back to normal.