Forum

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.

Blocking PB migrati...
 
Notifications
Clear all

Blocking PB migration 6.1.0 to 6.1.2

32 Posts
2 Users
0 Reactions
21 K Views
(@pipobru)
Posts: 180
Active Member
Topic starter
 
[#4211]

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 ?


 
Posted : 16 Mar 2017 17H23
(@pipobru)
Posts: 180
Active Member
Topic starter
 

same pb with a empty database .....PLEASE HELP ME !!!


 
Posted : 16 Mar 2017 17H31
(@pipobru)
Posts: 180
Active Member
Topic starter
 

Pb with postgresql.


 
Posted : 16 Mar 2017 17H37
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

You connection fails (connection is empty)
This may be do to incorrect migration process : you may have lost connection parameters.


 
Posted : 17 Mar 2017 2H28
(@pipobru)
Posts: 180
Active Member
Topic starter
 

Thanks for for your answer, but after some research i think the problem is with the new update of php.


 
Posted : 17 Mar 2017 10H59
(@pipobru)
Posts: 180
Active Member
Topic starter
 

with roleback to 6.1.0 the site running OK


 
Posted : 17 Mar 2017 12H12
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

i think the problem is with the new update of php.

What do you mean ? You also upgraded PHP version ?


 
Posted : 17 Mar 2017 12H26
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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 ?


 
Posted : 17 Mar 2017 12H27
(@pipobru)
Posts: 180
Active Member
Topic starter
 

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


 
Posted : 17 Mar 2017 12H47
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

OK, but how did you upgrade projeqtor ?
Please explain step by step what you did ...


 
Posted : 17 Mar 2017 12H50
(@pipobru)
Posts: 180
Active Member
Topic starter
 

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


 
Posted : 17 Mar 2017 12H52
(@pipobru)
Posts: 180
Active Member
Topic starter
 

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


 
Posted : 17 Mar 2017 12H55
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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


 
Posted : 17 Mar 2017 12H58
(@pipobru)
Posts: 180
Active Member
Topic starter
 

same mode for roleback. You think the problem is when unzip files before upload ?


 
Posted : 17 Mar 2017 13H00
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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 ?


 
Posted : 17 Mar 2017 13H04
(@pipobru)
Posts: 180
Active Member
Topic starter
 

yes overwrite


 
Posted : 17 Mar 2017 13H39
(@pipobru)
Posts: 180
Active Member
Topic starter
 

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()


 
Posted : 17 Mar 2017 16H22
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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) ?


 
Posted : 17 Mar 2017 19H48
(@pipobru)
Posts: 180
Active Member
Topic starter
 

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 ?


 
Posted : 20 Mar 2017 10H29
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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'


 
Posted : 22 Mar 2017 10H46
(@pipobru)
Posts: 180
Active Member
Topic starter
 

I have check and all parameters are OK:
$paramDbType = 'pgsql';
$paramDbHost = '127.0.0.1';
$paramDbPort = '5432';
$paramDbUser = 'pgsql';


 
Posted : 24 Mar 2017 10H13
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

check if 'pgsql' is owner of your database.


 
Posted : 25 Mar 2017 18H51
(@pipobru)
Posts: 180
Active Member
Topic starter
 

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()


 
Posted : 27 Mar 2017 13H26
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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");

 
Posted : 27 Mar 2017 16H37
(@pipobru)
Posts: 180
Active Member
Topic starter
 

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()


 
Posted : 27 Mar 2017 19H06
Page 1 / 2
Share:

Scroll to Top