[Vtigercrm-developers] Error creating new users and permissions recalculate

Thu Nov 1 11:31:56 PDT 2012

So my friend, have looked at that table and does not have the tabid 50 ...

Will some other table that refers to tabid?

Atte,
*Rodrigo Souza de Oliveira*
*Consultor de TI
*Hostplan Informática Ltda
Telefones: (21) 9217-7909 e/ou (21) 8153-5287
website: www.hostplan.com.br
e-mail/msn: rodrigo at hostplan.com.br

2012/11/1 Adam Heinz <amh at metricwise.net>

> 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.
>
>  On Thu, Nov 1, 2012 at 12:21 PM, Rodrigo Souza <rodrigo at hostplan.com.br>wrote:
>
>>  Master Adam :),
>>
>> I looked at the table and jumps vtiger_tab ID 49 to ID 51 ... And I do
>> not recall having excluded
>>
>> I removed this item and get access to user created!
>>
>> Now how to solve the problem permanently? I insert a record with ID 50 in
>> vtiger_tab? does not give another problem?
>>
>> Atte,
>> *Rodrigo Souza de Oliveira*
>> *Consultor de TI
>> *Hostplan Informática Ltda
>> Telefones: (21) 9217-7909 e/ou (21) 8153-5287
>> website: www.hostplan.com.br
>> e-mail/msn: rodrigo at hostplan.com.br
>>
>>
>>
>>
>> 2012/11/1 MAGGI Conrado RE-INGENIA <conrado at reingenia.com.ar>
>>
>>>  The error is the first line.. Look at
>>>
>>> ,'49'=>1*,'50'=>,'*51'=>2,'
>>>
>>> Regards,
>>>
>>>
>>> *Conrado Maggi*
>>> (re)ingenia Soluciones
>>> Tel: (011) 2054.6296
>>> Cel: (011) 15.4973.8784
>>> www.reingenia.com.ar
>>>  On 11/01/2012 12:52 PM, Rodrigo Souza wrote:
>>>
>>> Sorry, this is the User_Privileges, when it should be the Sharing
>>> Privileges. I am attaching the file.
>>>
>>> Atte,
>>> *Rodrigo Souza de Oliveira*
>>> *Consultor de TI
>>> *Hostplan Informática Ltda
>>> Telefones: (21) 9217-7909 e/ou (21) 8153-5287
>>> website: www.hostplan.com.br
>>> e-mail/msn: rodrigo at hostplan.com.br
>>>
>>>
>>>
>>>
>>> 2012/11/1 Adam Heinz <amh at metricwise.net>
>>>
>>>> Are you sure that you didn't just paste me user_privileges_444.php?
>>>>  There's nothing wrong with the file below.
>>>>
>>>>  On Thu, Nov 1, 2012 at 11:26 AM, Rodrigo Souza <
>>>> rodrigo at hostplan.com.br> wrote:
>>>>
>>>>>  Adam,
>>>>>
>>>>>  The problem is that I never made any changes to rules via SQL ...
>>>>>
>>>>>  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.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>  <?php
>>>>>
>>>>>
>>>>>  //This is the access privilege file
>>>>> $is_admin=false;
>>>>>
>>>>>  $current_user_roles='H17';
>>>>>
>>>>>  $current_user_parent_role_seq='H1::H2::H3::H20::H17';
>>>>>
>>>>>  $current_user_profiles=array(8,);
>>>>>
>>>>>  $profileGlobalPermission=array('1'=>1,'2'=>1,);
>>>>>
>>>>>
>>>>> $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,);
>>>>>
>>>>>  $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,),);
>>>>>
>>>>>  $current_user_groups=array();
>>>>>
>>>>>  $subordinate_roles=array();
>>>>>
>>>>>  $parent_roles=array('H1','H2','H3','H20',);
>>>>>
>>>>>  $subordinate_roles_users=array();
>>>>>
>>>>>
>>>>> $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'=>'
>>>>> rodrigo at hostplan.com.br','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'=>'
>>>>> 2192177909','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');
>>>>> ?>
>>>>>
>>>>>
>>>>>
>>>>> Atte,
>>>>> *Rodrigo Souza de Oliveira*
>>>>> *Consultor de TI
>>>>> *Hostplan Informática Ltda
>>>>> Telefones: (21) 9217-7909 <%2821%29%209217-7909> e/ou (21) 8153-5287<%2821%29%208153-5287>
>>>>> website: www.hostplan.com.br
>>>>> e-mail/msn: rodrigo at hostplan.com.br
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>  2012/11/1 Adam Heinz <amh at metricwise.net>
>>>>>
>>>>>>  On Thu, Nov 1, 2012 at 10:43 AM, Rodrigo Souza <
>>>>>> rodrigo at hostplan.com.br> wrote:
>>>>>>
>>>>>>> Warning: chmod(): Operation not permitted in
>>>>>>> /var/www/vtiger/vtiger_novo/log4php.debug/appenders/LoggerAppenderFile.php
>>>>>>> on line 80 Parse error: syntax error, unexpected ',' in
>>>>>>> /var/www/vtiger/vtiger_novo/user_privileges/sharing_privileges_444.php
>>>>>>> on line 5
>>>>>>>
>>>>>>
>>>>>>  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?
>>>>>>
>>>>>>  _______________________________________________
>>>>>> http://www.vtiger.com/
>>>>>>
>>>>>
>>>>>
>>>>>  _______________________________________________
>>>>> http://www.vtiger.com/
>>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> http://www.vtiger.com/
>>>>
>>>
>>>
>>>
>>> _______________________________________________http://www.vtiger.com/
>>>
>>>
>>>
>>> _______________________________________________
>>> http://www.vtiger.com/
>>>
>>
>>
>> _______________________________________________
>> http://www.vtiger.com/
>>
>
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20121101/c3dceff8/attachment-0001.html 