In cookbook:
http://webpy.org/cookbook/sessions
----<----
create table sessions (
session_id char(128) UNIQUE NOT NULL,
atime datetime NOT NULL default current_timestamp,
data text
);
----<----
Error msg:
----<----
ERROR 1067 (42000): Invalid default value for 'atime'
----<----
If i use 'timestamp' instead of 'datetime', it works.
My OS: RHEL 5.2 (x86_64)
MySQL: 5.0.45-7.el5
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web.py" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/webpy?hl=en
-~----------~----~----~----~------~----~------~--~---