Syncer error with existing user database when photoUrl column is null

hi, I want to try casdoor with syncer options to sync with existing user database but got this error even though I didn't use that column for sync options. Is there any workaround for this ? Thank you

docker image version: casdoor-all-in-one:v1.407.0

what's your DB and version?

And can you provide a screenshot for the web page just before the previous one?

Mask the username and password

I use postgresql 13.7

ignore those error that the db is not exists, forgot to correct the name sorry

so what is the "photoUrl" in the screenshot?

Can you remove this field for test?

sorry, the screenshot above is actually after I fixed the problem by changing null value to empty string in the database.

It is working now but if I set the database value back to null, I will get the same error even though I don't use the photoUrl column in the sync options (like the screenshot above). Should I create a github issue for this?

You got this issue because that your field "photoUrl" is null?

I don't think this is Casdoor's issue. Setting field to null is just not a good practice. You should make sure that all columns of your DB table get reasonable values before syncing with Casdoor