Page 1 of 1

[Solved] Can't add photos to database

PostPosted: Sat Mar 20, 2021 12:51 pm
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.

Re: Can't add photos to database

PostPosted: Sat Mar 20, 2021 1:03 pm
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.

Re: Can't add photos to database

PostPosted: Sat Mar 20, 2021 5:14 pm
by UnklDonald418