Which version of PHP and MySql do you use ?

Hello,

Php version : PHP 7.4.3
Mysql version : 8.0.20-0ubuntu0.20.04.1

Thanks

Hello,

We've been experiencing exactly the same problem since Monday on an installation from a Docker image that had been running for over a month (8.4.3 / PHP 7.3.16 / Mysql 8.0.20).

I created a new installation with an empty database on an external temporary server and I'm encountering exactly the same problem.
I tried from several navigators and several computers : same problem.

It seems to me that it's the execution of the JS that causes the problem.

I can give you access to this external environment if you wish to reproduce this issue.

Best regards,

Lionel

Here is an example of my issue :

You can login on http://ip172-18-0-46-br3ufglim9m000eigvo0-80.direct.labs.play-with-docker.com/view/main.php with admin / admin
This is a fresh install and no data are stored.

Menu #tickets/#New => dropdown menu are not available

Thanks for your help.

Can you please give result of SQL command :

DESC project;

+---------------------------+----------------+------+-----+---------+----------------+
| 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)

PhpMyAdmin : http://ip172-18-0-46-br3ufglim9m000eigvo0-8080.direct.labs.play-with-docker.com/index.php
Login with projeqtor / projeqtor

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.

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 ?

Sorry.
There is no change

Could you also reproduce the issue on your own ?

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.

I'll try to rollback my database tonight and I'll let you know.
Thanks for your analyse.

Hi babynus,

ProjeQtOr (re)works perfectly with a MariaDB 10.5.3.
My dump was corrupted (no size on int fields) and I had to create a new database from scratch and apply manually all truncate / insert queries from my dump for restoring all data, but now it's ok.

Once again, many thanks for your help,

Lionel

I have also changed mysql to mariadb and it works now.