BASE, error: The data content could not be loaded

[ikopanas]

Well I use LibreOffice 6.3.3.2 (x86) BASE to connect through JDBC with MySQL (com.mysql.jdbc.Driver).
Created a new mySQL database with some tables and then some queries stored to BASE which are running without any problems so far.

Then I have created one more query also stored to BASE called:

qOrderServicesByCustomer

When opening gives the results OK which means its correct. But when I create and run a new query based on the initial one

e.g SELECT * from qOrderServicesByCustomer

then I get the error: Unable to Load Data Content

Any ideas out there?
Also I wonder keeping queries to BASE is a good practise? Is it better to save them to MySQL as stored procedures?

[Ratslinger]

Hello,

If in fact you are running 32-bit that may be where the problem lies. Only have 64-bit in which all seems to work without a problem:

Linux Ubuntu 18.04
LO v6.3.3.2
MySQL v5.7.28
JDBC    MySQL(JDBC)

Please verify you are in fact using 32-bit & also please state OS and MySQL version.

[ikopanas]

At first I want really to thank you Ratslinger for your time and advice…

Well I was really using the 32bit LO. So I uninstall and reinstall the 64 bit version.
Here is my configuration now:
Client Side:
Operating System Windows 10-64bit
RAM 4GB
LibreOffice Edition: 6.3.3.2 (x64)
JRE 1.8.0_231
MySQL Connector Java 8.0.18
I also use a static IP via NordVPN to connect to server
Server Side:
Server: Localhost via UNIX socket
Server Type: MariaDB
Server Version: 10.2.27-MariaDB-cll-lve - MariaDB Server

Now my system became unstable and crashes all the time, when working with the LO and the MySQL database… and still getting the message

I wonder what causes the problem… In my opinion could be a memory problem, anyway still getting the message: Unable to Load Data Content and an SQLState: HY000 error during I run some complicated queries that are calling other queries…

I d appreciate any help!

[Ratslinger]

@ikopanas,

Unfortunately abandoned Windows years ago for Linux and don’t have a testing setup for remote DB.

Have tested remote MySQL (not MariaDB) in past and had little problem. This worked with JDBC 5.x connector and also an older native connector not available in current LO version. Had some problems with JDBC 8.x connector but don’t recall if that was for the local or remote connection or both.

Have not experienced the problems you note and have used LO for years now. You may want to try local creation of Base file or even Writer & Calc to see if crashes continue. If not it may the connector or connection string etc.

Other than that it appears to be more of a hands on type of problem. Eliminate items one at a time.

[EasyTrieve]

I got this error message too on GNU/Linux Debian 10.2.

It was after I closed LO and other SQL users, and stopped and restarted the mysql server (maria server actually) with a backup of the /var/lib/msql folder in between. (systemctl stop mysql, … cp -a /var/lib/mysql …, then … systemctl start mysql).

Strange error.

Database server restarted ok with no errors. And I could test the mariadb server at the command line with $ mysql --host=localhost --user='root' -p and show databases;, and I could start my LibreOffice database, but then I got this error, and the tables wouldn’t appear. I checked the connection parameters and made sure that the connection was correct, but still no tables appeared.

The database in question does have a password, and I’m guessing that some sort of cache might have been messed up with it. But you would think restarting the database and LO would clear it. Something else must have been running that was holding this password I think. … Or perhaps I’m on the wrong path and something else was wrong. ???

A system reboot fixed it, thankfully.