Solved A glitch in the number of posts in the topic

Maybe it's worth doing this at the level of your programs?

The field can contain huge amount of characters, enough for normal forum use.

The standard 

Code:

TEXT

 data object is sufficiently capable of handling typical long-form text content. TEXT data objects top out at 64 KB (expressed as 2^16 -1) or 65,535 characters

Looking at your "forum" it seems that you are using it as a sort of blog.

Pinkeltje wrote:

Maybe it's worth doing this at the level of your programs?

The field can contain huge amount of characters, enough for normal forum use.

The standard TEXT data object is sufficiently capable of handling typical long-form text content. TEXT data objects top out at 64 KB (expressed as 2^16 -1) or 65,535 characters

Looking at your "forum" it seems that you are using it as a sort of blog.

Pinkeltje wrote:

TEXT data objects top out at 64 KB (expressed as 2^16 -1) or 65,535 character

You have ambiguity in the word "character", so for Russian and many other languages, a letter can take up two or more bytes. So the capacity of TEXT data for the Russian part of my site is almost half that.

Pinkeltje post=231694 userid=31071

Looking at your "forum" it seems that you are using it as a sort of blog.

This remark is unclear to me, as it is an explicit off-top. Nevertheless, I will answer that more than a hundred users participate in the work of the "forum" in the German and Russian-speaking parts of the site and they discuss with each other on different topics. So the word "blog" is not appropriate.
If you mean the wrong choice of Kunena as a platform, then I can inform you that the choice took place in those blessed times when it was possible to choose a tree structure in the Kunena template, which of course is best suited for a popular science forum. Unfortunately, this option has disappeared over time.
This led to some outflow of users, but I am still very grateful to the Kunena developers for their work and for their very attentive attitude to the problems that arise by users of the Kunena platform.

Pinkeltje wrote:

Have you tried to recount statistics and run diagnostics?

I have done recount statistics. I received a message:

Exception throw at line 442 in file /.../libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php with message Data too long for column 'last_post_message' at row 368

After "run diagnostics", in all lines there is "No errors found!".

BUT!
The information about the number of posts in the topic, given in the first and second posts of this topic

5. However,
a) the number of posts in the topic has not changed (that is, the new post has not been taken into account
b) When clicking on the "Last" button on the Forum -> Recent Topics page, the move takes place to the previous post (which has not had a problem yet).

In the topic with which the problem occurred, there are 22 posts in total, and the Recent Topics page shows that there are 19 answers.

remained unfortunately valid.
----

How can I react to the message:
Exception throw at line 442 in file /.../libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php with message Data too long for column 'last_post_message' at row 368

Thanks
 

Try the solution that rich gave you.

rich wrote:

It must be an extremely long text. If you then edit it, you will probably add a lot more, so that the character limit is exceeded. It might help if you change the value of the columns last_post_message and first_post_message in the table #__kunena_topics from TEXT to LONGTEXT.

I did not make changes to the database, but took advantage of Rich's assumption that the text was too long.

I divided the problematic post into two, and everything worked fine. In particular, "run diagnostics" has brought the statistics and operation of the Recent Topics button back to normal.

Many thanks to Rich and Pinkeltje for their help.

The topic is closed.