To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=116174 Issue #|116174 Summary|Subform record add or modify results in error message Component|Database access Version|OOo 3.2.1 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|cscj01
------- Additional comments from csc...@openoffice.org Sun Dec 19 18:28:12 +0000 2010 ------- I am using Ubuntu x64 and Openoffice 3.2.1 with MySQL databases. I have forms with subforms that have been working since Ubuntu 9.04. After upgrading to 10.10 from 10.04, the following situation occurs with all databases and subform entries: When adding or modifying a record in a subform, the following message is displayed: Error inserting record No value specified for parameter 1 Selecting more gives: SQL Status: 07001 No value specified for parameter 1 If I choose OK, the error reoccurs. If I change focus from that subform to the form or another subform, the error reappears. If I choose X to exit the error message and exit the form without saving it, when I reopen the form, the subform record(s) is/are there. I get a duplicate record for each time I exit the message popup with OK or change focus to the form or another subform. As I said, this behavior happens with all forms and MySQL databases when attempting to add or modify a subform record. I can delete subform records with no problems, and I can add, modify, and delete form records with no problems (assuming appropriate cascade options are set in the databases). This behavior was not present in Ubuntu 10.04 and Openoffice 3.2.0 or any releases prior. --------------------------------------------------------------------- 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