Re: Incorrect timestamp value
Posted by: Glenn Puckett
Date: May 22, 2013 04:10PM

I am at an even bigger quandry now. I implemented log4jdbc to get the actual data being applied to MySQL. In the statement that fails the specific field that is failing contains:

last_labor_rpt_date='2013-05-22 17:55:05'

The entire update statement is:

update xyz.account_tbl set acct_type=1, industry_role_id=18, contr_type='N',
date_joined='2008-11-10', date_paid=NULL, description=NULL, fee_paid=0.00, labor_alt_descr='',
last_activity_date='2013-05-22', last_labor_rpt_date='2013-05-22 17:55:05', name='Test Account',
due_date='2013-01-31', status=1, website_url='www.test.com' where id=71;

The table definition is:

use xyz;

CREATE TABLE `account_tbl` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`website_url` varchar(255) DEFAULT NULL,
`date_joined` date NOT NULL,
`last_activity_date` date NOT NULL,
`industry_role_id` int(11) unsigned NOT NULL DEFAULT '0',
`acct_type` tinyint(4) DEFAULT '-1',
`status` tinyint(3) unsigned NOT NULL DEFAULT '0',
`description` text,
`last_labor_rpt_date` timestamp NULL DEFAULT NULL,
`labor_alt_descr` text,
`fee_paid` decimal(8,2) DEFAULT '0.00',
`date_paid` date DEFAULT NULL,
`due_date` date DEFAULT NULL,
`contr_type` char(1) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `account_name_idx` (`name`),
KEY `FK_ACCT_INDROLE` (`industry_role_id`),
CONSTRAINT `FK_ACCT_INDROLE` FOREIGN KEY (`industry_role_id`) REFERENCES `admin_industry_role_tbl` (`id`) ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;



I don't understand why this statement is failing.

Options: ReplyQuote


Subject
Written By
Posted
Re: Incorrect timestamp value
May 22, 2013 04:10PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.