Page 1 of 1

field State change to 3 or more letters or numbers (char)

PostPosted: Tue Feb 15, 2022 11:12 am
by speedmaker
Hello

When i log in as an agent and i look at field State i just can use 2 Letters - is there a posibillty to change that in 3 or more letters or numbers.
i dont need the state i want to relabel it to my needs ,, but we need mininum 3 letters / numbers

https://www.transfernow.net/dl/vici

the yellow one ,,,

thx Speedmaker

Re: field State change to 3 or more letters or numbers (char

PostPosted: Wed Feb 16, 2022 7:17 am
by mflorell
Since it's a text field, the agent script will adjust the form size if you alter the table column on the MySQL client:

ALTER TABLE vicidial_list MODIFY state VARCHAR(3);

Keep in mind you should only perform that query after-hours when nobody is using the system since it may take a while to perform, and it will lock up your system until it is finished.

Re: field State change to 3 or more letters or numbers (char

PostPosted: Mon Feb 21, 2022 1:35 am
by speedmaker
Hello Matt,

Thx but i thing something went wrong ,, i logged in in maria db and tryed it but nothing happend. i waited over a day.
regards speed

Re: field State change to 3 or more letters or numbers (char

PostPosted: Mon Feb 21, 2022 7:22 am
by mflorell
Post the results of this query from the "mysql>" prompt:

describe vicidial_list;