Ask Your Question

Error message in Base: The data content could not be loaded. Invalid Descriptor index.

asked 2019-04-11 12:47:40 +0100

Martin691 gravatar image


I have upgraded Libre Office from version 5 to 6.1 and now I am getting the error message.

I also installed a later version of ODBC, which you can see here: image description image description

When I then open up the file, I then get this message: image description

I can then click on OK, and the search functionality on the right side of the screen works, so I can see it connects to the database, but the left hand side of the screen doesn't work, and I cannot retrieve the details that I see on the right hand side of the screen in the search area.

Any ideas what my problem may be?

Thanks is advance.


edit retag flag offensive close merge delete


Thank you, very much.

This worked. Unzipping the file, changing the content, re-zipping it and renaming it didn't work, as the file became corrupt. But right clicking on it and selecting '7-zip' - 'Open Archive', then editing the content.xml file seemed to work. This requires that 7-zip is installed.

I don't really understand the logic in this. Is this a bug? Can no-one use MYSQL and LibreOffice Base without this knowledge? Is this going to be fixed in future versions? Would it be wiser to stick with version 6.0 of Libre Office?

Is it recommended that I be connecting with JDBC or another method.

Sorry to ask so many questions.

Martin691 gravatar imageMartin691 ( 2019-04-11 21:58:34 +0100 )edit


Please do not respond with an answer - use add a comment. Answers are to respond to original question.

Had you read the comments attached to the answer in my link, you would not have questions. Also if you used my code, the zipping would not have been necessary.

Ratslinger gravatar imageRatslinger ( 2019-04-11 22:32:47 +0100 )edit

Noted - add a comment. I re-read your comments, a few times, but it's not really answering my questions, but that's probably just me. Thank you anyway.

Martin691 gravatar imageMartin691 ( 2019-04-11 22:43:46 +0100 )edit


The comments mention this setting should be part of database Advanced Settings (from main odb menu -> Edit->Database->Advanced settings.... There are also noted links to bug reports (tdf#'s - these are links to the actual bug reports, just click on them) in both the answer & comments.

It's obvious you cannot use it unless you apply the fix. When the bug is fixed the problem will go away. Sticking with 6.0.x seems a bit drastic seeing as it takes 5 seconds to run the fix I have provided (you avoided it and took the long route).

Ratslinger gravatar imageRatslinger ( 2019-04-11 23:29:32 +0100 )edit

Thank you.

Martin691 gravatar imageMartin691 ( 2019-04-12 09:45:33 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-04-11 16:58:01 +0100

Ratslinger gravatar image


This is not unique to ODBC. Also is a problem with JDBC, SDBC and Firebird.

Please see my answer in this post -> Form got broken with Libreoffice Base version and later [MySQL(ODBC)] for method to fix the problem.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-04-11 12:47:40 +0100

Seen: 298 times

Last updated: Apr 11 '19