Hi,
I have many error in my log file, i have multpile entry with this message :2021-09-20 17:30:22.138 ** ERROR ** [V9.2.2] For query : SELECT COLUMN_COMMENT as comment FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='securite' AND TABLE_NAME='projeqtorproject' AND COLUMN_NAME='idprojeqtortask'
This query in sqlelement.php not working on postgres SQL$sqlColumn="SELECT COLUMN_COMMENT as comment FROM INFORMATION_SCHEMA.COLUMNS " ." WHERE TABLE_SCHEMA='$dbName' AND TABLE_NAME='$tableName' AND COLUMN_NAME='$dbFieldName'";
How i can fix the issue ?
Thanks a lot
Replace line 4004 in model/persistence/SqlElement.php
from
} else if ($type=='int' or $type=='int(10)' or $type=='int(11)') {
to
} else if (($type=='int' or $type=='int(10)' or $type=='int(11)') and !Sql::isPgsql()) {
Hi,
is Perfect 🙂
Thank for your help