You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/08/26 14:04:43 UTC
[Bug 120714] New: Document created on en_US version of Base gives
error when used on es_ES install
https://issues.apache.org/ooo/show_bug.cgi?id=120714
Priority: P3
Bug ID: 120714
CC: ooo-issues@incubator.apache.org
Assignee: needsconfirm@dba.openoffice.org
Summary: Document created on en_US version of Base gives error
when used on es_ES install
Severity: normal
Issue Type: DEFECT
Classification: Application
OS: All
Reporter: rgb-es@apache.org
Hardware: All
Status: CONFIRMED
Version: AOO 3.4.0
Component: none
Product: database access
Created attachment 79148
--> https://issues.apache.org/ooo/attachment.cgi?id=79148&action=edit
Sample database
A valid database created on the English version of AOO Base 3.4.1 gives a
"Syntax error in SQL expression" when opened on the Spanish version.
== Steps to reproduce the problem
1- Open the attached "biblio.odb" database on a Spanish version of AOO.
2- Select "Consultas"
3- Right click on Consulta1 → Editar
4- Run it with F5 (Ejecutar)
Result: a pop up window with the following message
"Syntax error in SQL expression"
NOTE: The same steps performed on an English AOO work without problems.
-------
The problem was first reported on the ES forums
--
You are receiving this mail because:
You are on the CC list for the bug.
[Bug 120714] Document created on en_US version of Base gives error
when used on es_ES install
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120714
--- Comment #3 from r4zoli <r4...@apache.org> ---
Now I tested with Xubuntu 12.04 32 bit AOO 3.4.1 Hungarian with Spanish
langpack. I met the problem which you described only when I used Spanish UI
settings. When I opened in HU settings no such problem.
When I opened with Spanish UI, I opened query in SQL edit mode, I can run
query. If I switched to query designer view, the error happens when I run
query.
The problem somwhere in spanish query UI code,
--
You are receiving this mail because:
You are on the CC list for the bug.
[Bug 120714] Document created on en_US version of Base gives error
when used on es_ES install
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120714
r4zoli <r4...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |r4zoli@apache.org
--- Comment #1 from r4zoli <r4...@apache.org> ---
In the example file only "Consulta1" query exists. No "Consultas".
It is run without any problem with installed spanish langpack on Hungarian
version AOO 3.4.1 under win7.
What platform you have this problem? All?
If you install other langpacks than spanish, change happens?
What is the query in SQL view? What happens if you run SQL direct option?
--
You are receiving this mail because:
You are on the CC list for the bug.
[Bug 120714] Document created on en_US version of Base gives error
when used on es_ES install
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120714
--- Comment #2 from rgb <rg...@apache.org> ---
>> In the example file only "Consulta1" query exists. No "Consultas".
Yes. "Consultas" is not a query, but the Spanish name of the second icon on the
left panel when you open the file.
The original reporter found the problem on Win7 ultimate. I opened the file on
Linux (64 bits) and got the same error message with AOO 3.4.1, full ES install
(no Language Pack).
For your other questions, I'll ask the original reporter and came back here.
--
You are receiving this mail because:
You are on the CC list for the bug.
[Bug 120714] Document created on en_US version of Base gives error
when used on es_ES install
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120714
rgb <rg...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Latest|--- |AOO 4.0.0
Confirmation on| |
--- Comment #5 from rgb <rg...@apache.org> ---
Problem still present on ES version for AOO 4.0:
AOO400m3(Build:9702) - Rev. 1503704
2013-07-16 14:49:37 (Tue, 16 Jul 2013) - Linux x86_64
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 120714] Document created on en_US version of Base gives error
when used on es_ES install
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120714
mriosv <mr...@wanadoo.es> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |mriosv@wanadoo.es
--- Comment #4 from mriosv <mr...@wanadoo.es> ---
Win7x64Ultimate AOO-3.4.1 Build 9593 Rev. 1372282 En-Us langpack-Es (Español)
langpack-Gl (Galician)
The problem is only with Spanish-Spain language interface.
When in edit the view, if I try to run:
-Syntax error in SQL expression.
- Options:
Detalles
Lista de errores
X Error
- Estado SQL:HY000
- Código de error:1000
- Syntax error in SQL expression.
X Error
- Estado SQL:HY000
- Código de error:1000
X Error
- Estado SQL:HY000
- Código de error:1000
- syntax error, unexpected $end, expecting
BETWEEN of IN or SQL_TOKINE_LIKE
When in edit the view, if I try to deactivate design view:
- Error en la sintaxis de SQL
- Options:
Detalles (details)
Lista de errores (list of errors)
X Error
- Estado SQL:HY000
- Código de error:1000
- Error en la sintaxis SQL.
--
You are receiving this mail because:
You are on the CC list for the bug.