To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115928 Issue #|115928 Summary|Duplicate entries in MySQL dbs Component|Database access Version|OOO320m18 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|MySQL Connector/OOo Assigned to|dbaneedsconfirm Reported by|vinnic777
------- Additional comments from vinnic...@openoffice.org Sun Dec 5 05:02:28 +0000 2010 ------- Hi, I created a basic database in OpenOffice Database, a few versions ago, to keep record and track of all the photo orders that we handle in our company. Very basic structure, one table with all the info. (unique ID = Order Number, etc.), One Form to enter the info and also search by OrderNumber. I updated yesterday to the latest version, rev. 000320m18, and since doing so there are now multiple entries in the table that are exact duplicates of each other, up to 4 entries that are exactly the same. Also, the table is missing some lines of data as well as. The search utility is also having issues as I am not able to find some entries that I know are there. Searching by the UniqueID (OrderNumber) was usually how it was done and it worked but now not at all. At first, I thought the database was corrupted but I, also, use this database via OpenOffice Writer to print out envelopes in a Mail Merge. When querying the database through Writer, the information shows up correctly as entered. Any info on how to resolve? Many Thanks --------------------------------------------------------------------- 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