[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

From: anonymous
Subject: [Phpgroupware-tracker] [bug #14210] Invalid default value for 'history_timestamp'
Date: Thu, 18 Aug 2005 06:14:59 +0000
User-agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.10) Gecko/20050716


                 Summary: Invalid default value for 'history_timestamp'
                 Project: phpGroupWare
            Submitted by: None
            Submitted on: Do 18.08.2005 um 06:14
              Item Group:
                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: 



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:

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:


  Nachricht geschickt von/durch Savannah

reply via email to

[Prev in Thread] Current Thread [Next in Thread]