View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Postgres - COLUMN_COMMENT Missing in INFORMATION_SCHEMA.COLUMNS - ProjeQtOr
 
 

[SOLVED] Postgres - COLUMN_COMMENT Missing in INFORMATION_SCHEMA.COLUMNS

More
20 Sep 2021 21:07 #1 by sensemila
Postgres - COLUMN_COMMENT Missing in INFORMATION_SCHEMA.COLUMNS was created by sensemila
Hi,

I have many error in my log file, i have multpile entry with this message :2021-09-20 17:30:22.138 ***** ERROR ***** /color][color=#569cd6]V9.2.2[/color][color=#d4d4d4    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

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

More
21 Sep 2021 12:19 - 21 Sep 2021 13:59 #2 by babynus
Replied by babynus on topic Postgres - COLUMN_COMMENT Missing in INFORMATION_SCHEMA.COLUMNS
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()) {

Babynus
Administrator of ProjeQtOr web site
Last edit: 21 Sep 2021 13:59 by babynus.
The following user(s) said Thank You: sensemila

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

More
22 Sep 2021 11:15 - 22 Sep 2021 11:16 #3 by sensemila
Replied by sensemila on topic Postgres - COLUMN_COMMENT Missing in INFORMATION_SCHEMA.COLUMNS
Hi,
is Perfect :)

Thank for your help
Last edit: 22 Sep 2021 11:16 by sensemila.

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

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