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

Rodrigo Souza rodrigo at hostplan.com.br
Thu Nov 1 12:08:47 PDT 2012


I can't believe .... that was it, the tabid 50 was this table with the
permission field null ...

I still do not know the structure of the Vtiger, then catch enough to get a
few points ...

Thank you for the quick help and understanding, you are grade 10, my friend!



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>

> 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.
>
> On Thu, Nov 1, 2012 at 2:31 PM, Rodrigo Souza <rodrigo at hostplan.com.br>wrote:
>
>> 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/
>>>
>>
>>
>> _______________________________________________
>> 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/6f8e3fc6/attachment-0001.html 


More information about the vtigercrm-developers mailing list