<div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Noted: <a href="https://code.vtiger.com/vtiger/vtigercrm/-/issues/1988">https://code.vtiger.com/vtiger/vtigercrm/-/issues/1988</a></div></div><br><div class="gmail_quote gmail_quote_container"><div dir="ltr" class="gmail_attr">On Fri, Aug 1, 2025 at 12:15 PM Prasad <<a href="mailto:prasad@vtiger.com">prasad@vtiger.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">crmid reference field should be int - some of these are legacy schema forward (ex: users.<span style="font-family:Arial,Helvetica,sans-serif">reports_to_id)</span></div><div class="gmail_default">Please report issues on <a href="https://code.vtiger.com/vtiger/vtigercrm" target="_blank">https://code.vtiger.com/vtiger/vtigercrm</a> so we can mark them for cleanup.</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jul 31, 2025 at 8:37 PM Steve Kenow <<a href="mailto:skenow@rdspos.com" target="_blank">skenow@rdspos.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>In all versions I've looked at, including a fresh install of 8.5, vtiger_troubletickets parent_id and product_id are defined as varchar and not as int. What would be the reason for this?</div><div><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><br></div><table cellpadding="0" cellspacing="0" style="font-family:Arial,sans-serif;font-size:14px;color:rgb(51,51,51)"><tbody><tr><td style="display:flex"><b><br></b><div><b>Steve Kenow</b></div></td></tr><tr><td><table cellpadding="0" cellspacing="0"><tbody><tr><td><br></td></tr></tbody></table></td></tr></tbody></table></div></div></div></div>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a></blockquote></div>
</blockquote></div>