Knowledge base - edit results in blank edit window without existing content?

ngegw 2013-04-01 14:25:01 UTC #21

CKEditor is really something I’m not familar with, but I had a look at the
demo (ckeditor.com/demo) and pasted your sample text in.
The source in that case for the line in question was:
touch -d “2012-07-23 14:21:23” filename
(double quote replaced with ", but still the space + )

CKEditor does have some configs as to what to do with pasted text, maybe
that’s a factor.
http://docs.cksource.com/ckeditor_api/symbols/CKEDITOR.config.html#.pasteFromWordCleanupFile

Also, maybe these configs have an effect?
http://docs.cksource.com/ckeditor_api/symbols/CKEDITOR.config.html#.entities
I’m not sure if or how egw allows changing the CKEditor config though.

Nathan

Ralf_Becker_Stylite 2013-04-01 15:18:49 UTC #22

Hi David,

I have no idea how to determine whether this is a bug with the way egw sends
info to ckeditor or whether it is ckeditor itself.

Can anyone who knows please take a look, or at least suggest a test I can do
to narrow it down?

Ralf, Klaus, Nathan, Anyone???

Klaus is the one dealing usually with CKEditor. He comes back from
vacation tomorrow.

Thought dealing with old posts on developer list will surely not be his
first priority

Are you using 1.8 or Trunk, because both are on totally different
versions of CKEditor?

Can you reproduce your issue with our public EPL demo?

Ralf

Ralf Becker
Director Software Development

Stylite AG

Morschheimer Strasse 15 | Tel. +49 6352 70629 0
D-67292 Kirchheimbolanden | Fax. +49 6352 70629 30

Email: rb@stylite.de

www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany

Own the Future-Intel® Level Up Game Demo Contest 2013
Rise to greatness in Intel’s independent game demo contest.
Compete for recognition, cash, and the chance to get your game
on Steam. $5K grand prize plus 10 genre and skill prizes.
Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

David_C_Rankin 2013-04-01 19:26:45 UTC #23

Thought dealing with old posts on developer list will surely not be his
first priority

Are you using 1.8 or Trunk, because both are on totally different
versions of CKEditor?

Can you reproduce your issue with our public EPL demo?

Ralf

Heh heh He might just stay gone if that is what was facing him upon return.

I’m running:

egroupware: 18.004 svn r42037

Strange deal. I’ve always been able to re-edit kb article with the double-spaces
in them, so something has changed. The big issue to me is (a) is this something
in how egw sends the egw_kb_articles table text to ckeditor, or (b) is this
something new in ckeditor?

Nathan gave me some good leads to follow up on. I’ll sift through those and see
if I can’t find anything to help narrow this down. If all fails – we will just
have to brighten Klaus’ return tomorrow

–
David C. Rankin, J.D.,P.E.

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

David_C_Rankin 2013-04-01 20:31:03 UTC #24

The source in that case for the line in question was:
touch -d "2012-07-23 14:21:23" filename
(double quote replaced with ", but still the space + )

I’m checking, but it looks like just pasting the line in the ckeditor demo
results in the demo placing

tags around the ‘text’. That masks the
double-space issue when the double-space is place within normal html tags.

Depending on how you paste into the ckeditor demo, you get different results.
NONE of which match what I get when I paste into the egw ckeditor in 1.8 svn.
Specifically, if I press the ‘Source’ button and paste in the exact text from
the egw_kb_articles ‘text’ field for the failing article we have been using:

sed

search within a file for an expression to modify, use:

sed -i ‘/search_term/s|existing|new|’ filename

print line from file:

sed -n ‘#p’ filename

touch

create empty file and set file times

touch filename

touch -d “2012-07-23 14:21:23” filename

touch -t 201207231421.23 filename

stat

view file or system statistics

stat filename

The ckeditor demo reformats the problem line as follows:

touch -d "2012-07-23 14:21:23" filename

This strips and does not preserve the double space in the text. If, on the
other hand, I copy the html in firefox with mouse-select and then
middle-mouse-paste the html text from
http://www.3111skyline.com/dl/bugs/egw/fck-test-html.html into the demo, then I
get html something similar to what the 1.8 svn ckeditor generates:

touch -d "2012-07-23 14:21:23" filename

Here, the double-space is preserved and the character is used. With the
egw ckeditor in 1.8, is used instead of . That should make no
difference, but for some reason it does. Since there is no ‘save’ option on the
ckeditor demo, there is no way to know what it would actually store in final
form, and no way to know if it would choke on re-opening the text.

I’m still stumped on this one – and more importantly – how to fix it.

–
David C. Rankin, J.D.,P.E.

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

Leithoff_Klaus 2013-04-02 06:46:11 UTC #25

do you have a trunk at hand?
Trunk uses the CKEDITOR4 (as the CKEDITOR Demo does).
here you could save and try to reopen.
I did try that stuff with my trunk, and it seemed to work?

kl@stylite.de
Stylite AG
[ open style of IT ]
Morschheimer Strasse 15
67292 Kirchheimbolanden
fon 06352 . 70629-0
fax 06352 . 70629-30
www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany

Leithoff_Klaus 2013-04-02 06:55:50 UTC #26

If I copy and paste the text of the last post into my 1.8 svn instance.
I can create and reedit the resulting knowledgebase article.

kl@stylite.de
Stylite AG
[ open style of IT ]
Morschheimer Strasse 15
67292 Kirchheimbolanden
fon 06352 . 70629-0
fax 06352 . 70629-30
www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany

Leithoff_Klaus 2013-04-03 11:02:02 UTC #27

tested that back and force.
works for me.

–
kl@stylite.de
Stylite AG
[ open style of IT ]
Morschheimer Strasse 15
67292 Kirchheimbolanden
fon 06352 . 70629-0
fax 06352 . 70629-30
www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany

Leithoff_Klaus 2013-04-03 11:26:27 UTC #28

please check your system-charset in egw_config.
If I alter that in my install from utf-8 to ascii
I get the same behavior

kl@stylite.de
Stylite AG
[ open style of IT ]
Morschheimer Strasse 15
67292 Kirchheimbolanden
fon 06352 . 70629-0
fax 06352 . 70629-30
www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany

David_C_Rankin 2013-04-03 20:50:49 UTC #29

please check your system-charset in egw_config.
If I alter that in my install from utf-8 to ascii
I get the same behavior

Klaus,

I think you might have found the problem. Never in 100 years would I have
thought to check this setting. I have it set as follows:

select * from egw_config where config_name=‘system_charset’;
±-----------±---------------±-------------+
config_app | config_name | config_value |
±-----------±---------------±-------------+
phpgwapi | system_charset | iso-8859-1 |
±-----------±---------------±-------------+
1 row in set (0.00 sec)

How do I change this value correctly from within egroupware? I can do an
update to the mysql table directly, but I would prefer setting it through
egroupware if that is possible.

I suspect this is the problem. I have never altered this setting, so most
likely there was a change to the server/system definition of the charset that
has led to this problem.

–
David C. Rankin, J.D.,P.E.

Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire
the most talented Cisco Certified professionals. Visit the
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

Ralf_Becker_Stylite 2013-04-04 06:10:22 UTC #30

Hi David,

please check your system-charset in egw_config.
If I alter that in my install from utf-8 to ascii
I get the same behavior

Klaus,

I think you might have found the problem. Never in 100 years would I have
thought to check this setting. I have it set as follows:

select * from egw_config where config_name=‘system_charset’;
±-----------±---------------±-------------+
config_app | config_name | config_value |
±-----------±---------------±-------------+
phpgwapi | system_charset | iso-8859-1 |
±-----------±---------------±-------------+
1 row in set (0.00 sec)

How do I change this value correctly from within egroupware? I can do an
update to the mysql table directly, but I would prefer setting it through
egroupware if that is possible.

I suspect this is the problem. I have never altered this setting, so most
likely there was a change to the server/system definition of the charset that
has led to this problem.

EGroupware charset is since 1.6 for new installations fixed to utf-8 and
we encouraged everyone to switch to utf-8, but we never enforced that.
Changing is easy: create a backup using EGroupware’s own database
backup, drop all tables via setup and install that backup again.
Installing the backup converts it to utf-8.

If you are sure all your content in the database is only in english,
which is fully covered by 7-bit standard ascii chars, you could also
simply update system_charset row in egw_config and be done with it
(login out and in of cause).

Ralf

Ralf Becker
Director Software Development

Stylite AG

Morschheimer Strasse 15 | Tel. +49 6352 70629 0
D-67292 Kirchheimbolanden | Fax. +49 6352 70629 30

Email: rb@stylite.de

www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

David_C_Rankin 2013-04-04 20:39:12 UTC #31

EGroupware charset is since 1.6 for new installations fixed to utf-8 and
we encouraged everyone to switch to utf-8, but we never enforced that.
Changing is easy: create a backup using EGroupware’s own database
backup, drop all tables via setup and install that backup again.
Installing the backup converts it to utf-8.

If you are sure all your content in the database is only in english,
which is fully covered by 7-bit standard ascii chars, you could also
simply update system_charset row in egw_config and be done with it
(login out and in of cause).

Ralf

Thank you Ralf!

I knew something had been added/changed regarding the character set, but I had
no idea when. Both the installs I have date from 1.0.000 (or earlier). The other
install I have does NOT even have the system_charset setting in egw_config:

select config_app,config_name from egw_config;
±---------------±---------------------------+
config_app | config_name |
±---------------±---------------------------+

phpgwapi | site_title |
phpgwapi | smpt_port |
phpgwapi | smtp_port |
phpgwapi | smtp_server |
phpgwapi | sql_encryption_type |
phpgwapi | temp_dir |
phpgwapi | tz_aliases_mtime |

If I follow your instruction and backup/drop-all/install-backup on the egw
installation with no system_charset setting, will that be added to the
egw_config table automatically?

Also – yes, everything is English charset only, so I’ll try backup and
updating the system_charset value to ‘utf-8’ and see if that solves the problem.

Thank you Klaus and Nathan for helping me stumble through this bewildering
issue. We may want to emphasize a link to the community page that describes this
issue and recommends a check of the system_charset variable so that others who
experience similar issues can narrow down the problem. I don’t know if a check
could be added to the egroupware/setup page that displays the current
characterset setting at the bottom of the page somewhere.

In fact, a nice formatted page that shows the egw_config settings all in one
place might be a neat ‘feature-request’ for the project. Nothing fancy, just
something similar to php_info() for egw. Say egw_info()

–
David C. Rankin, J.D.,P.E.

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

David_C_Rankin 2013-04-04 21:05:53 UTC #32

Also – yes, everything is English charset only, so I’ll try backup and
updating the system_charset value to ‘utf-8’ and see if that solves the problem.

Ralf, Klaus, Nathan,

It W O R K S !!!

Since I had an English only install, I simply backed up and then updated the
system_charset value to ‘utf-8’. On relogin, I can now edit the article that
failed to begin with. For others, if there is any question whether your content
conforms to the ASCII character set, then use Ralf’s advise and

(1) backup your database
(2) settings – drop all tables
(3) reinstall your backup and it will be converted to utf-8

If you have English/ASCII-only content for your egw install you can simply

(1) backup your database
(2) change the system_charset config_value to ‘utf-8’ in mysql
(3) logout/login

To change the value directly in your egw_config mysql table, you can use the
following:

use egroupware;
Database changed
update egw_config set config_value=“utf-8” where
config_name=‘system_charset’;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

select config_app,config_name,config_value from egw_config where
config_name=‘system_charset’;
±-----------±---------------±-------------+
config_app | config_name | config_value |
±-----------±---------------±-------------+
phpgwapi | system_charset | utf-8 |
±-----------±---------------±-------------+
1 row in set (0.00 sec)

Thank everyone again for their help on this issue.

–
David C. Rankin, J.D.,P.E.

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers