Question Getting Access Denied errors on posts and random postings happening

Hi first of all I am not sure if this an Kunena issue or not.

I recently upgraded to 3.01 and all has been fine with our forum for about a month until yesterday afternoon.

The site itself seemed very slow. I made a post and viewed it afterwards it was fine. Later in the evening I went to check a reply to the post and I got an access denied error to the post.

I am an administrator of the forum and I created the post so I found this very strange. I also noticed a number of other threads with the same issue. The common theme was they were either started within the past couple days or had a reply to them within that time frame.

Later in the evening I pruned some of the categories based on threads that had not had replies to them and magically the threads in question disappeared. So it appears problem solved.

But today we are having issues where duplicate replies are happening in threads under different user names. So might be hard to explain but for example I have a reply to a thread from user "a" that says "hi great to hear from you." There is now a duplicate post from user "b" that says "hi great to hear from you." in the same thread that user "b" never posted themselves. It is a carbon copy of the orginal post under a different user name.

Does any of this make sense to anyone? Do I have an issue with my database or is Kunena related? Any help would be appreciated.

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

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

This message contains confidential information

htaccess: Missing | PHP environment: Max execution time: 30 seconds | Max execution memory: 128M | Max file upload: 250000000

Kunena menu details:

Warning: Spoiler!

ID	Name	Menutype	Link	Path
120	NRCM Forum	top	view=category&catid=0&layout=list	nrcm-forum
109	Forum	kunenamenu	view=home&defaultmenu=111	forum
110	Index	kunenamenu	view=category&layout=list	forum/index
111	Recent Topics	kunenamenu	view=topics&layout=default&mode=replies	forum/recent
112	New Topic	kunenamenu	view=topic&layout=create	forum/newtopic
113	No Replies	kunenamenu	view=topics&layout=default&mode=noreplies	forum/noreplies
114	My Topics	kunenamenu	view=topics&layout=user&mode=default	forum/mylatest
115	Profile	kunenamenu	view=user	forum/profile
116	Rules	kunenamenu	view=misc	forum/rules
117	Help	kunenamenu	view=misc	forum/help
118	Search	kunenamenu	view=search	forum/search
119	Forum	mainmenu	Itemid=109	2012-02-20-23-37-26

Joomla default template details : Entrepreneur-tg | author: TG | version: 1.6.0 | creationdate: Unknown

Kunena default template details : Blue Eagle (default) | author: Kunena Team | version: 1.7.2 | creationdate: 2012-01-31

Kunena version detailed: Kunena 3.0.1 | 2013-06-29 [ Noordwijkerhout ]
| Kunena detailed configuration:

Warning: Spoiler!

Kunena config settings:
board_offline	0
enablerss	1
threads_per_page	20
messages_per_page	10
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
disemoticons	0
template	default
showannouncement	1
avataroncat	1
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	1
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	0
captcha	0
mailfull	1
allowavatarupload	1
allowavatargallery	1
avatarquality	65
avatarsize	2048
imageheight	800
imagewidth	800
imagesize	250
filetypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2,avi,mpeg,flv,mpg,mpg2,wmv,mov
filesize	5000
showranking	1
rankimages	1
userlist_rows	100
userlist_online	1
userlist_avatar	1
userlist_name	1
userlist_posts	1
userlist_karma	1
userlist_email	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
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	75
thumbheight	200
thumbwidth	200
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
rss_feedburner_url
autolink	1
access_component	1
enablepdf	1
jmambot	0
annmodid	62
changename	0
userlist_username	1
userlist_usertype	0
rules_infb	1
help_infb	1
sefutf8	0
onlineusers	1

| Kunena integration settings:

Warning: Spoiler!

Kunena - AlphaUserPoints Enabled: activity=1 avatar=1 profile=1 activity_points_limit=0
Kunena - Community Builder Enabled: access=1 login=1 activity=1 avatar=1 profile=1 private=1
Kunena - Gravatar Disabled
Kunena - JomSocial Enabled: access=1 login=1 activity=1 avatar=1 profile=1 private=1 activity_points_limit=0 activity_stream_limit=0
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.6

Third-party SEF components: None

Plugins: None

Modules: Kunena Latest 3.0.1 | Kunena Stats 3.0.1

Now I am getting this error on my joomla site front page:

Got error 28 from storage engine SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM mukdz_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM mukdz_content AS a LEFT JOIN mukdz_categories AS c ON c.id = a.catid LEFT JOIN mukdz_users AS ua ON ua.id = a.created_by LEFT JOIN mukdz_users AS uam ON uam.id = a.modified_by LEFT JOIN mukdz_categories as parent ON parent.id = c.parent_id LEFT JOIN mukdz_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM mukdz_categories AS cat JOIN mukdz_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN mukdz_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1,2,3) AND c.access IN (1,1,2,3) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END IN (0,1,2) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-07-30 19:49:25') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-07-30 19:49:25') ORDER BY a.featured DESC, fp.ordering, a.created DESC LIMIT 0, 3 Got error 28 from storage engine SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM mukdz_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM mukdz_content AS a LEFT JOIN mukdz_categories AS c ON c.id = a.catid LEFT JOIN mukdz_users AS ua ON ua.id = a.created_by LEFT JOIN mukdz_users AS uam ON uam.id = a.modified_by LEFT JOIN mukdz_categories as parent ON parent.id = c.parent_id LEFT JOIN mukdz_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM mukdz_categories AS cat JOIN mukdz_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN mukdz_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1,2,3) AND c.access IN (1,1,2,3) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END IN (0,1,2) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-07-30 19:49:25') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-07-30 19:49:25') ORDER BY a.featured DESC, fp.ordering, a.created DESC

Until you updated the topic with your second posting, I was going to say that this sounded similar to Some forum users post double text . In that case we did not find the reason why this was happening to the users who were using a different version of Kunena.

However, the key clue, in this case, is:

blann wrote:

I recently upgraded to 3.0.1 and all has been fine with our forum for about a month until yesterday afternoon.

(Emphasis added by me)

Software doesn't just fall over or misbehave, by itself, if operations that have been working well mysteriously do not work or change in some way. There must be a reason for this to happen.

The reasons may include other changes that you have made elsewhere on your site (including other software updates), data corruption at the server - these things happen despite the best intentions that you have or the best precautions taken by the webhost provider, malintent or deliberate sabotage. Notwithstanding these things, determining the cause may be a fruitless search and efforts to work around the problem may be time-consuming and costly and, sometimes (in extreme cases) the only choices are to revert to the state your site was in when you took your last site backup. Unfortunately, some people do not make regular backups and the data loss can, in certain cases, be major.

Obviously, for a site like this one that has a lot of traffic and a lot of forum activity (and thousands of people depend on this site's availability to find information that will help them in their businesses), we take the best care we can take to ensure that the site retains its presence, availability and performance to meet the expectations of our users. These precautions are not 100% fool-proof, of course, but they are the best we can do with the resources that we have at our disposal.

Having said these things, the error listing you present does not indicate a failure of Kunena, per se. Indeed, as you do not have Kunena as a front page component, the errors arise from something that is called to generate your site front page. The errors indicate an issue with your MySQL database.

I have to say that I have no personal experience using MySQL 5.5.28 (my personal sites are hosted using MySQL 5.5.25 and this website uses MySQL 5.5.30) but, according to the Kunena Technical Requirements specification and Joomla Technical Requirements specification, MySQL 5.5.28 should work. That is not to say that MySQL 5.5.28 is unsuitable; it only means that we haven't tried it for ourselves.

I suggest you consider reverting to a previous backup of your site when things were working and before these problems started to occur.

Two other suggestions I would make (possibly unrelated to this issue) are

(1) Change your forum integration plugin settings as follows (recommendations shown in red):

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

(2) Use the Blue Eagle template designed for K 3.0.1, not the one designed for K 1.7.2