Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Can't see my contac...
 
Notifications
Clear all

Can't see my contact in the contact list

6 Posts
3 Users
0 Reactions
1,637 Views
Bena
 Bena
(@bena)
Posts: 65
Active Member
Topic starter
 
[#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

 
Posted : 17 Feb 2021 12H15
Flou
 Flou
(@flou)
Posts: 253
Active Member
 

Hi,

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


 
Posted : 17 Feb 2021 14H02
Bena
 Bena
(@bena)
Posts: 65
Active Member
Topic starter
 

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

 
Posted : 17 Feb 2021 23H06
Flou
 Flou
(@flou)
Posts: 253
Active Member
 

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


 
Posted : 18 Feb 2021 13H35
Bena
 Bena
(@bena)
Posts: 65
Active Member
Topic starter
 

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

 
Posted : 20 Feb 2021 12H58
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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


 
Posted : 23 Feb 2021 11H26
Share:

Scroll to Top