Hi

I can't reproduce this. Can you please give me some more information.
What kind of database connection type do you use? ( HSQLDB / ODBC / JDBC /.. )

I assume that it's ODBC, right?
Does the crash also occurr if you use another ODBC driver ?

Bye Marc

I can't reproduce it with m163.

There was a bug in prior version to input data via forms.

@ jeffsilv
Which is the exact version number you use?

Here is the procedure I use to connect to the database.  Start OpenOffice
(ooffice).  File -> New -> database .  Select Connect to an existing database
using ODBC.   Use MySQL-equipment_test as the data source name (note that this
comes from the /etc/odbc.ini file).  Enter the username, and turn on the
password required checkbox if needed.  Since the equipment_test database allows
anonymous read/only access, this step is optional.  Click on the test database
button, and it should say that it connected successfully.  Register the
database, which creates a file so you can do this faster next time.  Click on
edit tables if you want to edit the tables.

To reproduce the problem: go through the procedure above.  Then, click on the
create table in design view, design a table, and click on the save icon and it
crashes. 

When I restart openoffice base, it goes through the recovery process fine.

I also tried: File -> New -> database .  Select Connect to an existing database
using MySQL.  Click on NEXT.  Select ODBC.   Click on Browse.  Select
MySQL_equipment_test.   It wants a user name, enter root select password
required.  Select register the database.  Select open database for editing.  
Again, click on the create table in design view, design a table, and click on
the save icon and it crashes.

I tried using JDBC, but it won't open the JDBC driver (probably because I
haven't installed it yet - I need to go back and read the manual).

I am using OpenOffice 2.0 from RedHat Fedora Core 4. 

[jeffs@black ~]$ rpm -q --file /usr/bin/oobase
openoffice.org-core-2.0.1.1-5.1
[jeffs@black ~]$ rpm -q -a | fgrep openoffice
openoffice.org-calc-2.0.1.1-5.1
openoffice.org-javafilter-2.0.1.1-5.1
openoffice.org-core-2.0.1.1-5.1
openoffice.org-debuginfo-2.0.1.1-5.1
openoffice.org-impress-2.0.1.1-5.1
openoffice.org-math-2.0.1.1-5.1
openoffice.org-xsltfilter-2.0.1.1-5.1
openoffice.org-pyuno-2.0.1.1-5.1
openoffice.org-graphicfilter-2.0.1.1-5.1
openoffice.org-writer-2.0.1.1-5.1
openoffice.org-testtools-2.0.1.1-5.1
openoffice.org-draw-2.0.1.1-5.1
[jeffs@black ~]$ uname -a
Linux black 2.6.14-1.1656_FC4 #1 Thu Jan 5 22:13:22 EST 2006 i686 athlon i386
GNU/Linux
Here is my odbc.ini file contents:

[MySQL-test]
Description = MySQL database test
Driver = MySQL
Server = localhost
Database = test
Port = 3306

[MySQL-equipment_dev]
Description    = MySQL equipment database development
Driver        = MySQL
Server        = black.commercialventvac.com
Database    = equipment_dev
Port        = 3306

[MySQL-equipment_test]
Description    = MySQL equipment database test
Driver        = MySQL
Server        = black.commercialventvac.com
Database    = equipment_test
Port        = 3306

[jeffs@black ~]$  more /etc/odbcinst.ini
# Example driver definitinions
#
#

# Included in the unixODBC package
#[PostgreSQL]
#Description    = ODBC for PostgreSQL
#Driver         = /usr/lib/libodbcpsql.so
#Setup          = /usr/lib/libodbcpsqlS.so
#FileUsage      = 1


# Driver from the MyODBC package
# Setup from the unixODBC package
[MySQL]
Description     = ODBC for MySQL
Driver          = /usr/lib/libmyodbc.so
Setup           = /usr/lib/libodbcmyS.so
FileUsage       = 1
[jeffs@black ~]$  ls -l /usr/lib/libodbcmy*
lrwxrwxrwx  1 root root   19 Jan 16 04:49 /usr/lib/libodbcmyS.so ->
libodbcmyS.so.1.0.0
lrwxrwxrwx  1 root root   19 Jan 16 04:49 /usr/lib/libodbcmyS.so.1 ->
libodbcmyS.so.1.0.0
-rwxr-xr-x  1 root root 6252 Sep 30  2005 /usr/lib/libodbcmyS.so.1.0.0
[jeffs@black ~]$   rpm -q --file /usr/lib/libodbcmy*
unixODBC-2.2.11-3.FC4.1
unixODBC-2.2.11-3.FC4.1
unixODBC-2.2.11-3.FC4.1
[jeffs@black ~]$  

Which version of mysql do you use?

MySQL version <= 4.1.x doesn't support views.

clu->jeffsilv: does mechtildes hint helped you further (solved your problem)?

seems that problem is solved

=> close

do not hestitate to reopen if problem still exist in current version