View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Drop down menu not available - Page 2 - 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)

  

 

 
 

Drop down menu not available

More
22 Mai 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 Mai 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 Mai 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 Mai 2020 18:24 - 22 Mai 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 Mai 2020 18:24 by babynus.
The topic has been locked.
More
22 Mai 2020 18:42 - 22 Mai 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 Mai 2020 18:44 by lfrugere.
The topic has been locked.
More
22 Mai 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.040 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.

Login Form