Friday, March 07, 2008

FCKeditor problem with fckeditor_role and fckeditor_settings missing

I've upgraded three different sites from Drupal 5 to Drupal 6.1 and in each case I had problems with the FckEditor module. The error message indicates that two tables can't be found or don't exist, fckeditor_role and fckeditor_settings. I've finally fixed the problem by doing the following:
  1. Login to your site
  2. Click on Administer
  3. Click on Site Building
  4. Click on Modules
  5. Uncheck the "Enable" box next to FCKeditor
  6. Click the "Save Configuration" button
  7. Click the "Uninstall" link next to the title "Modules" at the top of the page
  8. Check the box and uninstall FCKeditor
  9. Now you need to open a connection to your database
  10. Run this script in your database: CREATE TABLE fckeditor_settings ( `name` VARCHAR(128) NOT NULL DEFAULT '', `settings` TEXT DEFAULT NULL, PRIMARY KEY (name) ) /*!40100 DEFAULT CHARACTER SET UTF8 */;
  11. Run this script in your database: CREATE TABLE fckeditor_role ( `name` VARCHAR(128) NOT NULL DEFAULT '', `rid` INT NOT NULL DEFAULT 0, PRIMARY KEY (name, rid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */
  12. Go back to the Modules area of your site, enable FCKeditor, click the "Save Configuration" button.
  13. Run the update.php script
  14. Click on the Administer menu item in your navigation menu
  15. Click on the FCKeditor link
  16. Create a "Global Settings"
  17. Create a "Profile"
That should do it, now you shouldn't receive the nasty red error message anymore and FCKeditor should load just fine!

1 comment:

Anonymous said...

Great workaround, this was driving me up the wall. Thanks!