Cacti / cacti

Cacti ™
http://www.cacti.net
GNU General Public License v2.0
1.64k stars 405 forks source link

New devices are not showing up in Devices Management after upgrade to 1.2.21 #4886

Closed herr-nandez closed 2 years ago

herr-nandez commented 2 years ago

Describe the bug

When adding a new device (Management -> Devices -> Add) and saving them they do not appear in the Devices List. Changing filters has no effect. The device only exists in the database and can be edited by manually entering the device ID in the URL (host.php?action=edit&id=ENTERID). When creating graphs for those devices the RRD files are not created and therefore no data is collected. Existing devices are not affected and new graphs as well as existing ones are populated with data.

SELECT * FROM cacti.host LIMIT 0, 10000 788 row(s) returned 0.031 sec / 0.063 sec

SPINE Log:

SPINE: Using spine config file [/etc/spine.conf]
Total[0.0093] DEBUG: The path_php_server variable is /opt/data/www/cacti/script_server.php
Total[0.0093] DEBUG: The path_cactilog variable is /opt/data/www/cacti/log/cacti.log
Total[0.0093] DEBUG: The version variable is 8.0.29-commercial
Total[0.0093] DEBUG: The log_destination variable is 4 (STDOUT)
Total[0.0094] DEBUG: The path_php variable is /bin/php
Total[0.0095] DEBUG: The availability_method variable is 2
Total[0.0096] DEBUG: The ping_recovery_count variable is 3
Total[0.0097] DEBUG: The ping_failure_count variable is 2
Total[0.0098] DEBUG: The ping_method variable is 2
Total[0.0099] DEBUG: The ping_retries variable is 1
Total[0.0100] DEBUG: The ping_timeout variable is 400
Total[0.0101] DEBUG: The snmp_retries variable is 3
Total[0.0102] DEBUG: The log_perror variable is 1
Total[0.0103] DEBUG: The log_pwarn variable is 0
Total[0.0104] DEBUG: The boost_redirect variable is 1
Total[0.0105] DEBUG: The boost_rrd_update_enable variable is 1
Total[0.0106] DEBUG: The log_pstats variable is 0
Total[0.0107] DEBUG: The threads variable is 45
Total[0.0109] DEBUG: The polling interval is 60 seconds
Total[0.0110] DEBUG: The number of concurrent processes is 10
Total[0.0111] DEBUG: The script timeout is 10
Total[0.0112] DEBUG: The selective_device_debug variable is 
Total[0.0113] DEBUG: The spine_log_level variable is 0
Total[0.0114] DEBUG: The number of php script servers to run is 15
Total[0.0115] DEBUG: The number of active data source profiles is 1
Total[0.0116] DEBUG: The number of snmp ports on the system is 1
Total[0.0118] DEBUG: StartDevice='1201', EndDevice='1201', TotalPHPScripts='0'
Total[0.0119] DEBUG: The PHP Script Server is Not Required
Total[0.0120] DEBUG: The Maximum SNMP OID Get Size is 20
Total[0.0154] DEBUG: Total Connections made 1
Total[0.0155] DEBUG: Creating Local Connection Pool of 45 threads.
Total[0.0155] DEBUG: Creating Local Connection 0.
Total[0.0192] DEBUG: Total Connections made 2
Total[0.0192] DEBUG: Creating Local Connection 1.
Total[0.0221] DEBUG: Total Connections made 3
Total[0.0221] DEBUG: Creating Local Connection 2.
Total[0.0255] DEBUG: Total Connections made 4
Total[0.0256] DEBUG: Creating Local Connection 3.
Total[0.0297] DEBUG: Total Connections made 5
Total[0.0297] DEBUG: Creating Local Connection 4.
Total[0.0329] DEBUG: Total Connections made 6
Total[0.0329] DEBUG: Creating Local Connection 5.
Total[0.0360] DEBUG: Total Connections made 7
Total[0.0360] DEBUG: Creating Local Connection 6.
Total[0.0389] DEBUG: Total Connections made 8
Total[0.0389] DEBUG: Creating Local Connection 7.
Total[0.0429] DEBUG: Total Connections made 9
Total[0.0429] DEBUG: Creating Local Connection 8.
Total[0.0457] DEBUG: Total Connections made 10
Total[0.0457] DEBUG: Creating Local Connection 9.
Total[0.0486] DEBUG: Total Connections made 11
Total[0.0486] DEBUG: Creating Local Connection 10.
Total[0.0517] DEBUG: Total Connections made 12
Total[0.0517] DEBUG: Creating Local Connection 11.
Total[0.0546] DEBUG: Total Connections made 13
Total[0.0546] DEBUG: Creating Local Connection 12.
Total[0.0578] DEBUG: Total Connections made 14
Total[0.0578] DEBUG: Creating Local Connection 13.
Total[0.0610] DEBUG: Total Connections made 15
Total[0.0611] DEBUG: Creating Local Connection 14.
Total[0.0647] DEBUG: Total Connections made 16
Total[0.0648] DEBUG: Creating Local Connection 15.
Total[0.0675] DEBUG: Total Connections made 17
Total[0.0675] DEBUG: Creating Local Connection 16.
Total[0.0705] DEBUG: Total Connections made 18
Total[0.0705] DEBUG: Creating Local Connection 17.
Total[0.0733] DEBUG: Total Connections made 19
Total[0.0733] DEBUG: Creating Local Connection 18.
Total[0.0767] DEBUG: Total Connections made 20
Total[0.0767] DEBUG: Creating Local Connection 19.
Total[0.0795] DEBUG: Total Connections made 21
Total[0.0795] DEBUG: Creating Local Connection 20.
Total[0.0826] DEBUG: Total Connections made 22
Total[0.0827] DEBUG: Creating Local Connection 21.
Total[0.0857] DEBUG: Total Connections made 23
Total[0.0857] DEBUG: Creating Local Connection 22.
Total[0.0886] DEBUG: Total Connections made 24
Total[0.0887] DEBUG: Creating Local Connection 23.
Total[0.0916] DEBUG: Total Connections made 25
Total[0.0916] DEBUG: Creating Local Connection 24.
Total[0.0945] DEBUG: Total Connections made 26
Total[0.0945] DEBUG: Creating Local Connection 25.
Total[0.0972] DEBUG: Total Connections made 27
Total[0.0972] DEBUG: Creating Local Connection 26.
Total[0.0998] DEBUG: Total Connections made 28
Total[0.0998] DEBUG: Creating Local Connection 27.
Total[0.1028] DEBUG: Total Connections made 29
Total[0.1028] DEBUG: Creating Local Connection 28.
Total[0.1058] DEBUG: Total Connections made 30
Total[0.1059] DEBUG: Creating Local Connection 29.
Total[0.1089] DEBUG: Total Connections made 31
Total[0.1089] DEBUG: Creating Local Connection 30.
Total[0.1117] DEBUG: Total Connections made 32
Total[0.1117] DEBUG: Creating Local Connection 31.
Total[0.1144] DEBUG: Total Connections made 33
Total[0.1144] DEBUG: Creating Local Connection 32.
Total[0.1171] DEBUG: Total Connections made 34
Total[0.1171] DEBUG: Creating Local Connection 33.
Total[0.1199] DEBUG: Total Connections made 35
Total[0.1200] DEBUG: Creating Local Connection 34.
Total[0.1228] DEBUG: Total Connections made 36
Total[0.1228] DEBUG: Creating Local Connection 35.
Total[0.1258] DEBUG: Total Connections made 37
Total[0.1258] DEBUG: Creating Local Connection 36.
Total[0.1287] DEBUG: Total Connections made 38
Total[0.1288] DEBUG: Creating Local Connection 37.
Total[0.1315] DEBUG: Total Connections made 39
Total[0.1316] DEBUG: Creating Local Connection 38.
Total[0.1346] DEBUG: Total Connections made 40
Total[0.1347] DEBUG: Creating Local Connection 39.
Total[0.1381] DEBUG: Total Connections made 41
Total[0.1381] DEBUG: Creating Local Connection 40.
Total[0.1411] DEBUG: Total Connections made 42
Total[0.1411] DEBUG: Creating Local Connection 41.
Total[0.1437] DEBUG: Total Connections made 43
Total[0.1437] DEBUG: Creating Local Connection 42.
Total[0.1465] DEBUG: Total Connections made 44
Total[0.1465] DEBUG: Creating Local Connection 43.
Total[0.1490] DEBUG: Total Connections made 45
Total[0.1490] DEBUG: Creating Local Connection 44.
Total[0.1526] DEBUG: Total Connections made 46
Total[0.1527] DEBUG: Version 1.2.21 starting
Total[0.1527] DEBUG: MySQL is Thread Safe!
Total[0.1527] DEBUG: Spine running as 2645 UID, 0 EUID
Total[0.1528] DEBUG: Spine is running as root.
Total[0.1528] DEBUG: Spine has got ICMP
Total[0.1529] DEBUG: Initializing Net-SNMP API
Total[0.1529] DEBUG: Issues with SNMP Header Version information, assuming old version of Net-SNMP.
Total[0.1551] DEBUG: Initializing PHP Script Server(s)
Total[0.1572] Spine will support multithread device polling.
Total[0.1574] DEBUG: Initial Value of Available Threads is 45 (0 outstanding)
Total[0.1576] DEBUG: Valid Thread to be Created (140278690002688)
Total[0.1576] DEBUG: Available Threads is 44 (1 outstanding)
Total[0.1577] DEBUG: Device[0] HT[1] In Poller, About to Start Polling
Total[0.1579] DEBUG: Valid Thread to be Created (140278597940992)
Total[0.1579] DEBUG: Available Threads is 43 (2 outstanding)
Total[0.1579] DEBUG: Traversing Local Connection Pool for free connection.
Total[0.1579] WARNING: Device[1201] polling sleeping while waiting for 2 Threads to End
Total[0.1580] DEBUG: Device[1201] HT[1] In Poller, About to Start Polling
Total[0.1580] DEBUG: Checking Local Pool ID 0.
Total[0.1580] DEBUG: Allocating Local Pool ID 0.
Total[0.1581] DEBUG: Traversing Local Connection Pool for free connection.
Total[0.1581] DEBUG: Checking Local Pool ID 0.
Total[0.1581] DEBUG: Checking Local Pool ID 1.
Total[0.1581] DEBUG: Allocating Local Pool ID 1.
Total[0.1584] DEBUG: Freeing Local Pool ID 1
Total[0.1591] Device[0] HT[1] Total Time: 0.0013 Seconds
Total[0.1593] DEBUG: Freeing Local Pool ID 0
Total[0.1594] DEBUG: Device[0] HT[1] DEBUG: HOST COMPLETE: About to Exit Device Polling Thread Function
Total[0.6581] The final count of Threads is 0
Total[0.6581] INFO: Thread complete for Device[0] and 0 to 0 sources
Total[0.6582] INFO: Thread incomplete for Device[1201] and 0 to 0 sources
Total[0.6582] DEBUG: Closing Local Connection Pool ID 0
Total[0.6584] DEBUG: Closing Local Connection Pool ID 1
Total[0.6585] DEBUG: Closing Local Connection Pool ID 2
Total[0.6587] DEBUG: Closing Local Connection Pool ID 3
Total[0.6588] DEBUG: Closing Local Connection Pool ID 4
Total[0.6588] DEBUG: Closing Local Connection Pool ID 5
Total[0.6588] DEBUG: Closing Local Connection Pool ID 6
Total[0.6589] DEBUG: Closing Local Connection Pool ID 7
Total[0.6589] DEBUG: Closing Local Connection Pool ID 8
Total[0.6590] DEBUG: Closing Local Connection Pool ID 9
Total[0.6590] DEBUG: Closing Local Connection Pool ID 10
Total[0.6590] DEBUG: Closing Local Connection Pool ID 11
Total[0.6591] DEBUG: Closing Local Connection Pool ID 12
Total[0.6591] DEBUG: Closing Local Connection Pool ID 13
Total[0.6592] DEBUG: Closing Local Connection Pool ID 14
Total[0.6592] DEBUG: Closing Local Connection Pool ID 15
Total[0.6593] DEBUG: Closing Local Connection Pool ID 16
Total[0.6593] DEBUG: Closing Local Connection Pool ID 17
Total[0.6594] DEBUG: Closing Local Connection Pool ID 18
Total[0.6594] DEBUG: Closing Local Connection Pool ID 19
Total[0.6595] DEBUG: Closing Local Connection Pool ID 20
Total[0.6595] DEBUG: Closing Local Connection Pool ID 21
Total[0.6595] DEBUG: Closing Local Connection Pool ID 22
Total[0.6596] DEBUG: Closing Local Connection Pool ID 23
Total[0.6596] DEBUG: Closing Local Connection Pool ID 24
Total[0.6597] DEBUG: Closing Local Connection Pool ID 25
Total[0.6597] DEBUG: Closing Local Connection Pool ID 26
Total[0.6598] DEBUG: Closing Local Connection Pool ID 27
Total[0.6598] DEBUG: Closing Local Connection Pool ID 28
Total[0.6599] DEBUG: Closing Local Connection Pool ID 29
Total[0.6599] DEBUG: Closing Local Connection Pool ID 30
Total[0.6599] DEBUG: Closing Local Connection Pool ID 31
Total[0.6600] DEBUG: Closing Local Connection Pool ID 32
Total[0.6600] DEBUG: Closing Local Connection Pool ID 33
Total[0.6601] DEBUG: Closing Local Connection Pool ID 34
Total[0.6601] DEBUG: Closing Local Connection Pool ID 35
Total[0.6602] DEBUG: Closing Local Connection Pool ID 36
Total[0.6602] DEBUG: Closing Local Connection Pool ID 37
Total[0.6602] DEBUG: Closing Local Connection Pool ID 38
Total[0.6603] DEBUG: Closing Local Connection Pool ID 39
Total[0.6603] DEBUG: Closing Local Connection Pool ID 40
Total[0.6604] DEBUG: Closing Local Connection Pool ID 41
Total[0.6604] DEBUG: Closing Local Connection Pool ID 42
Total[0.6605] DEBUG: Closing Local Connection Pool ID 43
Total[0.6605] DEBUG: Closing Local Connection Pool ID 44
Total[0.6605] DEBUG: Thread Cleanup Complete
Total[0.6606] DEBUG: PHP Script Server Pipes Closed
Total[0.6606] DEBUG: Allocated Variable Memory Freed
Total[0.6606] DEBUG: MYSQL Free & Close Completed
Total[0.6607] DEBUG: Net-SNMP Close Completed
Total[0.6607] Time: 0.6606 s, Threads: 45, Devices: 2

System

Screenshots

device hosts

TheWitness commented 2 years ago

Run this:

SELECT * FROM host WHERE id = ?\G

Post the output, black out identifiable information. That spine output was useless.

TheWitness commented 2 years ago

I fixed your spine output to make it readable.

TheWitness commented 2 years ago

You should also run the cli:

cd /var/www/html/cacti/cli
php -q audit_database.php --report

Post any exceptions.

herr-nandez commented 2 years ago

Hello TheWitness, Thank you helping me. Here's the output:

mysql> status
--------------
/u00/app/mysql/mysqlclient/bin/mysql  Ver 8.0.29-commercial for Linux on x86_64 (MySQL Enterprise Server - Commercial)
<cut>
mysql> SELECT * FROM cacti.host WHERE id = ?\G
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?' at line 1
mysql> SELECT * FROM cacti.host WHERE id = ?\G;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?' at line 1
ERROR: 
No query specified

mysql> 
user@server:/opt/data/www/cacti/cli> php -q audit_database.php --report
mysql: [Warning] Using a password on the command line interface can be insecure.
SUCCESS: Loaded the Audit Schema
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graph_templates'                  
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'graph_template_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'graph_type', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'total', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'total_type', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'order_type', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'created', Attribute 'Extra' invalid. Should be: '', Is: 'DEFAULT_GENERATED'
ERROR Col: 'user_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 8, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graph_templates_graph'            
ERROR Col: 'aggregate_template_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'height', Attribute 'Type' invalid. Should be: 'mediumint(8)', Is: 'mediumint'
ERROR Col: 'width', Attribute 'Type' invalid. Should be: 'mediumint(8)', Is: 'mediumint'
ERROR Col: 'base_value', Attribute 'Type' invalid. Should be: 'mediumint(8)', Is: 'mediumint'
ERROR Col: 'right_axis_format', Attribute 'Type' invalid. Should be: 'mediumint(8)', Is: 'mediumint'

ERRORS: 5, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graph_templates_item'             
ERROR Col: 'aggregate_template_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'graph_templates_item_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'sequence', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'color_template', Attribute 'Type' invalid. Should be: 'int(11)', Is: 'int'
ERROR Col: 'graph_type_id', Attribute 'Type' invalid. Should be: 'tinyint(3)', Is: 'tinyint'
ERROR Col: 'cdef_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 6, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graphs'                           
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'aggregate_template_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'local_graph_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'graph_template_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'graph_type', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'total', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'total_type', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'order_type', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'created', Attribute 'Extra' invalid. Should be: 'on update CURRENT_TIMESTAMP', Is: 'DEFAULT_GENERATED on update CURRENT_TIMESTAMP'
ERROR Col: 'user_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 10, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graphs_graph_item'                
ERROR Col: 'aggregate_graph_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'graph_templates_item_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'sequence', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'color_template', Attribute 'Type' invalid. Should be: 'int(11) unsigned', Is: 'int unsigned'
ERROR Col: 'graph_type_id', Attribute 'Type' invalid. Should be: 'tinyint(3)', Is: 'tinyint'
ERROR Col: 'cdef_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 6, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graphs_items'                     
ERROR Col: 'aggregate_graph_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'local_graph_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'sequence', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 3, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'automation_devices'                         
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'bigint(20) unsigned', Is: 'bigint unsigned'
ERROR Col: 'network_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'snmp_version', Attribute 'Type' invalid. Should be: 'tinyint(1) unsigned', Is: 'tinyint unsigned'
ERROR Col: 'snmp_port', Attribute 'Type' invalid. Should be: 'mediumint(5) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'sysUptime', Attribute 'Type' invalid. Should be: 'bigint(20) unsigned', Is: 'bigint unsigned'
ERROR Col: 'snmp', Attribute 'Type' invalid. Should be: 'tinyint(4)', Is: 'tinyint'
ERROR Col: 'known', Attribute 'Type' invalid. Should be: 'tinyint(4)', Is: 'tinyint'
ERROR Col: 'up', Attribute 'Type' invalid. Should be: 'tinyint(4)', Is: 'tinyint'
ERROR Col: 'time', Attribute 'Type' invalid. Should be: 'int(11)', Is: 'int'

ERRORS: 9, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'automation_graph_rule_items'                
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'rule_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'sequence', Attribute 'Type' invalid. Should be: 'smallint(3) unsigned', Is: 'smallint unsigned'
ERROR Col: 'operation', Attribute 'Type' invalid. Should be: 'smallint(3) unsigned', Is: 'smallint unsigned'
ERROR Col: 'operator', Attribute 'Type' invalid. Should be: 'smallint(3) unsigned', Is: 'smallint unsigned'

ERRORS: 5, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'automation_graph_rules'                     
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'snmp_query_id', Attribute 'Type' invalid. Should be: 'smallint(3) unsigned', Is: 'smallint unsigned'
ERROR Col: 'graph_type_id', Attribute 'Type' invalid. Should be: 'smallint(3) unsigned', Is: 'smallint unsigned'

ERRORS: 3, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'automation_ips'                             
ERROR Col: 'network_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'pid', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'status', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'thread', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 4, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'automation_match_rule_items'                
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'rule_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'rule_type', Attribute 'Type' invalid. Should be: 'smallint(3) unsigned', Is: 'smallint unsigned'
ERROR Col: 'sequence', Attribute 'Type' invalid. Should be: 'smallint(3) unsigned', Is: 'smallint unsigned'
ERROR Col: 'operation', Attribute 'Type' invalid. Should be: 'smallint(3) unsigned', Is: 'smallint unsigned'
ERROR Col: 'operator', Attribute 'Type' invalid. Should be: 'smallint(3) unsigned', Is: 'smallint unsigned'

ERRORS: 6, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'automation_networks'                        
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'poller_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'site_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'snmp_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'total_ips', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'up_hosts', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'snmp_hosts', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'ping_method', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'ping_port', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'ping_timeout', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'ping_retries', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'sched_type', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'threads', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'run_limit', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'recur_every', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 15, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'automation_processes'                       
ERROR Col: 'pid', Attribute 'Type' invalid. Should be: 'int(8) unsigned', Is: 'int unsigned'
ERROR Col: 'poller_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'network_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'up_hosts', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'snmp_hosts', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 5, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'automation_snmp'                            
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'automation_snmp_items'                      
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'snmp_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'sequence', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'snmp_version', Attribute 'Type' invalid. Should be: 'tinyint(1) unsigned', Is: 'tinyint unsigned'
ERROR Col: 'snmp_port', Attribute 'Type' invalid. Should be: 'mediumint(5) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'snmp_timeout', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'snmp_retries', Attribute 'Type' invalid. Should be: 'tinyint(1) unsigned', Is: 'tinyint unsigned'
ERROR Col: 'max_oids', Attribute 'Type' invalid. Should be: 'int(12) unsigned', Is: 'int unsigned'
ERROR Col: 'bulk_walk_size', Attribute 'Type' invalid. Should be: 'int(11)', Is: 'int'

ERRORS: 9, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'automation_templates'                       
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(8)', Is: 'int'
ERROR Col: 'host_template', Attribute 'Type' invalid. Should be: 'int(8)', Is: 'int'
ERROR Col: 'availability_method', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'sequence', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 4, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'automation_tree_rule_items'                 
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'rule_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'sequence', Attribute 'Type' invalid. Should be: 'smallint(3) unsigned', Is: 'smallint unsigned'
ERROR Col: 'sort_type', Attribute 'Type' invalid. Should be: 'smallint(3) unsigned', Is: 'smallint unsigned'

ERRORS: 4, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'automation_tree_rules'                      
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'tree_id', Attribute 'Type' invalid. Should be: 'smallint(3) unsigned', Is: 'smallint unsigned'
ERROR Col: 'tree_item_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'leaf_type', Attribute 'Type' invalid. Should be: 'smallint(3) unsigned', Is: 'smallint unsigned'
ERROR Col: 'host_grouping_type', Attribute 'Type' invalid. Should be: 'smallint(3) unsigned', Is: 'smallint unsigned'

ERRORS: 5, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'cdef'                                       
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'system', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'cdef_items'                                 
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'cdef_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'sequence', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'type', Attribute 'Type' invalid. Should be: 'tinyint(2)', Is: 'tinyint'

ERRORS: 4, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'color_template_items'                       
ERROR Col: 'color_template_item_id', Attribute 'Type' invalid. Should be: 'int(12) unsigned', Is: 'int unsigned'
ERROR Col: 'color_template_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'color_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'sequence', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 4, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'color_templates'                            
ERROR Col: 'color_template_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'colors'                                     
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_debug'                                 
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(11) unsigned', Is: 'int unsigned'
ERROR Col: 'started', Attribute 'Type' invalid. Should be: 'int(11)', Is: 'int'
ERROR Col: 'done', Attribute 'Type' invalid. Should be: 'int(11)', Is: 'int'
ERROR Col: 'user', Attribute 'Type' invalid. Should be: 'int(11)', Is: 'int'
ERROR Col: 'datasource', Attribute 'Type' invalid. Should be: 'int(11)', Is: 'int'

ERRORS: 5, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_input'                                 
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'type_id', Attribute 'Type' invalid. Should be: 'tinyint(2)', Is: 'tinyint'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_input_data'                            
ERROR Col: 'data_input_field_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'data_template_data_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_input_fields'                          
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'data_input_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'sequence', Attribute 'Type' invalid. Should be: 'smallint(5)', Is: 'smallint'

ERRORS: 3, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_local'                                 
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'data_template_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'host_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'snmp_query_id', Attribute 'Type' invalid. Should be: 'mediumint(8)', Is: 'mediumint'
ERROR Col: 'orphan', Attribute 'Type' invalid. Should be: 'tinyint(1) unsigned', Is: 'tinyint unsigned'

ERRORS: 5, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_profiles'                       
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'step', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'heartbeat', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 3, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_profiles_cf'                    
ERROR Col: 'data_source_profile_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'consolidation_function_id', Attribute 'Type' invalid. Should be: 'smallint(5) unsigned', Is: 'smallint unsigned'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_profiles_rra'                   
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'data_source_profile_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'steps', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'rows', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'timespan', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 5, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_purge_action'                   
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'local_data_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'action', Attribute 'Type' invalid. Should be: 'tinyint(2)', Is: 'tinyint'

ERRORS: 3, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_purge_temp'                     
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'local_data_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'size', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'in_cacti', Attribute 'Type' invalid. Should be: 'tinyint(4)', Is: 'tinyint'
ERROR Col: 'data_template_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 5, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_daily'                    
ERROR Col: 'local_data_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_hourly'                   
ERROR Col: 'local_data_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_hourly_cache'             
ERROR Col: 'local_data_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_hourly_last'              
ERROR Col: 'local_data_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_monthly'                  
ERROR Col: 'local_data_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_weekly'                   
ERROR Col: 'local_data_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_source_stats_yearly'                   
ERROR Col: 'local_data_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_template'                              
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_template_data'                         
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'local_data_template_data_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'local_data_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'data_template_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'data_input_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'rrd_step', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'data_source_profile_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 7, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'data_template_rrd'                          
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'local_data_template_rrd_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'local_data_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'data_template_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'rrd_heartbeat', Attribute 'Type' invalid. Should be: 'mediumint(6)', Is: 'mediumint'
ERROR Col: 'data_source_type_id', Attribute 'Type' invalid. Should be: 'smallint(5)', Is: 'smallint'
ERROR Col: 'data_input_field_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 7, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'external_links'                             
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(11)', Is: 'int'
ERROR Col: 'sortorder', Attribute 'Type' invalid. Should be: 'int(11)', Is: 'int'
ERROR Col: 'refresh', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 3, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'graph_local'                                
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'graph_template_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'host_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'snmp_query_id', Attribute 'Type' invalid. Should be: 'mediumint(8)', Is: 'mediumint'
ERROR Col: 'snmp_query_graph_id', Attribute 'Type' invalid. Should be: 'mediumint(8)', Is: 'mediumint'

ERRORS: 5, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'graph_template_input'                       
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'graph_template_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'graph_template_input_defs'                  
ERROR Col: 'graph_template_input_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'graph_template_item_id', Attribute 'Type' invalid. Should be: 'int(12) unsigned', Is: 'int unsigned'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates'                            
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates_gprint'                     
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates_graph'                      
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'local_graph_template_graph_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'local_graph_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'graph_template_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'height', Attribute 'Type' invalid. Should be: 'mediumint(8)', Is: 'mediumint'
ERROR Col: 'width', Attribute 'Type' invalid. Should be: 'mediumint(8)', Is: 'mediumint'
ERROR Col: 'base_value', Attribute 'Type' invalid. Should be: 'mediumint(8)', Is: 'mediumint'
ERROR Col: 'right_axis_format', Attribute 'Type' invalid. Should be: 'mediumint(8)', Is: 'mediumint'

ERRORS: 8, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'graph_templates_item'                       
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'local_graph_template_item_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'local_graph_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'graph_template_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'task_item_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'color_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'graph_type_id', Attribute 'Type' invalid. Should be: 'tinyint(3)', Is: 'tinyint'
ERROR Col: 'dash_offset', Attribute 'Type' invalid. Should be: 'mediumint(4)', Is: 'mediumint'
ERROR Col: 'cdef_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'vdef_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'consolidation_function_id', Attribute 'Type' invalid. Should be: 'tinyint(2)', Is: 'tinyint'
ERROR Col: 'gprint_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'sequence', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 13, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'graph_tree'                                 
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'smallint(5) unsigned', Is: 'smallint unsigned'
ERROR Col: 'locked', Attribute 'Type' invalid. Should be: 'tinyint(4)', Is: 'tinyint'
ERROR Col: 'sort_type', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint unsigned'
ERROR Col: 'sequence', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'user_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'modified_by', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 6, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'graph_tree_items'                           
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'bigint(20) unsigned', Is: 'bigint unsigned'
ERROR Col: 'parent', Attribute 'Type' invalid. Should be: 'bigint(20) unsigned', Is: 'bigint unsigned'
ERROR Col: 'position', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'graph_tree_id', Attribute 'Type' invalid. Should be: 'smallint(5) unsigned', Is: 'smallint unsigned'
ERROR Col: 'local_graph_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'host_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'site_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'host_grouping_type', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint unsigned'
ERROR Col: 'sort_children_type', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint unsigned'

ERRORS: 9, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'host'                                       
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'poller_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'site_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'host_template_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'snmp_version', Attribute 'Type' invalid. Should be: 'tinyint(1) unsigned', Is: 'tinyint unsigned'
ERROR Col: 'snmp_port', Attribute 'Type' invalid. Should be: 'mediumint(5) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'snmp_timeout', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'snmp_sysUpTimeInstance', Attribute 'Type' invalid. Should be: 'bigint(20) unsigned', Is: 'bigint unsigned'
ERROR Col: 'availability_method', Attribute 'Type' invalid. Should be: 'smallint(5) unsigned', Is: 'smallint unsigned'
ERROR Col: 'ping_method', Attribute 'Type' invalid. Should be: 'smallint(5) unsigned', Is: 'smallint unsigned'
ERROR Col: 'ping_port', Attribute 'Type' invalid. Should be: 'int(12) unsigned', Is: 'int unsigned'
ERROR Col: 'ping_timeout', Attribute 'Type' invalid. Should be: 'int(12) unsigned', Is: 'int unsigned'
ERROR Col: 'ping_retries', Attribute 'Type' invalid. Should be: 'int(12) unsigned', Is: 'int unsigned'
ERROR Col: 'max_oids', Attribute 'Type' invalid. Should be: 'int(12) unsigned', Is: 'int unsigned'
ERROR Col: 'bulk_walk_size', Attribute 'Type' invalid. Should be: 'int(11)', Is: 'int'
ERROR Col: 'device_threads', Attribute 'Type' invalid. Should be: 'tinyint(2) unsigned', Is: 'tinyint unsigned'
ERROR Col: 'status', Attribute 'Type' invalid. Should be: 'tinyint(2)', Is: 'tinyint'
ERROR Col: 'status_event_count', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'total_polls', Attribute 'Type' invalid. Should be: 'int(12) unsigned', Is: 'int unsigned'
ERROR Col: 'failed_polls', Attribute 'Type' invalid. Should be: 'int(12) unsigned', Is: 'int unsigned'
ERROR Col: 'last_updated', Attribute 'Extra' invalid. Should be: 'on update CURRENT_TIMESTAMP', Is: 'DEFAULT_GENERATED on update CURRENT_TIMESTAMP'

ERRORS: 21, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'host_graph'                                 
ERROR Col: 'host_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'graph_template_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'host_snmp_cache'                            
ERROR Col: 'host_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'snmp_query_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'present', Attribute 'Type' invalid. Should be: 'tinyint(4)', Is: 'tinyint'
ERROR Col: 'last_updated', Attribute 'Extra' invalid. Should be: 'on update CURRENT_TIMESTAMP', Is: 'DEFAULT_GENERATED on update CURRENT_TIMESTAMP'

ERRORS: 4, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'host_snmp_query'                            
ERROR Col: 'host_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'snmp_query_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'reindex_method', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint unsigned'

ERRORS: 3, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'host_template'                              
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'host_template_graph'                        
ERROR Col: 'host_template_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'graph_template_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'host_template_snmp_query'                   
ERROR Col: 'host_template_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'snmp_query_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_config'                              
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'status', Attribute 'Type' invalid. Should be: 'tinyint(2)', Is: 'tinyint'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_db_changes'                          
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_hooks'                               
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'status', Attribute 'Type' invalid. Should be: 'int(8)', Is: 'int'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_dashboard'                  - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_panel_dashboard'            - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_panel_data'                 - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_panel_definition'           - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_trends'                     - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_intropage_user_auth'                  - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_notification_lists'                   - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_realms'                              
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_contacts'                       - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_daemon_data'                    - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_daemon_processes'               - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_host_failed'                    - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_host_template'                  - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_log'                            - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_template_contact'               - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'plugin_thold_threshold_contact'              - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'poller'                                     
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'smallint(5) unsigned', Is: 'smallint unsigned'
ERROR Col: 'status', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'dbport', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'dbretries', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'total_polls', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'processes', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'threads', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'sync_interval', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'snmp', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'script', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'server', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 11, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'poller_command'                             
ERROR Col: 'poller_id', Attribute 'Type' invalid. Should be: 'smallint(5) unsigned', Is: 'smallint unsigned'
ERROR Col: 'action', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint unsigned'
ERROR Col: 'last_updated', Attribute 'Extra' invalid. Should be: 'on update CURRENT_TIMESTAMP', Is: 'DEFAULT_GENERATED on update CURRENT_TIMESTAMP'

ERRORS: 3, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'poller_data_template_field_mappings'        
ERROR Col: 'data_template_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'last_updated', Attribute 'Extra' invalid. Should be: 'on update CURRENT_TIMESTAMP', Is: 'DEFAULT_GENERATED on update CURRENT_TIMESTAMP'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'poller_item'                                
ERROR Col: 'local_data_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'poller_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'host_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'action', Attribute 'Type' invalid. Should be: 'tinyint(2) unsigned', Is: 'tinyint unsigned'
ERROR Col: 'present', Attribute 'Type' invalid. Should be: 'tinyint(4)', Is: 'tinyint'
ERROR Col: 'last_updated', Attribute 'Extra' invalid. Should be: 'on update CURRENT_TIMESTAMP', Is: 'DEFAULT_GENERATED on update CURRENT_TIMESTAMP'
ERROR Col: 'snmp_version', Attribute 'Type' invalid. Should be: 'tinyint(1) unsigned', Is: 'tinyint unsigned'
ERROR Col: 'snmp_port', Attribute 'Type' invalid. Should be: 'mediumint(5) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'snmp_timeout', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'rrd_num', Attribute 'Type' invalid. Should be: 'tinyint(2) unsigned', Is: 'tinyint unsigned'
ERROR Col: 'rrd_step', Attribute 'Type' invalid. Should be: 'mediumint(8)', Is: 'mediumint'
ERROR Col: 'rrd_next_step', Attribute 'Type' invalid. Should be: 'mediumint(8)', Is: 'mediumint'

ERRORS: 12, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output'                              
ERROR Col: 'local_data_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output_boost'                        
ERROR Col: 'local_data_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output_boost_local_data_ids'         
ERROR Col: 'local_data_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'process_handler', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output_boost_processes'              
ERROR Col: 'sock_int_value', Attribute 'Type' invalid. Should be: 'bigint(20) unsigned', Is: 'bigint unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'poller_output_realtime'                     
ERROR Col: 'local_data_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'poller_reindex'                             
ERROR Col: 'host_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'data_query_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'action', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint unsigned'
ERROR Col: 'present', Attribute 'Type' invalid. Should be: 'tinyint(4)', Is: 'tinyint'

ERRORS: 4, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'poller_resource_cache'                      
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'attributes', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'poller_time'                                
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'bigint(20) unsigned', Is: 'bigint unsigned'
ERROR Col: 'pid', Attribute 'Type' invalid. Should be: 'int(11) unsigned', Is: 'int unsigned'
ERROR Col: 'poller_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 3, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'processes'                                  
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'bigint(20) unsigned', Is: 'bigint unsigned'
ERROR Col: 'pid', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'taskid', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'timeout', Attribute 'Type' invalid. Should be: 'int(11)', Is: 'int'
ERROR Col: 'started', Attribute 'Extra' invalid. Should be: '', Is: 'DEFAULT_GENERATED'

ERRORS: 5, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'reports'                                    
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'user_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'font_size', Attribute 'Type' invalid. Should be: 'smallint(2) unsigned', Is: 'smallint unsigned'
ERROR Col: 'alignment', Attribute 'Type' invalid. Should be: 'smallint(2) unsigned', Is: 'smallint unsigned'
ERROR Col: 'intrvl', Attribute 'Type' invalid. Should be: 'smallint(2) unsigned', Is: 'smallint unsigned'
ERROR Col: 'count', Attribute 'Type' invalid. Should be: 'smallint(2) unsigned', Is: 'smallint unsigned'
ERROR Col: 'offset', Attribute 'Type' invalid. Should be: 'int(12) unsigned', Is: 'int unsigned'
ERROR Col: 'mailtime', Attribute 'Type' invalid. Should be: 'bigint(20) unsigned', Is: 'bigint unsigned'
ERROR Col: 'attachment_type', Attribute 'Type' invalid. Should be: 'smallint(2) unsigned', Is: 'smallint unsigned'
ERROR Col: 'graph_height', Attribute 'Type' invalid. Should be: 'smallint(2) unsigned', Is: 'smallint unsigned'
ERROR Col: 'graph_width', Attribute 'Type' invalid. Should be: 'smallint(2) unsigned', Is: 'smallint unsigned'
ERROR Col: 'graph_columns', Attribute 'Type' invalid. Should be: 'smallint(2) unsigned', Is: 'smallint unsigned'
ERROR Col: 'lastsent', Attribute 'Type' invalid. Should be: 'bigint(20) unsigned', Is: 'bigint unsigned'

ERRORS: 13, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'reports_items'                              
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'report_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'item_type', Attribute 'Type' invalid. Should be: 'tinyint(1) unsigned', Is: 'tinyint unsigned'
ERROR Col: 'tree_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'branch_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'site_id', Attribute 'Type' invalid. Should be: 'int(11)', Is: 'int'
ERROR Col: 'host_template_id', Attribute 'Type' invalid. Should be: 'int(11)', Is: 'int'
ERROR Col: 'host_id', Attribute 'Type' invalid. Should be: 'int(11)', Is: 'int'
ERROR Col: 'graph_template_id', Attribute 'Type' invalid. Should be: 'int(11)', Is: 'int'
ERROR Col: 'local_graph_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'timespan', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'align', Attribute 'Type' invalid. Should be: 'tinyint(1) unsigned', Is: 'tinyint unsigned'
ERROR Col: 'font_size', Attribute 'Type' invalid. Should be: 'smallint(2) unsigned', Is: 'smallint unsigned'
ERROR Col: 'sequence', Attribute 'Type' invalid. Should be: 'smallint(5) unsigned', Is: 'smallint unsigned'

ERRORS: 14, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'sessions'                                   
ERROR Col: 'access', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'user_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'start_time', Attribute 'Extra' invalid. Should be: '', Is: 'DEFAULT_GENERATED'
ERROR Col: 'transactions', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 4, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'settings'                                    - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'settings_tree'                              
ERROR Col: 'user_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'graph_tree_item_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'settings_user'                              
ERROR Col: 'user_id', Attribute 'Type' invalid. Should be: 'smallint(8) unsigned', Is: 'smallint unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'settings_user_group'                        
ERROR Col: 'group_id', Attribute 'Type' invalid. Should be: 'smallint(8) unsigned', Is: 'smallint unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'sites'                                      
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'zoom', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint unsigned'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query'                                 
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'graph_template_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'data_input_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 3, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph'                           
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'snmp_query_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'graph_template_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 3, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph_rrd'                       
ERROR Col: 'snmp_query_graph_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'data_template_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'data_template_rrd_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 3, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph_rrd_sv'                    
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'snmp_query_graph_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'data_template_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'sequence', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 4, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'snmp_query_graph_sv'                        
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'snmp_query_graph_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'sequence', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 3, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_cache'                             - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_cache_notifications'              
ERROR Col: 'sequence_id', Attribute 'Type' invalid. Should be: 'smallint(6)', Is: 'smallint'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_cache_textual_conventions'         - Clean
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_managers'                         
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(8)', Is: 'int'
ERROR Col: 'snmp_version', Attribute 'Type' invalid. Should be: 'tinyint(1) unsigned', Is: 'tinyint unsigned'
ERROR Col: 'snmp_port', Attribute 'Type' invalid. Should be: 'mediumint(5) unsigned', Is: 'mediumint unsigned'

ERRORS: 3, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_managers_notifications'           
ERROR Col: 'manager_id', Attribute 'Type' invalid. Should be: 'int(8)', Is: 'int'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_mibs'                             
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(8)', Is: 'int'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'snmpagent_notifications_log'                
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(12)', Is: 'int'
ERROR Col: 'time', Attribute 'Type' invalid. Should be: 'int(24)', Is: 'int'
ERROR Col: 'manager_id', Attribute 'Type' invalid. Should be: 'int(8)', Is: 'int'

ERRORS: 3, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'table_columns'                              
ERROR Col: 'table_sequence', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'table_indexes'                              
ERROR Col: 'idx_non_unique', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'idx_seq_in_index', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'idx_cardinality', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 3, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'thold_data'                                  - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'thold_template'                              - Plugin Detected
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth'                                  
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'realm', Attribute 'Type' invalid. Should be: 'mediumint(8)', Is: 'mediumint'
ERROR Col: 'policy_graphs', Attribute 'Type' invalid. Should be: 'tinyint(1) unsigned', Is: 'tinyint unsigned'
ERROR Col: 'policy_trees', Attribute 'Type' invalid. Should be: 'tinyint(1) unsigned', Is: 'tinyint unsigned'
ERROR Col: 'policy_hosts', Attribute 'Type' invalid. Should be: 'tinyint(1) unsigned', Is: 'tinyint unsigned'
ERROR Col: 'policy_graph_templates', Attribute 'Type' invalid. Should be: 'tinyint(1) unsigned', Is: 'tinyint unsigned'
ERROR Col: 'lastchange', Attribute 'Type' invalid. Should be: 'int(12)', Is: 'int'
ERROR Col: 'lastlogin', Attribute 'Type' invalid. Should be: 'int(12)', Is: 'int'
ERROR Col: 'failed_attempts', Attribute 'Type' invalid. Should be: 'int(5)', Is: 'int'
ERROR Col: 'lastfail', Attribute 'Type' invalid. Should be: 'int(12)', Is: 'int'
ERROR Col: 'reset_perms', Attribute 'Type' invalid. Should be: 'int(12) unsigned', Is: 'int unsigned'

ERRORS: 11, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_cache'                            
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'user_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'last_update', Attribute 'Extra' invalid. Should be: '', Is: 'DEFAULT_GENERATED'

ERRORS: 3, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group'                            
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'policy_graphs', Attribute 'Type' invalid. Should be: 'tinyint(1) unsigned', Is: 'tinyint unsigned'
ERROR Col: 'policy_trees', Attribute 'Type' invalid. Should be: 'tinyint(1) unsigned', Is: 'tinyint unsigned'
ERROR Col: 'policy_hosts', Attribute 'Type' invalid. Should be: 'tinyint(1) unsigned', Is: 'tinyint unsigned'
ERROR Col: 'policy_graph_templates', Attribute 'Type' invalid. Should be: 'tinyint(1) unsigned', Is: 'tinyint unsigned'

ERRORS: 5, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group_members'                    
ERROR Col: 'group_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'user_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group_perms'                      
ERROR Col: 'group_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'item_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'type', Attribute 'Type' invalid. Should be: 'tinyint(2) unsigned', Is: 'tinyint unsigned'

ERRORS: 3, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_group_realm'                      
ERROR Col: 'group_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'realm_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_perms'                            
ERROR Col: 'user_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'item_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'type', Attribute 'Type' invalid. Should be: 'tinyint(2) unsigned', Is: 'tinyint unsigned'

ERRORS: 3, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'user_auth_realm'                            
ERROR Col: 'realm_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'user_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 2, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'user_domains'                               
ERROR Col: 'domain_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'type', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'defdomain', Attribute 'Type' invalid. Should be: 'tinyint(3)', Is: 'tinyint'
ERROR Col: 'user_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'

ERRORS: 4, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'user_domains_ldap'                          
ERROR Col: 'domain_id', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'port', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'port_ssl', Attribute 'Type' invalid. Should be: 'int(10) unsigned', Is: 'int unsigned'
ERROR Col: 'proto_version', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint unsigned'
ERROR Col: 'encryption', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint unsigned'
ERROR Col: 'referrals', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint unsigned'
ERROR Col: 'mode', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint unsigned'
ERROR Col: 'group_member_type', Attribute 'Type' invalid. Should be: 'tinyint(3) unsigned', Is: 'tinyint unsigned'

ERRORS: 8, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'user_log'                                   
ERROR Col: 'user_id', Attribute 'Type' invalid. Should be: 'mediumint(8)', Is: 'mediumint'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'vdef'                                       
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'

ERRORS: 1, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'vdef_items'                                 
ERROR Col: 'id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'vdef_id', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'sequence', Attribute 'Type' invalid. Should be: 'mediumint(8) unsigned', Is: 'mediumint unsigned'
ERROR Col: 'type', Attribute 'Type' invalid. Should be: 'tinyint(2)', Is: 'tinyint'

ERRORS: 4, WARNINGS: 0
---------------------------------------------------------------------------------------------
Checking Table: 'version'                                     - Clean
---------------------------------------------------------------------------------------------
ERRORS are fixable using the --repair option.  WARNINGS will not be rapaired
due to ambiguous use of the column.
---------------------------------------------------------------------------------------------
TheWitness commented 2 years ago

What MariaDB/MySQL version are you using? It looks like there is some problem there. Also, for the Host query, you need to replace the ? with the device_id.

herr-nandez commented 2 years ago

I'm using MySQL 8.0.29 (Oracle MySQL Enterprise Server), this Version was also used before I upgraded from Cacti 1.2.16. Sorry I got confused by the '?' in your request. The output in the DB looks like this:

mysql> SELECT * FROM host WHERE id = 1201\G
*************************** 1. row ***************************
                    id: 1201
             poller_id: 1
               site_id: 2
      host_template_id: 36
           description: HOSTNAMEREMOVED
              hostname: HOSTNAMEREMOVED
              location: 
                 notes: 
           external_id: 
        snmp_community: COMMUNITY1 COMMUNITY2
          snmp_version: 3
         snmp_username: MYSNMPV3USER
         snmp_password: MYSNMPV3SHA
    snmp_auth_protocol: SHA
  snmp_priv_passphrase: MYSNMPV3AES
    snmp_priv_protocol: AES128
          snmp_context: 
        snmp_engine_id: 
             snmp_port: 161
          snmp_timeout: 500
         snmp_sysDescr: 
      snmp_sysObjectID: 
snmp_sysUpTimeInstance: 0
       snmp_sysContact: 
          snmp_sysName: 
      snmp_sysLocation: 
   availability_method: 2
           ping_method: 1
             ping_port: 23
          ping_timeout: 400
          ping_retries: 1
              max_oids: 20
        bulk_walk_size: -1
        device_threads: 1
               deleted: NULL
              disabled: 
      thold_send_email: 0
      thold_host_email: 0
   thold_failure_count: 0
                status: 0
    status_event_count: 0
      status_fail_date: 0000-00-00 00:00:00
       status_rec_date: 0000-00-00 00:00:00
     status_last_error: 
              min_time: 9.99999
              max_time: 0.00000
              cur_time: 0.00000
              avg_time: 0.00000
          polling_time: 0
           total_polls: 0
          failed_polls: 0
          availability: 100.00000
          last_updated: 2022-08-11 11:26:25
1 row in set (0.00 sec)

mysql> 
herr-nandez commented 2 years ago

I have an interesting update. Creating new hosts will set Column "deleted" in Table "host" to Value NULL. Removing this value with the command

UPDATE `cacti`.`host` SET `deleted` = '' WHERE (`id` = '1201');

will make the devices available in the Cacti GUI and after saving them again and re-create the graphs the RRD files get populated by the poller.

This can be repeated for all Devices matching the following query:

SELECT * FROM host WHERE deleted IS NULL\G
TheWitness commented 2 years ago
ALTER TABLE host MODIFY COLUMN deleted CHAR(2) NOT NULL default '';

Not that you are going to likely have some issues with this MySQL version. For example, the audit script was having some issues that we were unaware of. Keep that in mind. Oracle is breaking compatibility all over the place.

TheWitness commented 2 years ago

Related to https://github.com/Cacti/cacti/issues/4887

TheWitness commented 2 years ago

This will be resolved in 1.2.22 by #4887. For now, just do that alter statement and you will be back in business. I'll be opening a new ticket for additional MySQL 8.x testing and certification. Right now, it's not certified (but most things 'should' work).