- Posts: 11
- Thank you received: 1
Kunena 6.2.5 & module Kunena Latest 6.0.7 released
The Kunena team has announce the arrival of Kunena 6.2.5 [K 6.2.5] which is now available for download as a native Joomla extension for J! 4.3.x/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
Solved Unknown column 'canSubscribe' in 'field list'
- Wh1teLeopard
- Topic Author
- Offline
- New Member
I recently had to do a fresh install, copied my users across, broke something (I'm guessing there's an extra/missing column in the php table) :whistle:
Your help would be much appreciated as that's about the extent of my knowledge
Error
Unknown column 'canSubscribe' in 'field list' SQL=UPDATE `#__kunena_users` SET `view`='0',`signature`='',`moderator`='1',`ordering`='0',`posts`='4635',`avatar`='users/avatar1.png',`karma`='0',`karma_time`='0',`group_id`='1',`uhits`='668',`personalText`='圭永遠に',`gender`='2',`birthdate`='1985-5-4',`location`='Tamworth',`websitename`='Kei Kars in the Park',`websiteurl`='www.KKITP.com',`rank`='7',`hideEmail`='0',`showOnline`='1',`icq`='',`aim`='',`yim`='',`msn`='',`skype`='',`twitter`='',`facebook`='',`gtalk`='',`myspace`='',`linkedin`='',`delicious`='',`friendfeed`='',`digg`='',`blogspot`='',`flickr`='',`bebo`='',`thankyou`='68',`canSubscribe`='-1',`userListtime`='-2' WHERE `userid`='1'
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: 32M | Max file upload: 2M
Kunena menu details:
Warning: Spoiler!
ID Name Menutype Link Path In trash 136 Home mainmenu view=home&defaultmenu=138 kunena No 137 Index mainmenu view=category&layout=list&catid=0 kunena/index No 139 New Topic mainmenu view=topic&layout=create kunena/newtopic No 138 Recent Topics mainmenu view=topics&mode=replies kunena/recent No 141 My Topics mainmenu view=topics&layout=user&mode=default kunena/mylatest No 142 Profile mainmenu view=user kunena/profile No 143 Help mainmenu view=misc kunena/help No 144 Search mainmenu view=search kunena/search No 140 No Replies mainmenu view=topics&mode=noreplies noreplies No
Joomla default template details : protostar | author: Kyle Ledbetter | version: 1.0 | creationdate: 4/30/2012
Kunena default template details : Crypsis | author: Kunena Team | version: 4.0.10 | creationdate: 2016-02-18
Kunena version detailed: Kunena 4.0.10 | 2016-02-18 [ Villavicencio ]
| 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 crypsis 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_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 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 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 2 show_session_starttime 1800 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 superadmin_userlist 0 legacy_urls 1 attachment_protection 0 categoryicons 1 avatarresizemethod 1 avatarcrop 0 user_report 1 searchtime 365 teaser 0 ebay_language 0 twitter_consumer_key twitter_consumer_secret allow_change_subject 1 max_links 6 | 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 (en-GB)
Third-party components: None
Third-party SEF components: None
Plugins: None
Modules: None
Please Log in or Create an account to join the conversation.
One suggestion: have you tried re-installing Kunena on your website and does it cure the problem? (Make a backup before you re-install K 4.0.10 just in case something else breaks.)
In the case of my friend's forum, we see the error message whenever someone tries to edit/save their user profile. Is that what happens in your case, too?
Blue Eagle vs. Crypsis reference guide
Read my blog and
Please Log in or Create an account to join the conversation.
- Wh1teLeopard
- Topic Author
- Offline
- New Member
- Posts: 11
- Thank you received: 1
It is indeed. Whenever I try and save my profile, I get that error. I did try uninstalling Kunena and re-installing it but sadly the error persisted. Everything else seems fine, posts seem to be going up OK, haven't tested registration yet but that would be a Joomla issue I guess.
Please Log in or Create an account to join the conversation.
Theoretically, the installer tries to upgrade the Kunena database tables when you're going from an older version to a newer version. One way to trick the installer into thinking that you've got a different version installed, is to drop the table _kunena_configuration (the table should be re-created when you run the installer again). Whether that would help, I don't know.
Although I'm trying to help my friend, I'm kind of doing it by "remote control" (we're exchanging emails and he's a worse at replying to emails than I am :lol: ).
I don't know what would happen if you tried to register a new account and would the problem you mentioned still occur. My guess is that there's an issue within the _kunena_users table itself.
Blue Eagle vs. Crypsis reference guide
Read my blog and
Please Log in or Create an account to join the conversation.
- Wh1teLeopard
- Topic Author
- Offline
- New Member
- Posts: 11
- Thank you received: 1
Please Log in or Create an account to join the conversation.
I compared the table structure between K 3.0 and K 4.0 and I've summarised the differences in a document that I'm attaching.
As you will see, the _kunena_users table in K 4.0 has four additional columns/fields compared to K 3.0. The problem, therefore, is how to add these four additional columns and populate them with meaningful data. I guess one way to achieve that is to write some SQL statements to add the extra columns (make sure you define the data-types correctly) and hope for the best.
I haven't been able to try this with my friend's site—I don't have access to his SQL database—but I would be fascinated to see how you go in fixing the problem.
Blue Eagle vs. Crypsis reference guide
Read my blog and
Please Log in or Create an account to join the conversation.
- Wh1teLeopard
- Topic Author
- Offline
- New Member
- Posts: 11
- Thank you received: 1
\o/
Thank you
I added in the missing columns into the table structure and was able to update my profile with a 'success' message!
Thank you for taking the time to find the missing columns.
Please Log in or Create an account to join the conversation.
In my own situation, all I have to do now is to pass on this information to my friend and hope that he acts accordingly.
Blue Eagle vs. Crypsis reference guide
Read my blog and
Please Log in or Create an account to join the conversation.
- Wh1teLeopard
- Topic Author
- Offline
- New Member
- Posts: 11
- Thank you received: 1
Please Log in or Create an account to join the conversation.