4.1.4 Base can't create tables on FreeBSD

Discuss setup / installation issues - Add a spell checker, Language pack?

4.1.4 Base can't create tables on FreeBSD

Postby weif » Thu Nov 09, 2017 7:33 pm

After upgrading to 4.1.4, Base seems extremely crippled.

In a new database, clicking create table in design view does nothing. Create table using wizard opens the wizard, but you can only select the tables available in the wizard. Once you complete the task an click finish, the window says open and the finish button is disabled. You can cancel which will close the window, and the table is there.

However, you cannot open or edit the table. These options are available, but they do nothing.

I have tried with Java and with Java disabled.

I have deleted OO.o and the jdk and reinstalled them.

I have tried installing from ports and installing from packages. The behavior is the same.

It looks like Calc works (though it gives an error about links every time you open a new file, though it then appears to update linked information if it exists...). It also looks like writer works.

However, if you select "exit quickstarter" from the quickstarter menu, it appears to exit, but the process does not end and it starts consuming processor...
OOo 3.4.1 FreeBSD
weif
 
Posts: 2
Joined: Thu Jul 11, 2013 6:35 am

Re: 4.1.4 Base can't create tables on FreeBSD

Postby RoryOF » Thu Nov 09, 2017 7:40 pm

Please report this as a bug on Bugzilla
[Tutorial] Reporting bugs or suggestions

A problem has been discovered on OO 4.1.4 for MacOS concerning use of charts in Calc; the fix for this has generated a problem in database work, and it may be that your BSD problem might be related.

For Mac users: pending release of a fixed version of OO 4.1.4 for MacOS it is recommended that you revert to OO 4.1.3.
Apache OpenOffice 4.1.4 on Xubuntu 16.04.03 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 25386
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: 4.1.4 Base can't create tables on FreeBSD

Postby charlie.it » Thu Nov 09, 2017 8:01 pm

Ciao,
I am a Mac user and before I announced the release of version 4.1.4 on the Italian forum (I am admin) I tested Open Office without any problems. In particular I use Base and I see no problems of any kind. I have not yet tried Calc's charts.
Maybe @weif's issues are related to the operating system? But he does not tell us what it is: I use both Lion and High Sierra.
charlie AOO Italian Forum Admin https://forum.openoffice.org/it/forum/index.php
Apache Open Office 4.1.3 - Libre Office 4.3.7 - NeoOffice 3.4.1
on Mac OSX 10.7.5 Lion / macOS 10.12.1 Sierra (dual boot)
User avatar
charlie.it
Volunteer
 
Posts: 268
Joined: Wed Aug 21, 2013 2:12 pm
Location: Italy

Re: 4.1.4 Base can't create tables on FreeBSD

Postby RoryOF » Thu Nov 09, 2017 8:02 pm

His Subject line says "FreeBSD"
Apache OpenOffice 4.1.4 on Xubuntu 16.04.03 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 25386
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: 4.1.4 Base can't create tables on FreeBSD

Postby charlie.it » Thu Nov 09, 2017 9:30 pm

I'm sorry, I did not understand well what wrote RoryOF :oops:
charlie AOO Italian Forum Admin https://forum.openoffice.org/it/forum/index.php
Apache Open Office 4.1.3 - Libre Office 4.3.7 - NeoOffice 3.4.1
on Mac OSX 10.7.5 Lion / macOS 10.12.1 Sierra (dual boot)
User avatar
charlie.it
Volunteer
 
Posts: 268
Joined: Wed Aug 21, 2013 2:12 pm
Location: Italy

Re: 4.1.4 Base can't create tables on FreeBSD

Postby RoryOF » Thu Nov 09, 2017 9:46 pm

In his Subject line he lists FreeBSD as the operating system.
Apache OpenOffice 4.1.4 on Xubuntu 16.04.03 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 25386
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: 4.1.4 Base can't create tables on FreeBSD

Postby charlie.it » Thu Nov 09, 2017 9:57 pm

I was talking about your previous post.
charlie AOO Italian Forum Admin https://forum.openoffice.org/it/forum/index.php
Apache Open Office 4.1.3 - Libre Office 4.3.7 - NeoOffice 3.4.1
on Mac OSX 10.7.5 Lion / macOS 10.12.1 Sierra (dual boot)
User avatar
charlie.it
Volunteer
 
Posts: 268
Joined: Wed Aug 21, 2013 2:12 pm
Location: Italy

Re: 4.1.4 Base can't create tables on FreeBSD

Postby RoryOF » Thu Nov 09, 2017 10:01 pm

There has been found a problem in OO 4.1.4 for Macs; Calc does _not_ save charts in the file. The fix for this has a side effect, making a problem in Base and database work. Until a fix for both problems is found we recommend Mac users to use OO 4.1.3.
Apache OpenOffice 4.1.4 on Xubuntu 16.04.03 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 25386
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: 4.1.4 Base can't create tables on FreeBSD

Postby Villeroy » Fri Nov 10, 2017 12:15 am

Calc has no Java dependencies unless you use Java extensions for Calc. Calc works perfectly well without any Java.

Base can be used productively without any Java installed on the system. I did so several years long with OpenOffice.org 1 and 2.
-- Create a non-Java database (MySQL or PostrgeSQL for instance) and connect a Base document via ODBC or via built-in drivers (a so called SDBC connection). You can use any database development tool you prefer. From within Base you can issue data definition statements via Tools>SQL which provides a simple command line for the connected database engine.
-- Without Java you can still design queries in the graphical designer (which is not that useful) and in SQL view. The Java driven query wizard is pointless anyway. You can also copy SQL SELECT statements from your preferred development tool and save them as Base queries. While in SQL view, you can use 2 modes, the "parsed mode" which uses a HSQL-like syntax for all types of database connections and "direct SQL mode" which uses the syntax of the underlying database. Direct mode has some limitations regarding input forms.
-- Without Java you can design input forms in design view. The Java driven form wizard is almost useless since it does not even cover 10% of the possibilities.
-- Without Java you can NOT create any reports that are embedded in the Base document but there are alternatives. With Calc you can easily build stand-alone reports on spreadsheets by means of linked database ranges and pivot tables. With Writer you can build stand-alone text documents as serial letters, record sets copied into text tables and macro driven report engines.

Troubleshooting Open/LibreOffice and Java lists some other office features that depend on Java and which you may want to try. If they fail too, the problem is not related to any specific office component.

P.S.: Without Java you can even create a new database, on Windows and Linux at least. You get a connection to a dBase directory with *.dbf files. This database type is very limited, nevertheless better than list keeping on spreadsheets.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24590
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Install, Setup and Troubleshooting

Who is online

Users browsing this forum: No registered users and 9 guests