Hi Mitch, thanks for the reply.
The problem is that I really don't know how to watch the database and do that. I did refresh the table view in the enterprise manager that my host provides and was able to see it change, but there isn't really any trigger for it, other than simply going into the editor mode. Hmm, I guess that's the trigger.. editing the module? The browser and OS make no difference to the issue - I've tried Firefox and IE6/7 and XP, Vista and OSX.
I've just spent the afternoon creating accounts and pages and adding modules to try and narrow down what is happening.
The CSS Tabs module is the one that lets me test for it easiest because it switches immediately back to the opposite editor mode as soon as one tries to change modes. Naturally, no other modules are present on the page when any of the modules is in edit mode.
I think I've discovered that the problem is not that it reverts to plain text mode, but simply that it reverts. I now have one portal with one user where the module is stuck in rich text mode and another portal with another user where the CSS Tabs module is stuck in plain text mode. Other modules such as the Text/HTML are also affected in the same manner.
It seems like particular portals are affected.. almost like they catch an illness. Other virtually identical portals remain unaffected. It looks to me like the editor within the modules is responding to the personalization setting in the db, and that something else keeps forcing that setting back to one way or the other.
I'm a little suspicious that the editor might be receiving conflicting personalization settings when user accounts exist in more than one portal - some of my users have more than one portal and most of them also have a matching account in the top-level portal for support purposes. Could that be a problem? I've been trying to test for that, but haven't been able to confirm it.
If I knew more about what affects the personalization settings and when and how it happens, I'm sure I'd be on the right track. I'm reaching a point where I'd be prepared to pay something to have this fixed. It's wrecking all my plans... anyone? Help? eek!
Rob