bugphpGroupWare - Bugs: bug #14210, Invalid default value for...


You are not allowed to post comments on this tracker with your current authentication level.

bug #14210: Invalid default value for 'history_timestamp'

Submitter:  None
Submitted:  Thu 18 Aug 2005 06:14:59 AM UTC
Category:  API - Setup Item Group:
Severity:  3 - Normal Priority:  7 - High
Status:  In Progress Privacy:  Public
Assigned to:  ajmitch Open/Closed:  Open
Component Version:  SVN Operating System:  None
Reproducibility:  Every Time Planned Release:  None
Fixed Release: 

Wed 07 Dec 2005 11:46:31 AM UTC, comment #4: 

This will not be fixed in stable CVS as it requires a database schema.  This will be fixed in the HEAD branch of CVS.

Dave Hall <skwashd>
Group administrator
Sat 19 Nov 2005 10:14:31 PM UTC, comment #3: 

i'm using mysql-server-5.0 (Debian, 5.0.13rc-1) and have same problem

Wed 16 Nov 2005 04:17:24 PM UTC, comment #2: 

I have the same problem using MySQL  5.0.15-nt on Windows

Rolf Ebert <rolf_ebert>
Wed 07 Sep 2005 01:05:17 PM UTC, comment #1: 


which version of mysql are you using ?

I never get such an error, how can we reproduce it ?



Caeies <Caeies>
Group administrator
Thu 18 Aug 2005 06:14:59 AM UTC, original submission:  

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.



(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached


Depends on the following items: None found

Items that depend on this one: None found


CC list is empty


There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.


Follow 3 latest changes.

Date Changed by Updated Field Previous Value => Replaced by
2005-12-07 skwashd StatusNeed Info In Progress
2005-10-20 skwashd Assigned toNone ajmitch
2005-09-07 Caeies StatusNone Need Info

Back to the top

Powered by Savane 3.13-b921.
Corresponding source code