when using subdirectory parent field shows subdirectory

[disgustipated]

When i download work packages in the excel document with the macro, the parent field has my subdirectory and then the parent id. example the parent id would be /openproject106 if the parent in the work packages is 106 and my subdirectory is openproject in the web url. this causes problems when i try to upload changes back.

I have the following options set in the container, i followed the steps from the openproject install documentation

    environment:
      - OPENPROJECT_HOST__NAME=servername
      - OPENPROJECT_SECRET_KEY_BASE=${openproject_secret}
      - OPENPROJECT_RAILS__RELATIVE__URL__ROOT=/openproject
      - OPENPROJECT_HTTPS=true
      - DATABASE_URL=${openproject_db_string}

nginx is configured like this

    location /openproject {
        proxy_set_header Host $host;
        proxy_set_header X-Real-IP  $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header X-Forwarded-Proto https;

        proxy_pass http://localhost:9600/openproject;
    }

everything else related to the system with the subdirectory seems to be working ok as far as i can tell