Tried to post this to the sourceforge site but it's down.
When adding a new domain using /usr/local/sbin/openserctl, the last_modified column isn't populated.
Changing the query as shown below for the "domain add" function within openserctl resolved this problem
QUERY="insert into $DOMAIN_TABLE (domain, last_modified) VALUES ('$1', now());"
An alternate solution might be to update the database definition for domain.last_modified as follows:
ALTER TABLE `domain` CHANGE `last_modified` `last_modified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
Each solution solves the problem and offers different benefits in terms of user control and simplicity of programming. I feel that one of the above should be implemented.
Regards, Norm _______________________________________________ Devel mailing list [email protected] http://openser.org/cgi-bin/mailman/listinfo/devel
