I've created a database in OpenOffice 4.1.9 which includes a photo. When I enter photos into the database I get so far and then I get a message saying:
SQL Status: S1000
Error code: 40
S1000 General error java.lang.NullPointerException in statement [UPDATE "Members" SET "Photo" = ? WHERE "ID" = ?]
How can I correct this problem. At the present time the database is only about 1.3 MB.
Thanks in advance.
[Solved] Can't add photos to database
-
- Posts: 1
- Joined: Sat Mar 20, 2021 12:42 pm
[Solved] Can't add photos to database
Last edited by 63 Spartan on Sun Mar 21, 2021 8:20 pm, edited 1 time in total.
OpenOffice 4.1.9 Windows 10
Re: Can't add photos to database
You can try the suggestion in https://ask.libreoffice.org/en/question ... e-code-40/ - basically you don't include the pictures in the embedded database at all, or you keep them in a split database file.
OpenOffice 4.1.11 on Ubuntu; LibreOffice 6.4 on Linux Mint, LibreOffice 7.6.2.1 on Ubuntu
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
-
- Volunteer
- Posts: 1548
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: Can't add photos to database
Also see [Tutorial] Pictures in Base]
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11