On Sun, Jan 06, 2002 at 07:54:46PM +0100, Olivier M. wrote:
On Sun, Jan 06, 2002 at 11:57:58AM -0500, Marc Delisle wrote:
Ok, waiting a minute :)
mmm, seems the automatic timestamp-feature (should be on NOW() per default) is broken again in tbl_change.php3, please wait... :)
found the "problem" :) : ____________________________________________________________________________________________________________________
Revision 1.60 / (view) - annotate - [select for diffs] , Tue Nov 20 15:54:01 2001 UTC (6 weeks, 5 days ago) by loic1 Branch: MAIN Changes since 1.59: +6 -4 lines Diff to previous 1.59 set the default function to "NOW()" for timestamp fields only in insert mode (ie not in update mode) ____________________________________________________________________________________________________________________
well... would you mind if we turn this on again ? The default mysql behaviour (using the mysql client or scripts) is to update the ts in *any* case, so I think it would be better the way it was in version 1.59...
As an example, on one of my servers, there are cronjob scripts watching for changes in an sql table: if a record changed (new timestamp), it would run some progs to update /etc/passwd etc... But if the timestamp is not updated, it won't work... and that is PMA's work :)
cheers, Olivier