Hallo,
nach dem Update von 3.3.7 auf 4.0.2 bekomme ich den oben genannten Fehler im Systemprotokoll angezeigt.
Im OTRS.log steht volgendens
[Kernel::SystemDynamicField::Backend::PossibleValuesGet][2077] The field configuration is invalid
das ganze wird ausgelöst wenn ich ein Ticket als Agent über AgentTicketClose schliesen möchte.
Der WebServer gibt danach diese Fehlermeldung aus, aber das Ticket wird trotzdem geschlossen.
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator at webmaster@localhost to inform them of the time this error occurred, and the actions you performed just before this error.
More information about this error may be available in the server error log.
Danke
Lars
Fehler OTRS-CGI-10 The field configuration is invalid
-
reneeb
- Znuny guru
- Posts: 5018
- Joined: 13 Mar 2011, 09:54
- Znuny Version: 6.0.x
- Real Name: Renée Bäcker
- Company: Perl-Services.de
- Contact:
Re: Fehler OTRS-CGI-10 The field configuration is invalid
Dann zeig mal die Feldkonfiguration (ist in der Tabelle dynamic_field) und welche YAML::XS-Version hast Du?
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
-
LarsDA
- Znuny newbie
- Posts: 14
- Joined: 06 Mar 2013, 10:08
- Znuny Version: 6.0.30
- Real Name: Lars
- Location: Berlin
Re: Fehler OTRS-CGI-10 The field configuration is invalid
Hallo reneeb,
XAML::XS (v0.41)
und die Tabelle dynamic_field sieht wie folgt aus:
<?xml version="1.0" encoding="utf-8"?>
<!--
- phpMyAdmin XML Dump
- version 4.0.10deb1
- http://www.phpmyadmin.net
-
- Host: localhost
- Erstellungszeit: 14. Jan 2015 um 13:40
- Server Version: 5.5.40-0ubuntu0.14.04.1
- PHP-Version: 5.5.9-1ubuntu4.5
-->
<pma_xml_export version="1.0" xmlns:pma="http://www.phpmyadmin.net/some_doc_url/">
<!--
- Structure schemas
-->
<pma:structure_schemas>
<pma:database name="otrs" collation="utf8_general_ci" charset="utf8">
<pma:table name="dynamic_field">
CREATE TABLE `dynamic_field` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`label` varchar(200) NOT NULL,
`field_order` int(11) NOT NULL,
`field_type` varchar(200) NOT NULL,
`object_type` varchar(200) NOT NULL,
`config` longblob,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
`internal_field` varchar(200) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `dynamic_field_name` (`name`),
KEY `FK_dynamic_field_create_by_id` (`create_by`),
KEY `FK_dynamic_field_change_by_id` (`change_by`),
KEY `FK_dynamic_field_valid_id_id` (`valid_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
</pma:table>
</pma:database>
</pma:structure_schemas>
<!--
- Datenbank: 'otrs'
-->
<database name="otrs">
<!-- Tabelle dynamic_field -->
<table name="dynamic_field">
<column name="id">1</column>
<column name="name">extTicketnummer</column>
<column name="label">ext. Ticketnummer</column>
<column name="field_order">1</column>
<column name="field_type">TextArea</column>
<column name="object_type">Ticket</column>
<column name="config">---
Cols: '35'
DefaultValue: ''
RegExList: []
Rows: '1'
</column>
<column name="valid_id">2</column>
<column name="create_time">2013-05-02 14:02:20</column>
<column name="create_by">2</column>
<column name="change_time">2014-12-04 13:00:52</column>
<column name="change_by">2</column>
<column name="internal_field">0</column>
</table>
<table name="dynamic_field">
<column name="id">2</column>
<column name="name">ProcessManagementActivityID</column>
<column name="label">Activity</column>
<column name="field_order">2</column>
<column name="field_type">ActivityID</column>
<column name="object_type">Ticket</column>
<column name="config">---
DefaultValue: ''
Link: ''
</column>
<column name="valid_id">2</column>
<column name="create_time">2013-05-03 10:20:07</column>
<column name="create_by">2</column>
<column name="change_time">2013-10-07 09:33:17</column>
<column name="change_by">2</column>
<column name="internal_field">0</column>
</table>
<table name="dynamic_field">
<column name="id">3</column>
<column name="name">prismamodul</column>
<column name="label">Prisma Modul</column>
<column name="field_order">3</column>
<column name="field_type">Dropdown</column>
<column name="object_type">Ticket</column>
<column name="config">---
DefaultValue: ''
Link: ''
PossibleNone: '1'
PossibleValues:
Antragsmodul: Antragsmodul
Auftragsmodul: Auftragsmodul
Begutachtermodul: Begutachtermodul
Optimierung allgemein: Optimierung allgemein
Verfahrensmodul: Verfahrensmodul
TranslatableValues: '0'
TreeView: '0'
</column>
<column name="valid_id">2</column>
<column name="create_time">2014-01-21 13:30:06</column>
<column name="create_by">2</column>
<column name="change_time">2014-12-04 13:01:01</column>
<column name="change_by">2</column>
<column name="internal_field">0</column>
</table>
<table name="dynamic_field">
<column name="id">4</column>
<column name="name">TicketCalendarStartTime</column>
<column name="label">Event Start</column>
<column name="field_order">4</column>
<column name="field_type">DateTime</column>
<column name="object_type">Ticket</column>
<column name="config">---
DateRestriction: ''
DefaultValue: 0
Link: ''
YearsInFuture: '5'
YearsInPast: '5'
YearsPeriod: '0'
</column>
<column name="valid_id">2</column>
<column name="create_time">2014-02-26 14:11:25</column>
<column name="create_by">2</column>
<column name="change_time">2014-12-04 13:01:08</column>
<column name="change_by">2</column>
<column name="internal_field">0</column>
</table>
<table name="dynamic_field">
<column name="id">5</column>
<column name="name">TicketCalendarEndTime</column>
<column name="label">Event Ende</column>
<column name="field_order">5</column>
<column name="field_type">DateTime</column>
<column name="object_type">Ticket</column>
<column name="config">---
DateRestriction: ''
DefaultValue: 0
Link: ''
YearsInFuture: '5'
YearsInPast: '5'
YearsPeriod: '0'
</column>
<column name="valid_id">2</column>
<column name="create_time">2014-02-26 14:11:44</column>
<column name="create_by">2</column>
<column name="change_time">2014-12-04 13:01:14</column>
<column name="change_by">2</column>
<column name="internal_field">0</column>
</table>
</database>
</pma_xml_export>
Vielen Dank
Grüße
Lars
XAML::XS (v0.41)
und die Tabelle dynamic_field sieht wie folgt aus:
<?xml version="1.0" encoding="utf-8"?>
<!--
- phpMyAdmin XML Dump
- version 4.0.10deb1
- http://www.phpmyadmin.net
-
- Host: localhost
- Erstellungszeit: 14. Jan 2015 um 13:40
- Server Version: 5.5.40-0ubuntu0.14.04.1
- PHP-Version: 5.5.9-1ubuntu4.5
-->
<pma_xml_export version="1.0" xmlns:pma="http://www.phpmyadmin.net/some_doc_url/">
<!--
- Structure schemas
-->
<pma:structure_schemas>
<pma:database name="otrs" collation="utf8_general_ci" charset="utf8">
<pma:table name="dynamic_field">
CREATE TABLE `dynamic_field` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL,
`label` varchar(200) NOT NULL,
`field_order` int(11) NOT NULL,
`field_type` varchar(200) NOT NULL,
`object_type` varchar(200) NOT NULL,
`config` longblob,
`valid_id` smallint(6) NOT NULL,
`create_time` datetime NOT NULL,
`create_by` int(11) NOT NULL,
`change_time` datetime NOT NULL,
`change_by` int(11) NOT NULL,
`internal_field` varchar(200) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `dynamic_field_name` (`name`),
KEY `FK_dynamic_field_create_by_id` (`create_by`),
KEY `FK_dynamic_field_change_by_id` (`change_by`),
KEY `FK_dynamic_field_valid_id_id` (`valid_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
</pma:table>
</pma:database>
</pma:structure_schemas>
<!--
- Datenbank: 'otrs'
-->
<database name="otrs">
<!-- Tabelle dynamic_field -->
<table name="dynamic_field">
<column name="id">1</column>
<column name="name">extTicketnummer</column>
<column name="label">ext. Ticketnummer</column>
<column name="field_order">1</column>
<column name="field_type">TextArea</column>
<column name="object_type">Ticket</column>
<column name="config">---
Cols: '35'
DefaultValue: ''
RegExList: []
Rows: '1'
</column>
<column name="valid_id">2</column>
<column name="create_time">2013-05-02 14:02:20</column>
<column name="create_by">2</column>
<column name="change_time">2014-12-04 13:00:52</column>
<column name="change_by">2</column>
<column name="internal_field">0</column>
</table>
<table name="dynamic_field">
<column name="id">2</column>
<column name="name">ProcessManagementActivityID</column>
<column name="label">Activity</column>
<column name="field_order">2</column>
<column name="field_type">ActivityID</column>
<column name="object_type">Ticket</column>
<column name="config">---
DefaultValue: ''
Link: ''
</column>
<column name="valid_id">2</column>
<column name="create_time">2013-05-03 10:20:07</column>
<column name="create_by">2</column>
<column name="change_time">2013-10-07 09:33:17</column>
<column name="change_by">2</column>
<column name="internal_field">0</column>
</table>
<table name="dynamic_field">
<column name="id">3</column>
<column name="name">prismamodul</column>
<column name="label">Prisma Modul</column>
<column name="field_order">3</column>
<column name="field_type">Dropdown</column>
<column name="object_type">Ticket</column>
<column name="config">---
DefaultValue: ''
Link: ''
PossibleNone: '1'
PossibleValues:
Antragsmodul: Antragsmodul
Auftragsmodul: Auftragsmodul
Begutachtermodul: Begutachtermodul
Optimierung allgemein: Optimierung allgemein
Verfahrensmodul: Verfahrensmodul
TranslatableValues: '0'
TreeView: '0'
</column>
<column name="valid_id">2</column>
<column name="create_time">2014-01-21 13:30:06</column>
<column name="create_by">2</column>
<column name="change_time">2014-12-04 13:01:01</column>
<column name="change_by">2</column>
<column name="internal_field">0</column>
</table>
<table name="dynamic_field">
<column name="id">4</column>
<column name="name">TicketCalendarStartTime</column>
<column name="label">Event Start</column>
<column name="field_order">4</column>
<column name="field_type">DateTime</column>
<column name="object_type">Ticket</column>
<column name="config">---
DateRestriction: ''
DefaultValue: 0
Link: ''
YearsInFuture: '5'
YearsInPast: '5'
YearsPeriod: '0'
</column>
<column name="valid_id">2</column>
<column name="create_time">2014-02-26 14:11:25</column>
<column name="create_by">2</column>
<column name="change_time">2014-12-04 13:01:08</column>
<column name="change_by">2</column>
<column name="internal_field">0</column>
</table>
<table name="dynamic_field">
<column name="id">5</column>
<column name="name">TicketCalendarEndTime</column>
<column name="label">Event Ende</column>
<column name="field_order">5</column>
<column name="field_type">DateTime</column>
<column name="object_type">Ticket</column>
<column name="config">---
DateRestriction: ''
DefaultValue: 0
Link: ''
YearsInFuture: '5'
YearsInPast: '5'
YearsPeriod: '0'
</column>
<column name="valid_id">2</column>
<column name="create_time">2014-02-26 14:11:44</column>
<column name="create_by">2</column>
<column name="change_time">2014-12-04 13:01:14</column>
<column name="change_by">2</column>
<column name="internal_field">0</column>
</table>
</database>
</pma_xml_export>
Vielen Dank
Grüße
Lars
You do not have the required permissions to view the files attached to this post.
-
reneeb
- Znuny guru
- Posts: 5018
- Joined: 13 Mar 2011, 09:54
- Znuny Version: 6.0.x
- Real Name: Renée Bäcker
- Company: Perl-Services.de
- Contact:
Re: Fehler OTRS-CGI-10 The field configuration is invalid
Wenn ich mich nicht irre, müsstest Du aus ein machen.
Code: Select all
DefaultValue: 0Code: Select all
DefaultValue: '0'Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
-
LarsDA
- Znuny newbie
- Posts: 14
- Joined: 06 Mar 2013, 10:08
- Znuny Version: 6.0.30
- Real Name: Lars
- Location: Berlin
Re: Fehler OTRS-CGI-10 The field configuration is invalid
Hallo reneeb,
hat leider nicht funktioniert.
Ist auch bei der (Livesystem 3.3.7) DB nicht so gesetzt.
Grüße
Lars
hat leider nicht funktioniert.
Ist auch bei der (Livesystem 3.3.7) DB nicht so gesetzt.
Grüße
Lars