Hello i am new to iTop, I am trying for the customization features of iTop community edition. i created a test extension and while trying to install the extension it gives an error.
Error detected during deployment!
iTop configuration has NOT been modified.
Failed to execute mysqldump: mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"') FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = 'itop' AND TABLE_NAME = 'applicationsolution';': Unknown table 'column_statistics' in information_schema (1109)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
This query is done by your module right ? I don't see anything related in the iTop code.
The table exists in MySQL 8 (https://dev.mysql.com/doc/refman/8.0/en/information-schema-column-statistics-table.html) but not on MySQL 5.7 (https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-system-tables.html)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello i am new to iTop, I am trying for the customization features of iTop community edition. i created a test extension and while trying to install the extension it gives an error.
Error detected during deployment!
iTop configuration has NOT been modified.
Failed to execute mysqldump: mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"') FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = 'itop' AND TABLE_NAME = 'applicationsolution';': Unknown table 'column_statistics' in information_schema (1109)
Hello,
This query is done by your module right ? I don't see anything related in the iTop code.
The table exists in MySQL 8 (https://dev.mysql.com/doc/refman/8.0/en/information-schema-column-statistics-table.html) but not on MySQL 5.7 (https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-system-tables.html)