Joomla Templates Club 406,261 posts

[obliat Friend obliatJoin date: December 2010Posts: 416Downloads:12Uploads:64 Thanks: 108 Thanked: 31 times in 1 posts]

#179141

Hi guys, anyone experiences character mismatch with JA Comment.

I do have a cyrillic website (http://www.ecars.bg) and some JA Comments look odd showing weird characters – please see picture. There is probably an encoding conflict, so I’d need some help resolving it. Thanks ahead.

Martin

---

Attachments:

1. 

[Stork11 Friend Stork11Join date: March 2011Posts: 2273Downloads:0Uploads:142 Thanks: 55 Thanked: 431 times in 393 posts]

#461143

Hello obliat,

Can you PM me with your site information (your site URL, your site admin account) and your FTP account? So I can diagnose this problem.

BTW, please include this forum thread URL in your PM, so I can follow it.

Best regards.

[obliat Friend obliatJoin date: December 2010Posts: 416Downloads:12Uploads:64 Thanks: 108 Thanked: 31 times in 1 posts]

#461360

Ah, thanks Stork – PM sent – nice having your support again 🙂

Still waiting for devs to make JA Bulletin have an option to set time frame for Most viewed K2 items LOL

[Stork11 Friend Stork11Join date: March 2011Posts: 2273Downloads:0Uploads:142 Thanks: 55 Thanked: 431 times in 393 posts]

#461569

Hello obliat,

Can you PM me with your phpMyadmin account? I guess your encoding of “comment” table in your database has some problems.

BTW, please include this forum thread URL in your PM, so I can follow it.

Best regards.

[obliat Friend obliatJoin date: December 2010Posts: 416Downloads:12Uploads:64 Thanks: 108 Thanked: 31 times in 1 posts]

#461651

Ah well, that could be a challenge – it’s a cyrillic hosting website and it’s lots of clicking until you get to cPanel and phpmyadmin. I guess I’ll have to make screenshots so you find your way trough – let me know so I can do it. Or you can tell me which table in the DB I check collation (encoding).

Thanks

[Stork11 Friend Stork11Join date: March 2011Posts: 2273Downloads:0Uploads:142 Thanks: 55 Thanked: 431 times in 393 posts]

#461708

<em>@obliat 331026 wrote:</em><blockquote>Ah well, that could be a challenge – it’s a cyrillic hosting website and it’s lots of clicking until you get to cPanel and phpmyadmin. I guess I’ll have to make screenshots so you find your way trough – let me know so I can do it. Or you can tell me which table in the DB I check collation (encoding).

Thanks</blockquote>
Thank you.

I need to know structure of “#__jacomment_items” table. Can you send me its screenshot?

Regards.

[obliat Friend obliatJoin date: December 2010Posts: 416Downloads:12Uploads:64 Thanks: 108 Thanked: 31 times in 1 posts]

#461712

can’t attach vie PM as it only allows images from url and image is on my desktop so attaching here

Thanks

---

Attachments:

1. 

[Stork11 Friend Stork11Join date: March 2011Posts: 2273Downloads:0Uploads:142 Thanks: 55 Thanked: 431 times in 393 posts]

#461908

Thank you obliat for your screenshot.

After 1 day to diagnose your site, I can’t find any problem in code. It ran well on my local host with utf-8 data. So I think your data has problem with utf-8 charset encoding. Please set up a phpMyadmin account and PM me. I need it to help you out.

Regards.

[obliat Friend obliatJoin date: December 2010Posts: 416Downloads:12Uploads:64 Thanks: 108 Thanked: 31 times in 1 posts]

#461918

Sure, I sent PM – let’s hope it works the way I describe it. I guess we have the issue locally, because we use cyrillic characters…

[Stork11 Friend Stork11Join date: March 2011Posts: 2273Downloads:0Uploads:142 Thanks: 55 Thanked: 431 times in 393 posts]

#462586

Hello obliat,

Because some your comments have some special character, so they’re displayed as characters with semi-colon ‘;’ at the end. If after these characters have a close bracket ‘)’, they’ll be converted to smiley.

So a temporary solution is you should add a space in front of close bracket in edit mode in back-end if you see problem. Like a sample here: index.php?Itemid=412&option=com_k2&view=item&task=3089:skupo-zarezhdane-elektromobili&id=3089:skupo-zarezhdane-elektromobili#jacommentid:154

I added this problem to our backlog and will ping our developers to resolve it.

Thank you for your report.

Regards.

[obliat Friend obliatJoin date: December 2010Posts: 416Downloads:12Uploads:64 Thanks: 108 Thanked: 31 times in 1 posts]

#462690

Thanks Stork

Sounds like a reasonable explanation and the only issue is that I won’t be able to tell this everyone who comments you know :laugh:

It’s of course a combo of a symbol and the closing bracket, and the system obviously does not like the cyrillic letters very much LOL

It will be great to have it fixed as it looks weird so thanks for your efforts. I have to come back to the forum all the time now as I don’t get email notifications on replies which I created new thread about 🙂

Best Regards

[Stork11 Friend Stork11Join date: March 2011Posts: 2273Downloads:0Uploads:142 Thanks: 55 Thanked: 431 times in 393 posts]

#462769

<em>@obliat 332396 wrote:</em><blockquote>Thanks Stork

Sounds like a reasonable explanation and the only issue is that I won’t be able to tell this everyone who comments you know :laugh:

It’s of course a combo of a symbol and the closing bracket, and the system obviously does not like the cyrillic letters very much LOL

It will be great to have it fixed as it looks weird so thanks for your efforts. I have to come back to the forum all the time now as I don’t get email notifications on replies which I created new thread about 🙂

Best Regards</blockquote>
Hello obliat,

Finally, I resolved the problems (phew). I added following code in to “showSmiley” function in “componentscom_jacommenthelpersjahelper.php”, above “foreach ($array as $k => $v)” line:
[PHP]$str = html_entity_decode($str, ENT_QUOTES, “ISO-8859-1”);[/PHP]

Please check and confirm the same 🙂

Regards.

1 user says Thank You to Stork11 for this useful post

1. obliat

[obliat Friend obliatJoin date: December 2010Posts: 416Downloads:12Uploads:64 Thanks: 108 Thanked: 31 times in 1 posts]

#462803

I checked out one of the articles with comments showing those weird characters and they are gone so FANTASTIC – thanks a lot – I guess all Bulgarian, Russian and whoever uses cyrillic is going to be fine with comments now.

Awesome

Thanks a bunch!

[Author]

Posts