Kunena 6.3.0 released

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

This is not a support forum for JomSocial or its related products. For JomSocial support you should visit JomSocial .

The information given in this category is intended to guide users who want to use JomSocial with Kunena and, mostly, was written by Kunena users. The information here is not necessarily accurate, up-to-date nor is it intended to replace the support given by the developers of JomSocial.

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 [SOLVED] when click menu "500 - JDatabaseMySQL::query: 1146"

ae3d
Topic Author
Offline
Junior Member

10 years 4 months ago - 10 years 4 months ago #1 by ae3d

[SOLVED] when click menu "500 - JDatabaseMySQL::query: 1146" was created by ae3d

SOLVED - look here for solution ( mine anyway )

man im losing my head on this one
I am building a new site. While i was building over the past year (its not public yet)
there was an Upgrade to Kunena so i installed that
Now running K 3.0.3 Ill paste the report below

Well i noticed that once the upgrade completed, if i clicked on my FORUM menu item in the MAIN MENU i get a 500 error screen
so i turned on DEBUG MODE for K!
It showed me there was a module conflicting with K! so i uninstalled that module.
The module most likely did NOT work with this verion of K!.
Not a problem.... in the end, if i have to install an older version of K! then i will but for now, each time i click my menu item for K! i get the 500 error screen

Once the module was removed, i get this

JDatabaseMySQL::query: 1146 - Table 'db33727_tuu.gruv_components' doesn't exist SQL=SELECT id from gruv_components WHERE link = 'option=com_community' and enabled='1'

ok says the component is not there. yes it is
So i removed the menu item and then created a new one (Forums) with a new alias.
I still get the same error
something is blocking K! and i cant find it

here we go: REPORT

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: 500 seconds | Max execution memory: 99M | Max file upload: 50M

Kunena menu details:

Warning: Spoiler!

ID Name Menutype Link Path

110 Forum mainmenu view=home&defaultmenu=270 forums

338 Recent Topics mainmenu view=topics&mode=replies forums/recent

339 New Topic mainmenu view=topic&layout=create forums/newtopic

340 No Replies mainmenu view=topics&mode=noreplies forums/noreplies

341 My Topics mainmenu view=topics&layout=user&mode=default forums/mylatest

342 Profile mainmenu view=user forums/profile

343 Help mainmenu view=misc forums/help

344 Search mainmenu view=search forums/search

269 Forum kunenamenu view=home&defaultmenu=270 forum

270 Index kunenamenu view=category&layout=list forum/index

271 Recent Topics kunenamenu view=topics&mode=replies forum/recent

272 New Topic kunenamenu view=topic&layout=create forum/newtopic

273 No Replies kunenamenu view=topics&mode=noreplies forum/noreplies

274 My Topics kunenamenu view=topics&layout=user&mode=default forum/mylatest

275 Profile kunenamenu view=user forum/profile

276 Help kunenamenu view=misc forum/help

277 Search kunenamenu view=search forum/search

Joomla default template details : Hardcore | author: JoomlaXTC | version: 1.0.0 | creationdate: Unknown

Kunena default template details : Blue Eagle (default) | author: Kunena Team | version: 1.6.5 | creationdate: 2011-07-27

Kunena version detailed: Kunena 3.0.3 | 2013-10-20 [ Bifrost ]
| 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 10

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 0

allowsubscriptions 1

subscriptionschecked 1

allowfavorites 1

maxsubject 70

maxsig 300

regonly 0

pubwrite 0

floodprotection 30

mailmod 1

mailadmin 1

captcha 1

mailfull 0

allowavatarupload 1

allowavatargallery 1

avatarquality 65

avatarsize 2048

imageheight 800

imagewidth 800

imagesize 150

filetypes jpg,JPG,gif,GIF,bmp,BMP,PDD,pdd

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 categories

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 50

thumbheight 120

thumbwidth 120

hideuserprofileinfo put_empty

boxghostmessage 0

userdeletetmessage 0

latestcategory_in 1

topicicons 1

debug 1

catsautosubscribed 0

showbannedreason 1

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 8760

show_session_type 0

show_session_starttime 0

userlist_allowed 0

userlist_count_users 0

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

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 0

cache_time 60

iptracking 1

rss_feedburner_url

autolink 1

access_component 0

userlist_usertype 0

sefutf8 0

enablepdf 1

jmambot 0

annmodid 62

changename 0

userlist_username 1

rules_infb 0

help_infb 1

onlineusers 1

| Kunena integration settings:

Warning: Spoiler!

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

Kunena config settings:
board_offline	0
enablerss	1
threads_per_page	20
messages_per_page	6
messages_per_page_search	15
showhistory	1
historylimit	10
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	0
allowsubscriptions	1
subscriptionschecked	1
allowfavorites	1
maxsubject	70
maxsig	300
regonly	0
pubwrite	0
floodprotection	30
mailmod	1
mailadmin	1
captcha	1
mailfull	0
allowavatarupload	1
allowavatargallery	1
avatarquality	65
avatarsize	2048
imageheight	800
imagewidth	800
imagesize	150
filetypes	jpg,JPG,gif,GIF,bmp,BMP,PDD,pdd
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	categories
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	50
thumbheight	120
thumbwidth	120
hideuserprofileinfo	put_empty
boxghostmessage	0
userdeletetmessage	0
latestcategory_in	1
topicicons	1
debug	1
catsautosubscribed	0
showbannedreason	1
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	8760
show_session_type	0
show_session_starttime	0
userlist_allowed	0
userlist_count_users	0
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
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	0
cache_time	60
iptracking	1
rss_feedburner_url
autolink	1
access_component	0
userlist_usertype	0
sefutf8	0
enablepdf	1
jmambot	0
annmodid	62
changename	0
userlist_username	1
rules_infb	0
help_infb	1
onlineusers	1

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

Third-party components: Jomsocial 2.8.3

Third-party SEF components: None

Plugins: JomSocial - My Kunena Forum Menu 2.0.3 | JomSocial - Kunena Groups 2.0.3

Modules: Kunena Latest 3.0.1

Last edit: 10 years 4 months ago by ae3d.

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

Mortti
Offline
Elite Member

10 years 4 months ago - 10 years 4 months ago #2 by Mortti

Replied by Mortti on topic when click menu "500 - JDatabaseMySQL::query: 1146"

Check that your database tables is not corrupted...
Interesthing name of table???

Table 'db33727_tuu.gruv_components'

Kunena default template details : Blue Eagle (default) | author: Kunena Team | version: 1.6.5 | creationdate: 2011-07-27

Last edit: 10 years 4 months ago by Mortti.

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

xillibit
Offline
Administrator

10 years 4 months ago #3 by xillibit

Replied by xillibit on topic when click menu "500 - JDatabaseMySQL::query: 1146"

Hello,

You need to update jomsocial and all his plugin, i remember to have seen this issue in the past

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.

ae3d
Topic Author
Offline
Junior Member

10 years 4 months ago #4 by ae3d

Replied by ae3d on topic when click menu "500 - JDatabaseMySQL::query: 1146"

xillibit wrote: Hello,

You need to update jomsocial and all his plugin, i remember to have seen this issue in the past

ya know what, would believe this is the problem.
Because i had Kunena installed already on this site, for the past year with Jomsocial and they were connected to eachother
again this site is NOT public, there are no members, its still in development

this probme didnt arrise until i did a backup reinstall of the site which came shortly after doing an upgrade of Kunena to v3.0.3

This site is bascially a copy of my radio station so right now im going to go to THAT site and check
What version Kunena is running on the radio station
What version Jomsocial is running on the radio station
What versions of the Jomsocial modules are running on the station

Ill do a little comparison but again, if i need to downgrade to a previous version of Kunena.... i really have no problem doing that

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

ae3d
Topic Author
Offline
Junior Member

10 years 4 months ago #5 by ae3d

Replied by ae3d on topic when click menu "500 - JDatabaseMySQL::query: 1146"

not sure if this will help any but
i did a comparison bewtween the two websites
they both have all the same items , modules, component versions installed

one website is working fine but there is something else i noticed.

on the site where i am having a problem with Kunena
i went to my Jomsocial profile there.

There is a KUNENA updates that should show on my profile
and instead of showing my posts in Kunena it says

" Kunena is not installed. Please contact site administrator. "

Ok so Jomsocial says Kunena is NOT installed.... well its possible its not installed completely during upgrade so can agree to that. Because i cant even get to it directly.

ok so now what?
all the versions are the same on both websites

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

Jiminimonka
Offline
Elite Member
YBAS!

10 years 4 months ago #6 by Jiminimonka

Replied by Jiminimonka on topic when click menu "500 - JDatabaseMySQL::query: 1146"

I do not think that JomSocial 2.8 is compatible with Kunena 3. You might have to contact the developers at Jomsocial for confirmation of that. As xillibit wrote earlier, you will have to update JomSocial to the latest version.

Please read the FAQ.
Only one question per topic.
Search before you ask a question.

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

ae3d
Topic Author
Offline
Junior Member

10 years 4 months ago #7 by ae3d

Replied by ae3d on topic when click menu "500 - JDatabaseMySQL::query: 1146"

ok got it worked out as far as i can tell

i uninstalled Jomsocial 2.8 and installed 3.0+
then i reinstalled Kunena
but i had to dump ALL the plugins and modules from BOTH components and start fresh on new installs

seems ok now.

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

Time to create page: 0.551 seconds