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 2015/08/04 03:06:59 UTC
[Issue 126445] New: OpenOffice crashes when tried to open sqlite3
table created with ODBC driver
https://bz.apache.org/ooo/show_bug.cgi?id=126445
Issue ID: 126445
Issue Type: DEFECT
Summary: OpenOffice crashes when tried to open sqlite3 table
created with ODBC driver
Product: Base
Version: 4.1.1
Hardware: Mac
OS: Mac OSX, 10.10
Status: UNCONFIRMED
Severity: critical
Priority: P5
Component: code
Assignee: issues@openoffice.apache.org
Reporter: xanadu6291@gmail.com
Created attachment 84853
--> https://bz.apache.org/ooo/attachment.cgi?id=84853&action=edit
This is one of Ooo crash report related with the issue
Base environment:
ODBC Administrator.app 1.1.0 by Apple
SQLite ODBC Driver by http://www.ch-werner.de/sqliteodbc/
(Used pre-compiled library, Version 0.93)
The Issue:
1.Using above environment, create BSAE document with ODBC connection.
2.Trial connection always success.
3.Try to open table in BSAE document.
4.Ooo always crash.
Note:
1.LibreOffice can open the same BASE document table without any problem.
2.FileMaker Pro also connect to SQLIte3 database used in above BSAE document.
So the issue is not related with Base environment.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126445] OpenOffice crashes when tried to open sqlite3 table
created with ODBC driver
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126445
Kay <ks...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |kschenk@apache.org
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126445] OpenOffice crashes on 64 bit systems when it tries
to open sqlite3 table created with ODBC driver
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126445
damjan@apache.org changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|OpenOffice crashes when |OpenOffice crashes on 64
|tried to open sqlite3 table |bit systems when it tries
|created with ODBC driver |to open sqlite3 table
| |created with ODBC driver
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126445] OpenOffice crashes when tried to open sqlite3 table
created with ODBC driver
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126445
damjan@apache.org changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |damjan@apache.org
OS|OS X 10.10 |All
Severity|Normal |Major
Latest|--- |4.1.4
Confirmation in| |
Hardware|Mac |All
Priority|P5 (lowest) |P2
Target Milestone|--- |4.2.0
Status|UNCONFIRMED |RESOLVED
Keywords| |crash
Resolution|--- |FIXED
--- Comment #2 from damjan@apache.org ---
Let me guess, your Ubuntu 14.04 was 64 bit?
The problem was that:
connectivity::odbc::OResultSet::getResultSetType()
expects a 32 bit integer, but on 64 bit systems it receives a 64 bit integer,
that corrupts the next 4 bytes on the stack, resulting in:
*** stack smashing detected ***: terminated
Patch committed in r1815545. Testing shows the problem no longer occurs, tables
can be opened. Resolving fixed.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126445] OpenOffice crashes on 64 bit systems when it tries
to open sqlite3 table created with ODBC driver
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126445
damjan@apache.org changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |drichard@largo.com
--- Comment #3 from damjan@apache.org ---
*** Issue 117904 has been marked as a duplicate of this issue. ***
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126445] OpenOffice crashes on 64 bit systems when it tries
to open sqlite3 table created with ODBC driver
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126445
--- Comment #4 from Anton Schults <bu...@ziggo.nl> ---
(In reply to damjan from comment #2)
> Let me guess, your Ubuntu 14.04 was 64 bit?
>
indeed, Thanks!!
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126445] OpenOffice crashes when tried to open sqlite3 table
created with ODBC driver
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126445
Matthias Seidel <ms...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |mseidel@apache.org
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126445] OpenOffice crashes when tried to open sqlite3 table
created with ODBC driver
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126445
Anton Schults <bu...@ziggo.nl> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |bugzilla@ziggo.nl
--- Comment #1 from Anton Schults <bu...@ziggo.nl> ---
Exactly the same problem under Ubuntu 14.04.
Environment:
ODBC: libodbc.so.2.0.0
Used precompiled version of UnixODBC at www.unixodbc.org.
Also downloaded sources and succesfull compiled latest version of libraries
from source.
Both had the same result
SQLiteODBC driver: libsqlite3odbc-0.9992.s0
Used precompiled version on ch-werner.de/sqliteodbc.
Also downloaded sources and succesfull compiled latest version of libraries
from source.
Both had the same result
odbcinst.ini:
[SQLite3]
Description=SQLite3 ODBC Driver
Driver=libsqlite3odbc.so
Setup=libsqlite3odbc.so
UsageCount=1
[sqlite3x]
Description=new compiled
Driver=/usr/local/lib/libsqlite3odbc.so
Driver64=/usr/local/lib/libsqlite3odbc.so
Setup=/usr/local/lib/libsqlite3odbc.so
Setup64=/usr/local/lib/libsqlite3odbc.so
UsageCount=1
Can use both drivers in /.odbc.ini with the same result.
Can open, create tables, insert records, SQL select using odbinst and iusql
tools, provided by UnixODBC. All works well.
OObase can open ODBC connection, show tables, make new tables but crashes as
soon as a table is opened, either by clicking or making a SQL query.
A good connection between OO and SQLite would be of great use for me and many
others, I think.
--
You are receiving this mail because:
You are the assignee for the issue.