By Johnyp on

Hey all
Just installed 4.7 drupal, downloaded official tinymce plugin (which should autoinstall once in the modules folder) loaded it, activated in modules and got a whole bunch of errors. Upon inpsection phpmyadmin revealed that no Tinymce SQL tables were loaded. So install files are not working correctly.

Anyone witht the same problem?

Anyone got a fix for this?

⋅ Categories: Drupal 4.7.x

Comments

heine’s picture

heine commented

What errors?

--
When your problem is solved, please post a follow-up to the thread you started.

Johnyp’s picture

Johnyp commented

As far as i can tell these errors say that there are no MySQL tables for tinymce.

    * user warning: Table 'drup_db.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 /var/www/site.com/htdocs/includes/database.mysql.inc on line 120.
    * user warning: Table 'drup_db.tinymce_settings' doesn't exist query: SELECT * FROM tinymce_settings in /var/www/site.com/htdocs/includes/database.mysql.inc on line 120.
    * user warning: Table 'drup_db.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 /var/www/site.com/htdocs/includes/database.mysql.inc on line 120.
    * user warning: Table 'drup_db.tinymce_settings' doesn't exist query: SELECT * FROM tinymce_settings in /var/www/site.com/htdocs/includes/database.mysql.inc on line 120.
    * user warning: Table 'drup_db.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 /var/www/site.com/htdocs/includes/database.mysql.inc on line 120.
    * user warning: Table 'drup_db.tinymce_settings' doesn't exist query: SELECT * FROM tinymce_settings in /var/www/site.com/htdocs/includes/database.mysql.inc on line 120.
m3avrck’s picture

m3avrck commented

What version of MySQL are you using? Do you have permission to "create table"?

Can you edit the tinymce.install file and remove the part "IF NOT EXISTS" so it just says "CREATE TABLE tinymce..." ?

Have you tried any other module that has the *.install file? Do those not work as well?

Johnyp’s picture

Johnyp commented

I'm running MySQL 4.1.14 on Gentoo Linux+php4+Apache. I do have permission to create tables and other modules with self install feature have loaded without problems.

Let me try removing the line in the install file and i will be back in a minute.

Johnyp’s picture

Johnyp commented

Ok, just removed "if not exists" but none of the tables were loaded still (checked with phpmyadmin).
user warning: Table 'hyper_drup_db.tinymce_settings' doesn't exist query: SELECT * FROM tinymce_settings in /var/www/hypersensory.com/htdocs/includes/database.mysql.inc on line 120.

m3avrck’s picture

m3avrck commented

Do you see an error "tables could not be created" after you try enabling? Or is nothing output?

Can you hop on #drupal-support and ping 'm3avrck' ?

Johnyp’s picture

Johnyp commented

There was no error message. The drupal mogules page only said something along the lines of "settings applied successfuly", but no other output.

I would love to hop on #drupal-support ( i assume it's an IRC channel), but i don't have IRC.

you can e-mail me at "integration at cox net"

m3avrck’s picture

m3avrck commented

Ok I think I might have found the problem and I committed changes to both HEAD and 4.7 version.

Run a CVS update and grab those.

Then try and install tinymce. Make sure though you clear out your systems table reference to tinymce, because if you try and install it and it fails, Drupal still thinks it was installed and it won't call the .install file again.

Martin Haanz’s picture

Martin Haanz commented

I just installed Drupal 4.7 + TinyMCE yesterday, and I got it working after one hickup. My problem was that I only downloaded the tinymce-4.7.0 plugin, with the tinymce.module file in the /modules/tinymce directory. You also have to install the TinyMCE 2.0 engine and place its files into the /modules/tinymce/tinymce directory.

Sounds like this won't solve your problem, though. Perhaps you did the opposite? If you got the tinymce.module file in the right spot, you should have the new MySQL tables, right?

http://tinymce.moxiecode.com/download.php

UPDATE:

Clearly I'm a noob. Don't listen to me. :)

Johnyp’s picture

Johnyp commented

I've got all the files in place - module files and engine files, but the table won't load into DB.

robert castelo’s picture

robert castelo commented

Look for a reference to tinymce module in the 'system' table of your database. This may have been added in by a previous installation. Deleting the row with 'tinymce' in it will enable the db tables to be installed again.

Cortext Communications
Drupal Themes & Modules

------------------------------------------
Drupal Specialists: Consulting, Development & Training

Robert Castelo, CTO
Code Positive
London, United Kingdom
----

Johnyp’s picture

Johnyp commented

I've looked for it in the system table, and i can see all of the other modules but no any Tinymce refernces.

Any other ideas?

m3avrck’s picture

m3avrck commented

See issue for any updates: http://drupal.org/node/62951