we're about to migrate to a new server, with a new address. i'm trying to find any remaining hard-coded URLs to the old server address. If I remember correctly, wiki content is actually stored in postgres. Can I do a query within postgres to find any page containing 'xnight.primate.wisc.edu'? i'd plan to correct these through labkey, but a side-wide way to find them would help.
are there other places in the DB where a URL might be hard coded? maybe the URLs in property descriptors?
thanks,
ben |
| |
| marki responded: |
2011-05-10 11:54 |
You should be able to query in the wiki schema to get this. You would want to query the body property of the comm.pageversions table joined to the comm.pages table to identify the current version of each page.
Property descirptors should be identified by unchanging URIs (not technically URLs) so don't update those, but the url property used to generate URLs in columns might be interesting to look at. It's likely all of those are in your custom module, however. |
| |
| Ben Bimber responded: |
2011-05-10 12:05 |
hi mark,
thanks. right, the URL field is what i was thinking of. i'm mostly worried about things others might have defined for lists and things. the EHR should be strictly defined in the code. i dont need to change them, but it'd be nice to make a list to alert people if their pages are going to break.
-ben |
| |
|
|