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,
i upgraded projeQtor from version 4 to vesion 6.0.7
everything works right but when i try to add or to modify something i got this error
Exception-[HY000] SQLSTATE[HY000]: General error: 1364 Field 'id' doesn't have a default value
i looked in the log file and i found
2017-01-31 16:10:39.683 ** ERROR ** Exception-[HY000] SQLSTATE[HY000]: General error: 1364 Field 'id' doesn't have a default value
2017-01-31 16:10:39.687 ** ERROR ** For query : insert into audit ( sessionId , auditDay , idUser , userName , platform , browser ,
browserVersion , userAgent , connectionDateTime , lastAccessDateTime , duration , idle , requestRefreshParam , requestRefreshProject ,
requestDisconnection ) values ('pnq36q5gsv5cba7fu5jebrk313', '20170131', '10', 'admin10', 'Windows',
'Google Chrome', '55.0.2883.87', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36
(KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36', '2017-01-31 16:10:39', '2017-01-31 16:10:39', '00:00:00', '0', '0', '0', '0')
2017-01-31 16:10:39.691 ** ERROR ** Strack trace :
2017-01-31 16:10:39.696 ** ERROR ** #0 Sql->query called at [C:wamp64wwwprojeqtormodelpersistenceSqlElement.php:840]
2017-01-31 16:10:39.701 ** ERROR ** #1 SqlElement->insertSqlElement called at [C:wamp64wwwprojeqtormodelpersistenceSqlElement.php:647]
2017-01-31 16:10:39.705 ** ERROR ** #2 SqlElement->saveSqlElement called at [C:wamp64wwwprojeqtormodelpersistenceSqlElement.php:495]
2017-01-31 16:10:39.709 ** ERROR ** #3 SqlElement->save called at [C:wamp64wwwprojeqtormodelAudit.php:188]
2017-01-31 16:10:39.713 ** ERROR ** #4 Audit->updateAudit called at [C:wamp64wwwprojeqtortoolprojeqtor.php:251]
2017-01-31 16:10:39.717 ** ERROR ** #5 require_once called at [C:wamp64wwwprojeqtortoolcheckAlertToDisplay.php:29]
could someone help me figure out the reason of this error?
It seems table Audit does not have correct definition.
Id should have attribute "AUTOINCREMENT".
Can you retreive migration log file and post it here ?
yes, i looked in the database and i found that many table has the field id not as primary key and not auto increment, i think it's a problem related to the database when i imported it, it's not related to the upgrade