[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#553578: openoffice.org-base: Table wizard can't create table after adding, then removing, a field



Package: openoffice.org-base
Version: 1:3.1.1-2
Severity: normal

Howdy,

In the table wizard, when I add a field, then remove that field, the
wizard is unable to later create the table in its final step.

Steps to reproduce:

* Open OpenOffice.org Base.

  * The “Database Wizard” opens at the “Select database” step.

* Select “Create a new database”, then select “Next”.

  * The wizard proceeds to the “Save and proceed” step.

* Select “No, do not register the database”.

* Select “Create tables using the table wizard”.

* Select “Finish".

  * The wizard prompts for a filename for the document.

* Select an arbitrary document filename for the new document, then select “Save”.

  * The “Table Wizard” appears, at the “Select fields” step.

* Select the sample table “Tasks”.

* Select all available fields with the “>>” control.

* Select “Next”.

  * The wizard proceeds to the “Set types and formats” step.

* Select the “+” control to add a new field.

  * The new field is added to the list, named “Field”.

* Select the new field, then select the “−” control to remove the field.

  * The field is removed from the list.

* Select “Next”.

  * The wizard proceeds to the “Set primary key” step.

* Select “Use an existing field as primary key”.

  * The “Fieldname” control becomes active.

* Select the field named “TaskID”.

* Select “Next”.

  * The wizard proceeds to the “Create table” step.

* Select “Create a form based on this table”.

* Select “Finish”.

  * An “OpenOffice.org Base” error dialogue appears, with the message:

    Unexpected token:  in statement [CREATE TABLE "Tasks" ("Notes" LONGVARCHAR,"TaskID" INTEGER NOT NULL,"EndDate" DATE,"StartDate" DATE,"Description" LONGVARCHAR,""]

  * The wizard will not proceed; no matter what action is selected,
    the same error message appears.


-- System Information:
Debian Release: squeeze/sid
  APT prefers testing
  APT policy: (990, 'testing'), (900, 'stable')
Architecture: powerpc (ppc64)

Kernel: Linux 2.6.30-2-powerpc64 (SMP w/2 CPU cores)
Locale: LANG=en_AU.UTF-8, LC_CTYPE=en_AU.UTF-8 (charmap=UTF-8) (ignored: LC_ALL set to en_AU.UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages openoffice.org-base depends on:
ii  java-gcj-compat [java5- 1.0.80-5.1       Java runtime environment using GIJ
ii  libc6                   2.9-25           GNU C Library: Shared libraries
ii  libgcc1                 1:4.4.1-4        GCC support library
ii  libhsqldb-java          1.8.0.10-5       Java SQL database engine
ii  libstdc++6              4.4.1-4          The GNU Standard C++ Library v3
ii  openjdk-6-jre [java5-ru 6b16-4           OpenJDK Java runtime, using Hotspo
ii  openoffice.org-base-cor 1:3.1.1-2        full-featured office productivity 
ii  openoffice.org-core     1:3.1.1-2        full-featured office productivity 
ii  openoffice.org-java-com 1:3.1.1-2        full-featured office productivity 
ii  ure                     1.5.1+OOo3.1.1-2 OpenOffice.org UNO runtime environ

openoffice.org-base recommends no packages.

Versions of packages openoffice.org-base suggests:
pn  libmysql-jav <none>                      (no description available)
ii  mdbtools     0.5.99.0.6pre1.0.20051109-5 JET / MS Access database (MDB) too
pn  openoffice.o <none>                      (no description available)
pn  openoffice.o <none>                      (no description available)
ii  unixodbc     2.2.11-20                   ODBC tools libraries

Versions of packages openoffice.org-core depends on:
ii  fontconfig             2.6.0-4           generic font configuration library
ii  libc6                  2.9-25            GNU C Library: Shared libraries
ii  libcairo2              1.8.8-2           The Cairo 2D vector graphics libra
ii  libcurl3-gnutls        7.19.5-1.1        Multi-protocol file transfer libra
ii  libdb4.7               4.7.25-8          Berkeley v4.7 Database Libraries [
ii  libexpat1              2.0.1-4           XML parsing C library - runtime li
ii  libfreetype6           2.3.11-1          FreeType 2 font engine, shared lib
ii  libgcc1                1:4.4.1-4         GCC support library
ii  libglib2.0-0           2.22.2-2          The GLib library of C routines
ii  libgstreamer-plugins-b 0.10.25-1         GStreamer libraries from the "base
ii  libgstreamer0.10-0     0.10.25-2         Core GStreamer libraries and eleme
ii  libgtk2.0-0            2.18.2-1          The GTK+ graphical user interface 
ii  libhunspell-1.2-0      1.2.8-5           spell checker and morphological an
ii  libhyphen0             2.4-6             ALTLinux hyphenation library - sha
ii  libice6                2:1.0.5-1         X11 Inter-Client Exchange library
ii  libicu42               4.2.1-3           International Components for Unico
ii  libjpeg62              6b-15             The Independent JPEG Group's JPEG 
ii  libldap-2.4-2          2.4.17-1          OpenLDAP libraries
ii  libneon27              0.29.0-1          An HTTP and WebDAV client library
ii  libnspr4-0d            4.8-1             NetScape Portable Runtime Library
ii  libnss3-1d             3.12.4-1          Network Security Service libraries
ii  librdf0                1.0.9-2           Redland Resource Description Frame
ii  libsm6                 2:1.1.1-1         X11 Session Management library
ii  libstdc++6             4.4.1-4           The GNU Standard C++ Library v3
ii  libx11-6               2:1.2.2-1+b1      X11 client-side library
ii  libxaw7                2:1.0.6-1         X11 Athena Widget library
ii  libxext6               2:1.0.4-1         X11 miscellaneous extension librar
ii  libxml2                2.7.6.dfsg-1      GNOME XML library
ii  libxrandr2             2:1.3.0-2         X11 RandR extension library
ii  libxrender1            1:0.9.4-2         X Rendering Extension client libra
ii  libxslt1.1             1.1.26-1          XSLT processing library - runtime 
ii  libxt6                 1:1.0.6-1         X11 toolkit intrinsics library
ii  libxtst6               2:1.0.3-1         X11 Testing -- Resource extension 
ii  openoffice.org-common  1:3.1.1-2         full-featured office productivity 
ii  ttf-opensymbol         1:3.1.1-2         OpenSymbol TrueType font
ii  ure                    1.5.1+OOo3.1.1-2  OpenOffice.org UNO runtime environ
ii  zlib1g                 1:1.2.3.3.dfsg-15 compression library - runtime

Versions of packages openoffice.org-base is related to:
pn  libmyodbc    <none>                      (no description available)
pn  libmysql-jav <none>                      (no description available)
pn  libpg-java   <none>                      (no description available)
pn  libsapdbc-ja <none>                      (no description available)
pn  libsqliteodb <none>                      (no description available)
ii  mdbtools     0.5.99.0.6pre1.0.20051109-5 JET / MS Access database (MDB) too
pn  odbc-postgre <none>                      (no description available)
pn  tdsodbc      <none>                      (no description available)
ii  unixodbc     2.2.11-20                   ODBC tools libraries

-- no debconf information

-- 
 \     “Please do not feed the animals. If you have any suitable food, |
  `\                     give it to the guard on duty.” —zoo, Budapest |
_o__)                                                                  |
Ben Finney <ben@benfinney.id.au>

Attachment: signature.asc
Description: Digital signature


Reply to: