Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Profile Updating Issue Error

Profile Updating Issue Error 4 years 1 week ago #7749

  • buipy001
  • buipy001's Avatar Topic Author
  • Offline
  • Moderator
  • Moderator
  • Peter Bui
  • Posts: 112
  • Thank you received: 19
Unknown column 'canSubscribe' in 'field list' SQL=UPDATE `jla_kunena_users` SET `view`='',`signature`='Peter Bui\r\n\r\nThe only limitation is your imagination\r\nhttp://pbwebdev.com\r\n\r\nTwitter: http://twitter.com/astroboysoup\r\nFacebook: http://facebook.com/pbwebdev',`moderator`='0',`ordering`='0',`posts`='81',`avatar`='users/avatar203.png',`karma`='13',`karma_time`='1424560184',`group_id`='1',`uhits`='661',`personalText`='Peter Bui',`gender`='0',`birthdate`='1-1-1',`location`='Sydney',`websitename`='PB Web Development',`websiteurl`='pbwebdev.com',`rank`='0',`hideEmail`='1',`showOnline`='1',`icq`='',`aim`='',`yim`='',`msn`='',`skype`='astroboysoup',`twitter`='astroboysoup',`facebook`='',`gtalk`='',`myspace`='',`linkedin`='',`delicious`='',`friendfeed`='',`digg`='',`blogspot`='',`flickr`='',`bebo`='',`thankyou`='21',`canSubscribe`='-1',`userListtime`='-2' WHERE `userid`='203'

Field canSubscribe doesn't exist in the new table.

Shayne, Can you please add the column please. Unsure if it is a new or old column in the DB.
Peter Bui

The only limitation is your imagination
pbwebdev.com

Twitter: twitter.com/astroboysoup
Facebook: facebook.com/pbwebdev

Please Log in or Create an account to join the conversation.

Profile Updating Issue Error 4 years 5 days ago #7750

  • manuman
  • manuman's Avatar
  • Offline
  • Moderator
  • Moderator
  • Posts: 86
  • Thank you received: 24
OK I'll have a look.

Can you also PM me with these, or use the thread i started as I subscribed so I would get notifications.
Co-Founder of Joomla!
Joomla / Web Hosting - Elastik Space elastik.space
Joomla, Web & App Development - Elastik Digital elastik.digital

Please Log in or Create an account to join the conversation.

Profile Updating Issue Error 3 years 11 months ago #7752

  • sozzled
  • sozzled's Avatar
  • Offline
  • Moderator
  • Moderator
  • I'm just a user, mate!
  • Posts: 160
  • Thank you received: 24
Similarly, when I try to update my profile—in my account here, the email address and some of the other information is wrong or outdated)—I have the same problem.

For example, attempting to update my avatar image (which was not transferred from the old website), this is what happens when I press the Save button:

[attachment:1]joz_profileSave_error.png[/attachment]

My guess is that it's a problem with the third-party template from 9themestore . There are several problems with Kunena templates from 9themestore and changes made by the Kunena developers that can cause Kunena to crash (in various ways) on sites that use 9themestore templates.

Please Log in or Create an account to join the conversation.

Last edit: by sozzled.

Profile Updating Issue Error 3 years 11 months ago #7753

  • sozzled
  • sozzled's Avatar
  • Offline
  • Moderator
  • Moderator
  • I'm just a user, mate!
  • Posts: 160
  • Thank you received: 24
See my post above. It tried to attach an image (to show you the error). The "attachment" appears as Kunena BBcode. Looks like there's another problem here, too.

Also, please note, that hyperlinks on these pages are not displayed in highlighted font (or underlined) or anything to differentiate them from the rest of the text.

For example: >>> this <<< is a link (to http//:microsoft.com)

Please Log in or Create an account to join the conversation.

Last edit: by sozzled.

Profile Updating Issue Error 3 years 9 months ago #7799

  • sozzled
  • sozzled's Avatar
  • Offline
  • Moderator
  • Moderator
  • I'm just a user, mate!
  • Posts: 160
  • Thank you received: 24

sozzled wrote: For example, attempting to update my avatar image (which was not transferred from the old website) ...

Well, the good news is that I can now upload an avatar image (but I still get an error message).

Puzzling, eh?

Please Log in or Create an account to join the conversation.

Profile Updating Issue Error 3 years 9 months ago #7800

  • sozzled
  • sozzled's Avatar
  • Offline
  • Moderator
  • Moderator
  • I'm just a user, mate!
  • Posts: 160
  • Thank you received: 24

buipy001 wrote:

Unknown column 'canSubscribe' in 'field list' SQL=UPDATE `jla_kunena_users` SET `view`='',`signature`='Peter Bui\r\n\r\nThe only limitation is your imagination\r\nhttp://pbwebdev.com\r\n\r\nTwitter: http://twitter.com/astroboysoup\r\nFacebook: http://facebook.com/pbwebdev',`moderator`='0',`ordering`='0',`posts`='81',`avatar`='users/avatar203.png',`karma`='13',`karma_time`='1424560184',`group_id`='1',`uhits`='661',`personalText`='Peter Bui',`gender`='0',`birthdate`='1-1-1',`location`='Sydney',`websitename`='PB Web Development',`websiteurl`='pbwebdev.com',`rank`='0',`hideEmail`='1',`showOnline`='1',`icq`='',`aim`='',`yim`='',`msn`='',`skype`='astroboysoup',`twitter`='astroboysoup',`facebook`='',`gtalk`='',`myspace`='',`linkedin`='',`delicious`='',`friendfeed`='',`digg`='',`blogspot`='',`flickr`='',`bebo`='',`thankyou`='21',`canSubscribe`='-1',`userListtime`='-2' WHERE `userid`='203'

Field canSubscribe doesn't exist in the new table.

Shayne, Can you please add the column please. Unsure if it is a new or old column in the DB.

A similar issue has just been reported at the Kunena forum . Indeed, if the problem is addressed there, we may get some help on this issue here.

Please Log in or Create an account to join the conversation.

Last edit: by sozzled.

Profile Updating Issue Error 3 years 9 months ago #7802

  • sozzled
  • sozzled's Avatar
  • Offline
  • Moderator
  • Moderator
  • I'm just a user, mate!
  • Posts: 160
  • Thank you received: 24
The topic I posted in my last message fixes the problem here: Unknown column 'canSubscribe' in 'field list '

This has been nagging me for weeks.

Please Log in or Create an account to join the conversation.

Profile Updating Issue Error 3 years 8 months ago #7826

  • sozzled
  • sozzled's Avatar
  • Offline
  • Moderator
  • Moderator
  • I'm just a user, mate!
  • Posts: 160
  • Thank you received: 24
I can confirm that this particular problem has been fixed

Please Log in or Create an account to join the conversation.

Profile Updating Issue Error 3 weeks 3 days ago #8659

  • garkell
  • garkell's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 1
  • Thank you received: 0
I'm new to the group/forum but I gather there has been a recent upgrade to the site? Well done to all concerned. I tried to update my newly created profile but it failed with an error "Microsoft" not in field list.

Cheers Glenn

"before engaging in a fight, weigh up the cost of winning" - Dick Francis (Wild Horses)

Please Log in or Create an account to join the conversation.

Profile Updating Issue Error 3 weeks 3 days ago #8660

  • sozzled
  • sozzled's Avatar
  • Offline
  • Moderator
  • Moderator
  • I'm just a user, mate!
  • Posts: 160
  • Thank you received: 24
Thank you, Glenn.

You're right. I can confirm that if people attempt to edit their forum profile, regardless of whether they change anything, and then try to save it, this causes the error "Microsoft not in field list". It happens to me, too.

I don't know the reason for that. There may be several contributory causes and we will need to examine the whole "package" carefully before we can consider what changes are required. In the meantime, however, it means that no users—existing users or new users—will be able to change their forum profiles. I would ask that people have patience while we investigate the matter. When the matter has been resolved, we will advise the forum community here.

Cheers

Please Log in or Create an account to join the conversation.

Profile Updating Issue Error 3 weeks 3 days ago #8664

  • nicky
  • nicky's Avatar
  • Offline
  • Moderator
  • Moderator
  • Posts: 76
  • Thank you received: 12
Thanks for the report - this should now be fixed. We had a slight data migration mixup and blah blah it should be fixed now. Can you please try again and let us know if it's all OK?

Cheers,
Nicky
The following user(s) said Thank You: garkell

Please Log in or Create an account to join the conversation.

Profile Updating Issue Error - should be resolved 3 weeks 3 days ago #8665

  • opn365
  • opn365's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 2
  • Thank you received: 3
Hello Glenn

This issue should now be resolved - it was a minor transition issue.

Please recheck that you can now save your profile successfully.

Thanks & regards
Stuart
The following user(s) said Thank You: garkell

Please Log in or Create an account to join the conversation.

Profile Updating Issue Error 3 weeks 3 days ago #8666

  • sozzled
  • sozzled's Avatar
  • Offline
  • Moderator
  • Moderator
  • I'm just a user, mate!
  • Posts: 160
  • Thank you received: 24
Looks good now. Thanks.
The following user(s) said Thank You: garkell

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Powered by Kunena Forum