docspell Error with smtp setting page

When I filled in a new smtp on the settings page for outlook.com, I got the following error which I suspect is coming from the database:

Internal error: ERROR: INSERT has more expressions than target columns Position: 194

Any help will be appreciated.

Jul 05 '25 10:07 GenesisAdam

Hi @GenesisAdam , sorry for that. Yes, that is bug :-(. As a workaround for now, you could insert it "by hand" using SQL. To generate an id, this little bash script could do:

full_id=$(openssl rand -base64 40 | head -c 44)
echo "${full_id:0:11}-${full_id:11:11}-${full_id:22:11}-${full_id:33:11}"

Just repeat until only alphanumeric characters appear (base64 might add + and /).

The table to insert into is useremail. The uid column refers to an existing user (in table user_).

Just to be sure, I'd do a db backup before :-)

Jul 08 '25 08:07 eikek

Thanks. I will wait until the bug is fixed in a new release/update. Just let me know when it's done. I hate to mess around the database/

Jul 08 '25 14:07 GenesisAdam