Kunena 7.0.8 Released

The Kunena team has announce the arrival of Kunena 7.0.8 [K 7.0.8] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x./6.1.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

Solved Database problems after migration from Kunena 5 to 6.3.2

More
2 years 1 month ago #231662 by Klausimausi
Database problems after migration from Kunena 5 to 6.3.2 was created by Klausimausi
Hi there,

i just updated two sites from Joomla 3.1 to Joomla 5.1.1. One one site all went well on the other side i exprerience odd behaviours which i cant fix.

i wanted to count Kunena stats in the backend since it seemed the Counts of Topics wasnt correct.

I got this error message in return:

0 Unknown fetch type '8'

So i tried diagnostic which gave me the following error:

1267 Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '='

In the database there seems to be a mix of both coalitions but it seems on the site where all is working fine its exact the same coalitions settings..

Any ideas?

Thanks in advance!

K.

This message contains confidential information

Database collation check: The collation of your table fields are correct
        

Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Disabled |
       

This message contains confidential information
htaccess: Exists | PHP environment: Max execution time: 240 seconds | Max execution memory: 256M | Max file upload: 

Kunena menu details:

Warning: Spoiler!

Joomla default template details : YOOtheme | author: YOOtheme | version: 4.4.4 | creationdate: June 2024

Kunena default template details : NTS Kay | author: Nice Theme Store Team | version: 6.2.5 | creationdate: 2024-06-22

Kunena template params:

Warning: Spoiler!

Kunena version detailed: Kunena 6.3.2 | 2024-06-14 [ Git Repository ]
        | Kunena detailed configuration:

Warning: Spoiler!
| Kunena integration settings:
Warning: Spoiler!
| Joomla! detailed language files installed:
Warning: Spoiler!

Third-party components: UddeIm 5.4

Third-party SEF components: None

Plugins: None

Modules: None

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

More
2 years 1 month ago #231665 by rich
Replied by rich on topic Database problems after migration from Kunena 5 to 6.3.2
Is this configuration report from the working page? No collation error is displayed in it.

Install Kunena on the broken site over it again and then go directly to the Kunena dashboard. This should adjust the collation.
Important! Always create a backup before you make any changes to your website!

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

More
2 years 1 month ago #231666 by Klausimausi
Replied by Klausimausi on topic Database problems after migration from Kunena 5 to 6.3.2
Hiho rich,

thank you for your quick reply!
Yes its from the working page.

i just solved the problem by going into phpMyAdmin and change the coalition of the kunena columms from utf8mb4_0900_ai_ci to utf8mb4_unicode_ci at the following tables:

kunena_categories
kunena_topics
kunena_messages
kunena_messages_text

After doing that it looks like working flawlessly. I was able to recount the stats and the stats are now correct. Also i was able to run diagnostic tool and fix broken elements.

Weird tho in the other forum the above mentioned tables still are set to utf8mb4_0900_ai_ci and work flawlesly...

Kind regards,
K.

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

More
2 years 1 month ago #231669 by rich
Replied by rich on topic Database problems after migration from Kunena 5 to 6.3.2
This problem can remain undetected for a long time until, for example, an emoji is inserted into a post. If this is not allowed with this collation, this error occurs ( see also here ).
Important! Always create a backup before you make any changes to your website!

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

Time to create page: 0.279 seconds