Hello,
On 11/02/05 19:19, 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());"
this is ok, I will commit the change on cvs.
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
I am not sure that this works with old mysql (3.x).
Cheers,
Daniel
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
