To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110202
------- Additional comments from hni...@openoffice.org Thu May 27 18:37:17 +0000 2010 ------- I can report precisely the same issue as aliospopp. I am running mysql 5.1.46-community via TCP/IP / (Mysql Client 5.1.11) / Openoffice 3.2.0m12(build 9483) on Win2K I have created a table as follows CREATE TABLE `fam_daten` ( `id` int(10) NOT NULL AUTO_INCREMENT, `fam_id` int(10) DEFAULT NULL, `datenblatt` longblob, `geladen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `empfangen` date DEFAULT NULL, `seiten_sort` int(10) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 In OOobase I created a form on the basis of the following query: SELECT `fam_daten`.`id` AS `id`, `fam_daten`.`fam_id` AS `fam_id`, `fam_daten`.`datenblatt` AS `datenblatt`, `fam_daten`.`geladen` AS `geladen`, `fam_daten`.`empfangen` AS `empfangen`, `fam_daten`.`seiten_sort` AS `seiten_sort` FROM `basisdaten`.`fam_daten` `fam_daten` WHERE ( `fam_daten`.`fam_id` IS NULL ) ORDER BY `fam_daten`.`id` The form displays all the records where the fam_id fields are empty (NULL). I enter an integer in the fam_id field and progress to the next record. Precisely the 2 error messages reported by aloispopp are displayed and it is impossible to progress to the next record. I have to close the form. However, on inspection of the contents of the fields (e.g. with a query) the record has been updated as I intended. Connecting to the same mysql db but from OpenOffice 3.2.0m21(build 9319) on OpenSuse 11.2 exactly the same error messages are produced. I hope this helps. Cheers Harvey Nimmo --------------------------------------------------------------------- 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
