Document URL when moving from WAMP or XXAMP to Linux

juggernautsei · December 21, 2022, 12:46pm

I have done a lot of upgrades and relocation of OpenEMR. The question has come up again about the documents URL in the documents table.

  file://C:/xampp/htdocs/openemr/sites/default/documents/10/Financial_Policy.pdf

My question is how important is everything before the /documents/10?

Is there a need to update the URL?

@brady.miller
@mdsupport

stephenwaite · December 21, 2022, 1:41pm

github.com/openemr/openemr

Absolute path to documents stored in database, rather than a path relative to the site root

opened 05:15PM - 16 Sep 22 UTC

tsimonq2

Enhancement

*(As a quick note to start, this work is being driven by my employer, [Altispeed… Technologies](https://altispeed.com/). I'm actively working on this issue. Any screenshots shown use test data, and are not associated with any real patient.)* I was writing a script to verify that all documents present in the database are also present on the filesystem. When we migrated to using a Git-based workflow, we re-deployed it from `/var/www/openemr` to `/var/www/emr.DOMAIN.TLD`, a use case I would not consider to be rare. However, querying the `url` column from the `documents` table, I'm finding an entry like such: `file:///var/www/openemr/sites/default/documents/12/MY_ID_HERE`. Ideally, this would be shortened to `file:///OE_SITE_WEBROOT/sites/default/documents/12/MY_ID_HERE` or similar. I'd like to remove the hackiness from my script while benefitting upstream. I also know that the multi-site module may need to be taken into consideration, and since we don't have such a setup, advice would be appreciated. Here's part of my script: `SELECT REGEXP_REPLACE(url, '(.+)/sites/default/documents', '/sites/default/documents') AS url FROM documents WHERE deleted = 0` - is there a global variable or database value I could use to substitute `default`? Thanks.

mdsupport · December 22, 2022, 6:52am

Look at function _check_relocation in PR#414.