Forum

Forums
Requests
Ask questions
Blocking PB migrati...
 
Notifications
Retirer tout

Blocking PB migration 6.1.0 to 6.1.2

 
Page 2 / 3
Ask questions
Dernier post par babynus Il y a 9 ans
32 Posts
2 Utilisateurs
0 Reactions
21 {numéro}K Vu
RSS
 Villedieu
(@pipobru)
Posts: 180
Active Member
Début du sujet
 

yes overwrite


 
Posté : 17 Mar PM 13:033
 Villedieu
(@pipobru)
Posts: 180
Active Member
Début du sujet
 

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


 
Posté : 17 Mar PM 16:033
 babynus
(@babynus)
Posts: 14952
Membre 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) ?


 
Posté : 17 Mar PM 19:033
 Villedieu
(@pipobru)
Posts: 180
Active Member
Début du sujet
 

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 ?


 
Posté : 20 Mar AM 10:033
 babynus
(@babynus)
Posts: 14952
Membre 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'


 
Posté : 22 Mar AM 10:033
 Villedieu
(@pipobru)
Posts: 180
Active Member
Début du sujet
 

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


 
Posté : 24 Mar AM 10:033
 babynus
(@babynus)
Posts: 14952
Membre Admin
 

check if 'pgsql' is owner of your database.


 
Posté : 25 Mar PM 18:033
 Villedieu
(@pipobru)
Posts: 180
Active Member
Début du sujet
 

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


 
Posté : 27 Mar PM 13:033
 babynus
(@babynus)
Posts: 14952
Membre 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");

 
Posté : 27 Mar PM 16:033
 Villedieu
(@pipobru)
Posts: 180
Active Member
Début du sujet
 

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


 
Posté : 27 Mar PM 19:033
 babynus
(@babynus)
Posts: 14952
Membre Admin
 

I cannot understand.
I tested again migration from V6.1.0 to V6.1.2, with postgresql database, and all worked like a charm

2017-03-27 20:43:38.387 ===== TRACE ===== =====================================
2017-03-27 20:43:38.388 ===== TRACE ===== 
2017-03-27 20:43:38.389 ===== TRACE ===== DataBase actual Version = V6.1.0
2017-03-27 20:43:38.389 ===== TRACE ===== ProjeQtOr actual Version = V6.1.2
2017-03-27 20:43:38.390 ===== TRACE ===== 
2017-03-27 20:43:38.391 ===== TRACE ===== =====================================
2017-03-27 20:43:38.392 ===== TRACE ===== 
2017-03-27 20:43:38.392 ===== TRACE ===== VERSION V6.1.1
2017-03-27 20:43:38.393 ===== TRACE ===== 
2017-03-27 20:43:38.403 ===== TRACE =====  1 lines updated into table "menu".
2017-03-27 20:43:38.405 ===== TRACE =====  2 lines updated into table "menu".
2017-03-27 20:43:38.406 ===== TRACE ===== 
2017-03-27 20:43:38.406 ===== TRACE ===== DATABASE UPDATED
2017-03-27 20:43:38.407 ===== TRACE =====  WITH NO ERROR
2017-03-27 20:43:38.407 ===== TRACE ===== 
2017-03-27 20:43:38.533 ===== TRACE ===== =====================================
2017-03-27 20:43:38.533 ===== TRACE ===== 
2017-03-27 20:43:38.534 ===== TRACE ===== DATABASE UPDATE COMPLETED TO VERSION V6.1.2
2017-03-27 20:43:38.534 ===== TRACE ===== 
2017-03-27 20:43:38.535 ===== TRACE ===== =====================================
2017-03-27 20:43:38.535 ===== TRACE =====

 
Posté : 27 Mar PM 22:033
 Villedieu
(@pipobru)
Posts: 180
Active Member
Début du sujet
 

Hello,
I check with a new server empty install (from scrach). With php 7.1.
On the first connexion with admin user for create new database i have same error.
After investigation the problem seems becom from PDO module.
In ../model/persistence/Sql.php at line 144 with error " cause = SQLSTATE[55000]: Object not in prerequisite state: 7 ERROR: lastval is not yet defined in this session"


 
Posté : 26 Avr PM 17:044
 Villedieu
(@pipobru)
Posts: 180
Active Member
Début du sujet
 

Do you think this page: https://fuelphp.com/forums/discussion/14057/uncaught-exception-pdoexception-sqlstate55000 is applicable ?


 
Posté : 26 Avr PM 17:044
 Villedieu
(@pipobru)
Posts: 180
Active Member
Début du sujet
 

I have solve the problem with a upddate of PDO module find here: https://github.com/kipkaev55/fuel-pqlib
The problem are present for php 7.1 (last version)


 
Posté : 26 Avr PM 18:044
 babynus
(@babynus)
Posts: 14952
Membre Admin
 

Hi,

We already pointed out that ProjeQtOr is not compatible with PHP 7.1
This version of PHP includes serious regressions in management of numeric values that leads to incompatiblity with many applications (including symfony framework)


 
Posté : 27 Avr PM 22:044
Page 2 / 3
Forum Jump:
  Sujet précédent
Sujet suivant  
Share:
Retour en haut