Albrechts Blog
from time to time I’ll report some stories about software I’m currently using/configuring etc.
Drupal gotchas
Currently I’m experimenting with Drupal as CMS. Theme adoption works much easier than in Magnolia, which I tried earlier, lots of Modules are available …
But some small glitches are hidden here and there, one such small thing is:
Howto install the CKEditor module after the FCKeditor module was already installed. It failes with some inconsistent database state, not allowing you to configure the access roles for CKEditor.
After reading th source it turned out that the settings migration from FCKEditor to CKEditor somehow fails. It leaves the SQL table ckeditor_settings with only one entry with name ‘CKEditor Global Profile’, the default entries named ‘Default’ and ‘Advanced’ are missing.
Solution: transfer them manually from the fckeditor_editor table, so (I use PostgreSQL) in your SQL commandline extract the settings field associated with Default:
select settings from fckeditor_settings where name=’Default’;
and put it into ckeditor_settings (via copy-pasting that long strange looking settings string):
insert into ckeditor_settings (name,settings) values (‘Default’,’COPY_PASTE_RESULT_FROM_ABOVE_HERE’);
Repeat this for name=’Advanced’;