By twestley on

Drupal version 4.6.1
TinyMCE module version 4.6.0
TinyMCE version 2.0.4
MSIE version 6.0

A total Drupal newbie is trying to install the TinyMCE module following instructions at http://cvs.drupal.org/viewcvs/drupal/contributions/modules/tinymce/INSTA....

I can enable the module in Admin->Modules. When going to Admin->Settings, I get this error message:

user error: Table 'armorbpc_drpl1.tinymce_settings' doesn't exist

and several more. My theme is not applied.

The file upload to my server looks OK as far as file contents is concerned. The server didn't duplicate the dates on my local files so I'm wondering if it didn't duplicate the permissions either. Would that possibly cause a problem like this? Something else? Possibly a version incompatibility?

⋅ Categories: Drupal 4.6.x

Comments

dmitrig01’s picture

dmitrig01 commented

Several fixes.
1. (this is no a fix, but do it anyway. please) GET FIREFOX
2. run the query in the TinyMCE folder somthing.mysql or somthing.pgsql, depending if you are using mysql or postgressql
3. it should work now. hope it does!

twestley’s picture

twestley commented

I was apparently using older/wrong set of instructions. I didn't run tinymce.mysql script which would have setup the missing table. Once I ran that from phpMyAdmin (newbie there too), everything was good. Fortunately, I'm not an SQL newbie (mostly Oracle) so when I read the tinymce.mysql script, it was obvious to me that not running it was the source of my problem.

Moral: follow instructions in the dowloaded package itself, not the online instructions. (That should be obvious.)

Thanks for the help.

P.S. I've actually been using MSIE to edit the site and Firefox to test it.

bugz_nz’s picture

bugz_nz commented

Did you import the included database additions into your current database?

Drupalace-1’s picture

Drupalace-1 commented

Info taken from another poster in another thread:

If you're getting errors related to missing tinymce_settings and tinymce_role tables, the following may help. I make no claims for specific combinations of TinyMCE version and Drupal version; I'll just note that it saved my bacon using Drupal 5.0 and TinyMCE 5.x-1.x-dev. I'd like to repeat the fix here for anyone else searching:

Add missing tables to TinyMCE using SQL statements:

CREATE TABLE tinymce_settings (
name varchar(128) NOT NULL default '',
settings text NOT NULL,
PRIMARY KEY (name)
) TYPE=MyISAM;

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

Fixed things right up for me.

watersugar’s picture

watersugar commented

Hallo,

thanks for the tips. Create Table functioned wonderfully for me!