[Phpgroupware-tracker] [bug #14210] Invalid default value for 'history_timestamp'

[anonymous]

URL:
  <http://savannah.gnu.org/bugs/?func=detailitem&item_id=14210>

                 Summary: Invalid default value for 'history_timestamp'
                 Project: phpGroupWare
            Submitted by: None
            Submitted on: Do 18.08.2005 um 06:14
              Item Group: 0.9.16.005
                Category: API - Setup
                Severity: 3 - Normal
                Priority: 7 - High
                  Status: None
                 Privacy: Public
             Assigned to: None
             Open/Closed: Open
       Component Version: CVS
        Platform Version: None
         Reproducibility: Every Time
         Planned Release: None
           Fixed Release: 

    _______________________________________________________

Details:

Database error: Invalid SQL: CREATE TABLE phpgw_history_log (history_id
int(11) auto_increment not null NOT NULL, history_record_id int NOT NULL,
history_appname varchar(64) NOT NULL, history_owner int NOT NULL,
history_status char(2) NOT NULL, history_new_value text NOT NULL,
history_timestamp datetime NOT NULL DEFAULT now(), history_old_value text NOT
NULL, PRIMARY KEY(history_id))
MySQL Error: 1067 (Invalid default value for 'history_timestamp')


Thats because of:

http://dev.mysql.com/doc/mysql/en/create-table.html

The DEFAULT clause specifies a default value for a column. With one
exception, the default value must be a constant; it cannot be a function or
an expression. This means, for example, that you cannot set the default for a
date column to be the value of a function such as NOW() or CURRENT_DATE. The
exception is that you can specify CURRENT_TIMESTAMP as the default for a
TIMESTAMP column as of MySQL 4.1.2.







    _______________________________________________________

Reply to this item at:

  <http://savannah.gnu.org/bugs/?func=detailitem&item_id=14210>

_______________________________________________
  Nachricht geschickt von/durch Savannah
  http://savannah.gnu.org/