Forum

Can't see my contac...
 
Notifications
Retirer tout

Can't see my contact in the contact list

6 Posts
3 Utilisateurs
0 Reactions
1,602 Vu
Bena
 Bena
(@bena)
Posts: 65
Estimable Member
Début du sujet
 
[#7317]

Hello,

I can't see my contact in the screen Contact (menu environnement > Contact).
I can add a contact.
I can add contact in my project.

In the log, I have the following error :

2021-02-17 10:13:16.938 ** ERROR ** [V9.0.4] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'resource.function' in 'field list' 2021-02-17 10:13:16.938 ** ERROR ** [V9.0.4]    For query : select resource.id as id, resource.fullName as name, 32 as photo, resource.initials as initials, T1.name as nameProvider, resource.idle as idle, resource.email as email, resource.function as function, resource.phone as phone, resource.dontReceiveTeamMails as dontReceiveTeamMails from resource left join provider as T1 on resource.idProvider = T1.id where resource.idle=0 and ((1=1)) and resource.isContact='1'  order by resource.id desc 2021-02-17 10:13:16.938 ** ERROR ** [V9.0.4]    Strack trace : 2021-02-17 10:13:16.938 ** ERROR ** [V9.0.4]    #0 Sql->query called at [/projeqtor/projeqtor/tool/jsonQuery.php:736]  

 


--
Bena

 
Posté : 17/02/2021 12:15 pm
Flou
 Flou
(@flou)
Posts: 253
Reputable Member
 

Hi,

have you the plugin screen customization or have you add or edit the application code to develop new features ?


 
Posté : 17/02/2021 2:02 pm
Bena
 Bena
(@bena)
Posts: 65
Estimable Member
Début du sujet
 

Hello,
I don't have the plugin and the only time i've modified the code, it was asked by your support to correct a bug.
Regards.


--
Bena

 
Posté : 17/02/2021 11:06 pm
Flou
 Flou
(@flou)
Posts: 253
Reputable Member
 

In contactMain.php ligne 44 have you   " public $contactFunction; " and in ligne 117   "private static $_colCaptionTransposition = array('name'=>'realName','contactFunction'=>'function'); " ?


 
Posté : 18/02/2021 1:35 pm
Bena
 Bena
(@bena)
Posts: 65
Estimable Member
Début du sujet
 

Hello,

I have that :

42   public $idClient;
 43   public $idProvider;
 44   public $contactFunction;
 45   public $phone;
 46   public $mobile;

then 

115   private static $_databaseCriteria = array('isContact'=>'1');
116
117   private static $_colCaptionTransposition = array('name'=>'realName','contactFunction'=>'function');
118
119   /** ==========================================================================

 


--
Bena

 
Posté : 20/02/2021 12:58 pm
(@babynus)
Posts: 14952
Membre Admin
 

In the column selected of screen "Contacts", click on button "reset".


 
Posté : 23/02/2021 11:26 am
Share:
Retour en haut