To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108022 Issue #|108022 Summary|Failing to open Mysql tables with NULL Datetime values | Component|Database access Version|OOO310m19 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|MySQL Connector/OOo Assigned to|dbaneedsconfirm Reported by|leongoogs
------- Additional comments from leongo...@openoffice.org Fri Jan 1 13:23:55 +0000 2010 ------- Mysql database version 4.1 , on an external machine . Connect via JDBC Sun Java Version 1.6.0.16 . Mysql-Connector-java 3.2.0 alpha . Datetime format of Field DD/MM/YY HH:MM some values in the table have no date time entered . You can look at the table in design view and Base recognizes that data in that field is not required . Error reported is that "The data content could not be loaded , Cannot convert value '0000-00-00 00:00:00'from column 7 to TIMESTAMP . Other tables in the same database without null values in a datetime field open OK . The same database table can be connected to from Microsoft Access in Windows via ODBC and shows NULL values in the table OK. Mysqlcc under windows also works to the same table as does a mysql client under linux. Seems the datetime conversion code is working all the time even if the field is marked as not always being required. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org