- Posts: 49
- Thank you received: 0
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
Solved All categories Access Nobody or Only Nobody
How can you change all categories to public viewing read only?
Kunena Ver
3.0.6
I used MigrateMe to move my J1.5 Kunena 1.7 to this new J2.5 Kunena 3.06
When I did that, twice, it changed all the categories to nobody access.
Configuration txt file attached.
Database collation check: jos_kunena_announcement have wrong collation of type latin1_swedish_ci on field title jos_kunena_announcement have wrong collation of type latin1_swedish_ci on field sdescription jos_kunena_announcement have wrong collation of type latin1_swedish_ci on field description jos_kunena_attachments have wrong collation of type latin1_swedish_ci on field hash jos_kunena_attachments have wrong collation of type latin1_swedish_ci on field folder jos_kunena_attachments have wrong collation of type latin1_swedish_ci on field filetype jos_kunena_attachments have wrong collation of type latin1_swedish_ci on field filename jos_kunena_categories have wrong collation of type latin1_swedish_ci on field name jos_kunena_categories have wrong collation of type latin1_swedish_ci on field alias jos_kunena_categories have wrong collation of type latin1_swedish_ci on field accesstype jos_kunena_categories have wrong collation of type latin1_swedish_ci on field channels jos_kunena_categories have wrong collation of type latin1_swedish_ci on field description jos_kunena_categories have wrong collation of type latin1_swedish_ci on field headerdesc jos_kunena_categories have wrong collation of type latin1_swedish_ci on field class_sfx jos_kunena_categories have wrong collation of type latin1_swedish_ci on field topic_ordering jos_kunena_categories have wrong collation of type latin1_swedish_ci on field params jos_kunena_messages have wrong collation of type latin1_swedish_ci on field name jos_kunena_messages have wrong collation of type latin1_swedish_ci on field email jos_kunena_messages have wrong collation of type latin1_swedish_ci on field subject jos_kunena_messages have wrong collation of type latin1_swedish_ci on field ip jos_kunena_messages have wrong collation of type latin1_swedish_ci on field modified_reason jos_kunena_messages_text have wrong collation of type latin1_swedish_ci on field message jos_kunena_polls have wrong collation of type latin1_swedish_ci on field title jos_kunena_polls_options have wrong collation of type latin1_swedish_ci on field text jos_kunena_ranks have wrong collation of type latin1_swedish_ci on field rank_title jos_kunena_ranks have wrong collation of type latin1_swedish_ci on field rank_image jos_kunena_sessions have wrong collation of type latin1_swedish_ci on field allowed jos_kunena_sessions have wrong collation of type latin1_swedish_ci on field readtopics jos_kunena_smileys have wrong collation of type latin1_swedish_ci on field code jos_kunena_smileys have wrong collation of type latin1_swedish_ci on field location jos_kunena_smileys have wrong collation of type latin1_swedish_ci on field greylocation jos_kunena_users have wrong collation of type latin1_swedish_ci on field view jos_kunena_users have wrong collation of type latin1_swedish_ci on field signature jos_kunena_users have wrong collation of type latin1_swedish_ci on field avatar jos_kunena_users have wrong collation of type latin1_swedish_ci on field personalText jos_kunena_users have wrong collation of type latin1_swedish_ci on field location jos_kunena_users have wrong collation of type latin1_swedish_ci on field icq jos_kunena_users have wrong collation of type latin1_swedish_ci on field aim jos_kunena_users have wrong collation of type latin1_swedish_ci on field yim jos_kunena_users have wrong collation of type latin1_swedish_ci on field msn jos_kunena_users have wrong collation of type latin1_swedish_ci on field skype jos_kunena_users have wrong collation of type latin1_swedish_ci on field twitter jos_kunena_users have wrong collation of type latin1_swedish_ci on field facebook jos_kunena_users have wrong collation of type latin1_swedish_ci on field gtalk jos_kunena_users have wrong collation of type latin1_swedish_ci on field myspace jos_kunena_users have wrong collation of type latin1_swedish_ci on field linkedin jos_kunena_users have wrong collation of type latin1_swedish_ci on field delicious jos_kunena_users have wrong collation of type latin1_swedish_ci on field friendfeed jos_kunena_users have wrong collation of type latin1_swedish_ci on field digg jos_kunena_users have wrong collation of type latin1_swedish_ci on field blogspot jos_kunena_users have wrong collation of type latin1_swedish_ci on field flickr jos_kunena_users have wrong collation of type latin1_swedish_ci on field bebo jos_kunena_users have wrong collation of type latin1_swedish_ci on field websitename jos_kunena_users have wrong collation of type latin1_swedish_ci on field websiteurl jos_kunena_users_banned have wrong collation of type latin1_swedish_ci on field ip jos_kunena_users_banned have wrong collation of type latin1_swedish_ci on field reason_private jos_kunena_users_banned have wrong collation of type latin1_swedish_ci on field reason_public jos_kunena_users_banned have wrong collation of type latin1_swedish_ci on field comments jos_kunena_users_banned have wrong collation of type latin1_swedish_ci on field params jos_kunena_version have wrong collation of type latin1_swedish_ci on field version jos_kunena_version have wrong collation of type latin1_swedish_ci on field build jos_kunena_version have wrong collation of type latin1_swedish_ci on field versionname jos_kunena_version have wrong collation of type latin1_swedish_ci on field state
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: 20M
Kunena menu details:
Warning: Spoiler!
ID Name Menutype Link Path 673 Forum mainmenu view=category&layout=list&catid=0 forum1 663 Forum kunenamenu view=home&defaultmenu=664 forum 664 Index kunenamenu view=category&layout=list forum/index 665 Recent Topics kunenamenu view=topics&mode=replies forum/recent 666 New Topic kunenamenu view=topic&layout=create forum/newtopic 667 No Replies kunenamenu view=topics&mode=noreplies forum/noreplies 668 My Topics kunenamenu view=topics&layout=user&mode=default forum/mylatest 669 Profile kunenamenu view=user forum/profile 670 Help kunenamenu view=misc forum/help 671 Search kunenamenu view=search forum/search
Joomla default template details : rt_iridescent | author: RocketTheme, LLC | version: 1.0 | creationdate: Unknown
Kunena default template details : Blue Eagle | author: Kunena Team | version: 3.0.6 | creationdate: 2014-07-28
Kunena version detailed: Kunena 3.0.6 | 2014-07-28 [ Tala ]
| Kunena detailed configuration:| Kunena integration settings:Warning: Spoiler!
Kunena config settings: board_offline 0 enablerss 1 threads_per_page 40 messages_per_page 20 messages_per_page_search 20 showhistory 1 historylimit 6 shownew 1 disemoticons 0 template default showannouncement 0 avataroncat 1 catimagepath category_images/ showchildcaticon 1 rtewidth 450 rteheight 300 enableforumjump 0 reportmsg 1 username 1 askemail 0 showemail 0 showuserstats 1 showkarma 0 useredit 1 useredittime 0 useredittimegrace 600 editmarkup 1 allowsubscriptions 1 subscriptionschecked 1 allowfavorites 1 maxsubject 75 maxsig 300 regonly 0 pubwrite 0 floodprotection 0 mailmod 0 mailadmin 1 captcha 0 mailfull 1 allowavatarupload 1 allowavatargallery 1 avatarquality 65 avatarsize 2048 imageheight 800 imagewidth 800 imagesize 1000 filetypes zip,txt,doc,gz,tgz,pdf,docx.doc.xls.xlsx.pptx filesize 4000 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 0 showwhoisonline 0 showgenstats 0 showpopuserstats 0 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 3600 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 10 pollallowvoteone 1 pollenabled 1 poppollscount 5 showpoppollstats 1 polltimebtvotes 00:15:00 pollnbvotesbyuser 100 pollresultsuserslist 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 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 8760 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 0 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 superadmin_userlist 0 enablepdf 1 jmambot 0 annmodid 62 changename 0 userlist_username 1 userlist_usertype 0 rules_infb 0 help_infb 0 sefutf8 0 onlineusers 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)
Third-party components: Jomsocial 3.2.1.5
Third-party SEF components: None
Plugins: None
Modules: None
Thank you.
Hayden
Please Log in or Create an account to join the conversation.
in the phpmyadmin on your database.
Also you have issue with your collation, you can fix that with admin tools.
Please Log in or Create an account to join the conversation.
I will try this, but I really do not know how to....
I will also look at the admin tools and try to fix what I do not know what is broken
Hayden
Please Log in or Create an account to join the conversation.
< query > UPDATE `jos_kunena_categories` SET pub_access =1 WHERE pub_access =0;
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<query>UPDATE `jos_kunena_categories` SET pub_access=1 WHERE pub_access=0' at line 1
Please Log in or Create an account to join the conversation.
And paste this:
Click on Go
Please Log in or Create an account to join the conversation.
Thank you!!!!!
Hayden
Now onto the next issue. I am sure that are more.\\Thanks again
Hayden
Please Log in or Create an account to join the conversation.
It looks like my categories in this thread are still not public read, only some are. Can you look at this image and see the problem? I have used Kunena for 5 years about, but these new categorie access settings are very confusing, especially since my upgrade.
Here is a picture of the category settings
I would like all categories and subcategories to be public read, but require login to post. Login to post is working, but public read is not for all categories.
Thanks again for helping again.
Hayden
Please Log in or Create an account to join the conversation.
See also here: www.kunena.org/docs/Simple_forum_setup_instructions
Please Log in or Create an account to join the conversation.
I see that, but, I have over 50 categories and sub categories. There must be a way to set all of these to...
Public read
registered to post
How can I do that?
I did run the SQL command as shown above, and I thought that fixed it, but now some and most are still no access.
Thanks for the help.
Hayden
Please Log in or Create an account to join the conversation.
Yes, for other people who are reading this topic, the problem here occurs when people are migrating from J! 1.5 to a later version of Joomla. This issue has been discussed before in the Miscellaneous, off-topic and general Joomla category; see Problems after migration from J! 1.5 as just one example.hayden wrote: I used MigrateMe to move my J1.5 Kunena 1.7 to this new J2.5 Kunena 3.06. When I did that, twice, it changed all the categories to nobody access.
As far as what tools exist in Kunena to fix the problem, Rich was correct .
Yes, it is possible to write a SQL query in the form of
In the past we were strongly cautioned to limit our advice to using the standard features of Kunena—which is exactly what Rich did and I applaud him for his diligence in that regard. The general warning—written in bold red text—given to all of us by fxstein, one of the founders of Kunena, is here: How To Destroy your forum data...
This warning has not changed even if some people may have forgotten about it.
Blue Eagle vs. Crypsis reference guide
Read my blog and
Please Log in or Create an account to join the conversation.