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.
hello,
after dowload files for migration i have this trace:
2017-03-16 15:06:30.538 ** ERROR ** EXCEPTION **
2017-03-16 15:06:30.538 ** ERROR ** on file '/var/www/html/model/persistence/Sql.php' at line (238)
2017-03-16 15:06:30.538 ** ERROR ** cause = Call to a member function quote() on null
2017-03-16 15:06:30.538 ** ERROR ** => #0 /var/www/html/model/persistence/SqlElement.php (1806) -> str()
2017-03-16 15:06:30.538 ** ERROR ** => #1 /var/www/html/model/persistence/SqlElement.php (2022) -> getSqlElementsFromCriteria()
2017-03-16 15:06:30.538 ** ERROR ** => #2 /var/www/html/model/Audit.php (139) -> getSingleSqlElementFromCriteria()
2017-03-16 15:06:30.538 ** ERROR ** => #3 /var/www/html/tool/projeqtor.php (249) -> updateAudit()
2017-03-16 15:06:30.538 ** ERROR ** => #4 /var/www/html/tool/checkAlertToDisplay.php (29) -> require_once()
2017-03-16 15:06:34.641 ** ERROR ***** Exception-[57P01] SQLSTATE[57P01]: Admin shutdown: 7 FATAL: terminating connection due to administrator command
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
It is a Blocking pb please can you help me ?
same pb with a empty database .....PLEASE HELP ME !!!
Pb with postgresql.
You connection fails (connection is empty)
This may be do to incorrect migration process : you may have lost connection parameters.
Thanks for for your answer, but after some research i think the problem is with the new update of php.
with roleback to 6.1.0 the site running OK
i think the problem is with the new update of php.
What do you mean ? You also upgraded PHP version ?
with roleback to 6.1.0 the site running OK
There is no reason V6.1.0 runs correct and not V6.1.2 (changes are very minor).
I'm almost sure it is due to migration process.
How did you run migration ?
Very thanks for your answer.
I have upgreted my OS and after upgrted projeqtor.
my version is PHP Version 7.0.15-0ubuntu0.16.04.4
OK, but how did you upgrade projeqtor ?
Please explain step by step what you did ...
1) stop apache
2) upload files (all) for the new version
3) re-start apache
4) connect with admin user for apply database migration => error just after login
and before upgrade projeqtor:
1) sudo apt-get update
2) sudo apt-get upgrade
3) sudo apt-get dist-upgrade
4) reboot
5) check if os running normaly
1) stop apache
2) upload files (all) for the new version
3) re-start apache
4) connect with admin user for apply database migration => error just after login
some issue may be there : you'd better upload zip file and extract it on server
same mode for roleback. You think the problem is when unzip files before upload ?
You think the problem is when unzip files before upload ?
It's possible.
Also issue during transfer is possible.
When you migrate, do you overwrite existing code with new one ?
yes overwrite
same problem with direct unzip on server
2017-03-17 14:21:42.812 ===== TRACE =====
2017-03-17 14:21:42.812 ===== TRACE ===== =====================================
2017-03-17 14:21:42.812 ===== TRACE =====
2017-03-17 14:21:42.812 ===== TRACE ===== DataBase actual Version = V6.1.0
2017-03-17 14:21:42.812 ===== TRACE ===== ProjeQtOr actual Version = V6.1.2
2017-03-17 14:21:42.812 ===== TRACE =====
2017-03-17 14:21:42.812 ===== TRACE ===== =====================================
2017-03-17 14:21:42.812 ===== TRACE =====
2017-03-17 14:21:42.812 ===== TRACE ===== VERSION V6.1.1
2017-03-17 14:21:42.812 ===== TRACE =====
2017-03-17 14:21:42.813 ** ERROR ** EXCEPTION **
2017-03-17 14:21:42.813 ** ERROR ** on file '/var/www/html/testvide/model/persistence/Sql.php' at line (144)
2017-03-17 14:21:42.813 ** ERROR ** cause = SQLSTATE[55000]: Object not in prerequisite state: 7
2017-03-17 14:21:42.813 ** ERROR ** => #0 /var/www/html/testvide/model/persistence/Sql.php (144) -> lastInsertId()
2017-03-17 14:21:42.813 ** ERROR ** => #1 /var/www/html/testvide/db/maintenanceFunctions.php (71) -> query()
2017-03-17 14:21:42.813 ** ERROR ** => #2 /var/www/html/testvide/db/maintenance.php (101) -> runScript()
2017-03-17 14:21:42.813 ** ERROR ***** => #3 /var/www/html/testvide/tool/loginCheck.php (135) -> include()
It seems to be an issue with connection to database.
Do you use same database, with same parameters on both cases (V6.1.0 and V6.1.2) ?
Same database, without change.
after pb just for test i have tested with postgesql 9.5 and a empty database with this protocol:
Create new databe in 6.1.0 (without data)
Test migration to 6.1.2
=> same result (and same error)
The question is why migration crash but all other records running normally ?
I hs a look again at error, and it seems Database is not identified as Postgres.
Error on line 144 in Sql.php : this line should be reached only for MySql database.
Check in /tool/parametersLocation.php where you stores parameters.php file
Check your parameters.php file, it should contain $paramDbType='pgsql'
I have check and all parameters are OK:
$paramDbType = 'pgsql';
$paramDbHost = '127.0.0.1';
$paramDbPort = '5432';
$paramDbUser = 'pgsql';
check if 'pgsql' is owner of your database.
I have check and same error ....
2017-03-27 11:22:37.847 ===== TRACE =====
2017-03-27 11:22:37.847 ===== TRACE ===== =====================================
2017-03-27 11:22:37.847 ===== TRACE =====
2017-03-27 11:22:37.847 ===== TRACE ===== DataBase actual Version = V6.1.0
2017-03-27 11:22:37.847 ===== TRACE ===== ProjeQtOr actual Version = V6.1.2
2017-03-27 11:22:37.847 ===== TRACE =====
2017-03-27 11:22:37.847 ===== TRACE ===== =====================================
2017-03-27 11:22:37.847 ===== TRACE =====
2017-03-27 11:22:37.847 ===== TRACE ===== VERSION V6.1.1
2017-03-27 11:22:37.847 ===== TRACE =====
2017-03-27 11:22:37.908 ** ERROR ** EXCEPTION **
2017-03-27 11:22:37.908 ** ERROR ** on file '/var/www/html/testvide/model/persistence/Sql.php' at line (144)
2017-03-27 11:22:37.908 ** ERROR ** cause = SQLSTATE[55000]: Object not in prerequisite state: 7
2017-03-27 11:22:37.908 ** ERROR ** => #0 /var/www/html/testvide/model/persistence/Sql.php (144) -> lastInsertId()
2017-03-27 11:22:37.908 ** ERROR ** => #1 /var/www/html/testvide/db/maintenanceFunctions.php (71) -> query()
2017-03-27 11:22:37.908 ** ERROR ** => #2 /var/www/html/testvide/db/maintenance.php (101) -> runScript()
2017-03-27 11:22:37.908 ** ERROR ***** => #3 /var/www/html/testvide/tool/loginCheck.php (135) -> include()
It seems you are running migration from V6.1.0 to V6.1.2 for database that already received upgrade to V6.1.1...
This is not blocking with MySql but seems more serious with pgSql.
Try and remove reference to this script on line 42 of db/maintenance.php.
from
"V6.0.0", "V6.0.2", "V6.0.3", "V6.0.6", "V6.1.0", "V6.1.1");
to
"V6.0.0", "V6.0.2", "V6.0.3", "V6.0.6", "V6.1.0");
same .....
2017-03-27 17:05:05.234 ===== TRACE =====
2017-03-27 17:05:05.267 ===== TRACE ===== =====================================
2017-03-27 17:05:05.267 ===== TRACE =====
2017-03-27 17:05:05.267 ===== TRACE ===== DataBase actual Version = V6.1.0
2017-03-27 17:05:05.267 ===== TRACE ===== ProjeQtOr actual Version = V6.1.2
2017-03-27 17:05:05.267 ===== TRACE =====
2017-03-27 17:05:05.353 ** ERROR ** EXCEPTION **
2017-03-27 17:05:05.353 ** ERROR ** on file '/var/www/html/testvide/model/persistence/Sql.php' at line (144)
2017-03-27 17:05:05.353 ** ERROR ** cause = SQLSTATE[55000]: Object not in prerequisite state: 7 ERROR: lastval is not yet defined in this session
2017-03-27 17:05:05.353 ** ERROR ** => #0 /var/www/html/testvide/model/persistence/Sql.php (144) -> lastInsertId()
2017-03-27 17:05:05.353 ** ERROR ** => #1 /var/www/html/testvide/model/persistence/SqlElement.php (2157) -> query()
2017-03-27 17:05:05.353 ** ERROR ** => #2 /var/www/html/testvide/model/persistence/SqlElement.php (467) -> getSqlElement()
2017-03-27 17:05:05.353 ** ERROR ** => #3 /var/www/html/testvide/model/ExpenseDetailType.php (85) -> __construct()
2017-03-27 17:05:05.353 ** ERROR ** => #4 /var/www/html/testvide/db/maintenance.php (133) -> __construct()
2017-03-27 17:05:05.353 ** ERROR ***** => #5 /var/www/html/testvide/tool/loginCheck.php (135) -> include()