<div dir="ltr"><div><div>Hi<br><br></div>I think it is due to <a href="https://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html">MySQL Row size Limit</a> <br></div><ol><li>To avoid this, you may use a script like below to add further fields in vtiger_leaddetails rather than vtiger_leadcf<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><br>include_once('vtlib/Vtiger/Module.php');<br>include_once('vtlib/Vtiger/Block.php');<br><br>$blockInstance = new Vtiger_Block();<br>$blockInstance = Vtiger_Block::getInstance('LBL_LEAD_INFORMATION');<br>$fieldInstance = new Vtiger_Field();<br>$fieldInstance->name = 'pickuplocation';<br>$fieldInstance->label = 'Pickup Location';<br>$fieldInstance->table = 'vtiger_leaddetails';<br>$fieldInstance->column = 'pickuplocation';<br>$fieldInstance->columntype = 'varchar(128)';<br>$fieldInstance->uitype = 15; <br>$fieldInstance->setPicklistValues(array('Makandana East','Yatawathura','Batakettara North','Moratumulla North'));<br>$fieldInstance->typeofdata = 'V~O';<br>$fieldInstance->defaultvalue = '';<br>$blockInstance->addField($fieldInstance);<br>echo 'ok';<br></blockquote></li><li><div>Otherwise you may try to convert varchar fields into tinytext in leadcf table, which can provide few more fields to accommodate. <br></div></li></ol><p><br></p><p>Thanks</p><p>Sutharsan Jeganathan<br></p></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Feb 21, 2017 at 12:45 AM, Stuart Maynard-Keene <span dir="ltr"><<a href="mailto:stuartmaynardkeene@findmypub.com" target="_blank">stuartmaynardkeene@findmypub.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi list, is there a limit to how many custom fields you can have for a module?<br>
<br>
Currently the vtiger_leadscf table is standing at 325 fields (don’t ask!) and suddenly when I try to add new fields through the vTiger interface its stopped adding them to this table but still adds the relevant picklist tables.<br>
<br>
Stu<br>
<br>
<br>
______________________________<wbr>_________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a></blockquote></div><br></div>