View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Error on Contact Screen - ProjeQtOr
 

Error on Contact Screen

More
23 Nov 2020 17:45 - 23 Nov 2020 17:47 #1 by dnaton
Error on Contact Screen was created by dnaton
Hello,

I've got an error message when I try to input value in the field (Title or Function on the Contact screen

File Attachment:



The message is

File Attachment:


When I go to the log, here is the informations mentionned :

2020-11-23 17:41:58.820 ***** ERROR ***** [V8.6.5] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'function' in 'field list'
2020-11-23 17:41:58.821 ***** ERROR ***** [V8.6.5] For query : insert into resource (isContact, fullName , initials , function , isResource , isUser , idle , dontReceiveTeamMails ) values ('1', 'user 1', 'U1', 'Titre', '0', '0', '0', '0')
2020-11-23 17:41:58.821 ***** ERROR ***** [V8.6.5] Strack trace :
2020-11-23 17:41:58.822 ***** ERROR ***** [V8.6.5] #0 Sql->query called at [/srv/data/web/vhosts/sepra.naton.fr/htdocs/model/persistence/SqlElement.php:1358]
2020-11-23 17:41:58.823 ***** ERROR ***** [V8.6.5] #1 SqlElement->insertSqlElement called at [/srv/data/web/vhosts/sepra.naton.fr/htdocs/model/persistence/SqlElement.php:1132]
2020-11-23 17:41:58.823 ***** ERROR ***** [V8.6.5] #2 SqlElement->saveSqlElement called at [/srv/data/web/vhosts/sepra.naton.fr/htdocs/model/persistence/SqlElement.php:790]
2020-11-23 17:41:58.824 ***** ERROR ***** [V8.6.5] #3 SqlElement->save called at [/srv/data/web/vhosts/sepra.naton.fr/htdocs/model/ContactMain.php:323]
2020-11-23 17:41:58.824 ***** ERROR ***** [V8.6.5] #4 ContactMain->save called at [/srv/data/web/vhosts/sepra.naton.fr/htdocs/tool/saveObject.php:110]


Could anybody explain me what is wrong ? :(

regards
Damien
Regards,
Damien
.
ProjeQtOr v12.1.0 - Apache v2.4.56 - MariaDB v10.4.28 - PHP v8.2.4
Plugins installed : PersonalizedTranslation 1.6 - ScreenCustomization 7.2
Last edit: 23 Nov 2020 17:47 by dnaton.

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

More
23 Nov 2020 19:46 #2 by babynus
Replied by babynus on topic Error on Contact Screen
Hi,

I guess you custimized screen Contact on older version.
Try and edit file projeqtor/model/custom/Contact.php, change
public $function;
to
public $contactFunction;

and if you have
private static $_databaseColumnName = array('name'=>'fullName',
                                              'userName'=>'name',
                                              'contactFunction'=>'function');
remove the thirs line like this
private static $_databaseColumnName = array('name'=>'fullName',
                                              'userName'=>'name');
Babynus
Administrator of ProjeQtOr web site

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

Moderators: babynus, protion
Time to create page: 0.035 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.

Login Form