- Posts: 22
COMMUNITY FORUM
Extra fields encoding problem after duplicate article
- sunconcept
- Topic Author
- Offline
- Junior Member
Less
More
7 years 2 months ago #160566
by sunconcept
Extra fields encoding problem after duplicate article was created 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
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
- Offline
- Platinum Member
Less
More
- Posts: 15920
7 years 2 months ago #160569
by Krikor Boghossian
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
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
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 22
7 years 2 months ago - 7 years 2 months ago #160574
by sunconcept
Replied by sunconcept on topic Extra fields encoding problem after duplicate article
Last edit: 7 years 2 months ago by sunconcept.
Please Log in or Create an account to join the conversation.
- Krikor Boghossian
- Offline
- Platinum Member
Less
More
- Posts: 15920
7 years 2 months ago #160589
by Krikor Boghossian
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
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.
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
- Offline
- Platinum Member
Less
More
- Posts: 15920
7 years 2 months ago #160590
by Krikor Boghossian
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
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.
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
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 22
7 years 2 months ago #160637
by sunconcept
Replied by sunconcept on topic Extra fields encoding problem after duplicate article
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
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
- Offline
- Platinum Member
Less
More
- Posts: 15920
7 years 2 months ago #160664
by Krikor Boghossian
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
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
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 22
7 years 2 months ago #160667
by sunconcept
Replied by sunconcept on topic Extra fields encoding problem after duplicate article
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.
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
- Offline
- Platinum Member
Less
More
- Posts: 15920
7 years 2 months ago #160677
by Krikor Boghossian
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
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.