Hello,
I've got an error message when I try to input value in the field (Title or Function on the Contact screen
The message is
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
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');