<div dir="ltr"><div><div><div>Hi <br><br></div>Insertion of Asset module (tab id =40) to vtiger_profile2utility table is got failed in all the cases.Please make sure that<span class=""><b> </b>whether</span> the entry for the Asset module(tab id =40) is already present in this table or not . <br><br>Regards<br></div></div>Manu Urs<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Jul 15, 2015 at 6:49 PM, Simone Travaglini <span dir="ltr"><<a href="mailto:simonetravaglini@gmail.com" target="_blank">simonetravaglini@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi, <div>I get this:</div><div><table><tbody><tr><td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (1,40,5,0)</td>
<td style="text-align:center;width:620px;padding:8px;color:red;background:rgb(238,246,254)">Failure</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (1,40,6,0)</td>
<td style="text-align:center;width:620px;padding:8px;color:red;background:rgb(238,246,254)">Failure</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (1,40,10,0)</td>
<td style="text-align:center;width:620px;padding:8px;color:red;background:rgb(238,246,254)">Failure</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (1,19,5,0)</td>
<td style="text-align:center;width:620px;padding:8px;color:green;background:rgb(238,246,254)">Success</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (1,19,6,0)</td>
<td style="text-align:center;width:620px;padding:8px;color:green;background:rgb(238,246,254)">Success</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (1,19,10,0)</td>
<td style="text-align:center;width:620px;padding:8px;color:green;background:rgb(238,246,254)">Success</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (2,40,5,1)</td>
<td style="text-align:center;width:620px;padding:8px;color:red;background:rgb(238,246,254)">Failure</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (2,40,6,1)</td>
<td style="text-align:center;width:620px;padding:8px;color:red;background:rgb(238,246,254)">Failure</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (2,40,10,0)</td>
<td style="text-align:center;width:620px;padding:8px;color:red;background:rgb(238,246,254)">Failure</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (2,19,5,1)</td>
<td style="text-align:center;width:620px;padding:8px;color:green;background:rgb(238,246,254)">Success</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (2,19,6,1)</td>
<td style="text-align:center;width:620px;padding:8px;color:green;background:rgb(238,246,254)">Success</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (2,19,10,0)</td>
<td style="text-align:center;width:620px;padding:8px;color:green;background:rgb(238,246,254)">Success</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (3,40,5,1)</td>
<td style="text-align:center;width:620px;padding:8px;color:red;background:rgb(238,246,254)">Failure</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (3,40,6,1)</td>
<td style="text-align:center;width:620px;padding:8px;color:red;background:rgb(238,246,254)">Failure</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (3,40,10,0)</td>
<td style="text-align:center;width:620px;padding:8px;color:red;background:rgb(238,246,254)">Failure</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (3,19,5,1)</td>
<td style="text-align:center;width:620px;padding:8px;color:green;background:rgb(238,246,254)">Success</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (3,19,6,1)</td>
<td style="text-align:center;width:620px;padding:8px;color:green;background:rgb(238,246,254)">Success</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (3,19,10,0)</td>
<td style="text-align:center;width:620px;padding:8px;color:green;background:rgb(238,246,254)">Success</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (4,40,5,1)</td>
<td style="text-align:center;width:620px;padding:8px;color:red;background:rgb(238,246,254)">Failure</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (4,40,6,1)</td>
<td style="text-align:center;width:620px;padding:8px;color:red;background:rgb(238,246,254)">Failure</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (4,40,10,0)</td>
<td style="text-align:center;width:620px;padding:8px;color:red;background:rgb(238,246,254)">Failure</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (4,19,5,1)</td>
<td style="text-align:center;width:620px;padding:8px;color:green;background:rgb(238,246,254)">Success</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (4,19,6,1)</td>
<td style="text-align:center;width:620px;padding:8px;color:green;background:rgb(238,246,254)">Success</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (4,19,10,0)</td>
<td style="text-align:center;width:620px;padding:8px;color:green;background:rgb(238,246,254)">Success</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (5,40,5,1)</td>
<td style="text-align:center;width:620px;padding:8px;color:red;background:rgb(238,246,254)">Failure</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (5,40,6,1)</td>
<td style="text-align:center;width:620px;padding:8px;color:red;background:rgb(238,246,254)">Failure</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (5,40,10,0)</td>
<td style="text-align:center;width:620px;padding:8px;color:red;background:rgb(238,246,254)">Failure</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (5,19,5,1)</td>
<td style="text-align:center;width:620px;padding:8px;color:green;background:rgb(238,246,254)">Success</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (5,19,6,1)</td>
<td style="text-align:center;width:620px;padding:8px;color:green;background:rgb(238,246,254)">Success</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (5,19,10,0)</td>
<td style="text-align:center;width:620px;padding:8px;color:green;background:rgb(238,246,254)">Success</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (6,40,5,1)</td>
<td style="text-align:center;width:620px;padding:8px;color:red;background:rgb(238,246,254)">Failure</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (6,40,6,1)</td>
<td style="text-align:center;width:620px;padding:8px;color:red;background:rgb(238,246,254)">Failure</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (6,40,10,0)</td>
<td style="text-align:center;width:620px;padding:8px;color:red;background:rgb(238,246,254)">Failure</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (6,19,5,1)</td>
<td style="text-align:center;width:620px;padding:8px;color:green;background:rgb(238,246,254)">Success</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (6,19,6,1)</td>
<td style="text-align:center;width:620px;padding:8px;color:green;background:rgb(238,246,254)">Success</td>
</tr>
<tr>
<td style="width:619px;padding:8px;background:rgb(238,246,254)" width="80%">INSERT
INTO
vtiger_profile2utility(profileid,tabid,activityid,permission)
VALUES (6,19,10,0)</td>
<td style="text-align:center;width:620px;padding:8px;color:green;background:rgb(238,246,254)">Success</td>
</tr>
</tbody>
</table>
<table>
<tbody>
<tr>
<th style="width:1255px;padding:8px;border-radius:3px 0px 0px;background:rgb(238,246,254)"><span style="font-weight:bold;color:red">620 ==> 630 Database changes -- Ends.</span><br><br><br><div style="text-align:left"><font color="#ff0000"><span style="font-weight:normal">Actually all value ending with 0 are present in DB. </span></font></div><div style="text-align:left"><font color="#ff0000"><span style="font-weight:normal">With value ending with 1 (permission) what I have to do? change 0 to 1 (are present in Db with 0 as permission) manually?</span></font></div></th></tr></tbody></table><span class="HOEnZb"><font color="#888888"><div><br></div>-- <br><div>Simone Travaglini<br>328 5499846<br>Linkedin: Simone Travaglini <br><br><br><span style="color:rgb(51,204,0)">Rispetta l'ambiente: non stampare questa mail se non ti è veramente necessario!</span><br></div>
</font></span></div></div>
<br>_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature"><div dir="ltr"><div>Regards,<br></div>Manu<br></div></div>
</div>