| Title | MySQL 5.0 doesn't like 0 in datetime fields |
| Status | closed |
| Priority | essential |
| Assigned user | Nick Barnes |
| Organization | Ravenbrook |
| Description | The 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. |
| Analysis | Change 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 found | manual_test |
| Evidence | I just know |
| Observed in | 2.3.5 |
| Created by | Nick Barnes |
| Created on | 2007-07-30 09:40:05 |
| Last modified by | Nick Barnes |
| Last modified on | 2007-07-30 09:43:37 |
| History | 2007-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. |