Dear all,
i have an existing website working perfectly
i created a sub-domaine inside to host Projeqtor
i have copied projeqtor files inside the folder properly
for the installation i have used the same database of the existing website
i can see the projeqtor interface display well but i can't get acces with admin/admin
please i need your help
Try and clean cache and cookies
I got a log file:
2017-11-12 15:45:24.151 ** ERROR ** [] ERROR **
2017-11-12 15:45:24.152 ** ERROR ** [] on file '/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/tool/projeqtor.php' at line (2797)
2017-11-12 15:45:24.153 ** ERROR ** [] cause = set_time_limit(): Cannot set max execution time limit due to system policy
2017-11-12 15:46:53.885 ** ERROR ** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'atezcorporation.parameter' doesn't exist
2017-11-12 15:46:53.886 ** ERROR ***** [] For query : select * from parameter where (idUser is null and idProject is null)
2017-11-12 15:46:53.887 ** ERROR ** [] Strack trace :
2017-11-12 15:46:53.887 ** ERROR ** [] #0 Sql->query called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/model/persistence/SqlElement.php:2255]
2017-11-12 15:46:53.889 ** ERROR ** [] #1 SqlElement->getSqlElementsFromCriteria called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/model/Parameter.php:895]
2017-11-12 15:46:53.890 ** ERROR ** [] #2 Parameter->getGlobalParameter called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/model/UserMain.php:139]
2017-11-12 15:46:53.891 ** ERROR ** [] #3 UserMain->__construct called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/model/User.php:38]
2017-11-12 15:46:53.892 ** ERROR ** [] #4 User->__construct called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/tool/projeqtor.php:2939]
2017-11-12 15:46:53.893 ** ERROR ** [] #5 getSessionUser called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/tool/projeqtor.php:155]
2017-11-12 15:46:53.894 ** ERROR ** [] #6 require_once called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/view/main.php:37]
2017-11-12 15:47:30.740 ** ERROR ** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'atezcorporation.resource' doesn't exist
2017-11-12 15:47:30.742 ** ERROR ** [] For query : desc resource
2017-11-12 15:47:30.742 ** ERROR ** [] Strack trace :
2017-11-12 15:47:30.743 ** ERROR ** [] #0 Sql->query called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/model/persistence/SqlElement.php:3255]
2017-11-12 15:47:30.744 ** ERROR ** [] #1 SqlElement->getFormatList called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/model/persistence/SqlElement.php:2836]
2017-11-12 15:47:30.744 ** ERROR ** [] #2 SqlElement->getDataType called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/model/persistence/SqlElement.php:2218]
2017-11-12 15:47:30.745 ** ERROR ** [] #3 SqlElement->getSqlElementsFromCriteria called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/model/persistence/SqlElement.php:2489]
2017-11-12 15:47:30.746 ** ERROR ** [] #4 SqlElement->getSingleSqlElementFromCriteria called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/tool/getHash.php:48]
2017-11-12 15:47:30.747 ** ERROR ** [] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'atezcorporation.resource' doesn't exist
2017-11-12 15:47:30.747 ** ERROR ** [] For query : select * from resource where resource.name='admin' and resource.isUser = '1'
2017-11-12 15:47:30.748 ** ERROR ** [] Strack trace :
2017-11-12 15:47:30.749 ** ERROR ** [] #0 Sql->query called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/model/persistence/SqlElement.php:2255]
2017-11-12 15:47:30.750 ** ERROR ** [] #1 SqlElement->getSqlElementsFromCriteria called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/model/persistence/SqlElement.php:2489]
2017-11-12 15:47:30.751 ** ERROR ** [] #2 SqlElement->getSingleSqlElementFromCriteria called at [/customers/3/1/7/atezcorporation.com/httpd.www/acelmgmt/tool/getHash.php:48]
It seems acces to database is not correct.
Check config in parameters.php file.
Here is my parameters.php
<?php
// =======================================================================================
// Automatically generated parameter file
// =======================================================================================
$paramDbType = 'mysql';
$paramDbHost = 'atezcorporation.com.mysql';
$paramDbPort = '3306';
$paramDbUser = 'atezcorporation';
$paramDbPassword = '##########';
$paramDbName = 'atezcorporation';
$paramDbDisplayName = 'projeqtor';
$paramDbPrefix = '';
$SslKey = '';
$SslCert = '';
$SslCa = '';
$paramLdap_allow_login = 'false';
$paramLdap_base_dn = 'dc=mydomain,dc=com';
$paramLdap_host = '127.0.0.1';
$paramLdap_port = '389';
$paramLdap_version = '3';
$paramLdap_search_user = 'cn=Manager,dc=mydomain,dc=com';
$paramLdap_search_pass = 'secret';
$paramLdap_user_filter = 'uid=%USERNAME%';
$paramMailSender = '';
$paramMailReplyTo = '';
$paramAdminMail = '';
$paramMailSmtpServer = '127.0.0.1';
$paramMailSmtpPort = '25';
$paramMailSendmailPath = '';
$paramDefaultPassword = 'projeqtor';
$paramPasswordMinLength = '5';
$paramDefaultLocale = 'fr';
$paramDefaultTimezone = 'Africa/Douala';
$currency = 'XAF';
$currencyPosition = 'after';
$paramFadeLoadingMode = 'true';
$paramIconSize = '22';
$defaultTheme = 'ProjeQtOrFlatBlue';
$paramAttachmentDirectory = '../files/attach/';
$paramAttachmentMaxSize = '2097152';
$paramReportTempDirectory = '../files/report/';
$paramMemoryLimitForPDF = '512';
$logFile = '../files/logs/projeqtor_${date}.log';
$logLevel = '2';
OK.
You are on first steps of installation.
Your database is empty, and possibly does not exist.
Check that database exists and is empty.
If it does not exist, you'll have to create it manually, as you use a hosted space, and your provider will rejet automatic creation.
If it exists and is not empty, possibly you use it for another application, so use dedicate paramDbPrefix to avoid conflicts