Page 1 of 1

Comments not staying

PostPosted: Thu Apr 04, 2024 12:20 pm
by atkins513
Hey team,
I am having some issues with comments and was hoping you could help. My text of the comments section constantly gets cut off. It's just not enough to add all the comments I need to for most things and I constantly run out of room or get cut off. I found a way to increase the Characters of comments to 500 or more via a Mysql command, but I am also somewhat of a novice with some of these things.
I know how to load Putty, connect and make commands, but the exact steps are a little beyond me. I found another post on the forum that went into detail about how to do this. Can you clarify these steps for me, step by step so that I can increase my comments characters to 500. Below is the original post. Thank you so much.
VERSION: 2.14-634c BUILD: 210421-2110


------------------------------------
dreedy » Thu May 17, 2018 4:14 pm
" IF I ALTER the comments field in the MYSQL to a VARCHAR (500) that this would enable the comments to go to 500 characters ? and would i need to expanded the agent and admin screen reference to allow the comment to be seen in one screen? "

The Response: mflorell » Thu May 17, 2018 9:46 pm
Yes, you can change the comments to VARCHAR(500) if you want and it should not cause any problems.

dreedy » Fri May 18, 2018 10:34 am
Thank you all i have tested this out and had to alter 2 places for the comments. vicidial_list and vicidial_comments. once i altered that to expand the store capacity to 500 char the information would go to 500 char. "
------------------------------------

Re: Comments not staying

PostPosted: Thu Apr 11, 2024 5:42 pm
by carpenox
yes that is correct, you can use the alter command to change varchar to 500