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: 0.9.16.005Category: API - Setup
Severity: 3 - NormalPriority: 7 - High
Status: In ProgressPrivacy: Public
Assigned to: Andrew Mitchell <ajmitch>Open/Closed: Open
Component Version: SVNOperating System: None
Reproducibility: Every TimePlanned 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

Anonymous
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:

Hi,

which version of mysql are you using ?

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

Regards,

Caeies

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:

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.

Anonymous

 

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 click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follow 3 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Wed 07 Dec 2005 11:46:31 AM UTCskwashdStatusNeed Info=>In Progress
Thu 20 Oct 2005 11:27:43 PM UTCskwashdAssigned toNone=>ajmitch
Wed 07 Sep 2005 01:05:17 PM UTCCaeiesStatusNone=>Need Info

Back to the top


Powered by Savane 3.1-cleanup1