- Posts: 9
- Thank you received: 0
Kunena 6.3.8 Released
The Kunena team has announce the arrival of Kunena 6.3.8 [K 6.3.8] in stable which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x/5.1.x/5.2.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.
Solved Problems after migration from J! 1.5
i'm trying to upgrade a 1.5 site with kunena, i imported all the old tables as writtem here:
webilicious.com.au/kunena-migration
But when i log in, i get these errors:
Table 'namedb.j25_kunena_configuration' doesn't exist SQL=SELECT * FROM j25_kunena_configuration WHERE id=1
Table 'namedb.j25_kunena_user_categories' doesn't exist SQL=SELECT user_id, category_id, role FROM j25_kunena_user_categories WHERE role IN (1,2)
Do you know why...?
Thnks guys and merry Xmas to everyone! :laugh:
Please Log in or Create an account to join the conversation.
What tool did you use to migrate from J! 1.5? What version of Kunena are you using now and what version of Joomla are you using now. Have you watched the video vimeo.com/69818669 ?
The short answer to your question is, based on the information you've given us, no, Idon't know why you're getting this error. Sounds like it was a Joomla migration gone wrong to me. :dry:
Blue Eagle vs. Crypsis reference guide
Read my blog and
Please Log in or Create an account to join the conversation.
thanks for answering so quickly!
I installed kunena 3.0.3 in joomla 2.5.17, the old version was the 1.5.6 in joomla 1.5.26.
I used jupgrade and this is the configuration report:
Database collation check: The collation of your table fields are correct
Joomla! SEF: Enabled | Joomla! SEF rewrite: Disabled | FTP layer: Disabled |
This message contains confidential informationhtaccess: Missing | PHP environment: Max execution time: 30 seconds | Max execution memory: 48M | Max file upload: 32M
Kunena menu details:
Warning: Spoiler!
ID Name Menutype Link Path 158 Forum kunenamenu view=home&defaultmenu=160 kunena 159 Indice delle categorie kunenamenu view=category&layout=list kunena/home 160 Discussioni recenti kunenamenu view=topics&mode=replies kunena/recente 161 Nuova discussione kunenamenu view=topic&layout=create kunena/nuovadiscussione 162 Senza risposta kunenamenu view=topics&mode=noreplies kunena/senzarisposte 163 Mie discussioni kunenamenu view=topics&layout=user&mode=default kunena/mierecenti 164 Profilo kunenamenu view=user kunena/profilo 165 Aiuto kunenamenu view=misc kunena/aiuto 166 Ricerca kunenamenu view=search kunena/cerca 167 Forum mainmenu Itemid=158 kunena-2013-12-24 66 Forum CTL mainmenu option=com_kunena forum-ctl
Joomla default template details : gantry | author: RocketTheme, LLC | version: 4.1.10 | creationdate: Unknown
Kunena default template details : Blue Eagle | author: Kunena Team | version: 3.0.3 | creationdate: 2013-10-20
Kunena version detailed: Kunena 3.0.3 | 2013-10-20 [ Bifrost ]
| Kunena detailed configuration:| Kunena integration settings: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 0 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 1 allowsubscriptions 1 subscriptionschecked 1 allowfavorites 1 maxsubject 50 maxsig 300 regonly 0 pubwrite 0 floodprotection 0 mailmod 0 mailadmin 0 captcha 0 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 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 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 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 1 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 | Joomla! detailed language files installed:Warning: Spoiler!Kunena - AlphaUserPoints Disabled
Kunena - Community Builder Disabled
Kunena - Gravatar Disabled
Kunena - JomSocial Disabled
Kunena - Joomla Enabled: access=1 login=1
Kunena - Kunena Enabled: avatar=1 profile=1
Kunena - UddeIM Disabled
Warning: Spoiler!
Joomla! languages installed: en-GB English (United Kingdom) it-IT Italian (IT)
Third-party components: CommunityBuilder 1.2.1
Third-party SEF components: None
Plugins: None
Modules: None
I hope there's everything here....
Thanks!!!
Please Log in or Create an account to join the conversation.
Next step is to upgrade to K 3.0.4.
Last of all, get rid of the conflicting Kunena menu item. The FAQs page will show you how to restore the standard Kunena menu.
After you've done those things, you need to go though, category by category, each of you forum categories and fix the permissions; these things should take a couple of hours.
Blue Eagle vs. Crypsis reference guide
Read my blog and
Please Log in or Create an account to join the conversation.
The item menu seems to be ok and the previus error vanished.
In the admin panel i don't see any category. Now you say i should fix the permissions, category by category.
You mean in the ftp? where do i find these categories to fix?
My report:
Database collation check: The collation of your table fields are correct
Joomla! SEF: Enabled | Joomla! SEF rewrite: Disabled | FTP layer: Disabled |
This message contains confidential informationhtaccess: Missing | PHP environment: Max execution time: 30 seconds | Max execution memory: 48M | Max file upload: 32M
Kunena menu details:
Warning: Spoiler!
ID Name Menutype Link Path 158 Forum kunenamenu view=home&defaultmenu=160 kunena 159 Indice delle categorie kunenamenu view=category&layout=list kunena/home 160 Discussioni recenti kunenamenu view=topics&mode=replies kunena/recente 161 Nuova discussione kunenamenu view=topic&layout=create kunena/nuovadiscussione 162 Senza risposta kunenamenu view=topics&mode=noreplies kunena/senzarisposte 163 Mie discussioni kunenamenu view=topics&layout=user&mode=default kunena/mierecenti 164 Profilo kunenamenu view=user kunena/profilo 165 Aiuto kunenamenu view=misc kunena/aiuto 166 Ricerca kunenamenu view=search kunena/cerca 167 Forum mainmenu Itemid=158 kunena-2013-12-24 66 Forum CTL mainmenu view=home&defaultmenu=158 forum-ctl
Joomla default template details : gantry | author: RocketTheme, LLC | version: 4.1.10 | creationdate: Unknown
Kunena default template details : Blue Eagle | author: Kunena Team | version: 3.0.4 | creationdate: 2013-12-22
Kunena version detailed: Kunena 3.0.4 | 2013-12-22 [ Ukko ]
| Kunena detailed configuration:| Kunena integration settings:Warning: Spoiler!
Kunena config settings: board_offline 0 enablerss 1 threads_per_page 20 messages_per_page 18 messages_per_page_search 20 showhistory 1 historylimit 10 shownew 1 disemoticons 0 template blue_eagle showannouncement 1 avataroncat 1 catimagepath category_images/ showchildcaticon 1 rtewidth 450 rteheight 300 enableforumjump 0 reportmsg 0 username 1 askemail 0 showemail 1 showuserstats 1 showkarma 0 useredit 1 useredittime 0 useredittimegrace 600 editmarkup 1 allowsubscriptions 1 subscriptionschecked 0 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 70 avatarsize 2048 imageheight 800 imagewidth 800 imagesize 150 filetypes zip,txt,doc,gz,tgz filesize 120 showranking 1 rankimages 1 userlist_rows 50 userlist_online 1 userlist_avatar 1 userlist_name 0 userlist_posts 1 userlist_karma 0 userlist_email 0 userlist_joindate 1 userlist_lastvisitdate 1 userlist_userhits 1 latestcategory showstats 1 showwhoisonline 0 showgenstats 1 showpopuserstats 1 popusercount 10 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 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 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 board_ofset 0 default_view flat enablepdf 1 newchar NEW! jmambot 0 templateimagepath default_ex joomlastyle 0 numchildcolumn 0 annmodid enablerulespage 0 poststats 1 statscolor 1 wrap 80 changename 0 allowavatar 1 imageprocessor gd2 avatarsmallheight 60 avatarsmallwidth 60 avatarheight 100 avatarwidth 100 avatarlargeheight 250 avatarlargewidth 250 allowimageupload 0 allowimageregupload 1 allowfileupload 0 allowfileregupload 1 cb_profile 0 discussbot 0 userlist_username 1 userlist_group 0 userlist_usertype 0 showlatest 1 latestcount 10 latestcountperpage 5 latestsinglesubject 1 latestreplysubject 1 latestsubjectlength 100 latestshowdate 1 latestshowhits 1 latestshowauthor 1 rules_infb 0 rules_cid 0 rules_link no enablehelppage 0 help_infb 0 help_cid 0 help_link NO fbsessiontimeout 1800 rsstype post rsshistory month fbdefaultpage categories integration_avatar kunena integration_access joomla integration_login joomla integration_profile kunena integration_activity none integration_private uddeim | Joomla! detailed language files installed:Warning: Spoiler!Kunena - AlphaUserPoints Disabled
Kunena - Community Builder Disabled
Kunena - Gravatar Disabled
Kunena - JomSocial Disabled
Kunena - Joomla Enabled: access=1 login=1
Kunena - Kunena Enabled: avatar=1 profile=1
Kunena - UddeIM Disabled
Warning: Spoiler!
Joomla! languages installed: en-GB English (United Kingdom) it-IT Italian (IT)
Third-party components: CommunityBuilder 1.9.1
Third-party SEF components: None
Plugins: None
Modules: None
Hope you can help me to handle this!
Thnak you very much!
Please Log in or Create an account to join the conversation.
This problem is discussed in the topic K 3.0: "There are no published categories in ." message . The answers you are looking for are all there.
Blue Eagle vs. Crypsis reference guide
Read my blog and
Please Log in or Create an account to join the conversation.
in the panel where i define the new category i see this error:
Unknown column 'parent_id' in 'where clause' SQL=SELECT a.id, a.name FROM j25_kunena_categories AS a WHERE parent_id='0' AND id!='0' ORDER BY ordering
And when i try to save, i get this error:
Saving category 0 failed: TableKunenaCategories::store() failed - Unknown column 'parent_id' in 'field list' SQL=INSERT INTO `j25_kunena_categories` (`id`,`parent_id`,`name`,`alias`,`locked`,`accesstype`,`access`,`pub_access`,`pub_recurse`,`admin_access`,`admin_recurse`,`ordering`,`published`,`review`,`allow_anonymous`,`post_anonymous`,`description`,`headerdesc`,`class_sfx`,`allow_polls`,`params`) VALUES ('0','0','Provincia','provincia','0','joomla.level','1','1','1','8','1','99999','0','0','0','0','','','','0','{}')
It doesn't let me save anything.
What's wrong...? :dry:
Please Log in or Create an account to join the conversation.
I do not know what's wrong. I have not encountered a situation like yours before. It sounds like your SQL tables have something wrong. It sounds like you may need to undertake some detailed analysis of your database tables. There are diagnostic tools available in Kunena that may assist you. (Please note that I have not used these tools and I do not know how to interpret the results.) See Diagnostic tool and Database schema tool .d4rkcloud wrote: What's wrong? :dry:
Blue Eagle vs. Crypsis reference guide
Read my blog and
Please Log in or Create an account to join the conversation.
topicMissingCategory TEST FAILED 1 issues
topicMissingMessages TEST FAILED 1 issues DELETE BROKEN ITEMS
messageOrphaned TEST FAILED 25608 issues DELETE BROKEN ITEMS
All the other items are ok!
In the layout scheme i don't see any error.
Should i copy it here?
Please Log in or Create an account to join the conversation.
In short, your response confirms my suspicion that you have problems within the database.
To fix this problem means we need to roll up our sleeves and get involved in some creative database repair work. From the looks of things, you have a missing record in the table _kunena_categories. Because you have a missing record, other records in the database contain references to something that doesn't exist. It's my guess that, using a tool like phpMyAdmin, you could patch the database by re-creating the missing information so that the database integrity is restored. As I am sure you would appreciate, doing this kind of work is outside the "standard" support service we offer here in a "question-and-answer forum". This kind of work is specialised, it's one-on-one and it's time-consuming.
I cannot make any guarantees that I could fix this particular problem for you and I cannot give you a reliable estimate of how much time would be involved, either. I think that we're talking a couple of hours.
What do you have to say to this? Would this be worth paying someone else to look at your current situation to see if it's feasible to rectify the problem you now have? As you know, this time of the year is the holiday season and there may be a shortage of skilled specialists available to assist you. I'm only guessing (I can't say for sure) but I think we're talking less than $100.
Blue Eagle vs. Crypsis reference guide
Read my blog and
Please Log in or Create an account to join the conversation.