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'

Submitted by:  None
Submitted on:  Thu 18 Aug 2005 06:14:59 AM UTC  
Item Group: Category:  API - Setup
Severity:  3 - Normal Priority:  7 - High
Status:  In Progress Privacy:  Public
Assigned to:  Andrew Mitchell <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>
Project 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>
Project 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.



No files currently attached


Depends on the following items: None found

Items that depend on this one: None found


CC list is empty


Do you think this task is very important?
If so, you can add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.




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.3