Our guess is that the value of the upload_path option in the wp_options table of the target database is defined to a custom value rather than null. In that case, WordPress would not be able to select it.

Then you can go to the target site > in the database > find the upload_path in wp_options > modify the the value the option to null.