Hello,
On 11/02/05 19:35, Klaus Darilion wrote:
Norman Brandinger wrote:
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
does this work with both, mysql and postgres?
if does not work for bot, maybe we can use the 'date' command from the
system. At least for dbtext, this should be the solution.
Cheers,
Daniel
regards
klaus
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
_______________________________________________
Devel mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/devel
_______________________________________________
Devel mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/devel
