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:
- Login to your site
- Click on Administer
- Click on Site Building
- Click on Modules
- Uncheck the "Enable" box next to FCKeditor
- Click the "Save Configuration" button
- Click the "Uninstall" link next to the title "Modules" at the top of the page
- Check the box and uninstall FCKeditor
- Now you need to open a connection to your database
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 */;
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 */
- Go back to the Modules area of your site, enable FCKeditor, click the "Save Configuration" button.
- Run the update.php script
- Click on the Administer menu item in your navigation menu
- Click on the FCKeditor link
- Create a "Global Settings"
- 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:
Great workaround, this was driving me up the wall. Thanks!
Post a Comment