View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Installation troubles on Ubuntu 16.04-18.x with xampp - 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)

 

 

 
 

Installation troubles on Ubuntu 16.04-18.x with xampp

More
20 Jan 2020 11:06 - 20 Jan 2020 11:08 #7 by fred12345
/files/config/parametersLocation.php contains:
$parametersLocation = '../files/config/parameters.php';
File: /files/config/parameters.php contains:
$logFile = '../files/logs/projeqtor_${date}.log';
$logLevel = '2';

But I see the file contains the same data twice including: TEST<?php
So, maybe this file was broken?
Last edit: 20 Jan 2020 11:08 by fred12345.

Please Connexion or Create an account to join the conversation.

More
20 Jan 2020 11:27 #8 by fred12345
So, now I can proceed to the login page.
But the message is shown before authorization: Upgrade in progress. Only admin user can connect.
After trying to login I get two more errors:
1) an error: An error occurred on 2020-01-20 at 11.22.43
2) "max_input_vars=1000 is too small - value should be at least 2000, 4000 recommended - check your php configuration (php.ini)"
Although the /opt/lampp/etc/php/ini has parameter: max_input_vars=4000

Please Connexion or Create an account to join the conversation.

More
20 Jan 2020 12:27 #9 by babynus
Hi,

But I see the file contains the same data twice including: TEST<?php
So, maybe this file was broken?

Possibly PHP user has possibility to update file, but not to delete it ?

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
20 Jan 2020 12:29 #10 by babynus

But the message is shown before authorization: Upgrade in progress. Only admin user can connect.

This is completely normal.

After trying to login I get two more errors:
1) an error: An error occurred on 2020-01-20 at 11.22.43

Please post error logged in log file

2) "max_input_vars=1000 is too small - value should be at least 2000, 4000 recommended - check your php configuration (php.ini)"
Although the /opt/lampp/etc/php/ini has parameter: max_input_vars=4000

This should not be a blocking error, just a warning (ping message, not red one)
This may be due to not restarting PHP (must be restarted to take into account changes in php.ini)

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
20 Jan 2020 13:28 - 20 Jan 2020 13:29 #11 by fred12345
Appeared the log file. New error time: 2020-01-20 13:23:40

2020-01-20 13:23:34.511 ***** ERROR ***** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2020-01-20 13:23:34.512 ***** ERROR ***** [] For query : select * from parameter where (idUser is null and idProject is null)
2020-01-20 13:23:34.512 ***** ERROR ***** [] Strack trace :
2020-01-20 13:23:34.512 ***** ERROR ***** [] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 13:23:34.512 ***** ERROR ***** [] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/model/Parameter.php:1173]
2020-01-20 13:23:34.512 ***** ERROR ***** [] #2 Parameter->getGlobalParameter called at [/opt/lampp/htdocs/model/SSO.php:25]
2020-01-20 13:23:34.512 ***** ERROR ***** [] #3 SSO->isEnabled called at [/opt/lampp/htdocs/view/index.php:56]
2020-01-20 13:23:34.831 ***** ERROR ***** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2020-01-20 13:23:34.831 ***** ERROR ***** [] For query : select * from parameter where (idUser is null and idProject is null)
2020-01-20 13:23:34.831 ***** ERROR ***** [] Strack trace :
2020-01-20 13:23:34.831 ***** ERROR ***** [] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 13:23:34.831 ***** ERROR ***** [] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/model/Parameter.php:1173]
2020-01-20 13:23:34.831 ***** ERROR ***** [] #2 Parameter->getGlobalParameter called at [/opt/lampp/htdocs/model/SSO.php:25]
2020-01-20 13:23:34.831 ***** ERROR ***** [] #3 SSO->isEnabled called at [/opt/lampp/htdocs/model/SSO.php:32]
2020-01-20 13:23:34.831 ***** ERROR ***** [] #4 SSO->isSamlEnabled called at [/opt/lampp/htdocs/tool/projeqtor.php:213]
2020-01-20 13:23:34.831 ***** ERROR ***** [] #5 require_once called at [/opt/lampp/htdocs/view/main.php:37]
2020-01-20 13:23:34.847 ***** ERROR ***** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.module' doesn't exist
2020-01-20 13:23:34.847 ***** ERROR ***** [] For query : select * from module where 1=1 order by module.sortOrder
2020-01-20 13:23:34.847 ***** ERROR ***** [] Strack trace :
2020-01-20 13:23:34.847 ***** ERROR ***** [] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 13:23:34.847 ***** ERROR ***** [] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/model/Module.php:175]
2020-01-20 13:23:34.847 ***** ERROR ***** [] #2 Module->initializeModuleList called at [/opt/lampp/htdocs/model/Module.php:105]
2020-01-20 13:23:34.847 ***** ERROR ***** [] #3 Module->isModuleActive called at [/opt/lampp/htdocs/tool/projeqtor.php:4726]
2020-01-20 13:23:34.847 ***** ERROR ***** [] #4 isLeavesSystemActiv called at [/opt/lampp/htdocs/tool/projeqtor.php:4390]
2020-01-20 13:23:34.847 ***** ERROR ***** [] #5 formatIcon called at [/opt/lampp/htdocs/view/login.php:344]
2020-01-20 13:23:34.847 ***** ERROR ***** [] #6 include called at [/opt/lampp/htdocs/tool/projeqtor.php:285]
2020-01-20 13:23:34.847 ***** ERROR ***** [] #7 require_once called at [/opt/lampp/htdocs/view/main.php:37]
2020-01-20 13:23:35.782 ***** ERROR ***** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2020-01-20 13:23:35.783 ***** ERROR ***** [] For query : select * from parameter where (idUser is null and idProject is null)
2020-01-20 13:23:35.783 ***** ERROR ***** [] Strack trace :
2020-01-20 13:23:35.783 ***** ERROR ***** [] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 13:23:35.783 ***** ERROR ***** [] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/model/Parameter.php:1173]
2020-01-20 13:23:35.783 ***** ERROR ***** [] #2 Parameter->getGlobalParameter called at [/opt/lampp/htdocs/model/SSO.php:25]
2020-01-20 13:23:35.783 ***** ERROR ***** [] #3 SSO->isEnabled called at [/opt/lampp/htdocs/model/SSO.php:32]
2020-01-20 13:23:35.783 ***** ERROR ***** [] #4 SSO->isSamlEnabled called at [/opt/lampp/htdocs/tool/projeqtor.php:213]
2020-01-20 13:23:35.783 ***** ERROR ***** [] #5 require_once called at [/opt/lampp/htdocs/tool/saveDataToSession.php:30]
2020-01-20 13:23:35.826 ***** ERROR ***** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2020-01-20 13:23:35.826 ***** ERROR ***** [] For query : select * from parameter where (idUser is null and idProject is null)
2020-01-20 13:23:35.826 ***** ERROR ***** [] Strack trace :
2020-01-20 13:23:35.826 ***** ERROR ***** [] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 13:23:35.826 ***** ERROR ***** [] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/model/Parameter.php:1173]
2020-01-20 13:23:35.826 ***** ERROR ***** [] #2 Parameter->getGlobalParameter called at [/opt/lampp/htdocs/model/SSO.php:25]
2020-01-20 13:23:35.826 ***** ERROR ***** [] #3 SSO->isEnabled called at [/opt/lampp/htdocs/model/SSO.php:32]
2020-01-20 13:23:35.826 ***** ERROR ***** [] #4 SSO->isSamlEnabled called at [/opt/lampp/htdocs/tool/projeqtor.php:213]
2020-01-20 13:23:35.826 ***** ERROR ***** [] #5 require_once called at [/opt/lampp/htdocs/tool/saveDataToSession.php:30]
2020-01-20 13:23:35.862 ***** ERROR ***** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2020-01-20 13:23:35.862 ***** ERROR ***** [] For query : select * from parameter where (idUser is null and idProject is null)
2020-01-20 13:23:35.862 ***** ERROR ***** [] Strack trace :
2020-01-20 13:23:35.862 ***** ERROR ***** [] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 13:23:35.862 ***** ERROR ***** [] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/model/Parameter.php:1173]
2020-01-20 13:23:35.862 ***** ERROR ***** [] #2 Parameter->getGlobalParameter called at [/opt/lampp/htdocs/model/SSO.php:25]
2020-01-20 13:23:35.862 ***** ERROR ***** [] #3 SSO->isEnabled called at [/opt/lampp/htdocs/model/SSO.php:32]
2020-01-20 13:23:35.862 ***** ERROR ***** [] #4 SSO->isSamlEnabled called at [/opt/lampp/htdocs/tool/projeqtor.php:213]
2020-01-20 13:23:35.862 ***** ERROR ***** [] #5 require_once called at [/opt/lampp/htdocs/tool/saveDataToSession.php:30]
2020-01-20 13:23:35.926 ***** ERROR ***** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2020-01-20 13:23:35.926 ***** ERROR ***** [] For query : select * from parameter where (idUser is null and idProject is null)
2020-01-20 13:23:35.926 ***** ERROR ***** [] Strack trace :
2020-01-20 13:23:35.926 ***** ERROR ***** [] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 13:23:35.926 ***** ERROR ***** [] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/model/Parameter.php:1173]
2020-01-20 13:23:35.926 ***** ERROR ***** [] #2 Parameter->getGlobalParameter called at [/opt/lampp/htdocs/model/SSO.php:25]
2020-01-20 13:23:35.926 ***** ERROR ***** [] #3 SSO->isEnabled called at [/opt/lampp/htdocs/model/SSO.php:32]
2020-01-20 13:23:35.926 ***** ERROR ***** [] #4 SSO->isSamlEnabled called at [/opt/lampp/htdocs/tool/projeqtor.php:213]
2020-01-20 13:23:35.926 ***** ERROR ***** [] #5 require_once called at [/opt/lampp/htdocs/tool/saveDataToSession.php:30]
2020-01-20 13:23:35.958 ***** ERROR ***** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2020-01-20 13:23:35.958 ***** ERROR ***** [] For query : select * from parameter where (idUser is null and idProject is null)
2020-01-20 13:23:35.958 ***** ERROR ***** [] Strack trace :
2020-01-20 13:23:35.958 ***** ERROR ***** [] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 13:23:35.958 ***** ERROR ***** [] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/model/Parameter.php:1173]
2020-01-20 13:23:35.958 ***** ERROR ***** [] #2 Parameter->getGlobalParameter called at [/opt/lampp/htdocs/model/SSO.php:25]
2020-01-20 13:23:35.958 ***** ERROR ***** [] #3 SSO->isEnabled called at [/opt/lampp/htdocs/model/SSO.php:32]
2020-01-20 13:23:35.958 ***** ERROR ***** [] #4 SSO->isSamlEnabled called at [/opt/lampp/htdocs/tool/projeqtor.php:213]
2020-01-20 13:23:35.958 ***** ERROR ***** [] #5 require_once called at [/opt/lampp/htdocs/tool/saveDataToSession.php:30]
2020-01-20 13:23:35.982 ***** ERROR ***** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2020-01-20 13:23:35.982 ***** ERROR ***** [] For query : select * from parameter where (idUser is null and idProject is null)
2020-01-20 13:23:35.982 ***** ERROR ***** [] Strack trace :
2020-01-20 13:23:35.982 ***** ERROR ***** [] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 13:23:35.982 ***** ERROR ***** [] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/model/Parameter.php:1173]
2020-01-20 13:23:35.982 ***** ERROR ***** [] #2 Parameter->getGlobalParameter called at [/opt/lampp/htdocs/model/SSO.php:25]
2020-01-20 13:23:35.982 ***** ERROR ***** [] #3 SSO->isEnabled called at [/opt/lampp/htdocs/model/SSO.php:32]
2020-01-20 13:23:35.982 ***** ERROR ***** [] #4 SSO->isSamlEnabled called at [/opt/lampp/htdocs/tool/projeqtor.php:213]
2020-01-20 13:23:35.982 ***** ERROR ***** [] #5 require_once called at [/opt/lampp/htdocs/tool/saveDataToSession.php:30]
2020-01-20 13:23:40.378 ***** ERROR ***** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2020-01-20 13:23:40.378 ***** ERROR ***** [] For query : select * from parameter where (idUser is null and idProject is null)
2020-01-20 13:23:40.378 ***** ERROR ***** [] Strack trace :
2020-01-20 13:23:40.378 ***** ERROR ***** [] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 13:23:40.378 ***** ERROR ***** [] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/model/Parameter.php:1173]
2020-01-20 13:23:40.378 ***** ERROR ***** [] #2 Parameter->getGlobalParameter called at [/opt/lampp/htdocs/model/SSO.php:25]
2020-01-20 13:23:40.378 ***** ERROR ***** [] #3 SSO->isEnabled called at [/opt/lampp/htdocs/model/SSO.php:32]
2020-01-20 13:23:40.378 ***** ERROR ***** [] #4 SSO->isSamlEnabled called at [/opt/lampp/htdocs/tool/projeqtor.php:213]
2020-01-20 13:23:40.379 ***** ERROR ***** [] #5 require_once called at [/opt/lampp/htdocs/tool/getHash.php:30]
2020-01-20 13:23:40.382 ***** ERROR ***** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.resource' doesn't exist
2020-01-20 13:23:40.382 ***** ERROR ***** [] For query : desc resource
2020-01-20 13:23:40.382 ***** ERROR ***** [] Strack trace :
2020-01-20 13:23:40.382 ***** ERROR ***** [] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:3597]
2020-01-20 13:23:40.382 ***** ERROR ***** [] #1 SqlElement->getFormatList called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:3147]
2020-01-20 13:23:40.382 ***** ERROR ***** [] #2 SqlElement->getDataType called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2448]
2020-01-20 13:23:40.382 ***** ERROR ***** [] #3 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2790]
2020-01-20 13:23:40.382 ***** ERROR ***** [] #4 SqlElement->getSingleSqlElementFromCriteria called at [/opt/lampp/htdocs/tool/getHash.php:48]
2020-01-20 13:23:40.382 ***** ERROR ***** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.resource' doesn't exist
2020-01-20 13:23:40.382 ***** ERROR ***** [] For query : select * from resource where resource.name='admin' and resource.isUser = '1'
2020-01-20 13:23:40.382 ***** ERROR ***** [] Strack trace :
2020-01-20 13:23:40.382 ***** ERROR ***** [] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 13:23:40.382 ***** ERROR ***** [] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2790]
2020-01-20 13:23:40.382 ***** ERROR ***** [] #2 SqlElement->getSingleSqlElementFromCriteria called at [/opt/lampp/htdocs/tool/getHash.php:48]
2020-01-20 13:23:40.426 ***** ERROR ***** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.parameter' doesn't exist
2020-01-20 13:23:40.427 ***** ERROR ***** [] For query : select * from parameter where (idUser is null and idProject is null)
2020-01-20 13:23:40.427 ***** ERROR ***** [] Strack trace :
2020-01-20 13:23:40.427 ***** ERROR ***** [] #0 Sql->query called at [/opt/lampp/htdocs/model/persistence/SqlElement.php:2485]
2020-01-20 13:23:40.427 ***** ERROR ***** [] #1 SqlElement->getSqlElementsFromCriteria called at [/opt/lampp/htdocs/model/Parameter.php:1173]
2020-01-20 13:23:40.427 ***** ERROR ***** [] #2 Parameter->getGlobalParameter called at [/opt/lampp/htdocs/model/SSO.php:25]
2020-01-20 13:23:40.427 ***** ERROR ***** [] #3 SSO->isEnabled called at [/opt/lampp/htdocs/model/SSO.php:32]
2020-01-20 13:23:40.427 ***** ERROR ***** [] #4 SSO->isSamlEnabled called at [/opt/lampp/htdocs/tool/projeqtor.php:213]
2020-01-20 13:23:40.427 ***** ERROR ***** [] #5 require_once called at [/opt/lampp/htdocs/tool/loginCheck.php:30]
2020-01-20 13:23:40.432 ***** ERROR ***** [] ERROR *****
2020-01-20 13:23:40.432 ***** ERROR ***** [] on file '/opt/lampp/htdocs/db/maintenance.php' at line (81)
2020-01-20 13:23:40.432 ***** ERROR ***** [] cause = fopen(../files/cron/MIGRATION): failed to open stream: Permission denied
Last edit: 20 Jan 2020 13:29 by fred12345.

Please Connexion or Create an account to join the conversation.

More
20 Jan 2020 14:19 #12 by babynus
PHP user don't have access to ../files/cron/
You sohuld give access 775 to whole files folder
chmod -R 775 files

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.047 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.