Bug #4118

Error during task migration

Added by walid about 7 years ago. Updated about 7 years ago.

Status:ClosedStart date:12/18/2012
Priority:NormalDue date:
Assignee:moyo% Done:

0%

Category:Install / Update
Target version:0.83.8

Description

During migration, when MySQL in strict mode this error occurs :
in graphic mode :

Incorrect datetime value: '' for column 'begin' at row 1

In sql-error.log :

==> sql-errors.log <==
2012-12-18 10:25
*** MySQL query error : 
***
SQL: UPDATE `glpi_tickettasks`
                      SET `begin` = \'\',
                          `end` = \'1970-01-01 02:00:00\',
                          `users_id_tech` = \'292\',
                          `state` = \'2\'
                      WHERE `id` = \'951\'
Error: Incorrect datetime value: '' for column 'begin' at row 1
Backtrace :
/home/walid/sources/svn-glpi/0.83/install/update_0803_083.php&nbsp;:451         DBmysql->query()
/home/walid/sources/svn-glpi/0.83/install/update.php&nbsp;:730          update0803to083()
/home/walid/sources/svn-glpi/0.83/install/update.php&nbsp;:912          updateDbUpTo031()
/home/walid/sources/svn-glpi/0.83/install/update.php

Associated revisions

Revision 19856
Added by moyo about 7 years ago

try to fix Error during task migration see #4118

Revision 19857
Added by moyo about 7 years ago

[0.83] try to fix Error during task migration see #4118

History

#1 Updated by walid about 7 years ago

  • Status changed from New to Resolved

#2 Updated by moyo about 7 years ago

  • Assignee set to moyo

#3 Updated by moyo about 7 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF