To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107315 Issue #|107315 Summary|Cannot create table: error in SQL syntax Component|Database access Version|OOO320m6 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|greenrd2004
------- Additional comments from [email protected] Mon Nov 30 09:42:02 +0000 2009 ------- I created a mysql 5.1 database on localhost (which is running Fedora Linux rawhide) and connected to it using the JDBC driver. I then created a table called File using the table design mode. In this table I put these 2 fields: 1. name: id, type: Integer [INT UNSIGNED], autoincrement: yes, primary key 2. name: image, type: Image [MEDIUMBLOB] When I saved the table, I got an error message dialog, and this is the full message which I got from clicking the More button: 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 '(10) NOT NULL auto_increment,`image` MEDIUMBLOB, PRIMARY KEY (`id`))' at line 1 --------------------------------------------------------------------- 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]
