Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By weimeng on
I get an SQL error with tinymce.module
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
query: SELECT s.name FROM drupal_tinymce_settings s INNER JOIN drupal_tinymce_role r ON r.name = s.name WHERE r.rid IN ()
I've tried dropping the two tinymce tables and reloading them, but it doesn't seem to help. Any ideas on what's going on?
Comments
It looks like you have not setup tinyMCE
The clue here is the part that reads 'WHERE r.rid IN ()'. Before you can actually use tinyMCE you need to define one or more profiles. Goto administer -> settings -> tinyMCE and click 'Create new profile' (riight below the introductry text)
That's exactly where I get the error
I've already tried that, and that's where I run into the error.
Any way to change tinyMCE settings without enabling the module?
No help forthcoming here?
No help forthcoming here?