Undo custom domain in vsite?

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
rpoyner's picture

Hosed my openscholar site this morning and I'm wondering if there is a graceful way to back out.

I set a private domain: prof.dept.u.edu for a working site: openscholar.dept.u.edu/openscholar/prof

Stupidly I did not add the prof.dept.u.edu domain as a cname to the server. Not that it would matter much since I can't edit the apache config to point the prof.dept domain at the openscholar directory.

Now when I try to load: openscholar.dept.u.edu/openscholar/prof I get redirected to prof.dept.u.edu with a link broken message. Which means I can't get to the control panel for the prof site to un-do the damage.

I'm thinking maybe I could go in through phpmyadmin and delete the offending record...if I new the table. Or maybe there's a way to do it through drupal that I'm missing.

TIA

Comments

Reverting back with PMA

rbrandon's picture

Until the next version of openscholar it is stored in the {spaces_settings} table.

Where:
sid, is the sites nid
type = "og"
id = "generic"

You can just delete that whole row along with the row in the purl table WHERE
id = sid
provider = "vsite_domain".

You should then have access to go back in and change the settings.

-Richard

Worked like a charm

rpoyner's picture

Many thanks

Did the Same

mohhess's picture

Hey, I'm struggling with same problem. I'm trying to change between two custom domains, but the old one is down and I cannot access my site. When I try to edit my site using my admin account it won't let me. I'm using the newest version of openscholar. Any thoughts on where to go in the database?

Spaces_overrides

mohhess's picture

I solved it. I'll post this for others who might need it.

spaces_overrides is the ticket...or uh table needed :). I wasn't it finding it there before, but then I realized there were multiple pages. Find the row mentioning domain and the custom one that you made and delete that row. Flush caches (browser and drupal) and your site should be back up.