Hey Cristiano,

We are no longer processing smileys as there was a major performance downside in processing them. This is the main reason why Komento 4 is a major upgrade.

Since unicode does a much better job, we decided to stick to this format and remove legacy processes.

Hey Mark,

yes I understand and I agree. You did the right thing removing the legacy. But a one-off batch tool "una tantum" or a simple one-time database query would have been useful for past comments, or during installation. Of course I can't ask it just for me. Maybe there aren't many of us in my situation, but I tried to edit one in the frontend as administrator and it signals me in the activity, forcing me to delete the string in the DB. I haven't tried it in the backend, but I see that the bbcode is not active there.
But basically as I said it's not serious, thanks for the answer.
Have a nice weekend

Cristiano

Thanks for your input, we do not do this smiley emoticon conversion process during the update, it might cause a performance issue during the update if the site has a lot of comments, because it needs to scan through each of the comments and see which comment contain those smiley emoticons.

If you would like to do this conversion separately from your database, you can try to do it this way, hope this can help you, and remember to do a full backup on your database first before you proceed with anything.

// Replace jos_ to your current table prefix

// remember check my attached screenshot because the smiley emoticons will get removed after I put into the reply content.



UPDATE `jos_komento_comments` 

   set 

`comment` = REPLACE(`comment`, '', '😊'), 

`preview` = REPLACE(`preview`, '', '😊');

Yes thank you, that's kind of you, and it might work. I was thinking of something similar. I make a backup every breath because I am busy updating many different extensions and conflicts.
Please put resolved and close here. If I have more I will let you know .
Have a good week!

Cristiano

Hi there,

You are most welcome. Glad to hear that your issue has been resolved now.

Just for your information, I have locked and marked this thread as resolved to avoid confusion in the future. Please start a new thread if you have any other issues in the future so it will be easier for us to manage your inquiries.

Thanks for understanding.