Kunena 6.3.0 released

The Kunena team has announce the arrival of Kunena 6.3.0 [K 6.3.0] in stable which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x/5.1.x. This version addresses most of the issues that were discovered in K 6.2 and issues discovered during the last development stages of K 6.3

Solved Error while rendering KunenaLayout

More
1 month 5 days ago #1 by stnw
Hello,
after the Update from Joomla 3 to Joomla 4 and Kunea 5 to Kunea 6, i become an Error message. If i click to "new topic" or if i want to read an old topic i get this error message:

Error while rendering KunenaLayout.
Table 'xx.xx_kunena_private' doesn't exist


I changend the template to the Joomla Standard Template Cassiopeia, but here also the same Error message.
Have anyone an idea where the error comes from?

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: 30 seconds | Max execution memory: 128M | Max file upload:

Kunena menu details:

Warning: Spoiler!

Joomla default template details : YOOtheme | author: YOOtheme | version: 4.3.8 | creationdate: March 2024

Kunena default template details : Aurelia | author: Kunena Team | version: 6.2.5 | creationdate: 2024-03-21

Kunena template params:

Warning: Spoiler!

Kunena version detailed: Kunena 6.2.5 | 2024-03-21 [ Git Repository ]
| Kunena detailed configuration:

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

Third-party components: None

Third-party SEF components: None

Plugins: Content - Kunena Discuss 6.0.5

Modules: Kunena Latest 6.0.5 | Kunena Stats 6.0.5 | Kunena Login 6.0.6 | Kunena Search 6.0.5

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

More
1 month 5 days ago #2 by Gindi
Is only the table 'xx.xx_kunena_private' missing in the database or also the tables 'xx.xx_kunena_private_attachment_map' , xx.xx_kunena_private_post_map' and 'xx.xx_kunena_private_user_map' ?

Have you tried in the Kunena configuration under users to set the "Enable private messages" to NO?

gindi

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

More
3 weeks 2 days ago #3 by stnw
Hi Gingi, thanks for your reply.
I checked the database. All of these tables are missing.
How can I restore these missing tables?

"Enable private messages" is set to Yes. But there is no difference if I set it to "No".

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

More
3 weeks 2 days ago - 3 weeks 2 days ago #4 by xillibit
Hello,

It seems in the update process the news tables hasn't been created. Do a abckup of your database and set your prefix for the tables and run that in phpmyadmin :
Code:
CREATE TABLE IF NOT EXISTS `#__kunena_private` (                 `id`          int                                 NOT NULL AUTO_INCREMENT,                 `parent_id`   int                                 NOT NULL DEFAULT '0',                 `author_id`   int                                 NOT NULL DEFAULT '0',                 `created_at`  datetime                            NOT NULL,                 `attachments` tinyint                             NOT NULL DEFAULT '0',                 `subject`     tinytext COLLATE utf8mb4_unicode_ci NOT NULL,                 `body`        text COLLATE utf8mb4_unicode_ci     NOT NULL,                 `params`      text COLLATE utf8mb4_unicode_ci     NOT NULL,                 PRIMARY KEY (`id`),                 KEY `parent_id` (`parent_id`),                 KEY `author_id` (`author_id`),                 KEY `created_at` (`created_at`)                 );             CREATE TABLE IF NOT EXISTS `#__kunena_private_attachment_map` (                 `private_id`    int NOT NULL,                 `attachment_id` int NOT NULL,                 PRIMARY KEY (`private_id`, `attachment_id`),                 KEY `attachment_id` (`attachment_id`)                 );             CREATE TABLE IF NOT EXISTS `#__kunena_private_post_map` (                 `private_id` int NOT NULL,                 `message_id` int NOT NULL,                 PRIMARY KEY (`private_id`, `message_id`),                 KEY `message_id` (`message_id`)                 );             CREATE TABLE IF NOT EXISTS `#__kunena_private_user_map` (                 `private_id` int      NOT NULL,                 `user_id`    int      NOT NULL,                 `read_at`    datetime NOT NULL,                 `replied_at` datetime NOT NULL,                 `deleted_at` datetime NOT NULL,                 PRIMARY KEY (`private_id`, `user_id`),                 KEY `user_id` (`user_id`)                 );

I don't provide support by PM, because this can be useful for someone else.
Last edit: 3 weeks 2 days ago by xillibit.
The following user(s) said Thank You: stnw

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

More
3 weeks 1 day ago #5 by stnw
It worked! Thank you very much.

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

Time to create page: 0.536 seconds