Apache OpenOffice (AOO) Bugzilla – Issue 24498
Can't edit mysql tables with multiple unique indexes or combined primary fields
Last modified: 2006-05-31 14:29:06 UTC
Mysql lets you set several fields as part of a single primary field or define several different fields as unique. If you have a table that has such a structure and then try to enter data in any of the fields via the OOo gui, you get the following message : [MySQL][ODBC 3.51 Driver][mysqld-4.0.15'-Max']You have an error in yourSQL syntax. Check the manual that corresponds to your MySQL serverversion for the right syntax to use near '00000000000000000e+00 AND`test3`.`keyword1` = 'test'' at line The end result is that you can not save any entered data into the table, whether in the data grid or via a form. THe problem occurs both on Windows and Linux OOo1.1. Excel is capable of handling such data structures, and will let you enter and modify mysql data via the gui. If you want to try this, someone on the French list did the following (I created my table originally via webmin, but the result is the same : # Table Structure `essaitony` CREATE TABLE `essaitony` ( `cle` int(10) NOT NULL default '0', `kjfd` varchar(50) NOT NULL default '', `cle2` int(10) NOT NULL default '0', `bs` varchar(50) NOT NULL default '', `shs` varchar(50) NOT NULL default '', UNIQUE KEY `cle` (`cle`,`cle2`), UNIQUE KEY `cletony` (`bs`,`cle`,`cle2`)) TYPE=MyISAM; Alex
setting oooqa
More info. I've been playing with this. Although the message appears saying that an error is generated, repeatedly hitting the "star" icon button in the grid/table view of the DSB appears to insert the data, but screen corruption occurs. I've included a screen shot to show what I mean. I have also just checked via the mysql command line whether the data is actually entered in the table and it is, so there is obviously a problem here somewhere along the line.
Created attachment 12531 [details] OOo screen corruption on multiple indexed mysql tables
correcting sub component (see http://www.openoffice.org/issues/describecomponents.cgi?component=Database%20access, please), and default owner
Hi, I guess you use a french locale with a "," as decimal delimiter. Please use a english locale with a "." as decimal delimiter. The ODBC driver doesn't work correct with a "," as delimiter. Does the issue still occurr with an english locale? Bye Marc
I have tried this with another table structure on my Linux box, with OOo EN : Field name Type Allow nulls? Key Default value Extras id int(11) No Primary 0 keyword1 varchar(10) No Primary keyword2 varchar(10) Yes None keyword3 varchar(10) Yes None So I don't think the locale makes a difference. Note that the problem occurs when two fields are designated as forming part of the primary key. The data can be entered via the OOo UI if you force it, but then you get incoherent data in the id field. Alex
change subcomponent to 'none'
What does changing the subcomponent to none imply ? That nobody wants to take it ? Just curious. Alex
http://qa.openoffice.org/servlets/BrowseList?list=dev&by=thread&from=112054
Has this been accepted as a bug or not ? I'm afraid I don't understand what status this issue actually has at the moment. Alex
Hi Alex, your issue is qualified as "NEW" and currently waiting in the queue to be processed further by a developer. see also this page for explanation: http://www.openoffice.org/bugs/issues.html
this issue is a duplicate of issue 26432 Yes, I know the handling is not right, I have to set issue 26432 as a duplicate to this one, however the other one is more clear and it's was send to the right developer allready. I will add a comment to issue 26432, that this issue should be tested also. Bye Marc *** This issue has been marked as a duplicate of 26432 ***
close this one