CiviCRM Community Forums (archive)

civicrm_uf_match

i've not read the details of your stuff closely enough, but in general swapping the userID in the tables is not recommended (IMO). CiviCRM does a lot of caching and does not invalidate the cache (since it does no expect the userID to change underneath it)

lobo

Perfect, one of the few tables I didn't click on LOL, thank you very much, are there any other ramifications of changing this value that anyone can come up with to discredit this solution, I honestly don't know so I genuinely am looking for feedback, I also posted in the feature request of some sort of reasonable faccimilee for this type of functionality.

Simply changing the ID seems to be the far easier solution in terms of cost (coding time) to deploy a solution and I'm already behind the deadline so I'm not really enthused about reading a mountain of API docs and implimenting a really complex solution. 

Thank you for bringing up the cache issue, you are absolutely right, simply changing the FKey of the civicrm Contact ID does and refreshing the Edit CIVICRM Profile page does not have the desire results, CiviCRM 'remembers' the old id via the cache -- is that a DB Cache or cookie or how does that store?

Is there an API Call or way to expire or reload the cache programatically?  Obviously logging completely out of my CMS and logging back in has the desired effect, and I am actually prepared to accept that as a fact of life (I can sell it as switching members requires you to "validate" your password LOL) but obviously making the switch transparent to the user is vastly the preferred solution.

Thanks!

David