Increase queue name limit

Moderator: crythias

Post Reply
otresi
OTRS expert
Posts: 84
Joined: 02 Sep 2014, 10:49
OTRS Version?: OTRS 5.0.8

Increase queue name limit

Post by otresi » 31 May 2018, 11:26

Hi,

Does it possible to increase size of queue name, current size is 50.
Thanks a lot
OTRS 5 /

otresi
OTRS expert
Posts: 84
Joined: 02 Sep 2014, 10:49
OTRS Version?: OTRS 5.0.8

Re: Increase queue name limit

Post by otresi » 01 Jun 2018, 13:24

Any help?
OTRS 5 /

alexus
OTRS superhero
Posts: 271
Joined: 20 Sep 2010, 16:54
OTRS Version?: ITSM 5.0.14
Real Name: Alexey Yusov
Company: Radiant System
Location: Prague
Contact:

Re: Increase queue name limit

Post by alexus » 01 Jun 2018, 18:51

https://github.com/OTRS/otrs/blob/maste ... .mysql.sql

Code: Select all

CREATE TABLE queue (
    id INTEGER NOT NULL AUTO_INCREMENT,
    name VARCHAR (200) NOT NULL,
otresi wrote:
31 May 2018, 11:26
current size is 50.
It sounds strange
Alexey Yusov

Production: OTRS ITSM 5.0.14 on CentOS 7 x64 Linux with MySQL 5.7
Tested: OTRS ITSM 5.0.14
Radiant System OTRS Intergrator
Stay tuned on our Facebook
Get OTRS Professional Services - Consulting, Implementation, Training, Development, Support!

otresi
OTRS expert
Posts: 84
Joined: 02 Sep 2014, 10:49
OTRS Version?: OTRS 5.0.8

Re: Increase queue name limit

Post by otresi » 04 Jun 2018, 12:06

50 character is now limit..
i don't understand how to increase in mysql and how to change?
OTRS 5 /

otresi
OTRS expert
Posts: 84
Joined: 02 Sep 2014, 10:49
OTRS Version?: OTRS 5.0.8

Re: Increase queue name limit

Post by otresi » 04 Jun 2018, 12:16

alexus wrote:
01 Jun 2018, 18:51
https://github.com/OTRS/otrs/blob/maste ... .mysql.sql

Code: Select all

CREATE TABLE queue (
    id INTEGER NOT NULL AUTO_INCREMENT,
    name VARCHAR (200) NOT NULL,
otresi wrote:
31 May 2018, 11:26
current size is 50.
It sounds strange
50 character is now limit..
i don't understand how to increase in mysql and how to change?
OTRS 5 /

jojo
Moderator
Posts: 14341
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

Re: Increase queue name limit

Post by jojo » 04 Jun 2018, 13:25

your database admin should be able to create the needed alter command. Otherwise check the admin manual of your DBMS
"Production": OTRS™ 6, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com :: Share your ideas

Post Reply