To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59010 Issue #:|59010 Summary:|unable to save View from MySQL Database Component:|Database access Version:|OOo 2.0 Platform:|PC URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|helmerj
------- Additional comments from [EMAIL PROTECTED] Wed Dec 7 00:49:41 -0800 2005 ------- Hi! I run the Suse version of OpenOffice 2.0 on Suse 10.0 and connect to a Mysql Database (4.1.13) via the java connector (3.1.11 or 3.0.16 or 3.1.12 using java 1.5.0_03 or 1.4.2_08). I can connect to the database and run queries just fine. Following the instructions here: http://searchopensource.techtarget.com/tip/1,289483,sid39_gci1149900,00.html I created a View from a MySQL table. After specifying the view, I can run the query in the view creation wizard but when I try to save the view (tried different names here, including the suggested "View1") I get the following error message: SQL Status: 42000 Error code: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VIEW `View1` AS SELECT `Substanz`, `Firma`, `Raum`, `ME`, `Anzahl` FROM `AG_Koet' at line 1 The MySQL error code stands for this one here: Error: 1064 SQLSTATE: 42000 (ER_PARSE_ERROR) Message: %s near '%s' at line %d Either this is a bug or this might be an incompatibility between OO and MySQL and/or the java connector. Woul dbe nice if this would work though... Thanks Juergen --------------------------------------------------------------------- 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]
