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

Prochaines Sessions

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

13 mai 2025 (10h30-12h)

5 juin 2025 (16h-17h30)

 
 

Planifiez avec ProjeQtOr

14 et 15 mai 2025 (9h-12h30)

18 et 19 juin 2025 (9h-12h30)

 
 

Administrez avec ProjeQtOr

20 et 21 mai (9h-12h30)

25 et 26 juin (9h-12h30)

 

 

 

Can't see my contact in the contact list

More
17 Fév 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 Connexion or Create an account to join the conversation.

More
17 Fév 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 Connexion or Create an account to join the conversation.

More
17 Fév 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 Connexion or Create an account to join the conversation.

More
18 Fév 2021 11:35 - 18 Fév 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 Fév 2021 11:36 by Flou.

Please Connexion or Create an account to join the conversation.

More
20 Fév 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 Connexion or Create an account to join the conversation.

More
23 Fév 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 Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.044 seconds

Paramétrages de cookies

×

Cookies fonctionnels

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

Veuillez vous connecter pour voir vos activités!

Autres cookies

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