[Solved] Can't add photos to database

Discuss the database features
Post Reply
63 Spartan
Posts: 1
Joined: Sat Mar 20, 2021 12:42 pm

[Solved] Can't add photos to database

Post by 63 Spartan »

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.
Last edited by 63 Spartan on Sun Mar 21, 2021 8:20 pm, edited 1 time in total.
OpenOffice 4.1.9 Windows 10
User avatar
floris v
Volunteer
Posts: 4423
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: Can't add photos to database

Post by floris v »

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
UnklDonald418
Volunteer
Posts: 1544
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Can't add photos to database

Post by UnklDonald418 »

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
Post Reply