By carpman on

Hello, ok am trying to do a 5 to 5.1 upgrade, have followed instructions, including upgrading modules but when i run update.php i get DB errors for Tinymce?



    * user warning: Table 'wwwuser_daisymaydrupal.tinymce_settings' doesn't exist query: ALTER TABLE tinymce_settings DEFAULT CHARACTER SET utf8 in /hsphere/local/home/wwwuser/daisy-may.net/includes/database.mysql.inc on line 172.
    * user warning: Table 'wwwuser_daisymaydrupal.tinymce_settings' doesn't exist query: SHOW FULL COLUMNS FROM tinymce_settings in /hsphere/local/home/wwwuser/daisy-may.net/includes/database.mysql.inc on line 172.
    * user warning: Table 'wwwuser_daisymaydrupal.tinymce_role' doesn't exist query: ALTER TABLE tinymce_role DEFAULT CHARACTER SET utf8 in /hsphere/local/home/wwwuser/daisy-may.net/includes/database.mysql.inc on line 172.
    * user warning: Table 'wwwuser_daisymaydrupal.tinymce_role' doesn't exist query: SHOW FULL COLUMNS FROM tinymce_role in /hsphere/local/home/wwwuser/daisy-may.net/includes/database.mysql.inc on line 172.

Will have to manually create DB tables if how best to do this?

Cheers

⋅ Categories: Drupal 5.x

Comments

carpman’s picture

carpman commented

Hello, ok below is content of TinyMCE install for DB, how can i convert this so i can add tables via myphpadmin?

cheers

function tinymce_install() {
 15   switch ($GLOBALS['db_type']) {
 16     case 'mysql':
 17     case 'mysqli':
 18       db_query("CREATE TABLE {tinymce_settings} (
 19                 name varchar(128) NOT NULL default '',
 20                 settings text,
 21                 PRIMARY KEY (name)
 22                ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
 23 
 24       db_query("CREATE TABLE {tinymce_role} (
 25                 name varchar(128) NOT NULL default '',
 26                 rid tinyint(3) unsigned NOT NULL default '0',
 27                 PRIMARY KEY (name,rid)
 28                ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
 29       break;
 30 
 31     case 'pgsql':
 32       db_query("CREATE TABLE {tinymce_settings} (
 33                 name varchar(128) NOT NULL default '',
 34                 settings text,
 35                 PRIMARY KEY (name)
 36                );");
 37 
 38       db_query("CREATE TABLE {tinymce_role} (
 39                 name varchar(128) NOT NULL default '',
 40                 rid smallint NOT NULL default '0',
 41                 PRIMARY KEY (name,rid)
 42                );");
 43       break;
 44    }
 45 }
 46 
 47 function tinymce_update_1() {
 48   return _system_update_utf8(array('tinymce_settings', 'tinymce_role'));
 49 }
Stephen Winters’s picture

Stephen Winters commented

Hi,
Looks like I have the same, or a very similar problem. Did you ever find out what to do.
Here is my situation.
Have Drupal 5.0, upgrading TinyMCE module to version tinymce-5.x-1.9-1. Downloaded and installed the TinyMCE engine version tinymce_2_1_1_1, which I followed directions and put in /sites/all/modules/tinymce/tinymce. When I ran the update.php file, After updating, this error message appeared: 

    * user warning: Table 'winterss_WinSewTestDrupal.tinymce_settings' doesn't exist query: ALTER TABLE tinymce_settings DEFAULT CHARACTER SET utf8 in /home/winterss/public_html/winsewtest/includes/database.mysql.inc on line 167.
    * user warning: Table 'winterss_WinSewTestDrupal.tinymce_settings' doesn't exist query: SHOW FULL COLUMNS FROM tinymce_settings in /home/winterss/public_html/winsewtest/includes/database.mysql.inc on line 167.
    * user warning: Table 'winterss_WinSewTestDrupal.tinymce_role' doesn't exist query: ALTER TABLE tinymce_role DEFAULT CHARACTER SET utf8 in /home/winterss/public_html/winsewtest/includes/database.mysql.inc on line 167.
    * user warning: Table 'winterss_WinSewTestDrupal.tinymce_role' doesn't exist query: SHOW FULL COLUMNS FROM tinymce_role in /home/winterss/public_html/winsewtest/includes/database.mysql.inc on line 167.

What do I do from here to get rid of the errors and get TinyMCE working?

Stephen Winters
Winters Sewing
Winters Sewing: Upholstery Information Website

Stephen Winters’s picture

Stephen Winters commented

Hi,
After trying a variety of things, I figured out what my problem was. My Drupal 5.0 installation MySQL database did not have the two TinyMCE tables in the database. In fact, I have several Drupal 5.0 websites. Even though I had installed TinyMCE on each of the websites, most do not have the TinyMCE tables in the databases. Fortunately one of website databases did have the required TinyMCE tables, which were these tables: "tinymce_settings" and "tinymce_role". My website hosting account has the CPanel control panel. To fix the problem, I went into the PhpMyAdmin and exported the structure of the two missing files out of the MySQL database that contained those files. Here are copies of those two exports:

CREATE TABLE `tinymce_role` (
  `name` varchar(128) NOT NULL default '',
  `rid` tinyint(3) unsigned NOT NULL default '0',
  UNIQUE KEY `name` (`name`,`rid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `tinymce_settings` (
  `name` varchar(128) NOT NULL default '',
  `settings` text NOT NULL,
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Then, while in PhpMyAdmin, after clicking on the SQL tab at the top, I copied each of the above scripts into the text box labeled "Run SQL query/queries on database", then pressed the Go button at the bottom.

Just a note, I don't know if it was necessary, but before I created the above tables, I had replaced the tinymce_2_1_1_1 TinyMCE engine with the tinymce_2_0_9 TinyMCE engine. I did this because I was trying to try everything I could think of, and the TinyMCE installation instructions had said to use the TinyMCE 2.0 engine.

I hope this helps someone else. I sure struggled with this.

Stephen Winters
Winters Sewing
Winters Sewing: Upholstery Information Website

Stephen Winters’s picture

Stephen Winters commented

Until I upgraded to this new version of TinyMCE, TinyMCE was working fine on the website. Just to check out if TinyMCE would work after the upgrade, I logged into my website, clicked on the menu "Create Content, then clicked "Book Page" and then this error message came up.

    * user warning: Table 'winterss_WinSewTestDrupal.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,3) in /home/winterss/public_html/winsewtest/includes/database.mysql.inc on line 167.
    * user warning: Table 'winterss_WinSewTestDrupal.tinymce_settings' doesn't exist query: SELECT * FROM tinymce_settings in /home/winterss/public_html/winsewtest/includes/database.mysql.inc on line 167.
    * user warning: Table 'winterss_WinSewTestDrupal.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,3) in /home/winterss/public_html/winsewtest/includes/database.mysql.inc on line 167.
    * user warning: Table 'winterss_WinSewTestDrupal.tinymce_settings' doesn't exist query: SELECT * FROM tinymce_settings in /home/winterss/public_html/winsewtest/includes/database.mysql.inc on line 167.
    * user warning: Table 'winterss_WinSewTestDrupal.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,3) in /home/winterss/public_html/winsewtest/includes/database.mysql.inc on line 167.
    * user warning: Table 'winterss_WinSewTestDrupal.tinymce_settings' doesn't exist query: SELECT * FROM tinymce_settings in /home/winterss/public_html/winsewtest/includes/database.mysql.inc on line 167.
    * user warning: Table 'winterss_WinSewTestDrupal.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,3) in /home/winterss/public_html/winsewtest/includes/database.mysql.inc on line 167.
    * user warning: Table 'winterss_WinSewTestDrupal.tinymce_settings' doesn't exist query: SELECT * FROM tinymce_settings in /home/winterss/public_html/winsewtest/includes/database.mysql.inc on line 167.

What is the problem and how do I fix it?
Is it a bug in TinyMCE?
Is the new version of TinyMCE module and engine incompatible with Drupal 5.0?
Do I have the right TinyMCE module version with the correct version of the TinyMCE engine?

Best Wishes,
Stephen Winters
Winters Sewing
Winters Sewing: Upholstery Information Website

Maurizio Naso’s picture

Maurizio Naso commented

That's right,
your solution has worked properly in my situation.

Upgrading TinyMCE to

tinymce-5.x-1.9 and

tinymce_2_1_2 (both Oct 09, 2007)

on Drupal 5.1, i've got the same PHP error.

I've just tried to create a new "Book Page"...OK! no problem...:-)

Thank you.
Maurizio Naso
maurizionaso.it