P4DTI issue job001699

TitleMySQL 5.0 doesn't like 0 in datetime fields
Assigned userNick Barnes
DescriptionThe P4DTI replicator keeps a table of past replication polls in the Bugzilla database. The columns in this table include an 'end time'. When a replication poll is started, this column is set to zero, which can then distinguish replications which fail to complete. MySQL 5.0 generates a warning message on setting a datetime field to zero.
AnalysisChange the Bugzilla/P4DTI schema to add a 'completed' field to this table, and use that instead. Set the end time to now() when starting a replication.
How foundmanual_test
EvidenceI just know
Observed in2.3.5
Created byNick Barnes
Created on2007-07-30 09:40:05
Last modified byNick Barnes
Last modified on2007-07-30 09:43:37
History2007-07-29 NB Created.


Change Effect Date User Description
163003 closed 2007-07-30 09:43:16 Nick Barnes P4DTI replicator low-level Bugzilla interface: schema changes.