MySQL Frustrations or: The Tale of Two Timestamps
January 5th, 2009
#1293 – Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
MySQL Lists discussion about this
This makes me sad, especially since that discussion thread is a year and a half old, but the fact that Dmitri mentions a community-submitted patch gives me hope. Is anybody working on this?