Error on login + permanent upgrade message

babynus
Offline
Administrator
Moderator

10 Mar 2017 09:14 #7 by babynus

Replied by babynus on topic Error on login + permanent upgrade message

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)

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Pruha
Topic Author
Offline
New Member

10 Mar 2017 11:46 #8 by Pruha

Replied by Pruha on topic Error on login + permanent upgrade message

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 ?

Please Connexion or Create an account to join the conversation.

babynus
Offline
Administrator
Moderator

10 Mar 2017 11:56 #9 by babynus

Replied by babynus on topic Error on login + permanent upgrade message

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
    }
  }
}

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, ...)

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Pruha
Topic Author
Offline
New Member

10 Mar 2017 12:49 - 10 Mar 2017 12:51 #10 by Pruha

Replied by Pruha on topic Error on login + permanent upgrade message

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 ^^

Last edit: 10 Mar 2017 12:51 by Pruha. Reason: word missing

Please Connexion or Create an account to join the conversation.

babynus
Offline
Administrator
Moderator

10 Mar 2017 14:08 #11 by babynus

Replied by babynus on topic Error on login + permanent upgrade message

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.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynus, protion

Time to create page: 0.057 seconds

Prochaines sessions de formation

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Planifiez avec ProjeQtOr

Administrez avec ProjeQtOr

Error on login + permanent upgrade message

Attachments:

Paramétrages de cookies

Cookies fonctionnels

Session

Autres cookies

Prochaines sessions de formation

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Planifiez avec ProjeQtOr

Administrez avec ProjeQtOr

Error on login + permanent upgrade message

Attachments:

Paramétrages de cookies

Cookies fonctionnels

Session

Autres cookies

Login Form