View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Drop down menu not available - Page 2 - ProjeQtOr
 
 

Drop down menu not available

More
22 May 2020 17:43 #7 by lfrugere
Replied by lfrugere on topic Drop down menu not available
+
+
+
+
+
+
+
| Field | Type | Null | Key | Default | Extra |
+
+
+
+
+
+
+
| id | int unsigned | NO | PRI | NULL | auto_increment |
| name | varchar(100) | NO | | NULL | |
| description | mediumtext | YES | | NULL | |
| idClient | int | YES | MUL | NULL | |
| projectCode | varchar(25) | YES | | NULL | |
| contractCode | varchar(25) | YES | | NULL | |
| color | varchar(7) | YES | | NULL | |
| idProject | int unsigned | YES | MUL | NULL | |
| idle | int unsigned | YES | | 0 | |
| idUser | int unsigned | YES | MUL | NULL | |
| done | int unsigned | YES | | 0 | |
| idleDate | date | YES | | NULL | |
| doneDate | date | YES | | NULL | |
| idContact | int unsigned | YES | MUL | NULL | |
| sortOrder | varchar(600) | YES | MUL | NULL | |
| idProjectType | int unsigned | YES | | NULL | |
| codeType | varchar(10) | YES | | OPE | |
| idRecipient | int unsigned | YES | MUL | NULL | |
| paymentDelay | int | YES | | NULL | |
| longitude | decimal(15,12) | YES | | NULL | |
| latitude | decimal(15,12) | YES | | NULL | |
| idStatus | int unsigned | YES | MUL | NULL | |
| idHealth | int unsigned | YES | | NULL | |
| fixPlanning | int unsigned | YES | | 0 | |
| clientCode | varchar(25) | YES | | NULL | |
| idOverallProgress | int unsigned | YES | | NULL | |
| cancelled | int unsigned | YES | | 0 | |
| idQuality | int unsigned | YES | | NULL | |
| idTrend | int unsigned | YES | | NULL | |
| idSponsor | int unsigned | YES | | NULL | |
| creationDate | date | YES | | NULL | |
| objectives | mediumtext | YES | | NULL | |
| idResource | int unsigned | YES | | NULL | |
| isUnderConstruction | int unsigned | YES | | 0 | |
| lastUpdateDateTime | datetime | YES | | NULL | |
| idOrganization | int unsigned | YES | MUL | NULL | |
| organizationInherited | int unsigned | YES | | NULL | |
| organizationElementary | int unsigned | YES | | NULL | |
| idCategory | int unsigned | YES | | NULL | |
| handled | int | YES | | 0 | |
| handledDate | date | YES | | NULL | |
| excludeFromGlobalPlanning | int unsigned | YES | | 0 | |
| fixPerimeter | int unsigned | YES | | 0 | |
| isLeaveMngProject | int unsigned | YES | | 0 | |
+
+
+
+
+
+
+
44 rows in set (0.00 sec)
The topic has been locked.
More
22 May 2020 17:51 #8 by lfrugere
Replied by lfrugere on topic Drop down menu not available
PhpMyAdmin : ip172-18-0-46-br3ufglim9m000eigvo0-8080....docker.com/index.php
Login with projeqtor / projeqtor
The topic has been locked.
More
22 May 2020 18:21 #9 by babynus
Replied by babynus on topic Drop down menu not available
Hi,

Issue is with MySql.
DESC returns no size for int
It returns int instead of int(12) or int(1).
So we cannot identify reference [int(12)] from booleans [int(1)] from normal integers.
Babynus
Administrator of ProjeQtOr web site
The topic has been locked.
More
22 May 2020 18:24 - 22 May 2020 18:24 #10 by babynus
Replied by babynus on topic Drop down menu not available
Can you try and change line 3653 in model/persistence/SqlElement.php from
$query = "desc " . $obj->getDatabaseTableName ();
to
$query = "explain " . $obj->getDatabaseTableName ();

Does it change anything ?
Babynus
Administrator of ProjeQtOr web site
Last edit: 22 May 2020 18:24 by babynus.
The topic has been locked.
More
22 May 2020 18:42 - 22 May 2020 18:44 #11 by lfrugere
Replied by lfrugere on topic Drop down menu not available
Sorry.
There is no change

Could you also reproduce the issue on your own ?
Attachments:
Last edit: 22 May 2020 18:44 by lfrugere.
The topic has been locked.
More
22 May 2020 19:05 #12 by babynus
Replied by babynus on topic Drop down menu not available
I confirm that this is an issue with MySql 8.0.20.
It does not give size for int in DESC.
It was working fine with MySql 8.0.16 and 8.0.20.
Try and switch to another correct version or switch to MariaDB or switch to postgreSql until we find a workaround.
Babynus
Administrator of ProjeQtOr web site
The topic has been locked.
Moderators: babynus, protion
Time to create page: 0.043 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