In Recipent model the $_layout contains the line
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
Best regards
Antonio Giarratana
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
${bankName}
This will not solve anything : ${bankName} just stands for display name