I am trying to go through the tutorial on adding a filed to the Server class but I keep getting an error message when using the Data Model Toolkit to apply my changes. After much experimenting I found that I get the same error when checking a brand new, empty iTop installation, before I have made any changes.
The error message I get is:
Class SynchroAttLinkSet
field 'attribute_qualifier' in table 'priv_sync_att_linkset' has a wrong type: found varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '\'\'' while expecting VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '\''
I have tried running the SQL cut & paste code:
ALTER TABLE priv_sync_att_linkset CHANGE attribute_qualifierattribute_qualifier VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '\''
and then checking again but the same error occurs.
I am running the following stack:
Database : MariaDB 10.4.11
Php : 7.2.30
iTop : 2.7.5-1
iTop setup: core CMDB, simple tickets, simple change, problem & error management
Hello,
This is a known bug that has nothing to do with your modification : Combodo internal ref : N°2607, and also on SF : [#1889]. This isn't blocking, iTop is just sending a useless ALTER query.
Hi all,
I am trying to go through the tutorial on adding a filed to the Server class but I keep getting an error message when using the Data Model Toolkit to apply my changes. After much experimenting I found that I get the same error when checking a brand new, empty iTop installation, before I have made any changes.
The error message I get is:
Class SynchroAttLinkSet
I have tried running the SQL cut & paste code:
ALTER TABLE
priv_sync_att_linkset
CHANGEattribute_qualifier
attribute_qualifier
VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '\''and then checking again but the same error occurs.
I am running the following stack:
Database : MariaDB 10.4.11
Php : 7.2.30
iTop : 2.7.5-1
iTop setup: core CMDB, simple tickets, simple change, problem & error management
The database is empty (new Production selected)
What am I doing wrong?
Thank you, Kevin Joubert
Hello,
This is a known bug that has nothing to do with your modification : Combodo internal ref : N°2607, and also on SF : [#1889]. This isn't blocking, iTop is just sending a useless ALTER query.
Related
Tickets: #1889