how to change the vtiger lastname field not mandatory

simply by running the below mysql command

update vtiger_field set typeofdata = 'V~O' where tablename = 'vtiger_leaddetails' and columnname = 'lastname';




Comments

Post a Comment

Popular posts from this blog

Run MySQL query from Asterisk Dialplan and get values

[MySQL] exten => 1234,1,Answer() exten => 1234,n,NoOp(${CALLERID(num)}) exten => 1234,n,Read(caller,,10) exten => 1234,n,Set(CID=${CALLERID(num)}) exten => 1234,n,NoOp(${caller}) exten => 1234,n,Set(userCID=${caller}) exten => 1234,n,MYSQL(Connect connid YOUR_IP username pwd Database_name) exten => 1234,n,MYSQL(Query resultid ${connid} select * from customer where caller='${userCID}') exten => 1234,n,MYSQL(Fetch fetchid ${resultid} id name) exten => 1234,n,SayAlpha(${name}) exten => 1234,n,Saydigits(${id}) exten => 1234,n,MYSQL(Clear ${resultid}) exten => 1234,n,MYSQL(Disconnect ${connid}) exten => 1234,n,Playback(vm-goodbye) Tested on Asterisk 11.22
Read more