Unable to install JCE Editor Component

[tripty]

Hi,

We have our international site built on Joomla 1.0. We were wanting to make some content changes and tried to use the HTML editor of JCE editor and it gave a blank page. This was the behavior with all the browsers.
I googled the error and found that I would have to install the
1. bot_jce_1192.zip
2. com_jce_111.zip

To install the above I had to uninstall the original ones, so I did that.
I was able to install the mambot but when I try to install the component it throws the error:
SQL Error DB function failed with error number 1064
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 'TYPE=MyISAM' at line 7 SQL=CREATE TABLE `viking_jce_langs` ( `id` int(11) NOT NULL auto_increment, `Name` varchar(100) NOT NULL default '', `lang` varchar(100) NOT NULL default '', `published` tinyint(3) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM
SQL =
CREATE TABLE `viking_jce_langs` (
`id` int(11) NOT NULL auto_increment,
`Name` varchar(100) NOT NULL default '',
`lang` varchar(100) NOT NULL default '',
`published` tinyint(3) NOT NULL default '0',
PRIMARY KEY (`id`) )
TYPE=MyISAM

I googled to fix this but I am not able to find the sql code in the component that does this.
Even when I totally remove the editor, I have no editor working fine and I cannot edit the content.

Please help.This is for one of our major sites.

Thanks,
Tripty

[Per Yngve Berg]

What version of Mysql are you running?

The syntax before 5.0 was ENGINE=MyISAM

There should be an .sql file in the installation folder of the extension.

[tripty]

Thats the problem, there is no .sql file in the installation folder for the JCE Editor component.

I took all the code/db and installed it on my localhost and XAMPP. I was successfully able to install. On the live site it gives the error mentioned above.

Live Site Details:
MySQL client version: 5.5.13
phpMyAdmin - 2.11.10

localhost details:
MySQL client version: 5.0.33
phpMyAdmin - 2.9.2

And I am a Super Admin for the live site and have all the privileges.
Please help.

Thanks,
Tripty

[Per Yngve Berg]

That's the MySQL client. What is the MySQL Server version?