Libre office base error simply saving a table

[grafenocarbono]

Hi Geeks,

I am using LibreOffice Base.

When I try to save a table the following message appears:

I have tracked some tracks:

Mar 11 09:51:13 machine audit[13275]: AVC apparmor="ALLOWED" operation="open" class="file" profile="libreoffice-soffice" name="/sys/fs/cgroup/user.slice/user-1001.slice/user@1001.service/app.slice/app-gnome-libreoffice-13240.scope/memory.max" pid=13275 comm=433220436F6D70696C657254687265 requested_mask="r" denied_mask="r" fsuid=1001 ouid=1001
Mar 11 09:51:13 machine kernel: audit: type=1400 audit(1710147073.264:463): apparmor="ALLOWED" operation="open" class="file" profile="libreoffice-soffice" name="/sys/fs/cgroup/user.slice/user-1001.slice/user@1001.service/app.slice/app-gnome-libreoffice-13240.scope/memory.max" pid=13275 comm=433220436F6D70696C657254687265 requested_mask="r" denied_mask="r" fsuid=1001 ouid=1001

I leave you the characteristics of my OS:

base) grafeno30@machine:~$ cat /etc/os-release
PRETTY_NAME=“Ubuntu 22.04.4 LTS”
NAME=“Ubuntu”
VERSION_ID=“22.04”
VERSION=“22.04.4 LTS (Jammy Jellyfish)”
VERSION_CODENAME=jammy
ID=ubuntu
ID_LIKE=debian

(base) grafeno30@machine:~$ cat /etc/lsb-release
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=22.04
DISTRIB_CODENAME=jammy
DISTRIB_DESCRIPTION=“Ubuntu 22.04.4 LTS”

Thanks in advance!

[RobertG]

Same problem posted 2 hours before.

More information about the database needed:
Do you use internal HSQLDB?
Did you create the table or did you try to change the table?
Did you create relations in Base → Tools → Relations?
Did you create view?

[Villeroy]

Looks like a problem with apparmor. In case of an embedded HSQLDB, the actual database resides in a temporary folder. Open Tools>Options>LibreOffice>Paths, set up some temporary path in your home directory, restart the office and see if it makes a difference.

[grafenocarbono]

When a student try to save his form appears the following message:

​journalctl -f

mar 15 18:04:42 alien tracker-extract[6220]: No member 'meta.xml' in zip file 'file:///home/grafeno30/Downloads/Eduardo%201%C2%BASMR%20-%20Crear%20formularios%20en%20LibreOffice%20Base.zip.odb'726166656E6F33302F446F776E6C6F6164732F4564756172646F2031C2BA5mar 15 18:05:13 alien gnome-shell[1814]: meta_wayland_pointer_set_focus: assertion 'meta_cursor_tracker_get_pointer_visible (cursor_tracker) || clutter_seat_is_unfocus_inhibited (clutter_seat) || surface == NULL' failedid=5687 comm=554E4F20416666696E6542mar 15 18:04:42 alien kernel: audit: type=1400 audit(1710522282.190:188): apparmor="ALLOWED" operation="unlink" class="file" profile="libreoffice-soffice" name=2F686F6D652F67726166656E6F33302F446F776E6C6F6164732F4564756172646F2031C2BA534D52202D2043726561 220666F726D756C6172696F7320656E204C696272654F666669636520426173652E7A69702E6F64622E6C636B pid=5687 comm=554E4F20416666696E65427220666F726D756C6172696F7320656E204C696272654F666669636520426173652E7A69702E6F64622E6C636B pid=5687 comm=554E4F20416666696E654272696467 requested_mask="d" denied_mask="d" fsuid=1000 ouid=1000' in zip file 'file:///home/grafeno30/Downloads/Eduardo%201%C2%mar 15 18:04:42 alien tracker-extract[6220]: No member 'meta.xml' in zip file 'file:///home/grafeno30/Downloads/Eduardo%201%C2%BASMR%20-%20Crear%20formularios%20en%20LibreOffice%20Base.zip.odb'focus: assertion 'meta_cursor_tracker_get_pointer_visible (cumar 15 18:05:13 alien gnome-shell[1814]: meta_wayland_pointer_set_focus: assertion 'meta_cursor_tracker_get_pointer_visible (cursor_tracker) || clutter_seat_is_unfocus_inhibited (clutter_seat) || surface == NULL' failed

I don´t understand…

Thanks in Advance. Thank you

[RobertG]

Have a look at the update the student wants to save. One of the fields should be filled by a value, which couldn’t be saved in the field.

Example: There is defined a field “name” as VARCHAR(25) and there will be tried to insert content with 26 or more characters.

So open the table for editing, look in field properties for “Length”.