New update issue

This is a new problem with using the Update DA. This error is showing up on existing sites that have always worked. Insert and Detail pages are fine, but when I click on update from either the detail page or the results pages, the content in the html editor is blank. If the content is just a sentence or two it is fine. If it is longer, it is blank.

The only change I can think of is about a month ago, the server had a php upgrade.

I am still testing and trying to see if there is anything in common. I did redo one of the sites with fresh DA pages, but it didn't affect it. I am on the latest version and running DW6 on a Mac.

This is fairly critical as all my sites are editable by clients and I don't want to have to send out an alert to everyone to not do any editing.

Thanks for any help.

More testing: If I switch to source code the editing seems to stick. It appears to be related to using paragraphs. If just a sentence, no problem. If two paragraphs done in visual mode, sometimes the cursor isn't in the right place. I can do paragraphs in source mode. But clients aren't going to remember that. I set up a test environment. Link in PM.

If, before I type anything in, I add a series of hard returns, I can then place cursor where I need it. Very odd. But if I click on an update on an older record, everything is gone.

Another test... I went into the database (id5) and added paragraphs. When using the admin, clicking on update, makes it disappear in the editor. And if I update, it erases in database.

This is a character encoding issue, where the char-type in the database doesn't match the php encoding. I've updated it so the content is re-encoded to UTF-8 so that it will display, but you will see the garbled incompatible character in the editor.

You may be able to fix it by just updating your database character encoding to utf-8.

I am using

<meta charset=UTF-8>

and validator (https://validator.w3.org/nu/) is throwing up errors about

"Internal encoding declaration utf-8 disagrees with the actual encoding of the document (windows-1252)"

So I went into server and changed from default of ISO-8859-1 to utf-8, and the validation error went away. However, a ton of sites where clients can type in their own content, probably cutting/pasting from Word, showed that weird symbol when there should be a hyphen or apostrophe etc. It is a black diamond with an s in the middle. So I changed it back because it would take me a zillion hours to track them all down and correct.

However, the first time I noticed the blank editor was before this weekend when I was testing out the validator. So I'll keep testing.
Where did you change to utf-8 in the test environment?

Thanks

I spotted it... line 137 in new php5.php
thanks...

And you said the database to utf-8, not the server... Let me see if I can adjust that. Thanks again.

Server charset: UTF-8 Unicode (utf8)
That is what I see in phpMyAdmin settings... Should I be looking somewhere else?

Check the database itself. I think that is probably where it is set differently.

I updated ckeditor_php5.php line 137 to convert the charset from the database value passed into the editor.

Yep... It looks right.

Posting your change here in case I need to remember for another site, or maybe someone else can use it (in web assist folder, ck folder, ckeditor_php5.php, line 137

old

$out = "<textarea name=\"" . $name . "\"" . $attr . ">" . htmlspecialchars($value) . "</textarea>\n";


new

$out = "<textarea name=\"" . $name . "\"" . $attr . ">" . htmlspecialchars($value, ENT_COMPAT|ENT_SUBSTITUTE, "UTF-8") . "</textarea>\n";

I'm seeing this again in a new site. When editing a section, placing the cursor at the end of a paragraph, hitting return, the cursor jumps to the beginning of the section. However, it is not consistent across browsers. Safari has a problem but Chrome and Firefox is ok. (Mac).

I did check the line at 137 and it is as noted above.

Any ideas?

Can you give me a url and username/password if necessary to reproduce the problem? I'll look into it.