Bug 144000 - MAILMERGE: LO crashes on any mailmerge attempt - because of three-letter registered database name?
Summary: MAILMERGE: LO crashes on any mailmerge attempt - because of three-letter reg...
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
7.1.5.2 release
Hardware: x86-64 (AMD64) Windows (All)
: low normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-08-22 01:18 UTC by Michael Boxall
Modified: 2022-11-26 03:42 UTC (History)
3 users (show)

See Also:
Crash report or crash signature: 4cbfc450-1868-421c-8c85-e0327275c6c6


Attachments
Example of an ODT file causing the crash (19.56 KB, application/vnd.oasis.opendocument.text)
2021-08-24 09:29 UTC, Michael Boxall
Details
My registered databases (48.55 KB, image/jpeg)
2021-08-25 16:24 UTC, Michael Boxall
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Michael Boxall 2021-08-22 01:18:02 UTC
Mailmerge files that have been in use for a long period no longer work.
Ctrl-P -> 'Do you want to print a form letter?'
Reply 'Y' -> LO crashes
A blank document recovery window appears briefly but then closes.
This happens with any mailmerge ODT file containing even a single merge field.

The problem first occurred on moving to the 'early adopter' version of LO a few updates ago. I can't remember exactly which version this was: most likely 7.1.3.
Comment 1 Roman Kuznetsov 2021-08-24 08:09:38 UTC Comment hidden (obsolete)
Comment 2 Michael Boxall 2021-08-24 09:29:46 UTC
Created attachment 174513 [details]
Example of an ODT file causing the crash

This attachment is the file being used when the linked crash report was created, but LO crashes with any file containing a mail merge field, including a file that contains nothing but a single field. Using an earlier version of LO (7.1.1.2) on a different computer, the same file is processed OK:
Ctrl-P -> 'Do you want to print a form letter?'
Y -> 'Data Source not found'
Comment 3 Roman Kuznetsov 2021-08-24 09:45:10 UTC
No problem in 7.1.0.3, nor in 7.2.0.4, nor in current master build. I just see a warning message about checking a data source


Version: 7.2.0.4 (x64) / LibreOffice Community
Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Vulkan; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: threaded
Comment 4 Alex Thurgood 2021-08-24 10:35:53 UTC
The ODT references a database called :

Pastoral

having a table HITN_print.

If that database table is no longer registered with the version of LibreOffice that you are using, it will often cause a crash.

Have you checked under :

Tools > Options > LibreOffice Base > Databases

that your Pastoral database is registered with that version of LibreOffice ?

If you had previously created an access to this database via the Writer menu 

Edit > Exchange database 

you might find that you have to do this again, as possibly, and I say possibly, the installation of 7.1.5.2 has overwritten your user configuration setting.

Can you check all of these and report back ?
Comment 5 Alex Thurgood 2021-08-24 10:38:13 UTC
FWIW, I don't get a crash with

Version: 7.1.5.2 / LibreOffice Community
Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5
CPU threads: 8; OS: Mac OS X 10.16; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded

rather I get an error message indicating that the datasource is unavailable and asking me whether I want to correct that. If I do, I get sent to the datasource configuration section under Tools > Options > LibreOffice Base > Databases that I indicated in my previous response.
Comment 6 Alex Thurgood 2021-08-24 10:39:16 UTC
@Michael,: whatever the case, you shouldn't get a crash.
Comment 7 Michael Boxall 2021-08-25 16:24:59 UTC
Created attachment 174534 [details]
My registered databases

Alex, thanks ever so much for pointing me in the right direction. I now have mail merge working. Nevertheless I think there is a bug in recent versions of LibreOffice.

The new version of LibreOffice hadn't overwritten any settings and my databases were still registered OK (the attachment shows how they were). One has an out-of-date path (date in the folder name) and so seems like a possible culprit. Surely LibreOffice doesn't crash just because a file doesn't exist? - nevertheless, deleting this registered database from the list got things working again.

But it turns out that the invalid path wasn't the problem: rather, LibreOffice doesn't like the three-letter registered name (agm). I haven't tested exhaustively, but I'm fairly sure that if any entry in the Registered Databases list has a name <= 3 characters, LibreOffice crashes on attempting a mail merge (the merge doesn't have to relate to the database in question). The problem didn't always exist because I had been using that three-letter registered name (agm) for several years.

I don't have the expertise to pursue this further. Can I leave it with you to try and reproduce the problem, and change the bug report (or create a new one) as you see fit?

Thanks again for you help.
Comment 8 QA Administrators 2021-08-26 03:47:45 UTC Comment hidden (obsolete)
Comment 9 Timur 2021-09-10 13:19:16 UTC
I tried to test this, made 3 letters name, had some crashes, but they are not reproducible.
Comment 10 Timur 2022-04-28 11:25:58 UTC
Problem here is that it wasn't reproducible.
You can only test with Lo 7.3.3 as there were some fixes there.
On https://www.libreoffice.org/download/download/ it's in Prerelease now.
Comment 11 QA Administrators 2022-10-26 03:36:23 UTC Comment hidden (obsolete)
Comment 12 QA Administrators 2022-11-26 03:42:48 UTC
Dear Michael Boxall,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-FollowUp