Apache OpenOffice (AOO) Bugzilla – Issue 21719
Cannot read table - MySQL - unixODBC
Last modified: 2006-05-31 14:29:06 UTC
When I try to read a table in my SQL database, I get the message : Syntax error or access violation, message from server: "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 'impression'' at line 1" Then I cannot do anything with my database.
The probleme was I had a column named 'Mode 'd'impression'. I think the qimple quote was not supported. Note that tools such as PHP my admin manages it well.
correcting sub component (see http://www.openoffice.org/issues/describecomponents.cgi?component=Database%20access, please), and default owner
my area
clu->mpupat: so you have resolved the problem or ist still exist? please discribe the bug (if still exist) step by step thx
I resolved the problem by ranaming my column "Mode d'impression" in "Mode d_impression" but the problem still exists : if you have a column with a single quote in it, you get the message show below
mpupat, do you mind trying other column names with single quotes? I suppose it may *not* be the quote, but the single "d" character, which may confuse our parser (since D is a keyword in some circumstances). It's just an idea.
CLU->protocol:i tried a french office and it works for me well - even with ' and stand alone d (i also used mpupats example without foults) means: generally it seems to work CLU->mpupat: must be a very special problem - please add your comment, if you have any new information that can maybe help to detect the deeper reasen i guess, that you created your table (or added the invalid column) in the office and not directly on your MySQL database, right? if not, please try it out and add your experience
CLU->All: can anybody repro the described behavior? please give me a hint and add a proper description
over a month (two weeks) no respond - not to repro, so i close this issue
I have to see this but I cannot reinstall my SQL <-> OOo link
change subcomponent to 'none'
I finally re-installed an Ooo <-> MySQL link. I re-open this to remember testing it. Sorry for the delay.
I'm using OOo1.9.74 and still have the problem. With a field named `mode d'impression`, I get: SQL Status: 42000 Error code: 1064 [unixODBC][TCX][MyODBC]You have an error in your SQL syntax near 'VIEW `View1` AS SELECT `Mode d'impression` FROM `France` `France` WHERE ( ( `Mod' at line 1 In fact it seems to happen with almost any name .....
clu->msc: a unixODBC problem? can you repro that?
hi mpupat, which versions do you use? MySQL? unixODBC? distro? French locale?
no response for 2 weeks, closing for now, mpupat, please add info as requested, thanks, Max
.