Kunena 6.2.6 released

The Kunena team has announce the arrival of Kunena 6.2.6 [K 6.2.6] which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x. This version addresses most of the issues that were discovered in K 6.1 / K 6.2 and issues discovered during the last development stages of K 6.2

The error code HTTP 500 Internal Server Error is a general-purpose message this indicates a general error in a web application. Please note that there is no general solution for this general error. You should first read HTTP 500 Internal Server Error before posting in this category.

If you are having problems then, for your own benefit, it would save us all a lot of time if you would kindly post your configuration report when you ask for help from this forum. If you do not post your configuration report we will not ask you for it but you will probably not get your problem solved, either.

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

Mariosgr
Topic Author
Visitor

9 years 10 months ago #1 by Mariosgr

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 was created by Mariosgr

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

This message contains confidential information

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)

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

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

Please Log in or Create an account to join the conversation.

Mariosgr
Topic Author
Visitor

9 years 9 months ago #2 by Mariosgr

Replied by Mariosgr on topic 500 - JDatabaseMySQL::query: 1146................

I still get this error,
can anybody help ?

Please Log in or Create an account to join the conversation.

xillibit
Offline
Administrator

9 years 9 months ago #3 by xillibit

Replied by xillibit on topic 500 - JDatabaseMySQL::query: 1146................

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

I don't provide support by PM, because this can be useful for someone else.

Please Log in or Create an account to join the conversation.

Mariosgr
Topic Author
Visitor

9 years 9 months ago #4 by Mariosgr

Replied by Mariosgr on topic 500 - JDatabaseMySQL::query: 1146................

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

Please Log in or Create an account to join the conversation.

Mariosgr
Topic Author
Visitor

9 years 9 months ago - 9 years 9 months ago #5 by Mariosgr

Replied by Mariosgr on topic 500 - JDatabaseMySQL::query: 1146................

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 ?

Last edit: 9 years 9 months ago by Mariosgr.

Please Log in or Create an account to join the conversation.

Mariosgr
Topic Author
Visitor

9 years 9 months ago #6 by Mariosgr

Replied by Mariosgr on topic 500 - JDatabaseMySQL::query: 1146................

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

Please Log in or Create an account to join the conversation.

Mariosgr
Topic Author
Visitor

9 years 9 months ago #7 by Mariosgr

Replied by Mariosgr on topic 500 - JDatabaseMySQL::query: 1146................

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

Please Log in or Create an account to join the conversation.

Mariosgr
Topic Author
Visitor

9 years 9 months ago #8 by Mariosgr

Replied by Mariosgr on topic 500 - JDatabaseMySQL::query: 1146................

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

Please Log in or Create an account to join the conversation.

Time to create page: 0.384 seconds