cms_site | Lift CMS site | Content Management System library

I created a dev instance of my Kentico sites from a copy of my staging instance. I changed all the site display names in the Sites admin module to denote that these were now all the dev sites instead of staging ones and it broke all my sites by setting the SiteDefaultStyleheetID and SiteDefaultEditorStylesheet columns to NULL on the CMS_Site table for each renamed site.

To be clear, I did not mess with any site code names when I did this. They all stayed the same. I also created this dev instance by copying the entire file system (7-zipped) and db (created a .bak file) from the staging server to a dev server. I didn't do any export or importing of sites to create this dev instance.

What's more, the "Site CSS stylesheet:" and "Editor CSS stylesheet:" dropdown menus don't display any of the stylesheets assigned to the renamed sites. However, when I check to see if any stylesheets are assigned to those sites under "Assigned Objects", all the appropriate stylesheets show up as assigned to their proper site.

If I brute force the default stylesheet IDs back onto the Site records in SQL, the sites will display properly, but the "Site CSS stylesheet:" and "Editor CSS stylesheet:" dropdown menus ins Sites will remain empty. Also, If I edit the site display names again, the default stylesheet columns get reset to NULL.

Does anyone know if this is intended behavior? Has anyone encountered this before, and if so, how did you remedy the problem?

It looks suspiciously like a bug for such an important part of a site such as a default stylesheet to break simply because the site's display name changed while the integer ID, GUID, and code name all remained the same.