Error adding custom fields - Assets

1

HI,
Recently I found out problems adding more custom fields to RT in asset section.
In the mean time i decide to upgrade my rt to the latest version and i managed to do that withou errors…

The question now is that I m still having the old problems …

Could not create CustomField: Internal Error: Couldn’t execute the query 'INSERT INTO CustomFields (UniqueValues, Name, Creator, RenderType, Description, ValuesClass, Type, LastUpdated, Created, MaxValues, BasedOn, LastUpdatedBy, LookupType, CanonicalizeClass, Pattern, Disabled) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'Unknown column ‘UniqueValues’ in ‘field list’

Logs :slight_smile:

`
Sep 14 19:11:03 web RT[15143]: [15143] Could not resolve -lgumbo at /usr/lib/perl5/vendor_perl/5.26.1/x86_64-linux-thread-multi/HTML/Gumbo.pm line 7.
Sep 14 19:11:12 web sshd[15209]: Connection closed by 172.16.0.226 port 46848 [preauth]
Sep 14 19:11:28 web RT[15143]: [15143] DBD::mysql::st execute failed: Unknown column ‘CanonicalizeClass’ in ‘field list’ at /usr/lib/perl5/vendor_perl/5.26.1/DBIx/SearchBuilder/Handle.pm line 586.
Sep 14 19:11:28 web RT[15143]: [15143] RT::Handle=HASH(0x56294fcc4bb0) couldn’t execute the query ‘INSERT INTO CustomFields (CanonicalizeClass, LastUpdatedBy, UniqueValues, Description, Created, MaxValues, LastUpdated, Pattern, RenderType, BasedOn, Creator, LookupType, Disabled, Type, Name, ValuesClass) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ at /usr/lib/perl5/vendor_perl/5.26.1/DBIx/SearchBuilder/Handle.pm line 599.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x56294fcc4bb0), “INSERT INTO CustomFields (CanonicalizeClass, LastUpdatedBy, U”…, undef, 78, 0, “”, “2019-09-14 18:11:28”, 1, …) called at /usr/lib/perl5/vendor_perl/5.26.1/DBIx/SearchBuilder/Handle.pm line 352
DBIx::SearchBuilder::Handle::Insert(RT::Handle=HASH(0x56294fcc4bb0), “CustomFields”, “CanonicalizeClass”, undef, “LastUpdatedBy”, 78, “UniqueValues”, 0, …) called at /usr/lib/perl5/vendor_perl/5.26.1/DBIx/SearchBuilder/Handle/mysql.pm line 36
DBIx::SearchBuilder::Handle::mysql::Insert(RT::Handle=HASH(0x56294fcc4bb0), “CustomFields”, “CanonicalizeClass”, undef, “LastUpdatedBy”, 78, “UniqueValues”, 0, …) called at /usr/lib/perl5/vendor_perl/5.26.1/DBIx/SearchBuilder/Record.pm line 1320
DBIx::SearchBuilder::Record::Create(RT::CustomField=HASH(0x5629506d1328), “UniqueValues”, 0, “Description”, “”, “LastUpdatedBy”, 78, “CanonicalizeClass”, …) called at /usr/lib/perl5/vendor_perl/5.26.1/RT/Record.pm line 316
RT::Record::Create(RT::CustomField=HASH(0x5629506d1328), “Name”, “IMEI 2”, “Type”, “Freeform”, “RenderType”, undef, “MaxValues”, …) called at /usr/lib/perl5/vendor_perl/5.26.1/RT/CustomField.pm line 366
RT::CustomField::Create(RT::CustomField=HASH(0x5629506d1328), “Name”, “IMEI 2”, “TypeComposite”, “Freeform-1”, “LookupType”, “RT::Catalog-RT::Asset”, “Description”, …) called at /usr/share/request-tracker/html/Admin/CustomFields/Modify.html line 215
HTML::Mason::Commands::ANON(“LinkValueTo”, “”, “EntryHint”, “Enter one value”, “Enabled”, 1, “TypeComposite”, “Freeform-1”, …) called at /usr/lib/perl5/vendor_perl/5.26.1/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x5629506d05d8), “LinkValueTo”, “”, “EntryHint”, “Enter one value”, “Enabled”, 1, “TypeComposite”, …) called at /usr/lib/perl5/vendor_perl/5.26.1/HTML/Mason/Request.pm line 1302
eval {…} called at /usr/lib/perl5/vendor_perl/5.26.1/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, “LinkValueTo”, “”, “EntryHint”, “Enter one value”, “Enabled”, …) called at /usr/lib/perl5/vendor_perl/5.26.1/HTML/Mason/Request.pm line 955
HTML::Mason::Request::call_next(RT::Interface::Web::Request=HASH(0x56294b5776f0), “Update”, “Create”, “SetUniqueValues”, 1, “Name”, “IMEI 2”, “id”, …) called at /usr/share/request-tracker/html/Admin/autohandler line 49
HTML::Mason::Commands::ANON(“LinkValueTo”, “”, “EntryHint”, “Enter one value”, “Enabled”, 1, “TypeComposite”, “Freeform-1”, …) called at /usr/lib/perl5/vendor_perl/5.26.1/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x5629506d9fa0), “LinkValueTo”, “”, “EntryHint”, “Enter one value”, “Enabled”, 1, “TypeComposite”, …) called at /usr/lib/perl5/vendor_perl/5.26.1/HTML/Mason/Request.pm line 1302
eval {…} called at /usr/lib/perl5/vendor_perl/5.26.1/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, “LinkValueTo”, “”, “EntryHint”, “Enter one value”, “Enabled”, …) called at /usr/lib/perl5/vendor_perl/5.26.1/RT/Interface/Web.pm line 697
RT::Interface::Web::ShowRequestedPage(HASH(0x56294fa9b780)) called at /usr/lib/perl5/vendor_perl/5.26.1/RT/Interface/Web.pm line 376
RT::Interface::Web::HandleRequest(HASH(0x56294fa9b780)) called at /usr/share/request-tracker/html/autohandler line 53
HTML::Mason::Commands::ANON(“Enabled”, 1, “TypeComposite”, “Freeform-1”, “LinkValueTo”, “”, “EntryHint”, “Enter one value”, …) called at /usr/lib/perl5/vendor_perl/5.26.1/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0x56294fce80f0), “Enabled”, 1, “TypeComposite”, “Freeform-1”, “LinkValueTo”, “”, “EntryHint”, …) called at /usr/lib/perl5/vendor_perl/5.26.1/HTML/Mason/Request.pm line 1300
eval {…} called at /usr/lib/perl5/vendor_perl/5.26.1/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, “Enabled”, 1, “TypeComposite”, “Freeform-1”, “LinkValueTo”, …) called at /usr/lib/perl5/vendor_perl/5.26.1/HTML/Mason/Request.pm line 481
eval {…} called at /usr/lib/perl5/vendor_perl/5.26.1/HTML/Mason/Request.pm line 481
eval {…} called at /usr/lib/perl5/vendor_perl/5.26.1/HTML/Mason/Request.pm line 433
HTML::Mason::Request::exec(RT::Interface::Web::Request=HASH(0x56294b5776f0)) called at /usr/lib/perl5/vendor_perl/5.26.1/HTML/Mason/PSGIHandler.pm line 96
eval {…} called at /usr/lib/perl5/vendor_perl/5.26.1/HTML/Mason/PSGIHandler.pm line 96
HTML::Mason::Request::PSGI::exec(RT::Interface::Web::Request=HASH(0x56294b5776f0)) called at /usr/lib/perl5/vendor_perl/5.26.1/HTML/Mason/Interp.pm line 342
HTML::Mason::Interp::exec(undef, undef, “Enabled”, 1, “TypeComposite”, “Freeform-1”, “LinkValueTo”, “”, …) called at /usr/lib/perl5/vendor_perl/5.26.1/HTML/Mason/PSGIHandler.pm line 59
eval {…} called at /usr/lib/perl5/vendor_perl/5.26.1/HTML/Mason/PSGIHandler.pm line 59
HTML::Mason::PSGIHandler::invoke_mason(HTML::Mason::PSGIHandler::Streamy=HASH(0x56294fa9be70), HASH(0x56294fd29f18), HASH(0x56295056fb70)) called at /usr/lib/perl5/vendor_perl/5.26.1/HTML/Mason/PSGIHandler/Streamy.pm line 52
HTML::Mason::PSGIHandler::Streamy::ANON(CODE(0x56294fca6710)) called at /usr/lib/perl5/vendor_perl/5.26.1/Plack/Util.pm line 339
Plack::Util::ANON(CODE(0x56294b627330)) called at /usr/lib/perl5/vendor_perl/5.26.1/Plack/Handler/FCGI.pm line 147
Plack::Handler::FCGI::run(Plack::Handler::FCGI=HASH(0x56294fc6d900), CODE(0x56294fc5cd50)) called at /usr/lib/perl5/vendor_perl/5.26.1/Plack/Loader.pm line 84
Plack::Loader::run(Plack::Loader=HASH(0x56294fc13218), Plack::Handler::FCGI=HASH(0x56294fc6d900)) called at /usr/lib/perl5/vendor_perl/5.26.1/Plack/Runner.pm line 277
Plack::runner::run(RT::PlackRunner=HASH(0x56294768ae08)) called at /usr/lib/perl5/vendor_perl/5.26.1/RT/PlackRunner.pm line 150
eval {…} called at /usr/lib/perl5/vendor_perl/5.26.1/RT/PlackRunner.pm line 150
RT::PlackRunner::run(RT::PlackRunner=HASH(0x56294768ae08)) called at /usr/sbin/rt-server.fcgi line 162
Sep 14 19:12:13 web sshd[15211]: Connection closed by 172.16.0.226 port 47138 [preauth]

`

Anyone have this problem ?

thank s

2

If you log into the database directly, what does the definition of the CustomFIelds table look like? Ie if you’re using MySQL or MariaDB, do a desc CustomFields and see what the result is.

3

Hello
I have the same erro when I try to create any custom field.

MariaDB [rt4]> desc CustomFields;
±--------------±-------------±-----±----±--------±---------------+
| Field | Type | Null | Key | Default | Extra |
±--------------±-------------±-----±----±--------±---------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| Name | varchar(200) | YES | | NULL | |
| Type | varchar(200) | YES | | NULL | |
| MaxValues | int(11) | YES | | NULL | |
| Pattern | varchar(255) | YES | | NULL | |
| Description | varchar(255) | YES | | NULL | |
| SortOrder | int(11) | NO | | 0 | |
| LookupType | varchar(255) | NO | | NULL | |
| Creator | int(11) | NO | | 0 | |
| Created | datetime | YES | | NULL | |
| LastUpdatedBy | int(11) | NO | | 0 | |
| LastUpdated | datetime | YES | | NULL | |
| Disabled | smallint(6) | NO | | 0 | |
| BasedOn | int(11) | YES | | NULL | |
| RenderType | varchar(64) | YES | | NULL | |
| ValuesClass | varchar(64) | YES | | NULL | |
| EntryHint | varchar(255) | YES | | NULL | |
±--------------±-------------±-----±----±--------±---------------+
17 rows in set (0.00 sec)

Can anybody suggest an fix.
rt 4.4.3

4

Check out my answer to the similar thread here.