Not quite sure why you're posting this here? OpenACS doesn't run on MySQL... Either way, I'm not 100% sure, but I don't think you need to specify the (10) size for the date data type. just say 'tdate' date not null, etc...
http://www.mysql.com/doc/en/Date_and_time_types.html
http://www.mysql.com/doc/en/DATETIME.html
The MySQL docs don't say there's an optional length to the date type, so I'm guessing that's where the problem is (especially since that's where the error points to).
