Libreoffice Base and Mysql issue

English
#1

I am using Ubuntu 22.04.4 x64, Libreoffice 7.6.6.3, and Mysql 8.0.36. The following is what occurred with LO Base.

I created a new database in MySQL with MySQL Workbench. and populated a few tables to get thing started. I then went to Base and found that it had included my new database in the listing of the DBs of which it was aware, In addition, it had created 4 forms, one for each table in the database with all fields available to add additional records. I was attempting to modify one of those forms when it would no longer respond. I was forced into stopping the process by killing it in the System Monitor. After that, I could not get the form to function correctly.

My question is this: if I completely remove the bad table form and go back to MySQL and enter more data, will LO Base become aware of the table again and create the form for the table that does not have a working one at this time?

#2

I have never seen Base creating a “form” without my command. So I would trust Base to show you all tables of the connected MySQL database. Auto-generation of forms I would not expect, besides the usual grid-view you find in the tables-section from Base.
.
But you may just copy your .odb and continue with the copy (or kee) the copy as backup of current state.
In your .odb you will find only the forms and queries you designed in Base. The tables with data are stored in MySQL.

#3

@cscj01 : In Base there will be different folders for tables, queries, forms and reports. When reading the description you are writing about “forms”, but what you are seeing are tables. You could input data into the tables.

If a table doesn’t respond: What is the error it produces. Or doesn’t exist any error dialog?

#4

I had never seen this happen before either. I starting using Open Office as a front end to my Mysql data bases years ago, and this is the first time I had opened Base to find Forms (and I do mean forms, not tables. I known what tables look like, and I know what forms look like). Before this occurrence, I had always had to register the data base in OO or LO and then design the forms. I did none of that this time.

#5

I suppose I could delete the .odb file for this data base, re-register the data base with LO, and design my forms from scratch as I have always done, but I was wondering if I could just delete the one form in the .obd that is not functioning and redo that one.

#6

You could delete any form and create it new. You could create forms by starting the form wizard or you could start to create the form on a blank page.

There has never been a function to automatically generate forms. I wonder if you have connected to MySQL/MariaDB by an old *.odb-file, which contains forms.

#7

I have resolved my issue, but it isn’t a solution in the software sense. I had a copy of this .odb file from September on one of my backup drives. I copied it over the one I could not make work, and now things are working as they should. I tried everything I knew from de-registering the DB from LO to editing the .obd that wasn’t working to … Now things are working. I have no idea what went wrong, but I no longer care because it is working again.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.