<font><font face="verdana,sans-serif"><div><div>I can't believe .... that was it, the tabid 50 was this table with the permission field null ...</div><div><br></div><div>I still do not know the structure of the Vtiger, then catch enough to get a few points ...</div>
<div><br></div><div>Thank you for the quick help and understanding, you are grade 10, my friend!</div></div><div><br></div><div><br></div><div><br></div></font></font><div class="gmail_extra">Atte,<br><b>Rodrigo Souza de Oliveira</b><div>
<b>Consultor de TI<br></b>Hostplan Informática Ltda<br>
<div>Telefones: <a href="tel:%2821%29%209217-7909" value="+552192177909" target="_blank">(21) 9217-7909</a> e/ou <a href="tel:%2821%29%208153-5287" value="+552181535287" target="_blank">(21) 8153-5287</a><div>website: <a href="http://www.hostplan.com.br" target="_blank">www.hostplan.com.br</a><br>
e-mail/msn: <a href="mailto:rodrigo@hostplan.com.br" target="_blank">rodrigo@hostplan.com.br</a><br>
<img src="http://www.hostplan.com.br/logo.jpg" height="137" width="200"><br></div></div></div><br>
<br><br><div class="gmail_quote">2012/11/1 Adam Heinz <span dir="ltr"><<a href="mailto:amh@metricwise.net" target="_blank">amh@metricwise.net</a>></span><br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div>Maybe vtiger_def_org_share? If that doesn't work, poke around in modules/Users/CreateUserPrivilegeFile.php. I'm getting a bit rusty on this stuff because I ripped it all out and we don't use privilege files anymore.</div>
<br><div class="gmail_quote"><div><div>On Thu, Nov 1, 2012 at 2:31 PM, Rodrigo Souza <span dir="ltr"><<a href="mailto:rodrigo@hostplan.com.br" target="_blank">rodrigo@hostplan.com.br</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div><div>
<font><font face="verdana,sans-serif"><div>So my friend, have looked at that table and does not have the tabid 50 ...</div><div><br></div><div>Will some other table that refers to tabid?</div></font></font><div class="gmail_extra">
<div><div>
<br clear="all">Atte,<br><b>Rodrigo Souza de Oliveira</b><div><b>Consultor de TI<br></b>Hostplan Informática Ltda<br><div>Telefones: <a href="tel:%2821%29%209217-7909" value="+552192177909" target="_blank">(21) 9217-7909</a> e/ou <a href="tel:%2821%29%208153-5287" value="+552181535287" target="_blank">(21) 8153-5287</a><div>
website: <a href="http://www.hostplan.com.br" target="_blank">www.hostplan.com.br</a><br>
e-mail/msn: <a href="mailto:rodrigo@hostplan.com.br" target="_blank">rodrigo@hostplan.com.br</a><br><img height="137" width="200"><br></div></div></div><br>
<br><br></div></div><div class="gmail_quote">2012/11/1 Adam Heinz <span dir="ltr"><<a href="mailto:amh@metricwise.net" target="_blank">amh@metricwise.net</a>></span><br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div><div>
I think I would go the other direction -- try to restore referential integrity by deleting rows related to missing tab 50. Off the top of my head, I would check vtiger_profile2tab.<div><br><div><div><div class="gmail_quote">
<div><div>
On Thu, Nov 1, 2012 at 12:21 PM, Rodrigo Souza <span dir="ltr"><<a href="mailto:rodrigo@hostplan.com.br" target="_blank">rodrigo@hostplan.com.br</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div><div>
<font><font face="verdana,sans-serif"><div>Master Adam :),</div><div><br></div><div>I looked at the table and jumps vtiger_tab ID 49 to ID 51 ... And I do not recall having excluded</div><div><br></div><div>I removed this item and get access to user created!</div>
<div><br></div><div>Now how to solve the problem permanently? I insert a record with ID 50 in vtiger_tab? does not give another problem?</div></font></font><div class="gmail_extra"><div><br clear="all">Atte,<br>
<b>Rodrigo Souza de Oliveira</b><div>
<b>Consultor de TI<br></b>Hostplan Informática Ltda<br><div>Telefones: <a href="tel:%2821%29%209217-7909" value="+552192177909" target="_blank">(21) 9217-7909</a> e/ou <a href="tel:%2821%29%208153-5287" value="+552181535287" target="_blank">(21) 8153-5287</a><div>
website: <a href="http://www.hostplan.com.br" target="_blank">www.hostplan.com.br</a><br>e-mail/msn: <a href="mailto:rodrigo@hostplan.com.br" target="_blank">rodrigo@hostplan.com.br</a><br>
<img height="137" width="200"><br></div></div></div><br>
<br><br></div><div class="gmail_quote"><div><div>2012/11/1 MAGGI Conrado RE-INGENIA <span dir="ltr"><<a href="mailto:conrado@reingenia.com.ar" target="_blank">conrado@reingenia.com.ar</a>></span><br></div>
</div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div><div>
<div bgcolor="#FFFFFF" text="#000000">
<div>The error is the first line.. Look at<br>
<br>
,'49'=>1<b>,'50'=>,'</b>51'=>2,'<br>
<br>
Regards,<br>
<br>
<br>
<div><b>Conrado Maggi</b><br>
(re)ingenia Soluciones<br>
Tel: <a href="tel:%28011%29%202054.6296" value="+551120546296" target="_blank">(011) 2054.6296</a><br>
Cel: (011) <a href="tel:15.4973.8784" value="+551549738784" target="_blank">15.4973.8784</a><br>
<a href="http://www.reingenia.com.ar" target="_blank">www.reingenia.com.ar</a><br>
</div><div>
On 11/01/2012 12:52 PM, Rodrigo Souza wrote:<br>
</div></div>
<blockquote type="cite"><div>
<div><span style="font-family:verdana,sans-serif">Sorry, this is
the User_Privileges, when it should be the Sharing Privileges.
I am attaching the file.</span><br>
</div>
</div><div class="gmail_extra"><div><br clear="all">
Atte,<br>
<b>Rodrigo Souza de Oliveira</b>
<div>
<b>Consultor de TI<br>
</b>Hostplan Informática Ltda<br>
<div>Telefones: <a href="tel:%2821%29%209217-7909" value="+552192177909" target="_blank">(21) 9217-7909</a> e/ou <a href="tel:%2821%29%208153-5287" value="+552181535287" target="_blank">(21) 8153-5287</a>
<div>website: <a href="http://www.hostplan.com.br" target="_blank">www.hostplan.com.br</a><br>
e-mail/msn: <a href="mailto:rodrigo@hostplan.com.br" target="_blank">rodrigo@hostplan.com.br</a><br>
<img height="137" width="200"><br>
</div>
</div>
</div>
<br>
<br>
<br>
</div><div class="gmail_quote">2012/11/1 Adam Heinz <span dir="ltr"><<a href="mailto:amh@metricwise.net" target="_blank">amh@metricwise.net</a>></span><br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div>
Are you sure that you didn't just paste me
user_privileges_444.php? There's nothing wrong with the
file below.<br>
<br>
</div><div class="gmail_quote"><div>
<div>
<div>On Thu, Nov 1, 2012 at 11:26 AM, Rodrigo
Souza <span dir="ltr"><<a href="mailto:rodrigo@hostplan.com.br" target="_blank">rodrigo@hostplan.com.br</a>></span>
wrote:<br>
</div>
</div>
</div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div>
<div><font><font face="verdana,sans-serif"><div>
<div>Adam,</div>
<div><br>
</div>
<div>The problem is that I never made any
changes to rules via SQL ...</div>
<div><br>
</div>
<div>I'll put the code below in file
sharing_privileges_444.php with you if you can
give me a direction to solve the problem I
will thank.</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
</div><div><div>
<div><?php</div>
<div><br>
</div>
<div><br>
</div>
<div>//This is the access privilege file</div>
<div>$is_admin=false;</div>
<div><br>
</div>
<div>$current_user_roles='H17';</div>
<div><br>
</div>
<div>$current_user_parent_role_seq='H1::H2::H3::H20::H17';</div>
<div><br>
</div>
<div>$current_user_profiles=array(8,);</div>
<div><br>
</div>
<div>$profileGlobalPermission=array('1'=>1,'2'=>1,);</div>
<div><br>
</div>
<div>$profileTabsPermission=array('1'=>0,'2'=>0,'4'=>0,'6'=>0,'7'=>0,'8'=>0,'9'=>0,'10'=>0,'13'=>1,'14'=>0,'15'=>1,'16'=>0,'18'=>1,'19'=>0,'20'=>0,'21'=>1,'22'=>0,'23'=>0,'24'=>1,'25'=>0,'26'=>0,'27'=>1,'30'=>1,'31'=>1,'32'=>1,'33'=>1,'34'=>1,'35'=>1,'36'=>1,'37'=>1,'38'=>1,'39'=>1,'40'=>1,'41'=>1,'42'=>1,'43'=>1,'45'=>0,'46'=>1,'47'=>1,'48'=>0,'49'=>0,'51'=>0,'52'=>0,);</div>
<div><br>
</div>
</div><div>$profileActionPermission=array(2=>array(0=>1,1=>1,2=>1,3=>0,4=>0,5=>0,6=>0,10=>0,),4=>array(0=>1,1=>1,2=>1,3=>0,4=>0,5=>0,6=>0,8=>0,10=>0,),6=>array(0=>1,1=>1,2=>1,3=>0,4=>0,5=>0,6=>0,8=>0,10=>0,),7=>array(0=>1,1=>1,2=>1,3=>0,4=>0,5=>0,6=>0,8=>0,9=>0,10=>0,),8=>array(0=>0,1=>0,2=>1,3=>0,4=>0,6=>0,),9=>array(0=>0,1=>0,2=>0,3=>0,4=>0,),13=>array(0=>1,1=>1,2=>1,3=>1,4=>1,5=>0,6=>0,8=>0,10=>0,),14=>array(0=>1,1=>1,2=>1,3=>0,4=>0,5=>0,6=>0,10=>0,),15=>array(0=>1,1=>1,2=>1,3=>1,4=>1,),16=>array(0=>0,1=>0,2=>0,3=>0,4=>0,),18=>array(0=>1,1=>1,2=>1,3=>1,4=>1,5=>0,6=>0,10=>0,),19=>array(0=>1,1=>1,2=>1,3=>0,4=>0,),20=>array(0=>1,1=>1,2=>1,3=>0,4=&gt!
;0,),21=&g
t;array(0=>1,1=>1,2=>1,3=>1,4=>1,),22=>array(0=>1,1=>1,2=>1,3=>0,4=>0,),23=>array(0=>1,1=>1,2=>1,3=>0,4=>0,),26=>array(0=>1,1=>1,2=>1,3=>0,4=>0,),31=>array(0=>1,1=>1,2=>1,3=>1,4=>1,5=>0,6=>0,10=>0,),32=>array(0=>1,1=>1,2=>1,3=>1,4=>1,5=>0,6=>0,8=>0,),34=>array(0=>1,1=>1,2=>1,3=>1,4=>1,5=>0,6=>0,10=>0,),35=>array(0=>1,1=>1,2=>1,3=>1,4=>1,),37=>array(0=>1,1=>1,2=>1,3=>1,4=>1,5=>0,6=>0,10=>0,),38=>array(0=>1,1=>1,2=>1,3=>1,4=>1,5=>0,6=>0,10=>0,),39=>array(0=>1,1=>1,2=>1,3=>1,4=>1,5=>0,6=>0,10=>0,),40=>array(0=>1,1=>1,2=>1,3=>1,4=>1,5=>0,6=>0,10=>0,),45=>array(0=>0,1=>0,2=>0,3=>0,4=>0,),47=>array(0=>1,1=>1,2=>1,3=>1,4=>1,),48=>array(0=>0,1=>0,2=>0,3=>0,4=&gt!
;0,5=>0
,6=>0,8=>0,),49=>array(0=>1,1=>1,2=>1,3=>0,4=>0,5=>0,6=>0,8=>0,),51=>array(0=>0,1=>0,2=>0,3=>0,4=>0,5=>0,6=>0,8=>1,),52=>array(0=>0,1=>0,2=>0,3=>0,4=>0,5=>0,6=>0,8=>1,),);</div>
<div>
<div><br>
</div>
<div>$current_user_groups=array();</div>
<div><br>
</div>
<div>$subordinate_roles=array();</div>
<div><br>
</div>
<div>$parent_roles=array('H1','H2','H3','H20',);</div>
<div><br>
</div>
<div>$subordinate_roles_users=array();</div>
<div><br>
</div>
<div>$user_info=array('user_name'=>'teste123','is_admin'=>'off','user_password'=>'$1$te000000$4PLMaZ/mhqu/WdNvIH0Cp0','confirm_password'=>'$1$te000000$4PLMaZ/mhqu/WdNvIH','first_name'=>'David','last_name'=>'Soares','roleid'=>'H17','email1'=>'<a href="mailto:rodrigo@hostplan.com.br" target="_blank">rodrigo@hostplan.com.br</a>','status'=>'Active','activity_view'=>'Today','lead_view'=>'Today','currency_id'=>'1','currency_name'=>'Brazil,
Reais','currency_code'=>'BRL','currency_symbol'=>'R$','conv_rate'=>'1.000','hour_format'=>'','end_hour'=>'','start_hour'=>'','title'=>'','phone_work'=>'','department'=>'','phone_mobile'=>'','reports_to_id'=>'74','phone_other'=>'','email2'=>'','phone_fax'=>'<a href="tel:2192177909" value="+552192177909" target="_blank">2192177909</a>','yahoo_id'=>'','phone_home'=>'','imagename'=>'','date_format'=>'dd-mm-yyyy','signature'=>'','description'=>'','reminder_interval'=>'5
Minutes','internal_mailer'=>'1','address_street'=>'','address_city'=>'','address_state'=>'','address_postalcode'=>'','address_country'=>'','asterisk_extension'=>'','use_asterisk'=>'1','accesskey'=>'bLucb6B4WtryNgKP','record_id'=>'','record_module'=>'','id'=>'446');</div>
<div>?></div>
</div></div>
<div><br>
</div>
<div><br>
</div>
</font></font><div>
<div class="gmail_extra">
<div><br clear="all">
Atte,<br>
<b>Rodrigo Souza de Oliveira</b>
<div><b>Consultor de TI<br>
</b>Hostplan Informática Ltda<br>
<div>Telefones: <a href="tel:%2821%29%209217-7909" value="+552192177909" target="_blank">(21)
9217-7909</a> e/ou <a href="tel:%2821%29%208153-5287" value="+552181535287" target="_blank">(21)
8153-5287</a>
<div>
website: <a href="http://www.hostplan.com.br" target="_blank">www.hostplan.com.br</a><br>
e-mail/msn: <a href="mailto:rodrigo@hostplan.com.br" target="_blank">rodrigo@hostplan.com.br</a><br>
<img height="137" width="200"><br>
</div>
</div>
</div>
<br>
<br>
<br>
</div>
<div class="gmail_quote">2012/11/1 Adam Heinz <span dir="ltr"><<a href="mailto:amh@metricwise.net" target="_blank">amh@metricwise.net</a>></span><br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div>
<div>
<div>On Thu, Nov 1, 2012 at 10:43 AM,
Rodrigo Souza <span dir="ltr"><<a href="mailto:rodrigo@hostplan.com.br" target="_blank">rodrigo@hostplan.com.br</a>></span>
wrote:<br>
</div>
<div class="gmail_quote">
<div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div class="gmail_extra"><span>Warning:
chmod(): Operation not permitted
in /var/www/vtiger/vtiger_novo/</span><span>log4php.debug/appenders/</span><span>LoggerAppenderFile.php
on line 80 Parse error: syntax
error, unexpected ',' in
/var/www/vtiger/vtiger_novo/</span><span>user_privileges/sharing_</span><span>privileges_444.php
on line 5</span></div>
</blockquote>
<div> </div>
</div>
<div>That's not a file permissions
error, it's a parse error. I'll bet
if you open
sharing_privileges_444.php, you will
find that some of the arrays inside
are malformed. This has happened to
me in the past prior to vtlib when I
used to do permissions updates by
hand. Have you changed any sharing
rules with SQL recently?</div>
</div>
<br>
</div>
</div>
_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
</blockquote>
</div>
<br>
</div>
<br>
</div></div>
</div>
_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
</blockquote>
</div>
<br>
<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a></pre>
</blockquote>
<br>
</div>
<br></div></div>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br></div>
<br></div></div>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br></div></div></div>
<br></div></div>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br></div>
<br></div></div>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br>
<br>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br></div>