Kunena move to crowdin for the translations

Like announced in the release nots of the K6.4 RC4 release, Kunena project has moved to crowdin : crowdin.com/project/kunena-forum to manage translations from K6.4 and beyond. The RC4 release is the last version before the stable, so for all translators please update your translations on crowdin.

Transifex is keept for translations from K6.3 and the previous versions of Kunena.

Kunena 6.3.10 Released
The Kunena team has announce the arrival of Kunena 6.3.10[K 6.3.10] in stable which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x/5.1.x/5.2.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 and issues discovered during the last development stages of K 6.3
Note: Please go to the Kunena Dashboard after an upgrade so that the Kunena database tables are also updated.

Solved Incorrect datetime value: '1696996446' for column 'allreadtime' at row 1

More
1 year 5 months ago - 1 year 5 months ago #1 by boyjah
Incorrect datetime value: '1696996446' for column 'allreadtime' at row 1 was created by boyjah
We are in the process of trying to upgrade our Joomla-based website to Joomla 4. We have figured out how to solve many problems so that we can move ahead. Our last issues are with Kunena. Everything in the Admin backend seems to be fine. Running all the tests and checks, Kunena tells us that everything is fine. But when we click on any link to a forum topic, we see the error:

Incorrect datetime value: '1696996446' for column 'allreadtime' at row 1

Of course the datetime value number changes depending on what user we login as, but it remains the same if we logout and then login again as the same user and click a forum post link.

Configuration report:

This message contains confidential information

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

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

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

Kunena menu details:

Warning: Spoiler!

Joomla default template details : cassiopeia | author: Joomla! Project | version: 1.0 | creationdate: 2017-02

Kunena default template details : Aurelia | author: Kunena Team | version: 6.1.4 | creationdate: 2023-10-05

Kunena template params:

Warning: Spoiler!

Kunena version detailed: Kunena 6.1.4 | 2023-10-05 [ Git Repository ]
        | Kunena detailed configuration:

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

Third-party components: CommunityBuilder 2.8.2

Third-party SEF components: None

Plugins: Content - Kunena Discuss 6.0.2-DEV

Modules: Kunena Latest 6.0.2


Please can someone tell us why this is happening, where it is coming from, and how we can fix it. Kunena problems are the only thing keeping us from going live with our Joomla 4 update.

Kunena version 6.1.4
Joomla version 4.3.4
Using all default templates for Joomla and Kunena
Last edit: 1 year 5 months ago by boyjah. Reason: Submission said that not configuration report probably means no help...

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

More
1 year 5 months ago #2 by Gindi
Replied by Gindi on topic Incorrect datetime value: '1696996446' for column 'allreadtime' at row 1
Please check in the database table xxxx_kunena_user_categories if name=allreadtime, type=int(11), null=no, default=0 is entered.

Gindi
 

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

More
1 year 5 months ago #3 by boyjah
Replied by boyjah on topic Incorrect datetime value: '1696996446' for column 'allreadtime' at row 1

Please check in the database table xxxx_kunena_user_categories if name=allreadtime, type=int(11), null=no, default=0 is entered.

Gindi


Your advice fixed the situation. But I want to know why such a technically difficult process is necessary to make Kunena work properly. Who is responsible for such issues? I have spent hours altering the collation of Kunena tables and columns to get past a previous problem. Why is this kind of problem not addressed when we are upgrading? We had to change the collation and Storage engine settings for all Kunena database items. Why is this kind of change not part of any Kunena update? Everything we have in our very complicated website is working after upgrading to Joomla 4. But Kunena gives us endless problems. SO MANY PROBLEMS BECAUSE OF KUNENA.

 

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

More
1 year 5 months ago #4 by Gindi
Replied by Gindi on topic Incorrect datetime value: '1696996446' for column 'allreadtime' at row 1
I am glad that my advice has helped.
To be clear, I am a normal Joomla and Kunena user and have nothing to do with the forum programmatically.
I just like to help other users within my possibilities and also like to test beta versions and release canditates.
About your many problems you would have to inform the programmers because for me the forum, except for a few blemishes, works very well.

Gindi

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

Time to create page: 0.357 seconds