Andreas Flack writes: >>> The oldest article I have in the database is from 2004-03-15 16:15:24 >>> (assuming the timestamp is correct). This one could be undeleted >>> successfully. I also tried a snippetdir where metadata_created is set to >>> 0000-00-00 00:00:00 (for reasons unknown, but it is like that with all >>> the snippetdirs in this db) and there, undeletion fails. >> >> I think these were created before metadata and undelete has been >> introduced. > > So that means I cannot undelete them, I guess. Do you think there could > be other problems with objects like this? I'm thinking especially about > replication,
I had problems with database like this and good solution ( at least for replication ) has been this simple SQL update: UPDATE tablename SET metadata_revised = '1970-01-01 00:00:00' where metadata_revised = '0000-00-00 00:00:00'; Point is, not to have 0000-00-00 datetimes, so you may tweak date. Piotras _______________________________________________ user mailing list [email protected] http://lists.midgard-project.org/mailman/listinfo/user
