XF 2.3 Old urls in xf_data_registry table displayStyles

[Rob1st]

We moved servers and changed the directory to the root of my domain instead of a subdomain, we followed all the steps and everything is working well expect some image links. The importer worked well and we believed everything was ok, and even checked the DB and performed some replaces where some old urls existed.

In my usertitles I have HTML to an image to display where the user comes from. In the xf_data_registry table for displayStyles, some of these have updated to remove the subdomain and some have not. This is not an editable entry, so not just a replace issue.

an example for the entry showing both urls is:

a:2:{s:12:"username_css";s:0:"";s:10:"user_title";s:86:"<img src="http://www.mydomain.com/flags/southafrica.png"><br>South Africa";}i:37;
a:2:{s:12:"username_css";s:0:"";s:10:"user_title";s:85:"<img src="http://www.forum.mydomain.com/flags/scotland.png"><br>Scotland";}i:39;

Why have some updated to the new url and not others, and what can I do to resolve the issue?

MySQL DB.
XF 2.3.4


Appreciate the assistance.

 

[Jeremy P]

There are various denormalized caches for values (and other processes which need to run in some cases), so we advise against manual database manipulation. In this case you can likely refresh the cached value by editing and saving the username CSS or user title of a user group from the control panel.

 

[Rob1st]

yep, I was trying the edit, but if I changed a little then changed back, all was better again.

Thank you.