Solved A glitch in the number of posts in the topic

Hallo alle,

When editing one of the posts in a topic , the following situation occurred.

1. I don't know if it matters, but I've made changes to the post several times in a row and memorized them.

2. At some point, I saw that instead of the remembered post, the editing form with the post was still displayed on the computer screen.

3. I began to look at the screen and saw a message at the top above the editing form: "Data too long for column 'last_post_message' at row 1". 

4. Repeated attempts to edit and close the post led to the same result.
Thank God, when opening the topic again, it turned out that all the changes were preserved.

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).

How can I fix this situation, or is it a bug in the program?

Thanks

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: 256M | Max file upload:  

Kunena menu details:

Warning: Spoiler!

ID	Name	Menutype	Link	Path	In trash
1596	Форумы сайта	mainmenu	Itemid=1586	forumi	No
1586	Форум	kunenamenu	view=home&defaultmenu=1588	forum	No
1587	Оглавление	kunenamenu	view=category&layout=list&catid=0	forum/index	No
1588	Последнее	kunenamenu	view=topics&mode=replies	forum/recent	No
1589	Не прочитанное	kunenamenu	view=topics&layout=unread	forum/unread	No
1590	Новая тема	kunenamenu	view=topic&layout=create	forum/newtopic	No
1591	Без ответов	kunenamenu	view=topics&mode=noreplies	forum/noreplies	No
1592	Мои темы	kunenamenu	view=topics&layout=user&mode=default	forum/mylatest	No
1593	Профиль	kunenamenu	view=user	forum/profile	No
2130	Редактировать профиль	kunenamenu	view=user&layout=edit	forum/redaktirovat-profil	No
1594	Помощь	kunenamenu	view=misc	forum/help	No
1595	Поиск	kunenamenu	view=search	forum/search	No

Joomla default template details : purity_III | author: JoomlArt.com | version: 2.1.1 | creationdate: March 28th, 2024

Kunena default template details : Aurelia | author: Kunena Team | version: 6.3.2 | creationdate: 2024-06-14

Kunena template params:

Warning: Spoiler!

DefaultCategoryicon
profileIconset	default
DefaultIconset	default
editorIconset	default
bootstrap	1
borderless	1
tooltips	1
SubjectLengthMessage	80
fullactions	1
quick	0
displayMenu	1
displayDropdownMenu	1
displayDropdownContent	1
displayModule	1
displayBreadcrumb	1
displayAnnouncement	1
displayFooter	1
avatarPosition	left
formRecover	0
labels	0
whoisonlineName	default
avatarType	rounded
topicicontype	svg
fontawesome	0
socialshare	0
socialsharetag
socialtheme	classic
optional_username	0
writeaccess	0
localstorage	0
moduleIdWebauthn	0
IconColor	inherit
IconColorNew	#48a348
editorType	ckeditor
Bold	1
Italic	1
Underline	1
Strike	1
Subscript	1
Emoticon	1
Superscript	1
RemoveFormat	1
BulletedList	1
NumberedList	1
Blockquote	1
JustifyLeft	1
JustifyCenter	1
JustifyRight	1
JustifyBlock	1
Link_Unlink	1
Image	1
Confidential	1
Hidetext	1
Spoiler	1
Code	1
Ebay	1
X_Social	1
Instagram	1
Soundcloud	1
FontSize	1
TextColor	1
Maximize	1
Map	1
Video	1
editorButtons
nameskinckeditor
ckeditorcustomprefixconfigfile
avatarSizeX	40
avatarSizeY	90
avatarSizeXThumb	36
avatarSizeYThumb	36
avatarSizeXWelcome	72
avatarSizeYWelcome	72
avatarSizeXList	36
avatarSizeYList	36
avatarSizeXPost	144
avatarSizeYPost	144
avatarSizeXProfile	200
avatarSizeYProfile	200
templatebyText
templatebyName
templatebyLink

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

Warning: Spoiler!

Kunena config settings:
boardOffline	0
enableRss	1
threadsPerPage	30
messagesPerPage	30
messagesPerPageSearch	15
showHistory	1
historyLimit	10
showNew	1
disableEmoticons	0
template	aurelia
showAnnouncement	0
avatarOnCategory	0
showChildCatIcon	1
rteWidth	450
rteHeight	300
enableForumJump	1
reportMsg	1
username	1
askEmail	0
showEmail	0
showUserStats	0
showKarma	0
userEdit	1
userEditTime	0
userEditTimeGrace	600
editMarkup	0
allowSubscriptions	1
subscriptionsChecked	1
allowFavorites	1
maxSig	300
regOnly	0
pubWrite	0
floodProtection	0
mailModerators	0
mailAdministrators	0
captcha	1
mailFull	1
allowAvatarUpload	1
allowAvatarGallery	0
avatarQuality	65
avatarSize	2048
imageHeight	800
imageWidth	800
imageSize	1000
fileTypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2
fileSize	7000
showRanking	0
rankImages	0
userlistRows	30
userlistOnline	0
userlistAvatar	1
userlistPosts	1
userlistKarma	0
userlistEmail	0
userlistJoinDate	0
userlistLastVisitDate	1
userlistUserHits	1
latestCategory	0
showStats	0
showWhoIsOnline	1
showGenStats	0
showPopUserStats	0
popUserCount	5
showPopSubjectStats	1
popSubjectCount	5
showSpoilerTag	1
showVideoTag	1
showEbayTag	1
trimLongUrls	1
trimLongUrlsFront	40
trimLongUrlsBack	20
autoEmbedYoutube	1
autoEmbedEbay	0
ebayLanguageCode	en-us
sessionTimeOut	9000
highlightCode	0
rssType	topic
rssTimeLimit	1 month
rssLimit	100
rssIncludedCategories
rssExcludedCategories
rssSpecification	rss2.0
rssAllowHtml	1
rssAuthorFormat	name
rssAuthorInTitle	1
rssWordCount	0
rssOldTitles	1
rssCache	900
defaultPage	recent
defaultSort	asc
sef	1
showImgForGuest	1
showFileForGuest	1
pollNbOptions	4
pollAllowVoteOne	1
pollEnabled	1
popPollsCount	5
showPopPollStats	1
pollTimeBtVotes	00:15:00
pollNbVotesByUser	10
pollResultsUserslist	0
allowUserEditPoll	0
maxPersonalText	50
orderingSystem	mesid
postDateFormat	datetime
postDateFormatHover	datetime
hideIp	0
imageTypes	jpg,jpeg,gif,png,webp
checkMimeTypes	1
imageMimeTypes	image/jpeg,image/jpg,image/gif,image/png,image/webp
imageQuality	70
thumbHeight	32
thumbWidth	32
hideUserProfileInfo	put_empty
boxGhostMessage	0
userDeleteMessage	0
latestCategoryIn	1
topicIcons	1
debug	0
catsAutoSubscribed	0
showBannedReason	0
showThankYou	1
showPopThankYouStats	1
popThanksCount	5
modSeeDeleted	0
bbcodeImgSecure	text
listCatShowModerators	0
lightbox	1
showListTime	8760
showSessionType	2
showSessionStartTime	1800
userlistAllowed	1
userlistCountUsers	1
enableThreadedLayouts	0
categorySubscriptions	post
topicSubscriptions	every
pubProfile	1
thankYouMax	10
emailRecipientCount	0
emailRecipientPrivacy	bcc
captchaPostLimit	0
imageUpload	registered
fileUpload	admin
topicLayout	flat
timeToCreatePage	0
showImgFilesManageProfile	1
holdNewUsersPosts	0
holdGuestPosts	0
attachmentLimit	12
pickupCategory	1
articleDisplay	link
sendEmails	1
fallbackEnglish	1
cache	1
cacheTime	180
ipTracking	1
rssFeedBurnerUrl
autoLink	1
accessComponent	1
statsLinkAllowed	1
superAdminUserlist	1
attachmentProtection	0
categoryIcons	1
avatarCrop	0
userReport	1
searchTime	all
teaser	0
ebayLanguage	0
ebayCertId
allowChangeSubject	1
maxLinks	30
readOnly	0
ratingEnabled	0
urlSubjectTopic	0
logModeration	0
attachStart	0
attachEnd	14
attachmentUtf8	1
autoEmbedSoundcloud	0
emailHeader	media/kunena/email/hero-wide.png
userStatus	1
signature	1
personal	1
social	0
plainEmail	0
moderatorPermDelete	0
avatarTypes	gif,jpeg,jpg,png
smartLinking	0
defaultAvatar	nophoto.png
defaultAvatarSmall	s_nophoto.png
quickReply	0
avatarEdit	0
activeMenuItem
mainMenuId
homeId
indexId
moderatorsId
topicListId
miscId
profileId
searchId
custom_id
avatarType	1
sefRedirect	1
allowEditPoll	1
useSystemEmails	0
autoEmbedInstagram	0
disableRe	0
email_sender_name
display_filename_attachment	0
new_users_prevent_post_url_images	0
minimal_user_posts_add_url_image	10
utmSource	0
emailHeaderSizeY	560
emailHeaderSizeX	560
moderator_id
profiler	0
pickup_category	1
privateMessage	1
datePickerFormat	mm/dd/yyyy
sendMailUserBanned	0
mailBodyUserBanned
board_title	Форумы сайта
board_offline	0
offline_message	Форум временно закрыт. Попробуйте зайти в другой раз!
enablerss	1
threads_per_page	30
messages_per_page	30
messages_per_page_search	15
showhistory	1
historylimit	10
shownew	1
disemoticons	1
showannouncement	0
avataroncat	0
catimagepath	category_images/
showchildcaticon	1
rtewidth	450
rteheight	300
enableforumjump	1
reportmsg	1
askemail	0
showemail	0
showuserstats	0
showkarma	0
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	1
allowfavorites	1
maxsubject	250
maxsig	200
regonly	0
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	0
mailfull	0
allowavatarupload	1
allowavatargallery	0
avatarquality	65
avatarsize	2048
imageheight	800
imagewidth	800
imagesize	1000
filetypes	zip,txt,doc,gz,tgz
filesize	7000
showranking	0
rankimages	0
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_posts	1
userlist_karma	0
userlist_email	0
userlist_joindate	0
userlist_lastvisitdate	1
userlist_userhits	1
latestcategory	0
showstats	0
showwhoisonline	1
showgenstats	0
showpopuserstats	0
popusercount	50
showpopsubjectstats	1
popsubjectcount	5
showspoilertag	0
showvideotag	1
showebaytag	0
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	0
ebaylanguagecode	en-us
sessiontimeout	9000
highlightcode	0
rss_type	topic
rss_timelimit	month
rss_limit	100
rss_included_categories
rss_excluded_categories
rss_specification	rss2.0
rss_allow_html	1
rss_author_format	name
rss_author_in_title	1
rss_word_count	0
rss_old_titles	1
rss_cache	900
defaultpage	recent
default_sort	asc
showimgforguest	1
showfileforguest	1
pollnboptions	4
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	1
pollresultsuserslist	0
allow_user_edit_poll	0
maxpersotext	150
ordering_system	replyid
post_dateformat	datetime
post_dateformat_hover	datetime
hide_ip	1
imagetypes	jpg,jpeg,gif,png
checkmimetypes	1
imagemimetypes	image/jpeg,image/jpg,image/gif,image/png
imagequality	50
thumbheight	32
thumbwidth	32
hideuserprofileinfo	put_empty
boxghostmessage	1
userdeletetmessage	0
latestcategory_in	1
topicicons	1
catsautosubscribed	0
showbannedreason	0
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	0
bbcode_img_secure	text
listcat_show_moderators	1
show_list_time	8760
show_session_type	1
show_session_starttime	20
userlist_allowed	1
userlist_count_users	2
enable_threaded_layouts	1
category_subscriptions	post
topic_subscriptions	every
pubprofile	1
thankyou_max	10
email_recipient_count	0
email_recipient_privacy	bcc
email_visible_address
captcha_post_limit	0
image_upload	registered
file_upload	admin
topic_layout	flat
time_to_create_page	0
show_imgfiles_manage_profile	0
hold_newusers_posts	0
hold_guest_posts	0
attachment_limit	12
article_display	link
send_emails	1
fallback_english	1
cache_time	300
ebay_affiliate_id
iptracking	0
rss_feedburner_url
autolink	1
access_component	1
statslink_allowed	1
superadmin_userlist	0
legacy_urls	1
attachment_protection	0
categoryicons	1
avatarresizemethod	1
avatarcrop	0
user_report	1
searchtime	all
ebay_language	0
ebay_api_key
ebay_cert_id
twitter_consumer_key
twitter_consumer_secret
allow_change_subject	1
max_links	30
read_only	0
ratingenabled	0
url_subject_topic	0
log_moderation	0
attach_start	0
attach_end	14
google_map_api_key
attachment_utf8	1
autoembedsoundcloud	0
emailheader	media/kunena/email/hero-wide.png
user_status	1
plain_email	0
moderator_permdelete	0
avatartypes	gif, jpeg, jpg, png
smartlinking	0
defaultavatar	nophoto.png
defaultavatarsmall	s_nophoto.png
stopforumspam_key
quickreply	1
avataredit	0
activemenuitem
mainmenu_id
home_id
index_id
moderators_id
topiclist_id
misc_id
profile_id
search_id
avatar_type	1
sef_redirect	1
allow_edit_poll	1
use_system_emails	0
autoembedinstagram	0
disable_re	0
recaptcha_publickey
recaptcha_privatekey
recaptcha_theme	white
keywords	0
userkeywords	0
userlist_name	0
usernamechange	0
version_check	1
userlist_usertype	0
sefutf8	0
default_view	flat
enablepdf	1
newchar	Новое!
jmambot	1
templateimagepath	default_ex
joomlastyle	0
numchildcolumn	2
annmodid	62
enablerulespage	0
poststats	0
statscolor	9
wrap	250
changename	0
imageprocessor	gd2
avatarsmallheight	40
avatarsmallwidth	40
avatarheight	80
avatarwidth	80
avatarlargeheight	250
avatarlargewidth	250
cb_profile	0
discussbot	1
userlist_username	1
showlatest	1
latestcount	20
latestcountperpage	5
latestsinglesubject	1
latestreplysubject	1
latestsubjectlength	100
latestshowdate	1
latestshowhits	0
latestshowauthor	1
rules_infb	0
rules_link	www.bestofjoomla.com/
enablehelppage	0
help_infb	0
help_link	www.bestofjoomla.com/
rsstype	thread
rsshistory	month
alphauserpoints	0
alphauserpointsrules	0
userlist_enable	1

| Kunena integration settings:

Warning: Spoiler!

Kunena - Finder Enabled 
 Kunena - AltaUserPoints Disabled
 Kunena - Community Builder Enabled:  access=1  login=1  activity=1  avatar=1  profile=1  private=1  
 Kunena - Easyblog Disabled
 Kunena - Easyprofile Disabled
 Kunena - Easysocial Disabled
 Kunena - Gravatar Disabled
 Kunena - JomSocial Disabled
 Kunena - Joomla Enabled:  access=1  login=1  
 Kunena - Kunena Enabled:  avatar=1  profile=1  
 Kunena - UddeIm Disabled

| Joomla! detailed language files installed:

Warning: Spoiler!

Joomla! languages installed:
de-DE	German (Germany)
en-GB	English (United Kingdom)
ru-RU	Russian (ru-RU)

Third-party components: CommunityBuilder 2.9.2

Third-party SEF components: None

Plugins: Content - Kunena Discuss 6.0.5

Modules: Kunena Latest 6.0.7 | Kunena Stats 6.0.5 | Kunena Search 6.0.5

 

It would probably be correct to title this topic:
"It is impossible to finish editing the post."
Excuse me

...
P.S. The ability to edit posts in this Kunena forum has disappeared somewhere. Maybe there is a limited time during which this is possible?

Therefore, here is an addition to the starting post:
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.

Have you tried to recount statistics and run diagnostics?

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.

Thank you.

No, I was afraid to do this, so as not to spoil the data for the Kunena-Team.

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.

Thank you. This post is no longer than the others in this topic. The only new thing I can point out is that I've used the "Undo" button quite a few times. Maybe it affects the character limit?

As for the advice:
"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 can try to do that.
But won't these parameters change after an update?
Maybe it's worth doing this at the level of your programs?

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