All installation and configuration problems and questions
Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
by speedmaker » Tue Feb 15, 2022 11:12 am
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/vicithe yellow one ,,,
thx Speedmaker
-
speedmaker
-
- Posts: 34
- Joined: Wed Sep 02, 2020 10:46 am
by mflorell » Wed Feb 16, 2022 7:17 am
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.
-
mflorell
- Site Admin
-
- Posts: 18384
- Joined: Wed Jun 07, 2006 2:45 pm
- Location: Florida
-
by speedmaker » Mon Feb 21, 2022 1:35 am
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
-
speedmaker
-
- Posts: 34
- Joined: Wed Sep 02, 2020 10:46 am
by mflorell » Mon Feb 21, 2022 7:22 am
Post the results of this query from the "mysql>" prompt:
describe vicidial_list;
-
mflorell
- Site Admin
-
- Posts: 18384
- Joined: Wed Jun 07, 2006 2:45 pm
- Location: Florida
-
Return to Support
Who is online
Users browsing this forum: Google [Bot], tantd and 112 guests