View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - 1364 Field 'id' doesn't have a default value_ upgrade to projeqtor 6.0.7 - ProjeQtOr
 
 

1364 Field 'id' doesn't have a default value_ upgrade to projeqtor 6.0.7

More
31 Jan 2017 16:45 #1 by Jihen17
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:\wamp64\www\projeqtor\model\persistence\SqlElement.php:840]
2017-01-31 16:10:39.701 ***** ERROR ***** #1 SqlElement->insertSqlElement called at [C:\wamp64\www\projeqtor\model\persistence\SqlElement.php:647]
2017-01-31 16:10:39.705 ***** ERROR ***** #2 SqlElement->saveSqlElement called at [C:\wamp64\www\projeqtor\model\persistence\SqlElement.php:495]
2017-01-31 16:10:39.709 ***** ERROR ***** #3 SqlElement->save called at [C:\wamp64\www\projeqtor\model\Audit.php:188]
2017-01-31 16:10:39.713 ***** ERROR ***** #4 Audit->updateAudit called at [C:\wamp64\www\projeqtor\tool\projeqtor.php:251]
2017-01-31 16:10:39.717 ***** ERROR ***** #5 require_once called at [C:\wamp64\www\projeqtor\tool\checkAlertToDisplay.php:29]


could someone help me figure out the reason of this error?

Please Log in or Create an account to join the conversation.

More
01 Feb 2017 09:50 #2 by babynus
It seems table Audit does not have correct definition.
Id should have attribute "AUTOINCREMENT".

Can you retreive migration log file and post it here ?

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
01 Feb 2017 14:02 #3 by Jihen17
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

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.029 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.