View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Can't see my contact in the contact list - ProjeQtOr
 

Can't see my contact in the contact list

More
17 Feb 2021 10:15 #1 by Bena
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

Please Log in or Create an account to join the conversation.

More
17 Feb 2021 12:02 #2 by Flou
Hi,

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

Please Log in or Create an account to join the conversation.

More
17 Feb 2021 21:06 #3 by Bena
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

Please Log in or Create an account to join the conversation.

More
18 Feb 2021 11:35 - 18 Feb 2021 11:36 #4 by Flou
In contactMain.php ligne 44 have you   " public $contactFunction; " and in ligne 117   "private static $_colCaptionTransposition = array('name'=>'realName','contactFunction'=>'function'); " ?
Last edit: 18 Feb 2021 11:36 by Flou.

Please Log in or Create an account to join the conversation.

More
20 Feb 2021 10:58 #5 by Bena
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

Please Log in or Create an account to join the conversation.

More
23 Feb 2021 09:26 #6 by babynus
In the column selected of screen "Contacts", click on button "reset".

Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: Bena

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.052 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.