Skip to main content

Tinymce Issue on Drupal Upgrade

After an upgrade, I was having trouble viewing some pages due to a number of errors. They all revolved around missing tables for tinymce.

I was able to solve this by creating two tables: tinymce_role and tinymce_settings.

The SQL to generate these two tables is:

CREATE TABLE `tinymce_role` (
    `name` varchar(128) NOT NULL default '',
    `rid` tinyint(3) unsigned NOT NULL default '0',
    UNIQUE KEY `name` (`name`,`rid`)

CREATE TABLE `tinymce_settings` (
    `name` varchar(128) NOT NULL default '',
    `settings` text NOT NULL,
    PRIMARY KEY  (`name`)

After running this, I was able to successfully run the update script to correct other missing dependencies.

UPDATE (04 March 2015): I never annotated what version of Drupal this was with. If my memory is correct, this is with something in the 5.x range of versions. Furhter, this was in MySQL, prior to my migration from MySQL to PostgreSQL.