By mSale on

I download tinymce from the following URL:
http://drupal.org/project/tinymce

I install database,and enable the module. When I create new content,then I find "enable rich-text" text under editbox,but error information appear on the top of webpage:

user error: 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 msb_tinymce_settings s INNER JOIN msb_tinymce_role r ON r.name = s.name WHERE r.rid IN () in /home/websites/msale.net/blog/includes/database.mysql.inc on line 66.

please help me,and thanks.

Comments

skeen’s picture

skeen commented

I would think it is due to 'IN()' being empty. So I guess the question is why is Drupal calling a query with an empty IN() clause.
If I figure it out, I'll post back here.

Sam Keen

andre75’s picture

andre75 commented

I forgot, did TinyMCE come with a database component that you need to add to your current database?

Andre

-------------------------------------------------
http://www.aguntherphotography.com
http://www.opentravelinfo.com

skeen’s picture

skeen commented

I had run the needed mysql script. I found what the problem was. If you view any page that will render a tinymce editor with a user that has no group (user 0, the admin user), the query above will be built incorrectly and you get the syntax error.

My solution was to stop navigating the site logged in as user 0, and instead use the user i created with the 'site admin' role (I gave that role ALL rights). That way the query above is build correctly and runs w/o error.

This way I am following a 'best practice' of logging in as the root user only when needed and there is no more error from tinymce.