Hello

I'm running the 5.x-dev version of TinyMCE in Drupal 5.1 and I'm getting several error messages.

1. When I try to create any type of content I get:

user warning: Table 'drupal.tinymce_settings' doesn't exist query: SELECT s.name FROM tinymce_settings s INNER JOIN tinymce_role r ON r.name = s.name WHERE r.rid IN (2) in C:\www\drupal\includes\database.mysql.inc on line 167.

user warning: Table 'drupal.tinymce_settings' doesn't exist query: SELECT * FROM tinymce_settings in C:\www\drupal\includes\database.mysql.inc on line 167.

user warning: Table 'drupal.tinymce_settings' doesn't exist query: SELECT s.name FROM tinymce_settings s INNER JOIN tinymce_role r ON r.name = s.name WHERE r.rid IN (2) in C:\www\drupal\includes\database.mysql.inc on line 167.

user warning: Table 'drupal.tinymce_settings' doesn't exist query: SELECT * FROM tinymce_settings in C:\www\drupal\includes\database.mysql.inc on line 167.

2. On the 'Administer by module' page I get:

user warning: Table 'drupal.tinymce_settings' doesn't exist query: SELECT s.name FROM tinymce_settings s INNER JOIN tinymce_role r ON r.name = s.name WHERE r.rid IN (2) in C:\www\drupal\includes\database.mysql.inc on line 167.

user warning: Table 'drupal.tinymce_settings' doesn't exist query: SELECT * FROM tinymce_settings in C:\www\drupal\includes\database.mysql.inc on line 167.

3. In Settings > TinyMCE I get:

user warning: Table 'drupal.tinymce_settings' doesn't exist query: SELECT * FROM tinymce_settings in C:\www\drupal\includes\database.mysql.inc on line 167.

I followed all the installation instructions, and granted access to the TinyMCE module to the Authenticated User Role. It won't let me add profiles.

Also, I did a search for this error and from what I saw I have a feeling the solution might involve manually editing my database? If this is the case I would really appreciate a bit of hand-holding as I've never had to do that before and don't know what the steps are.

Thanks in advance for your help.

Tom

Comments

mfricke’s picture

Me too. Exactly the same error, the same error messages.

Insights?

Thanks,

Martin

mfricke’s picture

We think we have fixed or worked around this now.
The two db tables tinymce_settings and tinymce_role are or were not created during the install. And we were looking to create them by hand. Jeremy S, one of our Systems programmers, noticed that in the 'tinymce.install' file there are a couple of curly braces that need removing before executing the table creation.
With those tables are created, ours seems to work fine now.
Best,
Martin

kreynen@drupal.org’s picture

Status: Active » Fixed

This has already been patched and is corrected in the HEAD.

http://drupal.org/node/115996#comment-207884

Anonymous’s picture

Status: Fixed » Closed (fixed)