Solved 500 - JDatabaseMySQL::query: 1146 - Table 'adultgr_db.adult_kunena_config' doesn't exist SQL=SELECT template FROM adult_kunena_config ORDER BY id DESC LIMIT 1

After a restore i made,
i noticed that kunena is not changing the configuration from the administration.
I enabled the debug mod and i got this error

500 - JDatabaseMySQL::query: 1146 - Table 'adultgr_db.adult_kunena_config' doesn't exist SQL=SELECT template FROM adult_kunena_config ORDER BY id DESC LIMIT 1


This is the configuration from Kunena admin

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: 7200 seconds | Max execution memory: 2000M | Max file upload: 2000M

Kunena menu details:

Warning: Spoiler!

ID	Name	Menutype	Link	Path
983	Forum	mainmenu	view=home&defaultmenu=711	escortstforum
989	Νέες απαντήσεις σε posts σου/New replies to your posts	mainmenu	view=topics&layout=user&mode=default&modetype=	escortstforum/replies-to-your-posts15
991	Τελευταία posts	mainmenu	view=topics&layout=posts&mode=recent&userid=	escortstforum/recent-post
214	Συζήτηση / ενότητες για City Tours	mainmenu	view=category&catid=3	city-tours/2012-10-06-22-39-43
44	Συζήτηση / ενότητες για Call - Gilrs	mainmenu	view=category&catid=5	call-girls/forum12
45	Συζήτηση / Ενότητες για Στούντιο	mainmenu	view=category&catid=16	studio/forum11
218	Συζήτηση / ενότητες για Massage	mainmenu	view=category&catid=10	studio-massage/2012-10-07-10-58-41
219	Συζήτηση / ενότητες για Bourdela	mainmenu	view=category&catid=6	bourdela/2012-10-07-11-18-52
220	Συζήτηση / ενότητες για Strip Clubs	mainmenu	view=category&layout=list&catid=28	strip-clubs/2012-10-07-11-39-07
277	Συζήτηση / ενότητες για XXX Bars	mainmenu	view=category&catid=213	kolompara/2012-10-24-08-42-59
39	Διαφορα	mainmenu	view=category&catid=281	2010-10-27-15-53-52
55	Χαιρετούρες !	mainmenu	view=category&catid=193	2010-10-27-15-53-52/2010-11-11-20-37-58
63	Διάφορα	mainmenu	view=category&catid=43	2010-10-27-15-53-52/2010-12-11-16-13-24
81	Δώρα, εκπλήξεις & προσφορές!!!	mainmenu	view=category&catid=278	2010-10-27-15-53-52/a
41	Ταινίες/TV	mainmenu	view=category&catid=55	2010-10-27-15-53-52/xxx
65	Αθλητικά	mainmenu	view=category&catid=110	2010-10-27-15-53-52/2010-12-17-08-54-35
66	Μουσική	mainmenu	view=category&catid=106	2010-10-27-15-53-52/2010-12-17-09-18-47
67	Celebrities	mainmenu	view=category&catid=204	2010-10-27-15-53-52/celebrities
973	Forum	kunenamenu	view=home&defaultmenu=974	adult
974	Αρχική	kunenamenu	view=category&layout=list&catid=0	adult/index
975	Πρόσφατα θέματα	kunenamenu	view=topics&mode=replies	adult/recent
976	Νέα θέματα	kunenamenu	view=topic&layout=create&catid=	adult/newtopic
977	Δεν απαντήθηκαν	kunenamenu	view=topics&mode=noreplies	adult/noreplies
978	Τα θέματα μου	kunenamenu	view=topics&layout=user&mode=default&modetype=	adult/mylatest
979	Προφίλ	kunenamenu	view=user	adult/profile
981	Αναζήτηση	kunenamenu	view=search	adult/search

Joomla default template details : helion | author: Shape5.com | version: 1.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	60
messages_per_page	15
messages_per_page_search	100
showhistory	1
historylimit	10
shownew	1
disemoticons	0
template	blue_eagle
showannouncement	1
avataroncat	1
catimagepath	category_images/
showchildcaticon	1
rtewidth	600
rteheight	300
enableforumjump	1
reportmsg	1
username	1
askemail	0
showemail	0
showuserstats	1
showkarma	0
useredit	1
useredittime	3600
useredittimegrace	3600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	0
allowfavorites	1
maxsubject	50
maxsig	255
regonly	0
pubwrite	0
floodprotection	0
mailmod	-1
mailadmin	-1
captcha	0
mailfull	0
allowavatarupload	1
allowavatargallery	1
avatarquality	65
avatarsize	150
imageheight	800
imagewidth	800
imagesize	20000
filetypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2
filesize	200000
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_joindate	1
userlist_lastvisitdate	1
userlist_userhits	1
latestcategory	0
showstats	0
showwhoisonline	1
showgenstats	0
showpopuserstats	1
popusercount	20
showpopsubjectstats	1
popsubjectcount	15
usernamechange	0
showspoilertag	1
showvideotag	1
showebaytag	0
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	0
ebaylanguagecode	en-us
sessiontimeout	3600
highlightcode	0
rss_type	post
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	categories
default_sort	asc
sef	1
showimgforguest	0
showfileforguest	0
pollnboptions	10
pollallowvoteone	1
pollenabled	1
poppollscount	10
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	1
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	100
thumbheight	200
thumbwidth	200
hideuserprofileinfo	put_empty
boxghostmessage	0
userdeletetmessage	0
latestcategory_in	0
topicicons	0
debug	0
catsautosubscribed	0
showbannedreason	1
version_check	1
showthankyou	1
showpopthankyoustats	1
popthankscount	10
mod_see_deleted	0
bbcode_img_secure	image
listcat_show_moderators	0
lightbox	1
show_list_time	720
show_session_type	2
show_session_starttime	15000
userlist_allowed	1
userlist_count_users	0
enable_threaded_layouts	1
category_subscriptions	post
topic_subscriptions	first
pubprofile	0
thankyou_max	10
email_recipient_count	5
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	0
hold_newusers_posts	0
hold_guest_posts	1
attachment_limit	8
pickup_category	0
article_display	intro
send_emails	1
fallback_english	1
cache	0
cache_time	60
iptracking	1
rss_feedburner_url
autolink	1
access_component	0
statslink_allowed	0
userlist_usertype	0
sefutf8	0
enablepdf	1
jmambot	0
annmodid	62
changename	1
userlist_username	1
rules_infb	1
help_infb	1
onlineusers	1

| 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 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:
el-GR	Greek
en-GB	English (United Kingdom)

Third-party components: UddeIM 3.4

Third-party SEF components: sh404sef 3.7.0.1485

Plugins: None

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

I still get this error,
can anybody help ?

The correct table is nammed _kunena_configuration but in your case it tried to load _kunena_config

i will try to rename and i will let you know the results.

Now it loads the forum but gives this error



Error

Kunena COM_KUNENA_INTERNAL_ERROR


and error in admin


Table 'adultgr_db.adult_kunena_configuration' doesn't exist SQL=SELECT * FROM adult_kunena_configuration WHERE id=1



where can i see what error it is ?

to resolve it i created 2 DBs one named config and one named cnfiguration

500 - JDatabaseMySQL::query: 1054 - Unknown column 'template' in 'field list' SQL=SELECT template FROM adult_kunena_config ORDER BY id DESC LIMIT 1


This is what i get now infront when i open the debug

I found an old menu link and i deleted it,
and everything is ok now.