Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
Hi,
I have successfully install ProjeQtor on my server.
I have tried to create first Project as "Today" guide but got error "Connection Lost" as image "projeqtor_1.png".
There are no dropdown list of project type and project status.
Error Logs file has messages:
2020-02-07 15:03:37.126 ** ERROR ** [V8.3.2] HACK ================================================================
2020-02-07 15:03:37.128 ** ERROR ** [V8.3.2] Try to hack detected
2020-02-07 15:03:37.129 ** ERROR ** [V8.3.2] Source Code = Id 'NaN' is not numeric
2020-02-07 15:03:37.130 ** ERROR ** [V8.3.2] QUERY_STRING = type=1&status=NaN&profile=&objectClass=Project
2020-02-07 15:03:37.130 ** ERROR ** [V8.3.2] REMOTE_ADDR = 172.19.0.1
2020-02-07 15:03:37.132 ** ERROR ** [V8.3.2] SCRIPT_FILENAME = /www/projeqtor/tool/getExtraHiddenFields.php
2020-02-07 15:03:37.133 ** ERROR ** [V8.3.2] REQUEST_URI = /tool/getExtraHiddenFields.php?type=1&status=NaN&profile=&objectClass=Project
Please give me some guide to fix this case. Thank you.
Hi,
You have strange behavior.
All fields that should be some list (type, status, category, ...) are displayed as input fields.
Something is wreong with your DB.
Which DB / Version are you using ?
Dear babynus,
I have installed lastest docker image mysql ( mysql 8.0.19 ). It means I should use older version of MySQL?
Thank you.
Hi,
I'm not aware about any non-compatibility with mySql V8.0
We only use basic ssql features through PDO, so, IMO, it should work.
Possibly confioguration of your DB, of docker installation causes the issue.
Have a look at your logs (prtojeqtor, php, mysql) to try and understand why db connection was closed.
Hi,
When I installed Projeqtor with MySQL 5.7. The process stucked at first time admin login.
There are difference to MySQL 8.
With MySQL 8, i got message "DATABASE UPDATE COMPLETED TO VERSION V8.3.2" in a green board. I can login, create user, contact, client ... with MySQL 8 also.
Don't you have components that can interact with DB connection ?
Selinux, Firewall, Antivirus ?
Same problem with installation from scratch with MySQL8, Dropdown list dont appear
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.
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.
Hi,
i added the 2 lines but it still doesn't work
regards
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
Hello,
the last log
2020-05-20 09:21:00.101 ===== TRACE ===== NEW CONNECTED USER 'admin'
2020-05-20 09:21:21.649 ===== TRACE ===== Cannot check Version at http://projeqtor.org/admin/getVersion.php
2020-05-20 09:21:21.650 ===== TRACE ===== Maybe allow_url_fopen is Off in php.ini...
2020-05-20 10:13:47.347 ===== TRACE ===== DISCONNECTED USER 'admin'
2020-05-20 10:14:24.923 ===== TRACE ===== NEW CONNECTED USER 'admin'
2020-05-20 10:14:46.452 ===== TRACE ===== Cannot check Version at http://projeqtor.org/admin/getVersion.php
2020-05-20 10:14:46.453 ===== TRACE ===== Maybe allow_url_fopen is Off in php.ini...
2020-05-20 11:00:38.504 ===== TRACE ===== DISCONNECTED USER 'admin'
2020-05-20 11:00:42.594 ===== TRACE ===== NEW CONNECTED USER 'admin'
2020-05-20 14:32:19.097 ===== TRACE ===== DISCONNECTED USER 'admin'
2020-05-20 14:43:14.320 ===== TRACE ===== NEW CONNECTED USER 'admin'
2020-05-20 14:52:21.138 ** ERROR ** [V8.4.4] HACK ================================================================
2020-05-20 14:52:21.139 ** ERROR ** [V8.4.4] Try to hack detected
2020-05-20 14:52:21.139 ** ERROR ** [V8.4.4] Source Code = Id 'NaN' is not numeric
2020-05-20 14:52:21.139 ** ERROR ** [V8.4.4] QUERY_STRING = idStatus=1&idProject=NaN&idType=48&destinationWidth=20&destinationHeight=0&isIE=&xhrPostDestination=graphStatusDiv&xhrPostIsResultMessage=false&xhrPostValidationType=&xhrPostTimestamp=1589979141040
2020-05-20 14:52:21.139 ** ERROR ** [V8.4.4] REMOTE_ADDR = xxx.xx..xx.xxxx
2020-05-20 14:52:21.139 ** ERROR ** [V8.4.4] SCRIPT_FILENAME = C:/www/projeqtor/tool/dynamicDialogGraphStatus.php
2020-05-20 14:52:21.140 ** ERROR ** [V8.4.4] REQUEST_URI = /tool/dynamicDialogGraphStatus.php?idStatus=1&idProject=NaN&idType=48&destinationWidth=20&destinationHeight=0&isIE=&xhrPostDestination=graphStatusDiv&xhrPostIsResultMessage=false&xhrPostValidationType=&xhrPostTimestamp=1589979141040
2020-05-20 14:52:35.060 ===== TRACE ===== NEW CONNECTED USER 'admin'
2020-05-20 15:24:42.322 ===== TRACE ===== DISCONNECTED USER 'admin'
2020-05-20 15:24:49.915 ===== TRACE ===== NEW CONNECTED USER 'admin'
2020-05-20 15:25:11.429 ===== TRACE ===== Cannot check Version at http://projeqtor.org/admin/getVersion.php
2020-05-20 15:25:11.430 ===== TRACE ===== Maybe allow_url_fopen is Off in php.ini...
2020-05-20 17:49:32.742 ===== TRACE ===== DISCONNECTED USER 'admin'
regards
Error logged at 14:52 has nothing to deal with this topic.
you mist replay the test that generated the error and post log afterwards.