To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95792 Issue #|95792 Summary|MySQL ODBC editing tables broken Component|Database access Version|OOO300m9 Platform|PowerPC URL| OS/Version|Mac OS X Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|chrroessner
------- Additional comments from [EMAIL PROTECTED] Mon Nov 3 10:19:56 +0000 2008 ------- Hi, first some information: Mini-Mac : 1,42Ghz PPC G4 - 1 GB DDR-SDRAM, Mac OS X 10.4.11 OpenOffice Version 3.0 - 300m9 (Build: 9358) MySQL-ODBC-Driver: MySQL Connector/ODBC 5.1.5 [ODBC Data Sources] myodbc = MySQL ODBC 5.1 Driver /Library/ODBC/odbc.ini: [ODBC] Trace = 0 TraceAutoStop = 0 TraceFile = TraceLibrary = [myodbc] Driver = /usr/local/lib/libmyodbc5.so DATABASE = example DESCRIPTION = Some Description here OPTION = 3 ReadOnly = No PWD = HIDDEN-HERE PORT = 3306 SERVER = 192.168.178.200 UID = HIDDEN-HERE /Library/ODBC/odbcinst.ini [ODBC Drivers] MySQL ODBC 5.1 Driver = Installed [ODBC Connection Pooling] PerfMon = 0 Retry Wait = [MySQL ODBC 5.1 Driver] Driver = /usr/local/lib/libmyodbc5.so SETUP = /usr/local/lib/libmyodbc3S.so -------------------- Description: I have created a mysql database on an Ubuntu Linux server (Hardy release). I created a new database document in OpenOffice under MAC OS X. I first selected the mysql-driver, then the odbc option. Anything else defaults. I chose the tables tab and created a new table called Tabelle1 (Default name in german). I added some fileds: name, given name and street as well as an ID, primary key with auto increment. All with OOo. I saved the table. Checking on the mysql-server side, the table got created successfully. After that I saw the newly created table in OOo and double clicked it for editing. The cursor was blinking, but as I started typing, nothing happened. I went to the server side and inserted some data with the defined database user (To make sure that it was not a privilege problem). After that I checked again under OOo. The data sets were listed now. I selected one line under OOo and told to delete this set and this worked! So I can read and delete data under OOo, but can not insert anything. I copied over the odbc-stuff to Windows XP and Linux (Ubuntu) all with the same release version of OOo. And at these platforms, everything was working as expected. So this seems to be a PPC platform bug. I noticed one difference with PPC: While under Windows and Linux there was <auto> in the ID field, it was empty under PPC. Trying to manually set a value in the PPC version did not work. I hope, you may confirm this :-) Kind regards Christian --------------------------------------------------------------------- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]