- Posts: 104
- Thank you received: 0
Kunena 7.0.4 Released
The Kunena team has announce the arrival of Kunena 7.0.4 [K 7.0.4] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0
Question FIX: html special characters appearing in subject and reply subject
- bytebandit01
-
Topic Author
- Offline
- Senior Member
-
* '&' (ampersand) becomes &
* '"' (double quote) becomes " when ENT_NOQUOTES is not set.
* ''' (single quote) becomes ' only when ENT_QUOTES is set.
* '<' (less than) becomes <
* '>' (greater than) becomes >
here's a possible fix that i used..
\components\com_kunena\template\default\fb_write.html.php
line 39:
replace with:
\components\com_kunena\template\CURRENT_TEMPLATE_USED(e.g. default_ex)\message.php
line 67:
replace with:
note: for default template it is..
\components\com_kunena\template\default\message.php it is around line 200:
edit: i did upgraded from kunena 1.08 to 1.08 maybe that's why i still have those special characters appearing from my old messages. if anyone is encountering the same, feel free to use the steps above, as it did work for me.
Please Log in or Create an account to join the conversation.
Even better solution would be to replace all &s etc in the database with the right characters. Does someone want some exercise?
Please Log in or Create an account to join the conversation.
- bytebandit01
-
Topic Author
- Offline
- Senior Member
-
- Posts: 104
- Thank you received: 0
i can't confirm this one now since i am using those patches already.. so far it's working as intended - no more html special characters appearing from the subject line.
Please Log in or Create an account to join the conversation.
- bytebandit01
-
Topic Author
- Offline
- Senior Member
-
- Posts: 104
- Thank you received: 0
i'm now interested in that exercise. if you can share an sql query for it, i'd appreciate it as am no well-verse with that stuff anymore.
Please Log in or Create an account to join the conversation.
UPDATE `jos_fb_messages` SET `subject` = REPLACE(`subject`, "&", "&");
UPDATE `jos_fb_messages` SET `subject` = REPLACE(`subject`, """, "\"");
UPDATE `jos_fb_messages` SET `subject` = REPLACE(`subject`, "'", "'");
UPDATE `jos_fb_messages` SET `subject` = REPLACE(`subject`, "<", "<");
UPDATE `jos_fb_messages` SET `subject` = REPLACE(`subject`, ">", ">");
I would like to know: did it work?
Please Log in or Create an account to join the conversation.