Just upgraded my site from 4.7-beta-3 to official 4.7. All went well with no errors. Downloaded Tinymce module, placed it into /site/modules directory. Placed tinymce 2.6.0.1 into that folder. Loged-in into my drupal site, activated the module and got a whole bunch of errors. 


    * 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.

Upon inspection of the drupal database with phpmyadmin i found out that there are no tinymce tables in the database. So the install script doesn't appear to work. Any help is highly appreciated.

Comments

rewted’s picture

rewted commented

Same issue here with 4.7 stable. Did you find the solution to auto insert the DB tables?

Johnyp’s picture

Johnyp commented

Nope, not yet at least.

m3avrck’s picture

m3avrck commented

Hmm this is very strange, many other people I have talked to have not had problems installing this module.

I've committed a few changes/tweaks to the install file on both HEAD and 4.7. Hopefully those fix it, as the code is the exact same as in other modules, like event.install or content.install (part of CCK).

rewted’s picture

rewted commented

m3avrck, so if I download tinymce-4.7.0.tar.gz from the modules page again, install a clean copy and proceed with an install things should be fine?

m3avrck’s picture

m3avrck commented

Once the tarballs are updated, right now they haven't been. Depends on the Drupal server, takes a few hours.

Johnyp’s picture

Johnyp commented

I ended up loading the tinymce.mysql from the 4.6 release by hand. That fixed the problem of autoinstall not loading the tables into DB.

rewted’s picture

rewted commented

Update: I've tried the new tar ball (Download latest release (4.7.0, 11/05/2006 - 18:31, 26.73 KB) and the same issue remains.

Back to the drawing board. :|

Johnyp’s picture

Johnyp commented

download the 4.6 module:
http://ftp.osuosl.org/pub/drupal/files/projects/tinymce-4.6.0.tar.gz
extract the tinymce.mysql and upload it to the server
Once that is done do
mysql -u root -p drupal < tinymce.mysql
where "drupal" is the name of your drupal database.
Then login to your drupal site>administer>modules -> enable tinymce

then go to Administer>Access Control and allow users to access tinymce

After that go to Administer>settings>tinymce and profile and you will be good to go.

Good luck,
JohnyP

rewted’s picture

rewted commented
Title: Drupal 4.7+ Tinymce 4.7 does not load MYSQL tables » No bandaids.

That is just a bandaid for an open wound, an actual fix would be best.

RayZ’s picture

RayZ commented
Title: No bandaids. » Drupal 4.7+ Tinymce 4.7 does not load MYSQL tables
rewted’s picture

rewted commented

Any luck with resolving this?

betsyj’s picture

betsyj commented
Assigned: Unassigned » betsyj

I have tried the suggestion to upload and execute the tinymce.mysql from the prior version. This creates the tables tinymce_settings and tinymce_role. But, when I try to administer->settings, I get a blank page, no errors, no configuration options, nada. I've repeated this process, dropping the tables and starting afresh. Same unhappy result. Anyone?

chrsc’s picture

chrsc commented

I had a simular problem when upgrading Drupal 4.6.0 to Drupal 4.6.6, I havn't modified the admin menu yet, but if you use the url ?q=admin/settings/tinymce you should see your admin control again.

rewted’s picture

rewted commented

I don't think getting the old .mysql is a solution. Something obviously doesn't work with the install 100% of the time, perhaps the Tinymce team should just include an updated .mysql in the tar for people having troubles and need to import manually.

betsyj’s picture

betsyj commented
Assigned: betsyj » Unassigned

I tried ?q=admin/settings/tinymce -- no results.

tobias_crefeld@demokratische-redaktion.selfhost.in_drupal’s picture

tobias_crefeld@demokratische-redaktion.selfhost.in_drupal commented

I got the same problem with a new 4.7.1 installation.

It seems that the script modules/tinymce/tinymce.install isn't executed.
Beside this there seems to be a syntax error by surrounding the table names with {} in this file which is described in its header (!?). Possibly the quotation marks are superflous as well but I have no PHP/MySQL-knowledge, sorry.

Here is a workaround if you are able to send SQL-statement e.g. at the console to the mysql-server. It works on MySQL 5:

mysql -u drupaluser
use drupaldr
CREATE TABLE tinymce_settings (
name varchar(128) NOT NULL default '',
settings text NOT NULL default '',
PRIMARY KEY (name)
) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;
CREATE TABLE tinymce_role (
name varchar(128) NOT NULL default '',
rid tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (name,rid)
) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;
quit

drupaldr and drupaluser are site depended, if you need a password you have to add parameter -p

If you have no access to a mysql-console that is able to connect to your database server you possibly have something like phpmyadmin on the webserver that will work as well. Logon to your server and select drupals database. Select the tab "SQL" and there you enter

CREATE TABLE tinymce_settings (
name varchar(128) NOT NULL default '',
settings text NOT NULL default '',
PRIMARY KEY (name)
) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;
CREATE TABLE tinymce_role (
name varchar(128) NOT NULL default '',
rid tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (name,rid)
) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;

and click OK.

If you're lucky you only get a warning and the statement is accepted and both table are created. Check on tab "structure" if there are both tables "tinymce_settings" and "tinymce_role".

rewted’s picture

rewted commented

I'd love to see this fixed, properly. Heck, even if the DB automation was removed and replaced with a *.mysql file for manual import.

SpasticWarrior’s picture

SpasticWarrior commented

Good news: I was able to create the TinyMCE tables using PHPmyAdmin with the tinymce.mysql file from TinyMCE version 4.6.

Bad news: now when I go to administer > settings > tinymce I get a completely blank screen!

Frustration!

rewted’s picture

rewted commented

Well of course.... the 4.7 version uses AJAX menus. I've requested a *.mysql for 4.7 be included weeks ago, no action on it yet.

rewted’s picture

rewted commented

Still nobody willing to create a stand alone *.mysql file to insert the proper tables manually?

chrisswaine’s picture

chrisswaine commented

Hiya - I have just installed Drupal 4.7. I downloaded the latest TinyMCE [Version 4.7] and uploaded all files as per instructions. Got same error messages as outlined above. I then checked MyPHPAdmin and noted no tables created.

Then I noticed that the tinymce.mysql file isn't included in the download, so had to get a copy of the tinymce.mysql from the old TinyMCE 4.6 download [http://drupal.org/node/18803/release]!!!

Uploaded the tinymce.mysql manually and then called the www.mydomain.com/update.php.

All now works ok.

So looks like two things maybe:

1. tinymce.mysql file needs to be included into 4.7 download
2. The install.txt needs to prompt users to call the update.php

Hope that helps...Chris... :o)

kreynen’s picture

kreynen commented
Status: Active » Closed (fixed)

Closing all old install issues