This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 139988 - [65cat] MySQL datetime field type error in Database Explorer
Summary: [65cat] MySQL datetime field type error in Database Explorer
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 6.x
Hardware: PC Windows XP
: P3 blocker (vote)
Assignee: _ ahimanikya
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-07-15 07:52 UTC by yudiset
Modified: 2008-09-22 16:33 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Structure of the table & default value (127.81 KB, image/jpeg)
2008-07-15 07:55 UTC, yudiset 		Details
SQL dump of the table (2.34 KB, text/plain)
2008-07-15 08:10 UTC, yudiset 		Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description yudiset 2008-07-15 07:52:48 UTC 
[ BUILD # : 200807040101 ]
[ JDK VERSION : 1.6.0_04 ]

I'm using Netbeans for PHP to connect to a local MySQL server.

When try to view the data on some of the tables, the Database
Explorer displays this error message:
"Executed successfully in 0 s.
Line 1, column 1

Execution finished after 0 s, 0 error(s) occurred.

An error occurred while reading the result set: Cannot convert value
'0000-00-00 00:00:00' from column 11 to TIMESTAMP."

I can access and see the same table using any MySQL admin tool (eq:
HeidiSQL, SQLYog, etc) without error.

Using NetBeans Database Explorer, I created a table with a datetime
field type.
By default it gives CURRENT_TIMESTAMP as the default value.

I think the problem may lie with how Database Explorer handles
illegal datetime field data value ('0000-00-00 00:00:00').
Comment 1 yudiset 2008-07-15 07:55:49 UTC 
Created attachment 64498 [details]
Structure of the table & default value
Comment 2 yudiset 2008-07-15 08:10:04 UTC 
Created attachment 64499 [details]
SQL dump of the table
Comment 3 Andrei Badea 2008-09-19 17:39:16 UTC 
Why is this marked "future", when it looks like a showdata issue and it wasn't evaluated by the owners of that subcomponent?
Comment 4 _ ahimanikya 2008-09-19 17:50:10 UTC 
I think this was fixed few weeks back, try with the latest build. '0000-00-00 00:00:00'  will be treated as NULL
Comment 5 Roman Mostyka 2008-09-22 10:46:37 UTC 
yudiset, can You verify that this issue was really fixed, please?
Comment 6 yudiset 2008-09-22 16:33:41 UTC 
I tested it with Netbeans PHP build 200809220413.
Yes, it's fixed now.

Thanks a lot.