CKeditor shows no custom styles

This is an open forum for any mojoPortal topics that don't fall into the other categories.

This thread is closed to new posts. You must sign in to post in the forums.
1/7/2010 8:56:01 AM
Matthias
Gravatar
Total Posts 220
View Posts

Re: CKeditor shows no custom styles

Hi Joe,

and I was digging around for a file (like ~\ClientScript\ckeditor302\plugins\stylescombo\styles\default.js) in which I can reduce the default list to a minimum ... :)

I created the database in Plesk with default settings. phpMyAdmin shows me the encoding UTF-8 Unicode (utf8) and the collation utf8_unicode_ci.

Best
Matthias

1/8/2010 6:44:46 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: CKeditor shows no custom styles

Hi Matthias,

You should not modify any javascript files included with the editors. That file is not even used, that is the file that would be used if we were not overriding it to use our service url for styles.

If you want it to only use your custom styles you should add this to your user.config

<add key="AddSystemStyleTemplatesAboveSiteTemplates" value="false" />
<add key="AddSystemStyleTemplatesBelowSiteTemplates" value="false" />

for more info see Creating Content Style Templates.

Regarding the special characters errors, in my testing it works fine in MySql.

Does the problem occur in all features for you or only in specific content features?

Does using a different web browser make a difference?

Best,

Joe

1/8/2010 8:17:09 AM
Matthias
Gravatar
Total Posts 220
View Posts

Re: CKeditor shows no custom styles

Hi Joe,

Thank you that you have solved my error. I thought, these keys only regulate the order. I never thought about why there are two :).

I have tested the special charachter for "minutes / feet" that causes the exeption in tinyMCE in 5 different HTML content, and also with Chrome and Firefox

Best
Matthias

P.S: chrome and firefox ... look what they've done to my fonts, ma ...

1/8/2010 8:41:46 AM
Matthias
Gravatar
Total Posts 220
View Posts

Re: CKeditor shows no custom styles

To end this never-ending story I tested all special charachters in FCKEditor on another web server with an older version (2.3.1.9 MySQL) once more and it works. And tomorrow I will make an update, and if it still works correctly, then I suppose ... hmm ... I really don't know what, but perhaps you will know who is to blame.

Best
Matthias

1/9/2010 8:49:48 AM
Matthias
Gravatar
Total Posts 220
View Posts

Re: CKeditor shows no custom styles

Hi Joe,

two different servers, both with version 2.3.3.4.

On both TinyMCE and FCKEditor do not encode special characters and write € instead of &euro; or ′ instead of &prime; into the html.

On one server this works fine but the other displays "?" for € and throws a MySql.Data.MySqlClient.MySqlException with the ′
But when I load up a html file with both € and &euro; both were displayed correct.

Both MySQL servers have:

Server Version: 5.0.45-community-nt
Protokoll-Version: 10
Server: localhost via TCP/IP
MySQL-Zeichensatz: UTF-8 Unicode (utf8)
Zeichensatz / Kollation der MySQL-Verbindung: utf_unicode_ci
I tested both: utf_unicode_ci and utf_general_ci

On both servers the CKEditor encode and write &euro; or &prime; into the html. No problems.
I will continue using this one and forget the others ...

Best
Matthias

1/9/2010 9:17:59 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: CKeditor shows no custom styles

Hi Matthias,

I suspect on the server where the error happens, there is something not correct in the charset and collation. I would inspect the charset and collation on the mp_HtmlContent table, specifically the column named "Body". It is possible that even if the table has the correct utf8/unicode setting that this column may have something different. I cannot produce the error with correct charset and encoding. 

Hope it helps,

Joe

1/10/2010 5:37:11 AM
Matthias
Gravatar
Total Posts 220
View Posts

Re: CKeditor shows no custom styles

Hi Joe,

here you can see the table ...

www.zisign.de

SELECT * FROM `mp_htmlcontent` LIMIT 0 , 30 : <p>? Maecenas lorem quam, nonummy et, sagittis non...

Have a good residual weekend ...

Matthias

1/10/2010 5:51:49 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: CKeditor shows no custom styles

Hi Matthias,

Check your connection string, make it like this:

<add key="MySqlConnectionString" value="Server=yourserver;Database=yourdatabase;Uid=youruser;Pwd=yourpassword;Charset=utf8;" />

Note the important part at the end is Charset=utf8;

Do you have that part?

Hope it helps,

Joe

1/10/2010 8:01:08 AM
Matthias
Gravatar
Total Posts 220
View Posts

Re: CKeditor shows no custom styles

:)

Cheers
Matthias

1/10/2010 9:20:49 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: CKeditor shows no custom styles

Glad that fixed it!

Many thanks for the beers!

Cheers,

Joe

You must sign in to post in the forums. This thread is closed to new posts.