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
-~----------~----~----~----~------~----~------~--~---

Reply via email to