Page 1 of 1

[Solved] Error in LibreOffice Base Access2Base Module 'Apn'

Posted: Fri Mar 24, 2017 7:15 pm
by Frie
Today I've upgraded LibreOffice to 5.3.1.2 but now I have Macro's that produce an error.

I have done some programming in Base with Access2Base but now the database connection gives an error in Sub DBOpen as it does not recognize 'ThisDataBaseDocument' any more.

When I try to execute the Access2Base module 'Application' in the editor screen it gives the following error:

BASIC syntax error. Expected: )

and it stops in Function HtmlEncode, where indeed the ")" is missing in line:

sOutput = sOutput & Utils._UTF8Encode(Mid(pvString, l, 1).

Who can help me?

Re: Error in LibreOffice Base Access2Base Module 'Applicatio

Posted: Fri Mar 24, 2017 8:01 pm
by Villeroy
The error is obvious, isn't it?
The latest version of LibreOffice seems to have a problem with trailing braces when they are missing. All other versions had no problem with this syntax error.

Re: Error in LibreOffice Base Access2Base Module 'Applicatio

Posted: Fri Mar 24, 2017 8:29 pm
by Frie
Thank you, but who is going to solve this? Who should I contact?

Re: Error in LibreOffice Base Access2Base Module 'Applicatio

Posted: Fri Mar 24, 2017 9:32 pm
by Villeroy
Frie wrote:Thank you, but who is going to solve this? Who should I contact?
The problem is known already: https://bugs.documentfoundation.org/sho ... ?id=106529

Re: Error in LibreOffice Base Access2Base Module 'Applicatio

Posted: Sat Mar 25, 2017 11:27 pm
by Villeroy
I attached to bug report https://bugs.documentfoundation.org/sho ... ?id=106529 a zip archive to fix all Basic modules shipped with LO 5.3.1.2.
https://bugs.documentfoundation.org/att ... ?id=132144
Shut down LO completely and run:

Code: Select all

sudo unzip -o ~/Downloads/fixed_basic_modules.zip  -d /opt/libreoffice5.3/share/basic/
where ~/Downloads/fixed_basic_modules.zip is the zip file in the current user's Downloads folder and /opt/libreoffice5.3/share/basic/ is the basic folder in my installation path of LO 5.3.1.2.