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()
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 =====
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"
Do you think this page: https://fuelphp.com/forums/discussion/14057/uncaught-exception-pdoexception-sqlstate55000 is applicable ?
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)
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)