LO Base Error: DB Created By Newer Version

users
#1

Hey Y'all,

I'm following directions in GS40-GettingStartedLO Chapter 8. I created
a new database, and then created the Fuel table per the instructions.

I saved the table and the database, then closed the database.

When I open the database, and click on the Tables icon I get this error:

The connection to the data source "NAME OF DB" could not be established.
The connection could not be established. The database was created by a
newer version of LibreOffice.

When I click the [More] button on the bottom of the error box I get two
errors listed.

The first says, "The connection to the data source "NAME OF DB" could
not be established."

The second says:
SQL STATUS: HY000

"The connection could not be established. The database was created by a
newer version of LibreOffice."

No it wasn't! It was created just a minute ago on the same machine, buy
the same user, with the same version of LO.

I tried erasing and then reinstalling LO and building a whole new
database. Same result.

I'm using:

LO Base, Version 4.0.4.2 (Build ID: 4.0.4.2-9.el6)
JRE, Sun Microsystems Inc. 1.6.0_30 with accessibility support

CentOS release 6.5 (Final)

Linux mushroom.patch 2.6.32-431.5.1.el6.i686 #1 SMP Tue Feb 11 21:56:33
UTC 2014 i686 i686 i386 GNU/Linux

22:37:28 up 5 days, 1:46, 2 users, load average: 1.33, 1.17, 1.11

Now the money question. How do I fix this?

#2

Hi Mark,

"The connection could not be established. The database was created by a
newer version of LibreOffice."

No it wasn't! It was created just a minute ago on the same machine, buy
the same user, with the same version of LO.

I tried erasing and then reinstalling LO and building a whole new
database. Same result.

I'm using:

LO Base, Version 4.0.4.2 (Build ID: 4.0.4.2-9.el6)
JRE, Sun Microsystems Inc. 1.6.0_30 with accessibility support

CentOS release 6.5 (Final)

Did you upgrade from a version 3.x of LO ? If so, your old user profile
might be the cause (the "automagic" migration from 3.x to 4.0.x possibly
didn't work properly).

Failing that, 4.0.4.2 is pretty old, and 4.0.4 also contained a fair
number of bugs which have since been fixed in more recent versions of LO.

Alex

#3

Hey Alex, I was thinking of clearing out my home while I was at work today.

I just moved .libreoffice to .libreoffice.old, and .openoffice.org to
.openoffice.org.old

That didn't seem to make any difference. When I went to Tools/Options
to check the settings there nothing was changed. I also scanned the
folders in my home after restarting LO and making a change in the
settings but didn't find any new folder.

Do you know where LO keeps it's settings?

I'm using the version of LO that is packaged with CentOS 6.5. It might
not be cutting edge, but it's supposed to work. That's what CentOS is
all about.

In the mean time I'm going to try installing the latest available JRE.

#4

Hi Mark,

Do you know where LO keeps it's settings?

AFAIK the user profile directory was moved to

/home/<user>/.config/libreoffice

sometime between 3.x and 4.x development

If you have that folder, you will probably find a "4" and a "3" in
there. Make sure LO isn't running (including the quickstarter, if you
have it) and move both to somewhere else or rename them and then restart LO.

I'm using the version of LO that is packaged with CentOS 6.5. It might
not be cutting edge, but it's supposed to work. That's what CentOS is
all about.

If none of the above works, this might be a problem for the CentOS
forums to help you with.

Alex

#5

Hey Alex,

Your a good man. I found .config/libreoffice. I moved it to
.config/libreoffice.old then started LO Writer. I set the java
association to Oracle Corporation 1.7.0_51 then restarted LO.

I then created a new DB and created a new table inside, closed it, then
restarted it. The table is now accessible.

Now to get my first real DB built, but that's another thread. :wink: