Forum

Error on login + pe...
 
Notifications
Clear all

Error on login + permanent upgrade message

11 Posts
3 Users
0 Reactions
11.8 K Views
(@pruha)
Posts: 7
Active Member
Topic starter
 
[#4176]

Hi everyone !

I've installed ProjeQtor on an Hostinger account and set it up but I can't log in (the only account existing in my projeqtor instance is admin admin).

The following error message appears : ERROR : An error occured on 2017-03-06 at 13:01:22

without any other explanation.

Plus, before any log in attempt, the login screen always displays this message : upgrade in progress only admin can connect

Any ideas, suggestions ?


 
Posted : 06 Mar 2017 15H08
(@babynus)
Posts: 14952
Member Admin
 

Check log file and report any error.


 
Posted : 06 Mar 2017 15H42
(@pruha)
Posts: 7
Active Member
Topic starter
 

There it is.

It seems that the parameter table can't be found ...

2017-03-06 21:27:38.351 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'my_db_name.parameter' doesn't exist
2017-03-06 21:27:38.351 ** ERROR ** For query : select * from parameter where (idUser is null and idProject is null)
2017-03-06 21:27:38.352 ** ERROR ** Strack trace :
2017-03-06 21:27:38.352 ** ERROR ** #0 Sql->query called at [/home/db_user_name/public_html/projeqtor/model/persistence/SqlElement.php:1740]
2017-03-06 21:27:38.352 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [/home/db_user_name/public_html/projeqtor/model/Parameter.php:665]
2017-03-06 21:27:38.352 ** ERROR ** #2 Parameter->getGlobalParameter called at [/home/db_user_name/public_html/projeqtor/view/login.php:274]
2017-03-06 21:27:38.352 ** ERROR ** #3 include called at [/home/db_user_name/public_html/projeqtor/tool/projeqtor.php:190]
2017-03-06 21:27:38.352 ** ERROR ** #4 require_once called at [/home/db_user_name/public_html/projeqtor/view/main.php:37]


 
Posted : 09 Mar 2017 10H21
(@babynus)
Posts: 14952
Member Admin
 

What is content of your database ?
Do you have any table existing in this table ?


 
Posted : 09 Mar 2017 19H40
(@pruha)
Posts: 7
Active Member
Topic starter
 

Sorry, I should have been more precise : this error log is coherent with what I have in my db.

The db name and the user name used by ProjeQtor are correct.
This user has all the available rights but the db is empty.

When I installed ProjeQtor I copied its folder to my server and filled the configuration form available on the default page.

I thought ProjeQtor would have created all the tables needed but obviously it didn't.

Did I miss something ?


 
Posted : 10 Mar 2017 10H22
henning telemann
(@4ce)
Posts: 56
Active Member
 

which Server operating System is in use?

the Apache webservice Needs full Access rights to projeqtor and the subfolders.


 
Posted : 10 Mar 2017 11H09
(@babynus)
Posts: 14952
Member Admin
 

All tables should be created at first connection of admin...

Please try again and post error logged in log file.
(from your previous example, error was logged at 13:01:22 and you show part of log at 21:27:38)


 
Posted : 10 Mar 2017 11H14
(@pruha)
Posts: 7
Active Member
Topic starter
 

I obtain this error (it is repeated again and again in the log file) :

2017-03-10 11:25:11.188 ** ERROR ** Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'u935180926_pjtr.parameter' doesn't exist
2017-03-10 11:25:11.237 ** ERROR ** For query : select * from parameter where (idUser is null and idProject is null)
2017-03-10 11:25:11.237 ** ERROR ** Strack trace :
2017-03-10 11:25:11.238 ** ERROR ** #0 Sql->query called at [/home/u935180926/public_html/projeqtor/model/persistence/SqlElement.php:1740]
2017-03-10 11:25:11.238 ** ERROR ** #1 SqlElement->getSqlElementsFromCriteria called at [/home/u935180926/public_html/projeqtor/model/Parameter.php:665]
2017-03-10 11:25:11.238 ** ERROR ** #2 Parameter->getGlobalParameter called at [/home/u935180926/public_html/projeqtor/model/UserMain.php:132]
2017-03-10 11:25:11.238 ** ERROR ** #3 UserMain->__construct called at [/home/u935180926/public_html/projeqtor/model/User.php:38]
2017-03-10 11:25:11.238 ** ERROR ** #4 User->__construct called at [/home/u935180926/public_html/projeqtor/tool/projeqtor.php:2611]
2017-03-10 11:25:11.238 ** ERROR ** #5 getSessionUser called at [/home/u935180926/public_html/projeqtor/tool/projeqtor.php:144]
2017-03-10 11:25:11.238 ** ERROR ** #6 require_once called at [/home/u935180926/public_html/projeqtor/view/main.php:37]

and the log file ends like so :

2017-03-10 11:25:32.767 ===== TRACE =====
2017-03-10 11:25:32.767 ===== TRACE ===== =====================================
2017-03-10 11:25:32.767 ===== TRACE =====
2017-03-10 11:25:32.767 ===== TRACE ===== DataBase actual Version =
2017-03-10 11:25:32.767 ===== TRACE ===== ProjeQtOr actual Version = V5.3.3
2017-03-10 11:25:32.767 ===== TRACE =====
2017-03-10 11:25:32.767 ** ERROR ** ERROR **
2017-03-10 11:25:32.767
** ERROR ** on file '/home/u935180926/public_html/projeqtor/tool/projeqtor.php' at line (2555)
2017-03-10 11:25:32.768
** ERROR ***** cause = set_time_limit() has been disabled for security reasons

This server runs on Linux (I don't know which build/version) : it's a free hosting service and pretty much everything is interfaced

I haven't found yet any means to configure Apache, (still searching) does it considers by default that it can't access a folder until I say so ?


 
Posted : 10 Mar 2017 13H46
(@babynus)
Posts: 14952
Member Admin
 

Your provided disabled the command set_time_limit()

To try and have something working, try and disable this feature.
in /tool/projeqtor.php, replace function

function projeqtor_set_time_limit($timeout) {
  if (ini_get ( 'safe_mode' )) {
    traceLog ( "WARNING : try to extend time limit to $timeout seconds forbidden by safe_mode. This may lead to unsuccessfull operation." );
  } else if (! function_exists('set_time_limit')) {
  	traceLog ( "WARNING : try to extend time limit to $timeout seconds but set_time_limit has been disabled. This may lead to unsuccessfull operation." );
  } else {
    $max = ini_get ( 'max_execution_time' );
    if ($max != 0 && ($timeout > $max or $timeout == 0)) { // Don't bother if unlimited or request max
      @set_time_limit ( $timeout );
    } else {
      @set_time_limit ( $max ); // Set time limit to max to reset current execution time to zero
    }
  }
}

to

function projeqtor_set_time_limit($timeout) {
  return; // Disable this feature
  if (ini_get ( 'safe_mode' )) {
    traceLog ( "WARNING : try to extend time limit to $timeout seconds forbidden by safe_mode. This may lead to unsuccessfull operation." );
  } else if (! function_exists('set_time_limit')) {
  	traceLog ( "WARNING : try to extend time limit to $timeout seconds but set_time_limit has been disabled. This may lead to unsuccessfull operation." );
  } else {
    $max = ini_get ( 'max_execution_time' );
    if ($max != 0 && ($timeout > $max or $timeout == 0)) { // Don't bother if unlimited or request max
      @set_time_limit ( $timeout );
    } else {
      @set_time_limit ( $max ); // Set time limit to max to reset current execution time to zero
    }
  }
}

Maybe you'll be able to install PrijeQtOr.
But this may lead to non working features (export to PDF for big plannings, copy of big projects, ...)


 
Posted : 10 Mar 2017 13H56
(@pruha)
Posts: 7
Active Member
Topic starter
 

Now I obtain a series of "table not found" exceptions but they are thrown for several tables (not only parameters) : is there any hope or should I change of provider ?

Thank you for your time and your patience ^^


 
Posted : 10 Mar 2017 14H49
(@babynus)
Posts: 14952
Member Admin
 

Post your complete log file (attch it)

Also what you can try is to install step by steps.
First install V1.0.0
Then V2.0.0
and so on up to lastest.


 
Posted : 10 Mar 2017 16H08
Share:

Scroll to Top