View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Project cannot be created, connection lost. - Page 2 - ProjeQtOr
 
 

Project cannot be created, connection lost.

More
18 May 2020 17:39 #7 by informatique@coopdefrance.coop
Replied by informatique@coopdefrance.coop on topic Project cannot be created, connection lost.
Same problem with installation from scratch with MySQL8, Dropdown list dont appear

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

More
18 May 2020 18:06 #8 by babynus
Replied by babynus on topic Project cannot be created, connection lost.
Hi,

Issue is not with MySql8 . I trested with MySql 8.0.16 and all works fine.
What is strange is that you don't get listboxes.
Please show description (DESC) fo table project.
Babynus
Administrator of ProjeQtOr web site

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

More
18 May 2020 18:23 #9 by informatique@coopdefrance.coop
Replied by informatique@coopdefrance.coop on topic Project cannot be created, connection lost.
Hi,
in attachement ,the project file description

File Attachment:

File Name: project_table.txt
File Size:2 KB
Attachments:

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

More
19 May 2020 11:51 - 19 May 2020 11:52 #10 by babynus
Replied by babynus on topic Project cannot be created, connection lost.
Strange, in your description, formant int also includes the "unsigned" attribute.
It this is result of DESC command, this may explain bad behavior.

Can you try and add 2 lines after line 3691 in file projeqtor/model/persistence/SqlElement.php, this may
      $from [] = 'bigint';
      $to [] = 'int';
      $from [] = 'int unsigned';
      $to [] = 'int';

Please tell us if this fixes the issue.
Babynus
Administrator of ProjeQtOr web site
Last edit: 19 May 2020 11:52 by babynus.

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

More
19 May 2020 12:07 #11 by informatique@coopdefrance.coop
Replied by informatique@coopdefrance.coop on topic Project cannot be created, connection lost.
Hi,
i added the 2 lines but it still doesn't work
regards


Attachments:

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

More
19 May 2020 18:34 #12 by babynus
Replied by babynus on topic Project cannot be created, connection lost.
Can you please help us debug : add 1 new line in projeqtor/model/persistence/SqlElement.php after line 3696, like this :
      $type = str_ireplace ( $from, $to, $type );
      $formatList [strtolower ( $fieldName )] = $type;
      debugLog("$class | $fieldName=>$type");

Then change file parameters.php (default location is in projeqtor/files/config) to set
$logLevel=3;

Access project and post here log projeqtor file.
Thanks
Babynus
Administrator of ProjeQtOr web site

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

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