Solved Kunena Forum Categories & Index Display Error: 1054

I am having trouble with the configuration of the Kunena v. 3.0.5 forum software I am trying to install & configure on my website. I am using the Joomla! v. 3.2.3 CMS software to build my website using the Shape 5 Vertex template.

I can & have installed the Kunena software just fine through my Joomla! admin dashboard Extensions => Extension Manager. I can also get the Kunena homepage to display properly. The issue I'm having is with the Categories I have created for my forum and getting them to display on the frontend. If I click on the Index tab on the frontend, it gives me the error message screen "Error: 1054" - an image of which I have attached to this message. If I try and select to navigate to any of my created categories, I get the same error message display. As far as I can tell, I have created and configured the categories properly and I'm at a loss as to why I am getting this error message. I have also attached a copy of the report configuration for you to look over.

I imagine the problem is going to be fairly obvious and simple, but I'm at a loss at how to fix this. Any assistance you may be able to provide would be very much appreciated.

My website URL is: www.gamingdecoded.com

Thanks again!

gamingdecoded wrote: I have also attached a copy of the report configuration for you to look over.

I think you may have forgotten it.

I could have sworn I attached both files. [strike]I am attempting to attach it again to this message. I have saved it as a .txt file in Notepad.[/strike][Moderator's comment]Watch the video vimeo.com/69818669 to see how to attach your configuration report. Configuration report appears below

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

Kunena menu details:

Warning: Spoiler!

ID	Name	Menutype	Link	Path
357	Community Forum	mainmenu	view=home&defaultmenu=336	explore/community-forum
335	Forum	mainmenu	Itemid=336	kunena-2014-04-12
336	Forum	kunenamenu	view=home&defaultmenu=338	forum
337	Index	kunenamenu	view=category&layout=list	forum/index
338	Recent Topics	kunenamenu	view=topics&mode=replies	forum/recent
339	New Topic	kunenamenu	view=topic&layout=create	forum/newtopic
340	No Replies	kunenamenu	view=topics&mode=noreplies	forum/noreplies
341	My Topics	kunenamenu	view=topics&layout=user&mode=default	forum/mylatest
342	Profile	kunenamenu	view=user	forum/profile
343	Help	kunenamenu	view=misc	forum/help
344	Search	kunenamenu	view=search	forum/search

Joomla default template details : shape5_vertex | author: Shape5.com | version: 3.0 | creationdate: Unknown

Kunena default template details : Blue Eagle | author: Kunena Team | version: 3.0.5 | creationdate: 2014-03-09

Kunena version detailed: Kunena 3.0.5 | 2014-03-09 [ Invecchiato ]
| 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	1
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	1
allowfavorites	1
maxsubject	50
maxsig	300
regonly	0
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	0
captcha	1
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_joindate	1
userlist_lastvisitdate	1
userlist_userhits	1
latestcategory	0
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	desc
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	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
rss_feedburner_url
autolink	1
access_component	1
statslink_allowed	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 Enabled: avatar=1
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: AlphaUserPoints 1.9.6

Third-party SEF components: None

Plugins: Search - Kunena Search 3.0.1 | Content - Kunena Discuss 3.0.1

Modules: Kunena Latest 3.0.1 | Kunena Stats 3.0.1 | Kunena Login 3.0.1 | Kunena Search 3.0.1

Thanks again.

I suggest that you do two things:

1) Change the integration plugin settings as shown in red below:

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

2) Remove the conflicting menu item (id=357) from your site. See Kunena Menu issues in the Wiki for more information.

I have made the changes suggested, but the problem still persists. Do you have any other suggestions that could be causing the issue?

Thanks again.

Hello,

If you look closely the SQL error, the table concerned isn't from Kunena :

Try to disable all third party modules and plugins and try if it's without them enabled.

After nearly one month since this topic started, and no follow-up further input from the person who started it, we will assume that the matter has been satisfactorily resolved and this discussion is now closed.

*** Topic closed by moderator ***