Keyword

Extra fields encoding problem after duplicate article

  • sunconcept
  • sunconcept's Avatar Topic Author
  • Offline
  • Junior Member
More
7 years 2 months ago #160566 by sunconcept
Hi guys I have a big problem with the extra fields encoding after duplicating an k2 article.

We're using k2 for a small job center and with the extra fields, we provide more information about the jobs. Some jobs needed to be duplicated and when I copy one of them, the extra fields are broken (I mean the characters öäüÖÄÜß) – even the name of the extra field! Please see my screenshot.

My customer also reported, that this bug occurs while a normal saving of articles... While working on the article, the characters are right and after saving, they are broken. I had a look in the DB, its all utf8mb4_general_ci but the special characters (only in extra fields!) are saved as: \u00c4\u00c4\u00c4.

Screenshot: test.sun-concept.de/screenshot_k2.jpg

Please help!

Greetings
Tobias

Please Log in or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
7 years 2 months ago #160569 by Krikor Boghossian
Replied by Krikor Boghossian on topic Extra fields encoding problem after duplicate article
Is the utf8mb4_general_ci collation for both the cell and the table?

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

  • sunconcept
  • sunconcept's Avatar Topic Author
  • Offline
  • Junior Member
More
7 years 2 months ago - 7 years 2 months ago #160574 by sunconcept
What do you mean? Have a look at this screenshot:

test.sun-concept.de/table-mysql.png
Last edit: 7 years 2 months ago by sunconcept.

Please Log in or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
7 years 2 months ago #160589 by Krikor Boghossian
Replied by Krikor Boghossian on topic Extra fields encoding problem after duplicate article
Halfway there :)
Check the table's cells as well.
PS, DO NOT perform any operations without a backup.

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
7 years 2 months ago #160590 by Krikor Boghossian
Replied by Krikor Boghossian on topic Extra fields encoding problem after duplicate article
Halfway there :)
Check the table's cells as well.
PS, DO NOT perform any operations without a backup.

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

  • sunconcept
  • sunconcept's Avatar Topic Author
  • Offline
  • Junior Member
More
7 years 2 months ago #160637 by sunconcept
Hi Krikor,

do you mean this: test.sun-concept.de/db.png

Or what do you mean and where can I check that?

Greetings
Tobias

Please Log in or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
7 years 2 months ago #160664 by Krikor Boghossian
Replied by Krikor Boghossian on topic Extra fields encoding problem after duplicate article
Here is what I mean -> imgur.com/a/yolnU

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

  • sunconcept
  • sunconcept's Avatar Topic Author
  • Offline
  • Junior Member
More
7 years 2 months ago #160667 by sunconcept
I had a look at it and the cells were also UTF8 collation.

But I solved the problem: I made a backup with akeeba backup and installed it with the options "force UTF collation" etc. and now it works!

Thank you.

Please Log in or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
7 years 2 months ago #160677 by Krikor Boghossian
Replied by Krikor Boghossian on topic Extra fields encoding problem after duplicate article
Nice to hear that you resolved the issue :)

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.


Powered by Kunena Forum