View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Recipient layout - ProjeQtOr

Prochaines sessions de formation

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

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

 
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

 
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

 

 

 
 

Recipient layout

More
14 Nov 2016 14:14 #1 by antonio.grr
Recipient layout was created by antonio.grr
In Recipent model the $_layout contains the line

<th field="bankName" width="25%">${bank}</th>
The recipient table instead has the column bankName. The table ColumnSelector has a row with attribute = 'bank', so the select query fails creating log lines like those :

2016-11-14 11:54:48.285 ***** ERROR ***** Exception-[42703] SQLSTATE[42703]: Undefined column: 7 ERROR: column pqo_recipient.bank does not exist
LINE 1: ...companyNumber", pqo_recipient.numTax as "numTax", pqo_recipi...
^
2016-11-14 11:54:48.287 ***** ERROR ***** For query : select pqo_recipient.id as "id", pqo_recipient.name as "name", pqo_recipient.companyNumber as "companyNumber", pqo_recipient.numTax as "numTax", pqo_recipient.bank as "bank", pqo_recipient.idle as "idle", pqo_recipient.bankName as "bankName" from pqo_recipient where pqo_recipient.idle=0 and ((1=1)) order by pqo_recipient.id desc
2016-11-14 11:54:48.287 ***** ERROR ***** Strack trace :
2016-11-14 11:54:48.287 ***** ERROR ***** #0 Sql->query called at [/var/www/projeqtor/tool/jsonQuery.php:535]

I fixed deleting the row in columnselector table and setting to false the variable $allFields in ColumnSelector model. I presume that I could instead correct the layout line in
<th field="bankName" width="25%">${bankName}</th>

Best regards
Antonio Giarratana
The topic has been locked.
More
18 Nov 2016 22:29 #2 by babynus
Replied by babynus on topic Recipient layout

The recipient table instead has the column bankName. The table ColumnSelector has a row with attribute = 'bank', so the select query fails

This is due to quite old migration.
Just go to column select and click "Refresh" button.

I fixed deleting the row in columnselector table and setting to false the variable $allFields in ColumnSelector model.

This is not mandatory (see above)

I presume that I could instead correct the layout line in
<th field="bankName" width="25%">${bankName}</th>

This will not solve anything : ${bankName} just stands for display name

Babynus
Administrator of ProjeQtOr web site
The topic has been locked.
Moderators: babynusprotion
Time to create page: 0.031 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.