Forum

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.

Unable to install P...
 
Notifications
Clear all

Unable to install ProjeQtor 6.4.4

10 Posts
2 Users
0 Reactions
7,574 Views
(@sogeti)
Posts: 135
Active Member
Topic starter
 
[#4789]

Hello,

Unable to install ProjeQtor with this stack :

- Ubuntu 16.04.03 LTS
- Apache 2.4.18
- Php 7.0.22
- Postgres 9.5.10

ProjeQtOr is not compatible with PHP V7.1, but PHP 7.0 ?
Someone would have any idea ?

See the log :


 
Posted : 20 Nov 2017 18H53
babynus
(@babynus)
Posts: 14954
Main Contributor Admin
 

Please describe your installation process and where you are blocked (at which step).


 
Posted : 21 Nov 2017 12H00
(@sogeti)
Posts: 135
Active Member
Topic starter
 

Hi,

The installation process is attached.
We are stuck in the first phase during the first connection to create the structure of the database.

Regards.


 
Posted : 21 Nov 2017 12H52
babynus
(@babynus)
Posts: 14954
Main Contributor Admin
 

OK, so now you connect to application.
And you have configuration page ?
Save OK ?
Arrive at connection page ?


 
Posted : 21 Nov 2017 13H43
(@sogeti)
Posts: 135
Active Member
Topic starter
 

Hello,

My answers to your questions :

OK, so now you connect to application. YES
And you have configuration page ? YES it's ok at this step.
Save OK ? Ok it's work correctly
Arrive at connection page ? Yes and i try admin / admin i have this error.

Regards.


 
Posted : 21 Nov 2017 14H56
babynus
(@babynus)
Posts: 14954
Main Contributor Admin
 

It seems there is some inconsistency between PHP / PostgreSql / PDO

I have no issue with
PHP 7.0.10
PostgreSql 9.4

It seems PHP 7.0.22 (or your PDO version) returns a resource for non select queries.
What is strange is that I tried with PHP 7.1.5 and all works fine.
So maybe some issue between PostgreSql 9.5 and PHP 7.0.

You can try this trick : in /model/persistence/Sql.php; add new line after line 127, this way

    self::$lastQueryType= (is_resource($result)) ? "SELECT" : "UPDATE";
    if (strtoupper(substr($sqlRequest,0,6)=='SELECT')) self::$lastQueryType='SELECT';

 
Posted : 21 Nov 2017 20H27
(@sogeti)
Posts: 135
Active Member
Topic starter
 

I try this trick, but same issue.
Please see the log in attachment


 
Posted : 22 Nov 2017 0H07
babynus
(@babynus)
Posts: 14954
Main Contributor Admin
 

add in your parameters.php file :

$debugQuery=true; 

Then test again and post log file


 
Posted : 22 Nov 2017 16H18
(@sogeti)
Posts: 135
Active Member
Topic starter
 

See attach the new log


 
Posted : 22 Nov 2017 16H33
(@sogeti)
Posts: 135
Active Member
Topic starter
 

Hello,

I want to put the topic in standby.
Indeed, I am waiting for the official stack of my client.
It is useless for the moment to push the investigations on the behavior of the application with PHP 7.0.x

Unless you want to continue testing for the community ?

Thanks again


 
Posted : 23 Nov 2017 14H28
Share:

Scroll to Top