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/
_______________________________________________
Phpgroupware-tracker mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/phpgroupware-tracker
