2018-12-03 17:56:45.056 ===== TRACE ===== NEW CONNECTED USER 'Naceur'
2018-12-03 17:56:53.397 ** ERROR ** [V7.2.5] Exception-[HY000] SQLSTATE[HY000]: General error: 1364 Field 'id' doesn't have a default value
2018-12-03 17:56:53.398 ** ERROR ** [V7.2.5] For query : insert into ticket ( reference , name , idTicketType , idProject , creationDateTime , lastUpdateDateTime , idUser , idContact , idStatus , isRegression , idAccountable , idResource , handled , done , solved , idle , cancelled , delayReadOnly ) values ('506--1026', 'Réunion avec Nabil + Test de la nouvelle version + Mise en place du nouveau plan marketing.', '135', '218', '2018-12-03 17:54:01', '2018-12-03 17:56:53', '1', '80', '1', '0', '1', '1', '0', '0', '0', '0', '0', '0')
2018-12-03 17:56:53.399 ** ERROR ** [V7.2.5] Strack trace :
2018-12-03 17:56:53.399 ** ERROR ** [V7.2.5] #0 Sql->query called at [C:wamp64wwwprojeqtormodelpersistenceSqlElement.php:1193]
2018-12-03 17:56:53.400 ** ERROR ** [V7.2.5] #1 SqlElement->insertSqlElement called at [C:wamp64wwwprojeqtormodelpersistenceSqlElement.php:992]
2018-12-03 17:56:53.401 ** ERROR ** [V7.2.5] #2 SqlElement->saveSqlElement called at [C:wamp64wwwprojeqtormodelpersistenceSqlElement.php:655]
2018-12-03 17:56:53.401 ** ERROR ** [V7.2.5] #3 SqlElement->save called at [C:wamp64wwwprojeqtormodelTicketMain.php:437]
2018-12-03 17:56:53.402 ** ERROR ** [V7.2.5] #4 TicketMain->save called at [C:wamp64wwwprojeqtortoolsaveObject.php:78]
2018-12-03 17:57:08.573 ** ERROR ** [V7.2.5] Exception-[HY000] SQLSTATE[HY000]: General error: 1364 Field 'id' doesn't have a default value
2018-12-03 17:57:08.573 ** ERROR ** [V7.2.5] For query : insert into ticket ( reference , name , idTicketType , idProject , creationDateTime , lastUpdateDateTime , idUser , idContact , idStatus , isRegression , idAccountable , idResource , handled , done , solved , idle , cancelled , delayReadOnly ) values ('506--1026', 'Réunion avec Nabil + Test de la nouvelle version + Mise en place du nouveau plan marketing.', '135', '218', '2018-12-03 17:54:01', '2018-12-03 17:57:08', '1', '80', '1', '0', '1', '1', '0', '0', '0', '0', '0', '0')
2018-12-03 17:57:08.574 ** ERROR ** [V7.2.5] Strack trace :
2018-12-03 17:57:08.575 ** ERROR ** [V7.2.5] #0 Sql->query called at [C:wamp64wwwprojeqtormodelpersistenceSqlElement.php:1193]
2018-12-03 17:57:08.575 ** ERROR ** [V7.2.5] #1 SqlElement->insertSqlElement called at [C:wamp64wwwprojeqtormodelpersistenceSqlElement.php:992]
2018-12-03 17:57:08.576 ** ERROR ** [V7.2.5] #2 SqlElement->saveSqlElement called at [C:wamp64wwwprojeqtormodelpersistenceSqlElement.php:655]
2018-12-03 17:57:08.577 ** ERROR ** [V7.2.5] #3 SqlElement->save called at [C:wamp64wwwprojeqtormodelTicketMain.php:437]
2018-12-03 17:57:08.577 ** ERROR ** [V7.2.5] #4 TicketMain->save called at [C:wamp64wwwprojeqtortoolsaveObject.php:78]
2018-12-03 17:57:22.669 ** ERROR ** [V7.2.5] Exception-[HY000] SQLSTATE[HY000]: General error: 1364 Field 'id' doesn't have a default value
2018-12-03 17:57:22.670 ** ERROR ** [V7.2.5] For query : insert into ticket ( reference , name , idTicketType , idProject , creationDateTime , lastUpdateDateTime , idUser , idStatus , isRegression , handled , done , solved , idle , cancelled , delayReadOnly ) values ('400--35', 'asupp', '135', '5', '2018-12-03 17:57:12', '2018-12-03 17:57:22', '9', '1', '0', '0', '0', '0', '0', '0', '0')
2018-12-03 17:57:22.670 ** ERROR ** [V7.2.5] Strack trace :
2018-12-03 17:57:22.671 ** ERROR ** [V7.2.5] #0 Sql->query called at [C:wamp64wwwprojeqtormodelpersistenceSqlElement.php:1193]
2018-12-03 17:57:22.672 ** ERROR ** [V7.2.5] #1 SqlElement->insertSqlElement called at [C:wamp64wwwprojeqtormodelpersistenceSqlElement.php:992]
2018-12-03 17:57:22.672 ** ERROR ** [V7.2.5] #2 SqlElement->saveSqlElement called at [C:wamp64wwwprojeqtormodelpersistenceSqlElement.php:655]
2018-12-03 17:57:22.673 ** ERROR ** [V7.2.5] #3 SqlElement->save called at [C:wamp64wwwprojeqtormodelTicketMain.php:437]
2018-12-03 17:57:22.674 ** ERROR ** [V7.2.5] #4 TicketMain->save called at [C:wamp64wwwprojeqtortoolsaveObject.php:78]
2018-12-03 17:57:50.106 ** ERROR ** [V7.2.5] Exception-[HY000] SQLSTATE[HY000]: General error: 1364 Field 'id' doesn't have a default value
2018-12-03 17:57:50.107 ** ERROR ** [V7.2.5] For query : insert into work ( idWorkElement , idResource , idProject , refType , refId , work , workDate , day , week , month , year ) values ('3295', '105', '218', 'Ticket', '3227', '0.0625', '2018-12-03', '20181203', '201849', '201812', '2018')
2018-12-03 17:57:50.107 ** ERROR ** [V7.2.5] Strack trace :
2018-12-03 17:57:50.108 ** ERROR ** [V7.2.5] #0 Sql->query called at [C:wamp64wwwprojeqtormodelpersistenceSqlElement.php:1193]
2018-12-03 17:57:50.109 ** ERROR ** [V7.2.5] #1 SqlElement->insertSqlElement called at [C:wamp64wwwprojeqtormodelpersistenceSqlElement.php:992]
2018-12-03 17:57:50.109 ** ERROR ** [V7.2.5] #2 SqlElement->saveSqlElement called at [C:wamp64wwwprojeqtormodelpersistenceSqlElement.php:655]
2018-12-03 17:57:50.110 ** ERROR ** [V7.2.5] #3 SqlElement->save called at [C:wamp64wwwprojeqtormodelGeneralWork.php:173]
2018-12-03 17:57:50.111 ** ERROR ** [V7.2.5] #4 GeneralWork->save called at [C:wamp64wwwprojeqtormodelWork.php:159]
2018-12-03 17:57:50.111 ** ERROR ** [V7.2.5] #5 Work->save called at [C:wamp64wwwprojeqtortoolsaveDispatchWork.php:118]
2018-12-03 17:57:50.119 ** ERROR ** [V7.2.5] Exception-[HY000] SQLSTATE[HY000]: General error: 1364 Field 'id' doesn't have a default value
2018-12-03 17:57:50.120 ** ERROR ** [V7.2.5] For query : insert into work ( idWorkElement , idResource , idProject , refType , refId , work , workDate , day , week , month , year ) values ('3295', '105', '218', 'Ticket', '3227', '0.0625', '2018-12-03', '20181203', '201849', '201812', '2018')
2018-12-03 17:57:50.120 ** ERROR ** [V7.2.5] Strack trace :
2018-12-03 17:57:50.121 ** ERROR ** [V7.2.5] #0 Sql->query called at [C:wamp64wwwprojeqtormodelpersistenceSqlElement.php:1193]
2018-12-03 17:57:50.122 ** ERROR ** [V7.2.5] #1 SqlElement->insertSqlElement called at [C:wamp64wwwprojeqtormodelpersistenceSqlElement.php:992]
2018-12-03 17:57:50.122 ** ERROR ** [V7.2.5] #2 SqlElement->saveSqlElement called at [C:wamp64wwwprojeqtormodelpersistenceSqlElement.php:655]
2018-12-03 17:57:50.123 ** ERROR ** [V7.2.5] #3 SqlElement->save called at [C:wamp64wwwprojeqtormodelGeneralWork.php:173]
2018-12-03 17:57:50.124 ** ERROR ** [V7.2.5] #4 GeneralWork->save called at [C:wamp64wwwprojeqtormodelWork.php:159]
2018-12-03 17:57:50.124 ** ERROR ** [V7.2.5] #5 Work->save called at [C:wamp64wwwprojeqtortoolsaveDispatchWork.php:131]
Your DB has issue.
All id of tables should be AUTOINCREMENT.
You have another issue : V7.2.5 is not latest stable release...
Ticket, Work, Workelement, Workperiod have lost their autoincrement on id
1-I make it autoincrement and now it's ok. Thank you.
2 - Why this happened?
3 - Is it safer to return to yesterday's backup before incident?
1-I make it autoincrement and now it's ok. Thank you.
Great.
2 - Why this happened?
A DB issue ?
A restore ?
NB : nothing on projeqtor scripts removed this
3 - Is it safer to return to yesterday's backup before incident?
Possibly if dump is correct (some other "hidden" issues may exist.)