View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur 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

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

 
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

 
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

 

 

 
 

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 Connexion or Create an account to join the conversation.

More
01 Fév 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 Connexion or Create an account to join the conversation.

More
01 Fév 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 Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.034 seconds

Paramétrages de cookies

×

Cookies fonctionnels

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

Veuillez vous connecter pour voir vos activités!

Autres cookies

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