Hello everybody, often I help to solve Base problems on Italian OO forum and I download and modify files .odb loaded by users.
Sometimes, when I reopen a Form after saved it, I obtain this error:"SfxBaseModel::loadFromStorage: 0xf26" and it does'n work more.
That does'nt happen with my databases, writed by me.
I use LibreOffice 6.4.6.2 with macOS 10.12 Sierra.
Can you helpl me? Thanks.
I attach database examples before/after problem (form: "f_anagrafica")
[Solved] "SfxBaseModel::loadFromStorage: 0xf26" Error
- charlie.it
- Volunteer
- Posts: 417
- Joined: Wed Aug 21, 2013 2:12 pm
- Location: Italy
[Solved] "SfxBaseModel::loadFromStorage: 0xf26" Error
Last edited by charlie.it on Fri Mar 12, 2021 1:09 pm, edited 1 time in total.
charlie
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
http://www.charlieopenoffice.altervista.org
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
http://www.charlieopenoffice.altervista.org
Re: "SfxBaseModel::loadFromStorage: 0xf26" Error
Might this simply be a race condition, Charlie? That before you can access the form after modification, there is need for a little time to allow OpenOffice do other housekeeping things before it is ready to permit you access the form.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: "SfxBaseModel::loadFromStorage: 0xf26" Error
Delete the form and replace it with the backup from Before.odb. Drag the form icon from Before.odb to After.odb
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
- charlie.it
- Volunteer
- Posts: 417
- Joined: Wed Aug 21, 2013 2:12 pm
- Location: Italy
Re: "SfxBaseModel::loadFromStorage: 0xf26" Error
@RoryOF, thanks. No the form does'nt work also now. Can you open it? I don't think so.
@Villeroy, thanks. I'm sorry, maybe I haven't explained enough that the form in After file has been modified by placing (right clic > replace with) a listbox on a formatted field and using sql code as content. As long as I don't save, close and reopen the form, the listbox works perfectly. It is something I do normally but in my databases it does not give problems, in those attached by the users of the forum, sometimes it does.
@Villeroy, thanks. I'm sorry, maybe I haven't explained enough that the form in After file has been modified by placing (right clic > replace with) a listbox on a formatted field and using sql code as content. As long as I don't save, close and reopen the form, the listbox works perfectly. It is something I do normally but in my databases it does not give problems, in those attached by the users of the forum, sometimes it does.
charlie
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
http://www.charlieopenoffice.altervista.org
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
http://www.charlieopenoffice.altervista.org
- MrProgrammer
- Moderator
- Posts: 4906
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: "SfxBaseModel::loadFromStorage: 0xf26" Error
The Before.odb file was written by LibreOffice 7.0.4.2 so I think there is an incompatibility between that and your version, or there is a problem with this type of form which one of the versions does not handle correctly. Note that your office:version level is lower than the Before.odb file. Here is what is in f_anagrafica (forms/Obj11/meta.xml):charlie.it wrote:Sometimes, when I reopen a Form after saved it, I obtain this error:"SfxBaseModel::loadFromStorage: 0xf26" and it doesn't work more.
That doesn't happen with my databases, written by me. I use LibreOffice 6.4.6.2 with macOS 10.12 Sierra.
Before → <office:document-meta … office:version="1.3"> Before → <meta:generator>LibreOffice/7.0.4.2$MacOSX_X86_64 … </meta:generator> After → <office:document-meta … office:version="1.2"> After → <meta:generator>LibreOffice/6.4.7.2$MacOSX_X86_64 … </meta:generator>Comparing their content.xml with diff -y, I find:
______________________ Before _______________________________ ______________________ After _______________________________
<office:document-content xmlns:css3t="http://www.w3.org/TR/cs | <office:document-content xmlns:officeooo="http://openoffice.o
> xmlns:drawooo="http://openoffice.org/2010/draw"
> xmlns:calcext="urn:org:documentfoundation:names:experimental:
> xmlns:tableooo="http://openoffice.org/2009/table"
> xmlns:oooc="http://openoffice.org/2004/calc"
> xmlns:ooow="http://openoffice.org/2004/writer"
> xmlns:css3t="http://www.w3.org/TR/css3-text/"
xmlns:field="urn:openoffice:names:experimental:ooo-ms-interop <
xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" <
xmlns:loext="urn:org:documentfoundation:names:experimental:of <
xmlns:officeooo="http://openoffice.org/2009/office" <
> xmlns:rpt="http://openoffice.org/2005/report"
xmlns:tableooo="http://openoffice.org/2009/table" <
xmlns:rpt="http://openoffice.org/2005/report" <
xmlns:of="urn:oasis:names:tc:opendocument:xmlns:of:1.2" <
xmlns:dc="http://purl.org/dc/elements/1.1/" <
xmlns:calcext="urn:org:documentfoundation:names:experimental: <
xmlns:oooc="http://openoffice.org/2004/calc" <
xmlns:drawooo="http://openoffice.org/2010/draw" <
xmlns:ooo="http://openoffice.org/2004/office" | xmlns:field="urn:openoffice:names:experimental:ooo-ms-interop
xmlns:ooow="http://openoffice.org/2004/writer" | xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0"
xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compat <
> xmlns:dc="http://purl.org/dc/elements/1.1/"
> xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compat
> xmlns:loext="urn:org:documentfoundation:names:experimental:of
> xmlns:ooo="http://openoffice.org/2004/office"
> xmlns:of="urn:oasis:names:tc:opendocument:xmlns:of:1.2"
office:version="1.3"> | office:version="1.2">
> <style:style style:name="gr3" style:family="graphic"
> style:data-style-name="C10000">
> <style:graphic-properties fo:background-color="#dddddd" />
> </style:style>
> <number:number-style style:name="C10000" number:language="it"
> number:country="IT">
> <number:number number:min-integer-digits="1" />
> </number:number-style>
xml:id="control8" form:id="control8" form:current-value="0" | xml:id="control8" form:id="control8" form:value="0"
form:value="0" form:data-field="Numero Tessera" | form:data-field="Numero Tessera" form:input-required="true"
form:input-required="true" form:convert-empty-to-null="true" | form:convert-empty-to-null="true" form:min-value="0"
form:min-value="0" form:max-value="100000"> | form:max-value="100000">
<form:text form:name="txtcome ci hai conosciuto" | <form:listbox form:name="txtcome ci hai conosciuto"
form:control-implementation="ooo:com.sun.star.form.component. | form:control-implementation="ooo:com.sun.star.form.component.
xml:id="control28" form:id="control28" form:input-required="f | xml:id="control28" form:id="control28" form:dropdown="true"
form:convert-empty-to-null="true"> | form:data-field="come ci hai conosciuto"
> form:input-required="false" form:bound-column="1"
> form:list-source-type="sql"
> form:list-source="SELECT "come ci hai conosciuto",
>
office:string-value="com.sun.star.form.control.TextField" /> | office:string-value="com.sun.star.form.control.ListBox" />
> <form:list-property form:property-name="DefaultSelection"
> office:value-type="float" />
> <form:list-property form:property-name="TypedItemList"
> office:value-type="float" />
</form:text> | </form:listbox>
<draw:control draw:name="Forma3" draw:style-name="gr2" | <draw:control draw:name="Forma3" draw:style-name="gr3"
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
-
- Posts: 34
- Joined: Sun Mar 01, 2015 3:34 am
Re: "SfxBaseModel::loadFromStorage: 0xf26" Error
This is a known bug in LibreOffice. V6.x to v7.0 is OK. Anything created or modified in v7.0 then modified in earlier versions have the problem. Can edit to resolve.
https://bugs.documentfoundation.org/sho ... ?id=138209
Comments there to fix a form or not use ODF-version 1.3
https://bugs.documentfoundation.org/sho ... ?id=138209
Comments there to fix a form or not use ODF-version 1.3
LibreOffice 7.0.2.2
OpenOffice 4.0.1
Ubuntu Mate 20.04.1
Mint 20.3
OpenOffice 4.0.1
Ubuntu Mate 20.04.1
Mint 20.3
Re: "SfxBaseModel::loadFromStorage: 0xf26" Error
Oh, this is bad. I thought it was a random problem with one of my forms and just restored it from backup. Good to know. Am I right that it is necessary to create a second version of a form when editing with LO 7.0 is inevitable?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 34
- Joined: Sun Mar 01, 2015 3:34 am
Re: "SfxBaseModel::loadFromStorage: 0xf26" Error
@Villeroy not certain creating a second form is the way to go. Possibly up to each as their situation dictates.
One solution is to set LibreOffice to not use ODF-version 1.3. This is in Tools->Options under Load/Save->General. Another is when the error occurs to modify the content.xml file for the form and set it back to:
office:version="1.3"
The 1.3 is set in LO 7.x and when modified in v6.x it is set to 1.2 and then will produce the error and not work. Changing it back to 1.3 gets it working again.
Which direction to take is up to each person. If enough switching between versions, possibly setting LO to 1.2 but then 1.3 benefits (don't know what this may be) are lost. I have taken the route of setting LO to 1.2 Extended and all seems fine thus far.
One solution is to set LibreOffice to not use ODF-version 1.3. This is in Tools->Options under Load/Save->General. Another is when the error occurs to modify the content.xml file for the form and set it back to:
office:version="1.3"
The 1.3 is set in LO 7.x and when modified in v6.x it is set to 1.2 and then will produce the error and not work. Changing it back to 1.3 gets it working again.
Which direction to take is up to each person. If enough switching between versions, possibly setting LO to 1.2 but then 1.3 benefits (don't know what this may be) are lost. I have taken the route of setting LO to 1.2 Extended and all seems fine thus far.
LibreOffice 7.0.2.2
OpenOffice 4.0.1
Ubuntu Mate 20.04.1
Mint 20.3
OpenOffice 4.0.1
Ubuntu Mate 20.04.1
Mint 20.3
- charlie.it
- Volunteer
- Posts: 417
- Joined: Wed Aug 21, 2013 2:12 pm
- Location: Italy
Re: "SfxBaseModel::loadFromStorage: 0xf26" Error
For me was important to understand what happens, not repair the After.odb file.
Thanks to @MrProgrammer and @Ratslinger I understood that the error occurs when I open an save a file.odb created with 1.3 ODF version, using the 1.2 version of LibreOffice 6.x.x.
Thanks to all.
Thanks to @MrProgrammer and @Ratslinger I understood that the error occurs when I open an save a file.odb created with 1.3 ODF version, using the 1.2 version of LibreOffice 6.x.x.
Thanks to all.
charlie
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
http://www.charlieopenoffice.altervista.org
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1
http://www.charlieopenoffice.altervista.org