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

David_C_Rankin 2013-03-19 14:03:31 UTC #1

Ralf, All,

Recently, the ‘edit’ feature in knowledge base has stopped working. When a
article is viewed, all exiting content is shown properly. However, when the
’Edit’ button is pressed, the editing window is blank - empty - no existing text
shown. This is with 18.004 svn. What should I check to find the cause? I am
accessing egw via Firefox 16.01 if that makes any difference.

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

Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar

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

el_es 2013-03-19 15:05:15 UTC #2

Ralf, All,

Recently, the ‘edit’ feature in knowledge base has stopped working. When a
article is viewed, all exiting content is shown properly. However, when the
’Edit’ button is pressed, the editing window is blank - empty - no existing text
shown. This is with 18.004 svn. What should I check to find the cause? I am
accessing egw via Firefox 16.01 if that makes any difference.

Last time this happened, Sabine suggested

http://svn.stylite.de/viewvc/egroupware/branches/1.8/phpgwapi/js/fckeditor/fckeditor_php5.php?view=markup&pathrev=40952

(iow, line 58 of fckeditor_php5.php needs to be modified to allow firefox >= 17)

(so make line 58 of phpgwapi/js/fckeditor/fckeditor_php5.php look like this:

return ($iVersion >= 20030210 || (stripos($sAgent,‘firefox/’) !== false && $iVersion>=17)) ;

)

Can you check that?
L.

Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar

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

David_C_Rankin 2013-03-19 20:58:40 UTC #3

Ralf, All,

Recently, the ‘edit’ feature in knowledge base has stopped working. When a
article is viewed, all exiting content is shown properly. However, when the
’Edit’ button is pressed, the editing window is blank - empty - no existing text
shown. This is with 18.004 svn. What should I check to find the cause? I am
accessing egw via Firefox 16.01 if that makes any difference.

Last time this happened, Sabine suggested

http://svn.stylite.de/viewvc/egroupware/branches/1.8/phpgwapi/js/fckeditor/fckeditor_php5.php?view=markup&pathrev=40952

(iow, line 58 of fckeditor_php5.php needs to be modified to allow firefox >= 17)

(so make line 58 of phpgwapi/js/fckeditor/fckeditor_php5.php look like this:

return ($iVersion >= 20030210 || (stripos($sAgent,‘firefox/’) !== false && $iVersion>=17)) ;

)

Can you check that?
L.

Thank you for the reply. Sure, I’m happy to check it. Looks like that line is
already exactly what you have suggested:

else if ( strpos($sAgent, ‘Gecko/’) !== false )
{
$iVersion = (int)substr($sAgent, strpos($sAgent, ‘Gecko/’) + 6, 8) ;
return ($iVersion >= 20030210 || (stripos($sAgent,‘firefox/’) !== false &&
$iVersion>=17)) ;
}

I ran some additional tests as well and this is NOT limited to firefox on
Linux. I have tried IE8 on a windows box and I get the exact same behavior. I
have used knowledge base quite a bit over the years and have a number of
articles that I edit frequently. It has been a couple of months since I last
edited an article, but this problem seems to have started in that period of time.

Looking at the server log, the only thing I see is a PHP Warning that appears
unrelated:

[Tue Mar 19 15:49:57 2013] [error] [client 192.168.6.121] PHP Warning: Unknown:
1 result set(s) not freed. Use mysql_free_result to free result sets which were
requested using mysql_query() in Unknown on line 0, referer:
http://www.3111skyline.com/egroupware/login.php?phpgw_forward=%2Findex.php

Let me know what else to check. Thank you again for your help.

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

Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar

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

David_C_Rankin 2013-03-19 22:10:03 UTC #4

Let me know what else to check. Thank you again for your help.

The version of egw and the underlying server is this:

egroupware: 18.004 svn r42037
apache 2.2.22-4
php 5.4.5-1
mysql 5.5.25.a-1

I don’t know if this matters, but I thought I would include it for the thread.

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

Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar

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

Leithoff_Klaus 2013-03-20 08:36:30 UTC #5

I guess, If you use ff16 and the modification suggested is part of our svn and
FCKEdITOR does check the reported version, and the version number schema for ff changed
somewhere around version 17, I suggest you add an error_log in fckeditor_php5.php
before line 58 for the sAgent.
If ff changed version numbering schema for version 16 as well, we will handle that.

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-03-20 08:53:13 UTC #6

Hi David,
not matching the version number should not result in a blank page, but
with a textbox showing the text in question as source. thats the fallback of fckeditor.
I checked with my 1.8 and I cannot reproduce the problem with my 1.8 (svn checkout)
Tested with IE8,
Chrome Version 25.0.1364.172 m
FF 18.0.1
Is that only occurring with knowledgebase?
Check with: mail-reply; news-admin; wiki;
The mysql-error may be causing the problem experienced, if it is stopping processing the request.
that would explain the blank page.
best regards
Klaus

–
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-03-21 19:17:38 UTC #7

Hi David,
not matching the version number should not result in a blank page, but
with a textbox showing the text in question as source. thats the fallback of fckeditor.
I checked with my 1.8 and I cannot reproduce the problem with my 1.8 (svn checkout)
Tested with IE8,
Chrome Version 25.0.1364.172 m
FF 18.0.1
Is that only occurring with knowledgebase?
Check with: mail-reply; news-admin; wiki;
The mysql-error may be causing the problem experienced, if it is stopping processing the request.
that would explain the blank page.
best regards
Klaus

Klaus,

Yes, this is only occurring with knowledge base. That is what is so strange.
Everything else seems fine. I just updated to FF 19.02 and the issue remain the
same. What is really unexplainable is that this only effects one of the two
egroupware installs I have. I just tested the install I have at another site and
I can use the knowledge base without issue. I cannot figure out why one install
would be working and another would not. Both are running on the same OS and
versions of apache, etc… The only difference is one is x86 and the other is
x86-64. The x86 install is working and the x86-64 install is not.

You mentioned adding an ‘error_log’ in fckeditor_php5.php
before line 58 for the sAgent. I’m unfamiliar with the syntax. Would that just be:

$iVersion = (int)substr($sAgent, strpos($sAgent, ‘Gecko/’) + 6, 8) ;
error_log (“What do you want here”);
return ($iVersion >= 20030210 || (stripos($sAgent,‘firefox/’) !== false &&
$iVersion>=17)) ;

Let me know and I’ll see if we can figure out what is going on…

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

Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar

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

David_C_Rankin 2013-03-21 22:12:00 UTC #8

Hi David,
not matching the version number should not result in a blank page, but
with a textbox showing the text in question as source. thats the fallback of fckeditor.
I checked with my 1.8 and I cannot reproduce the problem with my 1.8 (svn checkout)
Tested with IE8,
Chrome Version 25.0.1364.172 m
FF 18.0.1
Is that only occurring with knowledgebase?
Check with: mail-reply; news-admin; wiki;
The mysql-error may be causing the problem experienced, if it is stopping processing the request.
that would explain the blank page.
best regards
Klaus

Klaus,

Yes, this is only occurring with knowledge base. That is what is so strange.
Everything else seems fine. I just updated to FF 19.02 and the issue remain the
same. What is really unexplainable is that this only effects one of the two
egroupware installs I have. I just tested the install I have at another site and
I can use the knowledge base without issue. I cannot figure out why one install
would be working and another would not. Both are running on the same OS and
versions of apache, etc… The only difference is one is x86 and the other is
x86-64. The x86 install is working and the x86-64 install is not.

You mentioned adding an ‘error_log’ in fckeditor_php5.php
before line 58 for the sAgent. I’m unfamiliar with the syntax. Would that just be:

$iVersion = (int)substr($sAgent, strpos($sAgent, ‘Gecko/’) + 6, 8) ;
error_log (“What do you want here”);
return ($iVersion >= 20030210 || (stripos($sAgent,‘firefox/’) !== false &&
$iVersion>=17)) ;

Let me know and I’ll see if we can figure out what is going on…

Klaus,

Really strange (see above comments as well), but I can create NEW kb articles
and I can EDIT the NEW articles I have created, but I cannot edit EXISTING kb
articles. What could this possibly be? It screams permissions, but I have not
changed anything in the setup, etc – honestly, I don’t even know what could
prevent edit of existing kb articles, but allow edit and re-edit of articles
created anew. Any ideas?

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

Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar

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

Leithoff_Klaus 2013-03-22 08:38:34 UTC #9

we can skip

You mentioned adding an ‘error_log’ in fckeditor_php5.php
if it is not a CKEditor in general issue.

You get a blank page. Right? That unusual for phpbrain/kb.
a) maybe the error
1 result set(s) not freed. Use mysql_free_result to free result sets which were
is related after all.
does it sho always when the error occurs?
b) check if you run into some javascript error. (Java Script error console of your browser)

Only suggestion I have is adding lots of error_log statements to uikb or bokb to
have a look where it fails.
error_log(METHOD.LINE);
shown method and line in the webservers error log,
if you add that to every other line in function uikb -> edit_article, you will (should) learn where it stops
call of ckeditor is in line 1420.
The stuff could as well fail by parsing out the template in line 1455 (if it was content related)

David_C_Rankin 2013-03-22 14:00:36 UTC #10

we can skip

You mentioned adding an ‘error_log’ in fckeditor_php5.php
if it is not a CKEditor in general issue.

I thought that was the case.

You get a blank page. Right? That unusual for phpbrain/kb.

Yes, here are screenshots of what I see when a) viewing; and b) after attempting
to edit. It is like something is preventing edit of existing articles, but I
haven’t a clue what could do that. js? php? mysql? You can see in the screenshot
b) that the edit window is completely blank. The information from the article
shown in a) is never put into the edit window for some reason. I don’t know what
could control that.

a) http://www.3111skyline.com/dl/bugs/egw/kb-article-view.jpg

b) http://www.3111skyline.com/dl/bugs/egw/kb-article-edit.jpg

a) maybe the error
1 result set(s) not freed. Use mysql_free_result to free result sets which were
is related after all.
does it sho always when the error occurs?

It seems to show when you login to egw each time. Here is the only error I get
when I log into egw and access kb and try and edit:

[Fri Mar 22 07:59:02 2013] [error] [client 192.168.6.102] PHP Warning: Unknown:
1 result set(s) not freed. Use mysql_free_result to free result sets which were
requested using mysql_query() in Unknown on line 0, referer:
http://www.3111skyline.com/egroupware/login.php?cd=10&phpgw_forward=%2Fhome%2Findex.php

The access_log for the kb session (open, view, edit, cancel) looks like the
following:

192.168.6.102 - - [22/Mar/2013:08:07:04 -0500] “GET
/egroupware/login.php?cd=10&phpgw_forward=%2Fhome%2Findex.php HTTP/1.1” 200 4519
192.168.6.102 - - [22/Mar/2013:08:07:04 -0500] “GET
/egroupware/phpgwapi/templates/idots/css/idots.css?1291345216 HTTP/1.1” 304 -
192.168.6.102 - - [22/Mar/2013:08:07:04 -0500] “GET
/egroupware/phpgwapi/templates/idots/print.css?1291345216 HTTP/1.1” 304 -
192.168.6.102 - - [22/Mar/2013:08:07:04 -0500] “GET
/egroupware/phpgwapi/js/jsapi/jsapi.js?1311540389 HTTP/1.1” 304 -
192.168.6.102 - - [22/Mar/2013:08:07:10 -0500] “POST
/egroupware/login.php?phpgw_forward=%2Fhome%2Findex.php HTTP/1.1” 302 2
192.168.6.102 - - [22/Mar/2013:08:07:11 -0500] “GET /egroupware/home/index.php
HTTP/1.1” 200 154392
192.168.6.102 - - [22/Mar/2013:08:07:12 -0500] “GET
/egroupware/phpgwapi/templates/idots/css/idots.css?1291345216 HTTP/1.1” 304 -
192.168.6.102 - - [22/Mar/2013:08:07:12 -0500] “GET
/egroupware/phpgwapi/templates/idots/print.css?1291345216 HTTP/1.1” 304 -
192.168.6.102 - - [22/Mar/2013:08:07:12 -0500] “GET
/egroupware/phpgwapi/js/jsapi/jsapi.js?1311540389 HTTP/1.1” 304 -
192.168.6.102 - - [22/Mar/2013:08:07:12 -0500] “GET
/egroupware/phpgwapi/js/wz_tooltip/wz_tooltip.js?1291345211 HTTP/1.1” 304 -
192.168.6.102 - - [22/Mar/2013:08:07:12 -0500] “GET
/egroupware/etemplate/js/etemplate.js?1311540392 HTTP/1.1” 304 -
192.168.6.102 - - [22/Mar/2013:08:07:16 -0500] “GET
/egroupware/index.php?menuaction=phpbrain.uikb.index HTTP/1.1” 200 45721
192.168.6.102 - - [22/Mar/2013:08:07:16 -0500] “GET
/egroupware/phpgwapi/templates/idots/css/idots.css?1291345216 HTTP/1.1” 304 -
192.168.6.102 - - [22/Mar/2013:08:07:16 -0500] “GET
/egroupware/phpgwapi/templates/idots/print.css?1291345216 HTTP/1.1” 304 -
192.168.6.102 - - [22/Mar/2013:08:07:16 -0500] “GET
/egroupware/phpgwapi/js/jsapi/jsapi.js?1311540389 HTTP/1.1” 304 -
192.168.6.102 - - [22/Mar/2013:08:07:23 -0500] "GET
/egroupware/index.php?menuaction=phpbrain.uikb.view_article&art_id=37 HTTP/1.1"
200 34174
192.168.6.102 - - [22/Mar/2013:08:07:23 -0500] “GET
/egroupware/phpgwapi/templates/idots/css/idots.css?1291345216 HTTP/1.1” 304 -
192.168.6.102 - - [22/Mar/2013:08:07:23 -0500] “GET
/egroupware/phpgwapi/templates/idots/print.css?1291345216 HTTP/1.1” 304 -
192.168.6.102 - - [22/Mar/2013:08:07:23 -0500] “GET
/egroupware/phpgwapi/js/tabs/tabs.js?1311540390 HTTP/1.1” 304 -
192.168.6.102 - - [22/Mar/2013:08:07:23 -0500] “GET
/egroupware/phpgwapi/js/jsapi/jsapi.js?1311540389 HTTP/1.1” 304 -
192.168.6.102 - - [22/Mar/2013:08:07:29 -0500] "POST
/egroupware/index.php?menuaction=phpbrain.uikb.edit_article&art_id=37 HTTP/1.1"
200 26551
192.168.6.102 - - [22/Mar/2013:08:07:30 -0500] “GET
/egroupware/phpgwapi/templates/idots/css/idots.css?1291345216 HTTP/1.1” 304 -
192.168.6.102 - - [22/Mar/2013:08:07:30 -0500] “GET
/egroupware/phpgwapi/templates/idots/print.css?1291345216 HTTP/1.1” 304 -
192.168.6.102 - - [22/Mar/2013:08:07:30 -0500] “GET
/egroupware/phpgwapi/js/jsapi/jsapi.js?1311540389 HTTP/1.1” 304 -
192.168.6.102 - - [22/Mar/2013:08:07:30 -0500] “GET
/egroupware/phpgwapi/js/fckeditor/editor/fckeditor.html?InstanceName=exec[text]&Toolbar=egw_advanced
HTTP/1.1” 304 -
192.168.6.102 - - [22/Mar/2013:08:07:36 -0500] "POST
/egroupware/index.php?menuaction=phpbrain.uikb.edit_article&art_id=37 HTTP/1.1"
302 2
192.168.6.102 - - [22/Mar/2013:08:07:37 -0500] "GET
/egroupware/index.php?menuaction=phpbrain.uikb.view_article&art_id=37 HTTP/1.1"
200 34174
192.168.6.102 - - [22/Mar/2013:08:07:37 -0500] “GET
/egroupware/phpgwapi/templates/idots/css/idots.css?1291345216 HTTP/1.1” 304 -
192.168.6.102 - - [22/Mar/2013:08:07:37 -0500] “GET
/egroupware/phpgwapi/templates/idots/print.css?1291345216 HTTP/1.1” 304 -
192.168.6.102 - - [22/Mar/2013:08:07:37 -0500] “GET
/egroupware/phpgwapi/js/tabs/tabs.js?1311540390 HTTP/1.1” 304 -
192.168.6.102 - - [22/Mar/2013:08:07:37 -0500] “GET
/egroupware/phpgwapi/js/jsapi/jsapi.js?1311540389 HTTP/1.1” 304 -
192.168.6.102 - - [22/Mar/2013:08:07:41 -0500] “GET /egroupware/logout.php
HTTP/1.1” 200 1319
192.168.6.102 - - [22/Mar/2013:08:07:42 -0500] “GET
/egroupware/login.php?cd=10&phpgw_forward=%2Fhome%2Findex.php HTTP/1.1” 200 4519
192.168.6.102 - - [22/Mar/2013:08:07:43 -0500] “GET
/egroupware/phpgwapi/templates/idots/css/idots.css?1291345216 HTTP/1.1” 304 -
192.168.6.102 - - [22/Mar/2013:08:07:43 -0500] “GET
/egroupware/phpgwapi/templates/idots/print.css?1291345216 HTTP/1.1” 304 -
192.168.6.102 - - [22/Mar/2013:08:07:43 -0500] “GET
/egroupware/phpgwapi/js/jsapi/jsapi.js?1311540389 HTTP/1.1” 304 -

b) check if you run into some javascript error. (Java Script error console of your browser)

These do not look that bad to me, but here are the error console messages from
firefox. The fckeditor error repeat many times with different line numbers:

Timestamp: 03/22/2013 08:49:03 AM
Warning: A form was submitted in the windows-1252 encoding which cannot encode
all Unicode characters, so user input may get corrupted. To avoid this problem,
the page should be changed so that the form is submitted in the UTF-8 encoding
either by changing the encoding of the page itself to UTF-8 or by specifying
accept-charset=utf-8 on the form element.
Source File:
http://www.3111skyline.com/egroupware/index.php?menuaction=phpbrain.uikb.view_article&art_id=37
Line: 0

Timestamp: 03/22/2013 08:49:05 AM
Warning: Error in parsing value for ‘filter’. Declaration dropped.
Source File:
http://www.3111skyline.com/egroupware/phpgwapi/js/fckeditor/editor/skins/default/fck_editor.css
Line: 154

<< Many More ‘Line: ##’ with same error >>

Timestamp: 03/22/2013 08:49:06 AM
Warning: Error in parsing value for ‘filter’. Declaration dropped.
Source File:
http://www.3111skyline.com/egroupware/phpgwapi/js/fckeditor/editor/skins/default/fck_editor.css
Line: 415

Only suggestion I have is adding lots of error_log statements to uikb or bokb to
have a look where it fails.

I’ll have to take some time to figure out where to go with this. If you see
anything in the information above, let me know.

error_log(METHOD.LINE);
shown method and line in the webservers error log,
if you add that to every other line in function uikb -> edit_article, you will (should) learn where it stops
call of ckeditor is in line 1420.
The stuff could as well fail by parsing out the template in line 1455 (if it was content related)

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

Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar

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

Leithoff_Klaus 2013-03-22 14:34:03 UTC #11

O.K.: you are not getting a blank page, but no content for the editing area
The warning you get could very well be the cause of your: not getting the
content for edit problem.

Timestamp: 03/22/2013 08:49:03 AM
Warning: A form was submitted in the windows-1252 encoding which cannot encode
all Unicode characters, so user input may get corrupted. To avoid this problem,
the page should be changed so that the form is submitted in the UTF-8 encoding
either by changing the encoding of the page itself to UTF-8 or by specifying
accept-charset=utf-8 on the form element.
Source File:
www.3111skyline.com/egroupware/index.php?menuaction=phpbrain.uikb.view_article&art_id=37
Line: 0

you can check if the content is available by adding
error_log(METHOD.LINE.$content);
just before line 1366 in uikb.
The output will/should show in webservers error_log

If the content is missing there, we have to look before that point
But I guess, the problem is located by passing the content to the fckeditor,
who is somehow stumbling over the content.

Question: If you copy the content visible into a new kb-page. save it, and try to reopen it.
What happens?
Could this be some change in your webservers config?
Could you step back via svn update until it is back to function as desired?

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-03-22 16:22:10 UTC #12

O.K.: you are not getting a blank page, but no content for the editing area
The warning you get could very well be the cause of your: not getting the
content for edit problem.

Timestamp: 03/22/2013 08:49:03 AM
Warning: A form was submitted in the windows-1252 encoding which cannot encode
all Unicode characters, so user input may get corrupted. To avoid this problem,
the page should be changed so that the form is submitted in the UTF-8 encoding
either by changing the encoding of the page itself to UTF-8 or by specifying
accept-charset=utf-8 on the form element.
Source File:
www.3111skyline.com/egroupware/index.php?menuaction=phpbrain.uikb.view_article&art_id=37
Line: 0

Ahah! I think we have the error identified, now – why is this happening??

Recall I have 2 egw installs: a) 3111skyline.com; b) rlfpllc.com. Site a)
has the problem, site b) does not. Accessing the kb on site b) I do NOT get
the windows-1252/UTF-8 Warning. This error is unique to site a). The question
becomes – what controls that warning?? Both servers are running Archlinux,
same config, same php, mysql, etc… So what gives??

The svnversion for site a) is:

10:07 nirvana:/srv/http/htdocs/egroupware> svnversion
33289:42037

The svnversion for site b) is:

10:07 phoenix:/srv/http/htdocs/egroupware> svnversion
37613:41685M

However, I don’t thinks this is svn version related. I have also compared
the php.ini configs and they are virtually identical.

you can check if the content is available by adding
error_log(METHOD.LINE.$content);
just before line 1366 in uikb.
The output will/should show in webservers error_log

where is uikb???

phoenix:/srv/http/htdocs/egroupware> find . -name uikb

If the content is missing there, we have to look before that point
But I guess, the problem is located by passing the content to the fckeditor,
who is somehow stumbling over the content.

Question: If you copy the content visible into a new kb-page. save it, and try to reopen it.
What happens?
Could this be some change in your webservers config?
Could you step back via svn update until it is back to function as desired?

WAIT!!! Something is fcked up here. If I COPY the content of the article into
a new article, I still CANNOT re-edit that article. Huh??

Take a look at these screenshots:

c) http://www.3111skyline.com/dl/bugs/egw/kb-article-copy-view.jpg

d) http://www.3111skyline.com/dl/bugs/egw/kb-article-copy-edit.jpg

Above, the text from the original article (
http://www.3111skyline.com/dl/bugs/egw/kb-article-view.jpg ) was copied into a
new article © above and Saved. I then attempted to re-edit the new article
and it failed (d) above. That makes NO sense to me. Could there be some
character in the text that is not shown that is causing the failure??? I have
had these egw installs since 1.0.0, so if there was every a character encoding
change, that may explain where the character problem is. But that still
doesn’t really make any sense!!!

I copied the text by simply selecting the text in ‘view’ mode and then used a
’middle-mouse-paste’ into the new article – so only the text was copied.
However, FF does attempt to copy the html formatting, so a html formatting
code may be the problem.

NEXT TEST - COPY INTO TEXT EDITOR THEN PASTE INTO 3RD NEW ARTICLE:

e) http://www.3111skyline.com/dl/bugs/egw/kb-article-copy2-view.jpg

f) http://www.3111skyline.com/dl/bugs/egw/kb-article-copy2-edit.jpg

IT WORKED !!! That makes no sense. The only way I can see this happening is
that there is some html tag that is causing fckeditor to choke. The damaging
part of this is that the only way the tag would have gotten into the articles
originally was if it was put there by the kb formatting. So it looks like
there may be some tag that was deprecated and then removed from fckeditor that
is now causing the current egw/kb/fckeditor to fail. If this is the case, then
all earlier articles that contain this tag will cause egw/kb to fail in the
way I’m seeing.

THIS ALSO APPEARS TO BE LIMITED TO THE NEW svnversion of egw.

I just permed the same test pasting the information into my 2nd egw install
( site b) ) above and I CAN re-edit the article even though it contains the
same information that caused the failure shown in d) above.

What a mess - what do you suggest next Klaus – I’m lost

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

Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar

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

David_C_Rankin 2013-03-22 17:31:20 UTC #13

WAIT!!! Something is fcked up here. If I COPY the content of the article into
a new article, I still CANNOT re-edit that article. Huh??

Take a look at these screenshots:

c) http://www.3111skyline.com/dl/bugs/egw/kb-article-copy-view.jpg

d) http://www.3111skyline.com/dl/bugs/egw/kb-article-copy-edit.jpg

Above, the text from the original article (
http://www.3111skyline.com/dl/bugs/egw/kb-article-view.jpg ) was copied into a
new article © above and Saved. I then attempted to re-edit the new article
and it failed (d) above. That makes NO sense to me. Could there be some
character in the text that is not shown that is causing the failure??? I have
had these egw installs since 1.0.0, so if there was every a character encoding
change, that may explain where the character problem is. But that still
doesn’t really make any sense!!!

I copied the text by simply selecting the text in ‘view’ mode and then used a
’middle-mouse-paste’ into the new article – so only the text was copied.
However, FF does attempt to copy the html formatting, so a html formatting
code may be the problem.

I dumped the contents from the new article from egw_kb_articles from the example
above. (select title, text from egw_kb_articles;) The contents of the article
that fails to include the text in the editor is:

test article 2 |
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 text for the ‘text-only’ article that can be opened again in the editor is:

Test Article 3 | This is a test of the fckeditor issue.

We will put some text here

Make a Title

Add more text

Here is another title added during edit

And more text…

The immediately notable difference is the presence of the

tag in the
article that will not open again in the editor and the absence of any

tag
in the one that works. Looking through the text of other articles in my kb, the
ones without the

tags can be opened up and edited in kb. The ones that
have

tags don’t work anymore. Could this be the issue?

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

Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar

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

David_C_Rankin 2013-03-22 17:37:41 UTC #14

WAIT!!! Something is fcked up here. If I COPY the content of the article into
a new article, I still CANNOT re-edit that article. Huh??

Take a look at these screenshots:

c) http://www.3111skyline.com/dl/bugs/egw/kb-article-copy-view.jpg

d) http://www.3111skyline.com/dl/bugs/egw/kb-article-copy-edit.jpg

Above, the text from the original article (
http://www.3111skyline.com/dl/bugs/egw/kb-article-view.jpg ) was copied into a
new article © above and Saved. I then attempted to re-edit the new article
and it failed (d) above. That makes NO sense to me. Could there be some
character in the text that is not shown that is causing the failure??? I have
had these egw installs since 1.0.0, so if there was every a character encoding
change, that may explain where the character problem is. But that still
doesn’t really make any sense!!!

I copied the text by simply selecting the text in ‘view’ mode and then used a
’middle-mouse-paste’ into the new article – so only the text was copied.
However, FF does attempt to copy the html formatting, so a html formatting
code may be the problem.

I dumped the contents from the new article from egw_kb_articles from the example
above. (select title, text from egw_kb_articles;) The contents of the article
that fails to include the text in the editor is:

test article 2 |
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 immediately notable difference is the presence of the

tag in the
article that will not open again in the editor and the absence of any
tag
in the one that works. Looking through the text of other articles in my kb, the
ones without the
tags can be opened up and edited in kb. The ones that
have
tags don’t work anymore. Could this be the issue?
I think we found the issue. Recall I also pasted the same information into my
2nd egw install and I could edit it. Well, I dumped the text there as well and
it is different! If you look below, the

tags are wrapped within a
tag which seems to allow fckeditor to handle the issue without any problem, but
you can see in the ‘test article 2’ text above there are no

tags. This
is the only difference I can find and the only difference that seems to point to
why it will open in one install and not in the other. Why are the
tags
not wrapping the
tags in ‘test article 2’?? Here is the text from the
working (rlfpllc.com) egw install:

Test Article 3 |

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

|

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

Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar

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

David_C_Rankin 2013-03-25 02:19:38 UTC #15

I think we found the issue. Recall I also pasted the same information into my
2nd egw install and I could edit it. Well, I dumped the text there as well and
it is different! If you look below, the

tags are wrapped within a
tag which seems to allow fckeditor to handle the issue without any problem, but
you can see in the ‘test article 2’ text above there are no

tags. This
is the only difference I can find and the only difference that seems to point to
why it will open in one install and not in the other. Why are the
tags
not wrapping the
tags in ‘test article 2’?? Here is the text from the
working (rlfpllc.com) egw install:

Test Article 3 |

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

|

Klaus,

After you have a chance to review the 3 earlier posts, I still do not know
where this error was introduced or exactly how/where the

tag wrapping of

takes place. Also, how do we fix all the existing kb articles that do not have the

tags -- that prevent the articles from being edited? If this problem is a lack of

tags for existing entries in the egw_kb_articles table -- How are the existing articles going to be fixed so they can be edited again? Should the kb code be updated to check for their existence and then add the appropriate tags if they do not exist? That way it would be transparent to current users, but still fix the problem.

Another issue is identifying when the

tags are required. From my rough
look at the issue, it looks like whenever there is an ‘indent’ within a kb
article a

is inserted to handle the indention. It appears that if a

is added – then the

tag wrapping the

is required.

Your thoughts?

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

Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar

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

David_C_Rankin 2013-03-25 20:50:19 UTC #16

Klaus,

After you have a chance to review the 3 earlier posts, I still do not know
where this error was introduced or exactly how/where the
tag wrapping of
takes place. Also, how do we fix all the existing kb articles that do not have the
tags -- that prevent the articles from being edited? If this problem is a lack of
tags for existing entries in the egw_kb_articles table -- How are the existing articles going to be fixed so they can be edited again? Should the kb code be updated to check for their existence and then add the appropriate tags if they do not exist? That way it would be transparent to current users, but still fix the problem.
Another issue is identifying when the

tags are required. From my rough
look at the issue, it looks like whenever there is an ‘indent’ within a kb
article a
is inserted to handle the indention. It appears that if a

is added – then the
tag wrapping the
is required.
Your thoughts?

Klaus,

The

tag may be a wild goose chase… I have done some more
line-by-line testing to see if I could make the editor fail with just plain text
– and I can.
Pasting line-by-line the following (excluding -----) will illustrate:
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
All works fine, (copy,paste,save,edit) until you get to the line:
touch -d “2012-07-23 14:21:23” filename
Looking at the actual code generated by fckeditor on paste you get:
touch -d “2012-07-23 14:21:23” filename
This BREAKS the ability to re-edit the article. Looking closely, you see that
the editor has inserted a non-breaking space terminated ( )
attempting to preserve the double-space between ‘a’ and ‘b’ in the original.
While the html code is correct, the or ( ), the code seems to be
what is killing the ability to re-edit.
Another simple example will illustrate what I’m talking about. Cut and paste the
following into kb and then, before saving, press the ‘Source’ button to see what
will be saved.
Two spaces between a and b:
a b
When you paste this into the fckeditor, and then press the ‘Source’ button on
the editor button bar you see the following:
Two spaces between a and b:

a b

Attempting to re-edit causes the exact blank edit window failure first reported.
Now simply remove the double-space between ‘a’ and ‘b’ and then everything
works fine.
So it looks like the character is the problem. I can’t explain why I can
re-edit the article in one egw install 1.8.004 (svn r41685) and why it fails in
(svn r42037). One thing that I can confirm, if in a egw_kb_article ‘text’ field,
you have the char, it does cause the blank edit window in the current
knowledge base. What is also clear, is even when no code is present, but
a double-space ’ ’ is present in the field – it also causes the current svn
rev to show a blank edit window on edit.
So in sum “It’s the Double-Space” that is causing the problems. Help!
–
David C. Rankin, J.D.,P.E.
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

ngegw 2013-03-27 14:13:06 UTC #17

…
The
tag may be a wild goose chase… I have done some more
line-by-line testing to see if I could make the editor fail with just plain text
– and I can.
…
So in sum “It’s the Double-Space” that is causing the problems. Help!
I have no idea about ckeditor or how to fix it, but that’s some nice debugging.
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-03-27 20:13:17 UTC #18

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

Correction,

For some reason, pasting from an e-mail causes fckeditor to insert a

 tag

at the beginning instead of 
 tags to preserver spacing. When a  tag is

inserted at the beginning, then no   non-breaking space is used for the

double-space. To provide the correct text/html from my example I created a

simple html page here:
http://www.3111skyline.com/dl/bugs/egw/fck-test-html.html
It is the same html as fckeditor creates on pasting the original article that

cannot be edited into a new article edit window.
Ralf, Klaus, let me know your thoughts on this and what additional testing you

want me to do. After identifying the double-space as the problem, I’m not sure

where to look next. I know this isn’t a huge issue, but at present every kb

article that has a double-space cannot be edited. Do you want me to open a

ticket on this, or do you just want to work it from this thread?
–

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

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-03-27 21:03:45 UTC #19

…

The
tag may be a wild goose chase… I have done some more
line-by-line testing to see if I could make the editor fail with just plain text
– and I can.
…
So in sum “It’s the Double-Space” that is causing the problems. Help!
I have no idea about ckeditor or how to fix it, but that’s some nice debugging.
Thanks Nathan – and that is the kicker. Is this:
(a) purely ckeditor? or
(b) the way egw is feeding the ‘text’ field contents from the egw_kb_articles
table to ckeditor?
We need a way to determine If the bug needs to go to the ckeditor folks or if
it is with egw. (I haven’t checked, but hope ckeditor is still an active project).
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?
–
David C. Rankin, J.D.,P.E.
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 14:10:48 UTC #20

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???

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

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

next page →