Solved Unknown column 'canSubscribe' in 'field list'

Greetings!

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 information

htaccess: 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:

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

| Kunena integration settings:

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

| Joomla! detailed language files installed:

Warning: Spoiler!

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

Third-party components: None

Third-party SEF components: None

Plugins: None

Modules: None

Like you, I am trying to assist a friend of mine who has a Kunena forum that has the same problem. I don't know the answer and I would be very interested to learn from your experience.

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?

Greetings Sozzled,

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.

Hmm, I wouldn't have suggested uninstalling (before re-installing)—just run the installer again—but it shouldn't make any difference. Uninstalling Kunena simply removes the files (but leaves the database intact); there is, however, an option to uninstall that also deletes the database tables.

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.

Agreed, I'm guessing from the error it's either looking for a column that isn't there OR it's finding columns that shouldn't be there

I think I may have something that will help resolve this. I think you're right that there's "something missing" in your _kunena_users table.

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.