Merged Last post date "42 years ago" - access denied to topic - database errors

Saying it's database corruption doesn't address the root cause. It only addresses the symptom. As far as I can tell with Google, there are more than a few sites with this issue.

Because my site is new and I'm beta-testing, the forum has been emptied numerous times to clear the issue. The issue still occurs about 50% of the time. The key question is what exactly is causing the problem. I gave you guys all the information I could possibly obtain regarding my site configuration in the hopes that maybe you could find a common thread as to why this is happening.

I understand this is free and that the devs are doing this for very little if anything, but it's a problem that extends beyond one site or two. I'm willing and able to provide any additional information you may need. I'm more a systems guy...16 years in IT, but I can get you logs or any other info you may need to troubleshoot the issue.

I had no issues with any other part of the site. You can pin it on MySQL, but there has to be a common factor somewhere. MySQL is used on millions of websites without issue. There has to be a common factor. Either the version of MySQL, version of PHP, conflict with other software, the order software was installed, or some other unknown common factor. It may not be a consistent issue, but it's common enough where I'd consider it a bug.

The real question is what info do you guys need to troubleshoot this issue? Perhaps if everyone that is having the issue posts the results of the Joomla Forum Post Assistant, you might be able to find commonality.

Thanks and I appreciate your efforts.

So it requires MySQL in the technical documents and yet no piece of the software accounts for the fact that MySQL is not a fully transactional database? There are thousands of programs that use MySQL for their database, and yet I've only seen this issue in Kunena. It seems to me that this is a solvable issue, and there are several ways around solving it that I can think of offhand.

The reason I spoke of escalation is the only feedback we're getting here is stating that you're not interested in pursuing this question while the users and administrators that are implementing your software clearly don't think editing the database directly or having corrupt data in the database is an acceptable solution.

Reasonable responses do not include "This is the last I'll say on this matter" but rather "we cannot solve the problem," "it's in the queue for the next patch," or "can you give us more information to troubleshoot it."

Ignoring the problem will not make it go away. You have people interested in a solution here, and willing to dig into their systems and find data for you to get an answer. Take advantage of this resource that's being offered.

I'll give a quick example of a solution I had to add to an application to avoid data corruption:

PHP was not consistently returning a true date value for the date() function, so I had records inserted with the invalid date from 1970. What I did was introduce a loop that checked the date value against the current year before calling the insert. If it had not been correctly set, it tried again until it was. Since like this problem it was a hiccup, not in the DB but in the server, and it was intermittent so hard to track down, 99% of the time, it passed the first validation and continued without interruption, but that 1% of the time that it would have put corrupt data in my database, it had a few milliseconds delay, mostly caused by me making it send me a notification in the hopes of finding a pattern, and neither the users nor the administrators had to care about it.

I have asked the Kunena developers to look at this topic. I cannot give you more information than this.

It would take you less than 2 minutes to fix the problem. Either
(1) Delete the bad record(s) from the database; or
(2) Fix the record(s) by plugging "meaningful" data into the fields that require meaningful data.

It's really as simple as that.

This problem is not isolated to Kunena, as you suggest. You are correct, MySQL is not a fully transactional database (like Oracle or SQL Server) and even on this forum (at www.kunena.org ) we occasionally - once in several thousand messages posted in the forum - see this, too.

I can fix these things in my own server/database. It's not difficult. The issue here is that this happens every now and then but some hosted environments (the cheap, unreliable kinds) have this problem more often. The way to reduce or eliminate the potential for these issues to arise is to start with a reliable hosted platform. I'm sure you would agree with that, wouldn't you?

I have asked the developers to look at this topic and to give it as much attention as they can. However, we also do not want to see development of Kunena halted indefinitely - looking for the proverbial "needle in a haystack" - or slowed down unnecessarily either, wouldn't you also agree? I believe that nothing is impossible but everything has a cost. The question is, how much are we all prepared to pay?

Thank you. That is all that I was asking for. The indication that the developers were aware of the concern and the availability of extra hands, which is how to reduce the research costs.

I'll admit, I've never seen this kind of behavior in other applications, and I work with many, including two other forum softwares (and several installations of same) all running on MySQL. That said, the hosting company I use is a very reliable one, so it may be that the problems were rare enough (and those softwares allowed the user to correct the records) that I didn't notice them.

Because I have a DBA background, my instinct would be to check the values before submitting them, but yes, this would mean a micro slowdown of posting. Personally, I'd say that time loss is crucial for a chat system, but negligible for a forum, but it's not my call to make. Regardless, I'm willing to look into it further on my end should the developers want the assistance.

Thank you for having the devs look into it.

Fixing the individual threads is not a problem, but it's also not practical over the long term. If it happened 1% of the time, that's one thing, but we're averaging 25-50% on new topics (and we only have 4 members...all beta testers).

I'm using a reliable host (the same host I used for a 1500 member Invision PowerBoard site) and I had no issues with the MySQL DB or the site.

I will happily provide any and all assistance they'd need to troubleshoot this further. As the site is still in beta-testing, I can do pretty much anything at this point to help (short of completely killing the rest of the site...too much work into it).

slayer99199 wrote: Fixing the individual threads is not a problem, but it's also not practical over the long term. If it happened 1% of the time, that's one thing, but we're averaging 25-50% on new topics...

slayer99199 wrote: I'm using a reliable host...

slayer99199 wrote: I will happily provide any and all assistance they'd need to troubleshoot this further.

It's a similar story for me. Thanks for getting the developers to look into this and if there's anything else I can do to help (e.g. Forum Post Assistant post etc), please let me know.

Neil.

The problem is how to reproduce the issue for now i'am not able to do it

@marfisk and @ozneilau : can-you put here your Kunena report configuration ?

Here's my configuration report. I do not believe the UddeIM plugin was installed when this last happened.

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

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

This message contains confidential information

htaccess: Exists | PHP environment: Max execution time: 120 seconds | Max execution memory: 149M | Max file upload: 100M

Kunena menu details:

Warning: Spoiler!

ID	Name	Menutype	Link	Path
110	Forum	kunenamenu	view=home&defaultmenu=112	forum
111	Forum Index	kunenamenu	view=category&layout=list&catid=0	forum/index
112	Recent Topics	kunenamenu	view=topics&mode=replies	forum/recent
113	Start Topic	kunenamenu	view=topic&layout=create&catid=	forum/newtopic
114	No Replies	kunenamenu	view=topics&mode=noreplies	forum/noreplies
115	My Topics	kunenamenu	view=topics&layout=user&mode=default	forum/mylatest
116	Profile	kunenamenu	view=user	forum/profile
117	Help	kunenamenu	view=misc	forum/help
122	FAQ	kunenamenu	view=category&catid=7	forum/faq-menu
118	Search	kunenamenu	view=search	forum/search
119	Forum	mainmenu	Itemid=110	kunena-2012-09-22

Joomla default template details : atomic | author: Ron Severdia | version: 2.5.0 | creationdate: 10/10/09

Kunena default template details : Blue Eagle 2.0 | author: Kunena Team | version: 2.0.2 | creationdate: 2012-09-02

Kunena version detailed: Kunena 2.0.2 | 2012-09-02 [ Botschafter ]
| Kunena detailed configuration:

Warning: Spoiler!

Kunena config settings:
board_offline	0
enablerss	1
threads_per_page	20
messages_per_page	20
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
disemoticons	0
template	blue_eagle
showannouncement	1
avataroncat	0
catimagepath	category_images
showchildcaticon	1
rtewidth	450
rteheight	300
enableforumjump	1
reportmsg	1
username	1
askemail	1
showemail	0
showuserstats	1
showkarma	1
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	0
allowfavorites	1
maxsubject	75
maxsig	500
regonly	0
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	0
captcha	0
mailfull	1
allowavatarupload	1
allowavatargallery	1
avatarquality	75
avatarsize	2048
imageheight	800
imagewidth	800
imagesize	300
filetypes	txt,rtf,pdf
filesize	120
showranking	1
rankimages	1
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_name	0
userlist_posts	1
userlist_karma	1
userlist_email	0
userlist_usertype	1
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	1
latestcategory
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	1
popusercount	5
showpopsubjectstats	1
popsubjectcount	5
usernamechange	0
showspoilertag	1
showvideotag	0
showebaytag	0
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	0
ebaylanguagecode	en-us
sessiontimeout	1800
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
sef	1
sefutf8	0
showimgforguest	1
showfileforguest	0
pollnboptions	4
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
maxpersotext	50
ordering_system	mesid
post_dateformat	ago
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	0
userdeletetmessage	0
latestcategory_in	1
topicicons	1
debug	0
catsautosubscribed	0
showbannedreason	0
version_check	1
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	0
bbcode_img_secure	text
listcat_show_moderators	1
lightbox	1
show_list_time	24
show_session_type	0
show_session_starttime	0
userlist_allowed	0
userlist_count_users	1
enable_threaded_layouts	1
category_subscriptions	post
topic_subscriptions	every
pubprofile	0
thankyou_max	10
email_recipient_count	30
email_recipient_privacy	bcc
captcha_post_limit	0
keywords	0
userkeywords	0
image_upload	registered
file_upload	moderator
topic_layout	threaded
time_to_create_page	1
show_imgfiles_manage_profile	1
hold_newusers_posts	0
hold_guest_posts	0
attachment_limit	8
pickup_category	0
article_display	intro
send_emails	1
fallback_english	1
cache	1
cache_time	60
iptracking	1
plugins	Array

| Kunena integration settings:

Warning: Spoiler!

Kunena - AlphaUserPoints Disabled
Kunena - Community Builder Disabled
Kunena - Gravatar Disabled
Kunena - JomSocial Disabled
Kunena - Joomla Enabled: access=1 login=1
Kunena - Kunena Enabled: avatar=1 profile=1
Kunena - UddeIM Enabled: private=1

| Joomla! detailed language files installed:

Warning: Spoiler!

Joomla! languages installed:
en-GB	English (United Kingdom)

Third-party components: UddeIM 2.8

Third-party SEF components: None

Plugins: None

Modules: Kunena Latest 2.0.2 | Kunena Login 2.0.2 | Kunena Search 2.0.2

xillibit wrote: The problem is how to reproduce the issue for now i'am not able to do it

@marfisk and @ozneilau : can-you put here your Kunena report configuration ?

Here's mine:

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

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

This message contains confidential information

htaccess: Exists | PHP environment: Max execution time: 60 seconds | Max execution memory: 128M | Max file upload: 16M

Kunena menu details:

Warning: Spoiler!

ID	Name	Menutype	Link	Path
286	Forum	mainmenu	view=category&catid=1	forums
287	Edit My Profile	mainmenu	view=user&layout=edit	forums/edit-my-profile
277	Forum	kunenamenu	view=home&defaultmenu=277	forum
278	Index	kunenamenu	view=category&layout=list	forum/index
279	Recent Topics	kunenamenu	view=topics&mode=replies	forum/recent
280	New Topic	kunenamenu	view=topic&layout=create	forum/newtopic
281	No Replies	kunenamenu	view=topics&mode=noreplies	forum/noreplies
282	My Topics	kunenamenu	view=topics&layout=user&mode=default	forum/mylatest
283	Profile	kunenamenu	view=user	forum/profile
284	Help	kunenamenu	view=misc	forum/help
285	Search	kunenamenu	view=search	forum/search

Joomla default template details : rt_momentum | author: RocketTheme, LLC | version: 1.6 | creationdate: April 12, 2012

Kunena default template details : Blue Eagle 2.0 | author: Kunena Team | version: 2.0.2 | creationdate: 2012-09-02

Kunena version detailed: Kunena 2.0.2 | 2012-09-02 [ Botschafter ]
| Kunena detailed configuration:

Warning: Spoiler!

Kunena config settings:
board_offline	0
enablerss	1
threads_per_page	20
messages_per_page	6
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
disemoticons	0
template	blue_eagle
showannouncement	1
avataroncat	0
catimagepath	category_images
showchildcaticon	1
rtewidth	450
rteheight	300
enableforumjump	1
reportmsg	1
username	1
askemail	0
showemail	0
showuserstats	1
showkarma	1
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	1
allowfavorites	1
maxsubject	50
maxsig	300
regonly	0
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	0
captcha	0
mailfull	1
allowavatarupload	1
allowavatargallery	1
avatarquality	75
avatarsize	2048
imageheight	800
imagewidth	800
imagesize	300
filetypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2
filesize	400
showranking	1
rankimages	1
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_name	1
userlist_posts	1
userlist_karma	1
userlist_email	0
userlist_usertype	0
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	1
latestcategory
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	1
popusercount	5
showpopsubjectstats	1
popsubjectcount	5
usernamechange	0
showspoilertag	1
showvideotag	1
showebaytag	1
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	1
ebaylanguagecode	en-us
sessiontimeout	1800
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
sef	1
sefutf8	0
showimgforguest	1
showfileforguest	1
pollnboptions	4
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
maxpersotext	50
ordering_system	mesid
post_dateformat	ago
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	0
userdeletetmessage	1
latestcategory_in	1
topicicons	1
debug	0
catsautosubscribed	0
showbannedreason	0
version_check	1
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	1
bbcode_img_secure	text
listcat_show_moderators	1
lightbox	1
show_list_time	720
show_session_type	0
show_session_starttime	0
userlist_allowed	1
userlist_count_users	1
enable_threaded_layouts	0
category_subscriptions	post
topic_subscriptions	every
pubprofile	0
thankyou_max	10
email_recipient_count	0
email_recipient_privacy	bcc
captcha_post_limit	0
keywords	0
userkeywords	0
image_upload	registered
file_upload	registered
topic_layout	flat
time_to_create_page	1
show_imgfiles_manage_profile	1
hold_newusers_posts	0
hold_guest_posts	0
attachment_limit	8
pickup_category	0
article_display	intro
send_emails	1
fallback_english	1
cache	1
cache_time	60
iptracking	1
plugins	Array

| Kunena integration settings:

Warning: Spoiler!

Kunena - AlphaUserPoints Disabled
Kunena - Community Builder 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:
en-GB	English (United Kingdom)

Third-party components: None

Third-party SEF components: sh404sef 3.6.3.1478

Plugins: None

Modules: None

Here's my info (in addition to the Joomla FPA I posted earlier).

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

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

This message contains confidential information

htaccess: Exists | PHP environment: Max execution time: 45 seconds | Max execution memory: 128M | Max file upload: 24M

Kunena menu details:

Warning: Spoiler!

ID	Name	Menutype	Link	Path
192	Forum	mainmenu	Itemid=183	kunena-2012-11-06
183	Forum	kunenamenu	view=home&defaultmenu=184	forum
184	Index	kunenamenu	view=category&layout=list	forum/index
185	Recent Topics	kunenamenu	view=topics&mode=replies	forum/recent
186	New Topic	kunenamenu	view=topic&layout=create	forum/newtopic
187	No Replies	kunenamenu	view=topics&mode=noreplies	forum/noreplies
188	My Topics	kunenamenu	view=topics&layout=user&mode=default	forum/mylatest
189	Profile	kunenamenu	view=user	forum/profile
190	Help	kunenamenu	view=misc	forum/help
191	Search	kunenamenu	view=search	forum/search

Joomla default template details : shaper_zaara | author: JoomShaper.com | version: 1.0.0 | creationdate: Apr 2012

Kunena default template details : JF Corporate | author: JoomForest | version: 1.1 | creationdate: 27.07.2012

Kunena version detailed: Kunena 2.0.2 | 2012-09-02 [ Botschafter ]
| Kunena detailed configuration:

Warning: Spoiler!

Kunena config settings:
board_offline	0
enablerss	1
threads_per_page	20
messages_per_page	6
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
disemoticons	0
template	jf_corporate
showannouncement	1
avataroncat	0
catimagepath	category_images
showchildcaticon	1
rtewidth	450
rteheight	300
enableforumjump	1
reportmsg	1
username	1
askemail	0
showemail	0
showuserstats	1
showkarma	1
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	1
allowfavorites	1
maxsubject	50
maxsig	300
regonly	0
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	0
captcha	0
mailfull	1
allowavatarupload	1
allowavatargallery	1
avatarquality	75
avatarsize	2048
imageheight	800
imagewidth	800
imagesize	150
filetypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2
filesize	120
showranking	1
rankimages	1
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_name	1
userlist_posts	1
userlist_karma	1
userlist_email	0
userlist_usertype	0
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	1
latestcategory
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	1
popusercount	5
showpopsubjectstats	1
popsubjectcount	5
usernamechange	0
showspoilertag	1
showvideotag	1
showebaytag	1
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	1
ebaylanguagecode	en-us
sessiontimeout	1800
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
sef	1
sefutf8	0
showimgforguest	1
showfileforguest	1
pollnboptions	4
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
maxpersotext	50
ordering_system	mesid
post_dateformat	ago
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	0
userdeletetmessage	0
latestcategory_in	1
topicicons	1
debug	0
catsautosubscribed	0
showbannedreason	0
version_check	1
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	0
bbcode_img_secure	text
listcat_show_moderators	1
lightbox	1
show_list_time	720
show_session_type	0
show_session_starttime	0
userlist_allowed	0
userlist_count_users	1
enable_threaded_layouts	0
category_subscriptions	post
topic_subscriptions	every
pubprofile	1
thankyou_max	10
email_recipient_count	0
email_recipient_privacy	bcc
captcha_post_limit	0
keywords	0
userkeywords	0
image_upload	registered
file_upload	registered
topic_layout	flat
time_to_create_page	1
show_imgfiles_manage_profile	1
hold_newusers_posts	0
hold_guest_posts	0
attachment_limit	8
pickup_category	0
article_display	intro
send_emails	1
fallback_english	1
cache	1
cache_time	60
iptracking	1
plugins	Array

| Kunena integration settings:

Warning: Spoiler!

Kunena - AlphaUserPoints Disabled
Kunena - Community Builder Enabled: access=1 login=1 activity=1 avatar=1 profile=1 private=1
Kunena - Gravatar Enabled: avatar=1
Kunena - JomSocial Disabled
Kunena - Joomla Enabled: access=1 login=1
Kunena - Kunena Enabled: avatar=1 profile=1
Kunena - UddeIM Enabled: private=1

| Joomla! detailed language files installed:

Warning: Spoiler!

Joomla! languages installed:
en-GB	English (United Kingdom)

Third-party components: CommunityBuilder 1.9 | UddeIM 2.8

Third-party SEF components: None

Plugins: Content - Kunena Discuss 2.0.2

Modules: Kunena Stats 2.0.2 | Kunena Login 2.0.2 | Kunena Search 2.0.2