- Posts: 10
- Thank you received: 1
Kunena 6.3.6 Released - Security release
The Kunena team has announce the arrival of Kunena 6.3.6 [K 6.3.6] 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 / K 6.3 and issues discovered during the last development stages of K 6.3
Note: Please go to the Kunena Dashboard after an upgrade so that the Kunena database tables are also updated.
Question K6.0.6 in Joomla 4.1 - Can't create categories, can't run Tools
No categories were imported during the migration? I can't create new categoires. All the posts were imported from the migration but they don't display since there are no categories.
I can't run the TOOLS in the dashboard.
Here are the error messages followed by a configuration
Call stack#FunctionLocation1()JROOT/libraries/vendor/joomla/database/src/Mysqli/:1412Joomla\Database\Mysqli\MysqliStatement->__construct()JROOT/libraries/vendor/joomla/database/src/Mysqli/:10483Joomla\Database\Mysqli\MysqliDriver->prepareStatement()JROOT/libraries/vendor/joomla/database/src/:19004Joomla\Database\DatabaseDriver->setQuery()JROOT/administrator/components/com_kunena/src/Model/:685Kunena\Forum\Administrator\Model\CategoryModel->getAdminCategory()JROOT/libraries/src/MVC/View/:1536Joomla\CMS\MVC\View\AbstractView->get()JROOT/administrator/components/com_kunena/src/View/Category/:1227Kunena\Forum\Administrator\View\Category\HtmlView->display()JROOT/libraries/src/MVC/Controller/:6978Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_kunena/src/Controller/:569Kunena\Forum\Administrator\Controller\DisplayController->display()JROOT/libraries/src/MVC/Controller/:73510Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/libraries/src/Dispatcher/:14611Joomla\CMS\Dispatcher\ComponentDispatcher->dispatch()JROOT/libraries/src/Component/:38912Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/:14313Joomla\CMS\Application\AdministratorApplication->dispatch()JROOT/libraries/src/Application/:18614Joomla\CMS\Application\AdministratorApplication->doExecute()JROOT/libraries/src/Application/:27815Joomla\CMS\Application\CMSApplication->execute()JROOT/administrator/includes/:6316require_once()JROOT/administrator/:321054 Unknown column 'parentid' in 'where clause'
Here's the error when I try to run
Call stack#FunctionLocation1()JROOT/libraries/vendor/joomla/database/src/Mysqli/:1412Joomla\Database\Mysqli\MysqliStatement->__construct()JROOT/libraries/vendor/joomla/database/src/Mysqli/:10483Joomla\Database\Mysqli\MysqliDriver->prepareStatement()JROOT/libraries/vendor/joomla/database/src/:19004Joomla\Database\DatabaseDriver->setQuery()JROOT/libraries/kunena/src/Forum/:915Kunena\Forum\Libraries\Forum\KunenaDiagnostics::count()JROOT/administrator/components/com_kunena/tmpl/tools/:936include()JROOT/libraries/src/MVC/View/:4367Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/:2208Joomla\CMS\MVC\View\HtmlView->display()JROOT/administrator/components/com_kunena/src/View/Tools/:1819Kunena\Forum\Administrator\View\Tools\HtmlView->display()JROOT/libraries/src/MVC/Controller/:69710Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_kunena/src/Controller/:5611Kunena\Forum\Administrator\Controller\DisplayController->display()JROOT/libraries/src/MVC/Controller/:73512Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/libraries/src/Dispatcher/:14613Joomla\CMS\Dispatcher\ComponentDispatcher->dispatch()JROOT/libraries/src/Component/:38914Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/:14315Joomla\CMS\Application\AdministratorApplication->dispatch()JROOT/libraries/src/Application/:18616Joomla\CMS\Application\AdministratorApplication->doExecute()JROOT/libraries/src/Application/:27817Joomla\CMS\Application\CMSApplication->execute()JROOT/administrator/includes/:6318require_once()JROOT/administrator/:321054 Unknown column '' in 'where clause'
Here's the config report.
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 informationhtaccess: Exists | PHP environment: Max execution time: 30 seconds | Max execution memory: 128M | Max file upload:
Kunena menu details:
Warning: Spoiler!
ID Name Menutype Link Path In trash 431 COMMUNITY FORUM mainmenu view=home&defaultmenu=421 equine-forum No 1869 Forum kunenamenu view=home&defaultmenu=1871 forum No 1870 Index kunenamenu view=category&layout=list forum/index No 1871 Recent Topics kunenamenu view=topics&mode=replies forum/recent No 1872 Unread kunenamenu view=topics&layout=unread forum/unread No 1873 New Topic kunenamenu view=topic&layout=create forum/newtopic No 1874 No Replies kunenamenu view=topics&mode=noreplies forum/noreplies No 1875 My Topics kunenamenu view=topics&layout=user&mode=default forum/mylatest No 1876 Profile kunenamenu view=user forum/profile No 1877 Help kunenamenu view=misc forum/help No 1878 Search kunenamenu view=search forum/search No 1879 Forum mainmenu Itemid=1869 kunena-2022-12-27 No
Joomla default template details : cassiopeia | author: Joomla! Project | version: 1.0 | creationdate: February 2017
Kunena default template details : Aurelia | author: Kunena Team | version: 6.0.7 | creationdate: 2022-12-14
Kunena template params:
Warning: Spoiler!
DefaultCategoryicon profileIconset default DefaultIconset default editorIconset default bootstrap 1 borderless 1 tooltips 1 SubjectLengthMessage 80 fullactions 1 quick 0 displayMenu 1 displayDropdownMenu 1 displayDropdownContent 1 displayModule 1 displayBreadcrumb 1 displayAnnouncement 1 displayFooter 1 avatarPosition left formRecover 0 labels 0 whoisonlineName default avatarType rounded topicicontype svg fontawesome 0 socialshare 0 socialsharetag socialtheme classic optional_username 0 writeaccess 0 localstorage 0 IconColor inherit IconColorNew #48a348 editorType ckeditor Bold 1 Italic 1 Underline 1 Strike 1 Subscript 1 Superscript 1 RemoveFormat 1 BulletedList 1 NumberedList 1 Blockquote 1 JustifyLeft 1 JustifyCenter 1 JustifyRight 1 JustifyBlock 1 Link_Unlink 1 Image 1 Smiley 1 Confidential 1 Hidetext 1 Spoiler 1 Code 1 Ebay 1 1 1 Soundcloud 1 FontSize 1 TextColor 1 Maximize 1 Map 1 Video 1 editorButtons nameskinckeditor ckeditorcustomprefixconfigfile avatarSizeX 40 avatarSizeY 90 avatarSizeXThumb 36 avatarSizeYThumb 36 avatarSizeXWelcome 72 avatarSizeYWelcome 72 avatarSizeXList 36 avatarSizeYList 36 avatarSizeXPost 144 avatarSizeYPost 144 avatarSizeXProfile 200 avatarSizeYProfile 200 templatebyText templatebyName templatebyLink
Kunena version detailed: Kunena 6.0.7 | 2022-12-14 [ Git Repository ]
| Kunena detailed configuration:| Kunena integration settings:Warning: Spoiler!
Kunena config settings: boardOffline 0 enableRss 1 threadsPerPage 20 messagesPerPage 6 messagesPerPageSearch 15 showHistory 1 historyLimit 6 showNew 1 disableEmoticons 0 template aurelia showAnnouncement 1 avatarOnCategory 0 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 maxSig 300 regOnly 0 pubWrite 0 floodProtection 0 mailModerators 0 mailAdministrators 0 captcha -1 mailFull 1 allowAvatarUpload 1 allowAvatarGallery 1 avatarQuality 75 avatarSize 2048 imageHeight 800 imageWidth 800 imageSize 150 fileTypes txt,rtf,pdf,zip,,tgz, fileSize 120 showRanking 0 rankImages 0 userlistRows 30 userlistOnline 1 userlistAvatar 1 userlistPosts 1 userlistKarma 1 userlistEmail 0 userlistJoinDate 1 userlistLastVisitDate 1 userlistUserHits 0 latestCategory 0 showStats 1 showWhoIsOnline 1 showGenStats 1 showPopUserStats 1 popUserCount 5 showPopSubjectStats 1 popSubjectCount 5 showSpoilerTag 1 showVideoTag 1 showEbayTag 1 trimLongUrls 1 trimLongUrlsFront 40 trimLongUrlsBack 20 autoEmbedYoutube 1 autoEmbedEbay 1 ebayLanguageCode en-us sessionTimeOut 1800 highlightCode 0 rssType topic rssTimeLimit 1 week rssLimit 100 rssIncludedCategories rssExcludedCategories rssSpecification rss2.0 rssAllowHtml 1 rssAuthorFormat name rssAuthorInTitle 1 rssWordCount 0 rssOldTitles 1 rssCache 900 defaultPage recent defaultSort asc sef 1 showImgForGuest 1 showFileForGuest 1 pollNbOptions 4 pollAllowVoteOne 1 pollEnabled 0 popPollsCount 5 showPopPollStats 1 pollTimeBtVotes 00:15:00 pollNbVotesByUser 100 pollResultsUserslist 1 allowUserEditPoll 0 maxPersonalText 50 orderingSystem mesid postDateFormat ago postDateFormatHover datetime hideIp 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 userDeleteMessage 0 latestCategoryIn 1 topicIcons 1 debug 0 catsAutoSubscribed 0 showBannedReason 0 showThankYou 1 showPopThankYouStats 1 popThanksCount 5 modSeeDeleted 0 bbcodeImgSecure text listCatShowModerators 1 lightbox 1 showListTime 720 showSessionType 2 showSessionStartTime 1800 userlistAllowed 1 userlistCountUsers 1 enableThreadedLayouts 0 categorySubscriptions post topicSubscriptions every pubProfile 1 thankYouMax 10 emailRecipientCount 0 emailRecipientPrivacy bcc captchaPostLimit 0 imageUpload registered fileUpload registered topicLayout flat timeToCreatePage 1 showImgFilesManageProfile 1 holdNewUsersPosts 0 holdGuestPosts 0 attachmentLimit 8 pickupCategory 0 articleDisplay intro sendEmails 1 fallbackEnglish 1 cache 1 cacheTime 60 ipTracking 1 rssFeedBurnerUrl autoLink 1 accessComponent 0 statsLinkAllowed 1 superAdminUserlist 0 attachmentProtection 0 categoryIcons 1 avatarCrop 0 userReport 1 searchTime 365 teaser 0 ebayLanguage 0 ebayCertId allowChangeSubject 1 maxLinks 6 readOnly 0 ratingEnabled 0 urlSubjectTopic 0 logModeration 0 attachStart 0 attachEnd 14 attachmentUtf8 1 autoEmbedSoundcloud 1 emailHeader media/kunena/email/ userStatus 1 signature 1 personal 1 social 1 plainEmail 0 moderatorPermDelete 0 avatarTypes gif,jpeg,jpg,png smartLinking 0 defaultAvatar defaultAvatarSmall s_ quickReply 1 avatarEdit 0 activeMenuItem mainMenuId homeId indexId moderatorsId topicListId miscId profileId searchId custom_id avatarType 1 sefRedirect 1 allowEditPoll 1 useSystemEmails 0 autoEmbedInstagram 1 disableRe 0 email_sender_name display_filename_attachment 0 new_users_prevent_post_url_images 0 minimal_user_posts_add_url_image 10 utmSource 0 emailHeaderSizeY 560 emailHeaderSizeX 560 moderator_id profiler 0 pickup_category 0 emailHeadersizey 560 emailHeadersizex 560 board_title Equine Info Exchange board_offline 0 offline_message The Forum is currently offline for maintenance.
Check back soon!enablerss 1 threads_per_page 60 messages_per_page 10 messages_per_page_search 15 showhistory 1 historylimit 6 shownew 1 disemoticons 1 showannouncement 0 avataroncat 0 catimagepath category_images showchildcaticon 1 rtewidth 450 rteheight 300 enableforumjump 1 reportmsg 1 askemail 1 showemail 0 showuserstats 1 showkarma 0 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 mailfull 1 allowavatarupload 1 allowavatargallery 1 avatarquality 75 avatarsize 2048 imageheight 400 imagewidth 400 imagesize 3000 filetypes txt,rtf,pdf,zip,,tgz,,docx,doc filesize 3000 showranking 0 rankimages 0 userlist_rows 30 userlist_online 1 userlist_avatar 1 userlist_posts 1 userlist_karma 0 userlist_email 0 userlist_joindate 1 userlist_lastvisitdate 1 userlist_userhits 1 latestcategory 0 showstats 0 showwhoisonline 0 showgenstats 0 showpopuserstats 0 popusercount 5 showpopsubjectstats 1 popsubjectcount 5 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 year 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 0 rss_word_count 0 rss_old_titles 0 rss_cache 900 defaultpage recent default_sort desc showimgforguest 1 showfileforguest 1 pollnboptions 4 pollallowvoteone 1 pollenabled 1 poppollscount 5 showpoppollstats 1 polltimebtvotes 00:15:00 pollnbvotesbyuser 100 pollresultsuserslist 1 allow_user_edit_poll 0 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 2 latestcategory_in 1 topicicons 1 catsautosubscribed 0 showbannedreason 0 showthankyou 1 showpopthankyoustats 1 popthankscount 5 mod_see_deleted 0 bbcode_img_secure text listcat_show_moderators 0 show_list_time -1 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 1 thankyou_max 10 email_recipient_count 0 email_recipient_privacy bcc email_visible_address captcha_post_limit 10 image_upload registered file_upload registered topic_layout flat time_to_create_page 0 show_imgfiles_manage_profile 1 hold_newusers_posts 5 hold_guest_posts 1 attachment_limit 8 article_display intro send_emails 1 fallback_english 1 cache_time 300 ebay_affiliate_id 5337089937 iptracking 1 rss_feedburner_url autolink 1 access_component 1 statslink_allowed 1 superadmin_userlist 0 legacy_urls 1 attachment_protection 0 categoryicons 1 avatarresizemethod 1 avatarcrop 0 user_report 1 searchtime 365 ebay_language 0 ebay_api_key twitter_consumer_key twitter_consumer_secret allow_change_subject 1 max_links 15 read_only 0 ratingenabled 0 url_subject_topic 0 log_moderation 0 attach_start 0 attach_end 14 google_map_api_key attachment_utf8 1 autoembedsoundcloud 1 emailheader /media/kunena/email/ user_status 1 plain_email 0 moderator_permdelete 0 avatartypes gif, jpeg, jpg, png smartlinking 0 defaultavatar defaultavatarsmall s_ stopforumspam_key 6c9h7aqzkngu2x quickreply 1 avataredit 0 activemenuitem mainmenu_id home_id index_id moderators_id topiclist_id misc_id profile_id search_id avatar_type 1 sef_redirect 1 allow_edit_poll 1 use_system_emails 0 autoembedinstagram 1 disable_re 0 recaptcha_publickey 6LfbKw4TAAAAAB6-DiKf-wjbQ5wnRBiVga6VdRld recaptcha_privatekey 6LfbKw4TAAAAAIPfRTE9mDHXvg35QioBuRPapYpC recaptcha_theme white keywords 0 userkeywords 0 userlist_name 1 usernamechange 0 version_check 1 | Joomla! detailed language files installed:Warning: Spoiler!Kunena - Finder Disabled
Kunena - AltaUserPoints Disabled
Kunena - Community Builder Enabled: access=1 login=1 activity=1 avatar=1 profile=1 private=1
Kunena - Easyblog Disabled
Kunena - Easyprofile Disabled
Kunena - Easysocial Disabled
Kunena - Gravatar Disabled
Kunena - JomSocial Disabled
Kunena - Joomla Enabled: access=1 login=1
Kunena - Kunena Enabled: avatar=1 profile=1
Warning: Spoiler!
Joomla! languages installed: en-GB English (United Kingdom)
Third-party components: None
Third-party SEF components: None
Plugins: None
Modules: None
Please Log in or Create an account to join the conversation.
After to have installed Kunena 6.0.x, did-you have opened the Kunena dashboard ? Because it's at this place that the Kunena tables are updated
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.
Have you tried to install the latest Kunena again?
And what you can try to take a look with phpmyadmin or at the Table: xxxxx_kunena_categories if the
parentid default value is 0
as my sample picture
L.v.d.A
Please Log in or Create an account to join the conversation.
kunena_categories
the main forum ID is 1, the parent id is 0 for main forum
all other entries parent id is 1 - so that's correct.
main forum and welcome mat are access type joomla group
Health & Education are access type joomla level - is that correct??
I login, I try to create NEW TOPIC and get this error
Is there a difference between categories and sections?403 Forbidden : You do not have permissions to start a new topic! Or you haven't created/published a top level category !
When look at the Kunena template in admin I get this error
The Joomla\Http\Transport\Stream transport is not supported in this environment.
Please Log in or Create an account to join the conversation.
I look in phpadmin and there is not a table for "sections".
When I click on "Categories" it shows me a blank table.
When I click on Create New Category I get a huge error message
here it
Call stack#FunctionLocation1()JROOT/libraries/vendor/joomla/database/src/Mysqli/:1412Joomla\Database\Mysqli\MysqliStatement->__construct()JROOT/libraries/vendor/joomla/database/src/Mysqli/:10483Joomla\Database\Mysqli\MysqliDriver->prepareStatement()JROOT/libraries/vendor/joomla/database/src/:19004Joomla\Database\DatabaseDriver->setQuery()JROOT/administrator/components/com_kunena/src/Model/:685Kunena\Forum\Administrator\Model\CategoryModel->getAdminCategory()JROOT/libraries/src/MVC/View/:1536Joomla\CMS\MVC\View\AbstractView->get()JROOT/administrator/components/com_kunena/src/View/Category/:1227Kunena\Forum\Administrator\View\Category\HtmlView->display()JROOT/libraries/src/MVC/Controller/:6978Joomla\CMS\MVC\Controller\BaseController->display()JROOT/administrator/components/com_kunena/src/Controller/:569Kunena\Forum\Administrator\Controller\DisplayController->display()JROOT/libraries/src/MVC/Controller/:73510Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/libraries/src/Dispatcher/:14611Joomla\CMS\Dispatcher\ComponentDispatcher->dispatch()JROOT/libraries/src/Component/:38912Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/:14313Joomla\CMS\Application\AdministratorApplication->dispatch()JROOT/libraries/src/Application/:18614Joomla\CMS\Application\AdministratorApplication->doExecute()JROOT/libraries/src/Application/:27815Joomla\CMS\Application\CMSApplication->execute()JROOT/administrator/includes/:6316require_once()JROOT/administrator/:321054 Unknown column 'parentid' in 'where clause'
Please Log in or Create an account to join the conversation.
but i had something like that in the beginning.
and then in phpmyadmin have kunena_categories at tab structure
looked at it and adjusted it like my picture.
and website on newly loaded cache cleared
after that the error was gone
or something with seo settings joomla and or kunena try it on or off
L.v.d.A
Please Log in or Create an account to join the conversation.