Welcome, Guest
Username: Password: Remember me

TOPIC: Profile Updating Issue Error

Profile Updating Issue Error 1 year 6 months ago #7749

  • buipy001
  • buipy001's Avatar
  • Offline
  • Moderator
  • Peter Bui
  • Posts: 111
  • Thank you received: 25
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
The administrator has disabled public write access.

Profile Updating Issue Error 1 year 6 months ago #7750

  • manuman
  • manuman's Avatar
  • Offline
  • Moderator
  • Posts: 75
  • Thank you received: 18
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!
CTO/Web Architect - Elastik Space elastik.space / Elastik Digital elastik.digital
The administrator has disabled public write access.

Profile Updating Issue Error 1 year 6 months ago #7752

  • sozzled
  • sozzled's Avatar
  • Offline
  • Moderator
  • I'm just a user, mate!
  • Posts: 116
  • Thank you received: 20
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.
Read my blog and
Last Edit: 1 year 4 months ago by sozzled.
The administrator has disabled public write access.

Profile Updating Issue Error 1 year 6 months ago #7753

  • sozzled
  • sozzled's Avatar
  • Offline
  • Moderator
  • I'm just a user, mate!
  • Posts: 116
  • Thank you received: 20
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)
Read my blog and
Last Edit: 1 year 6 months ago by sozzled.
The administrator has disabled public write access.

Profile Updating Issue Error 1 year 4 months ago #7799

  • sozzled
  • sozzled's Avatar
  • Offline
  • Moderator
  • I'm just a user, mate!
  • Posts: 116
  • Thank you received: 20
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?
Read my blog and
The administrator has disabled public write access.

Profile Updating Issue Error 1 year 3 months ago #7800

  • sozzled
  • sozzled's Avatar
  • Offline
  • Moderator
  • I'm just a user, mate!
  • Posts: 116
  • Thank you received: 20
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.
Read my blog and
Last Edit: 1 year 3 months ago by sozzled.
The administrator has disabled public write access.

Profile Updating Issue Error 1 year 3 months ago #7802

  • sozzled
  • sozzled's Avatar
  • Offline
  • Moderator
  • I'm just a user, mate!
  • Posts: 116
  • Thank you received: 20
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.
Read my blog and
The administrator has disabled public write access.

Profile Updating Issue Error 1 year 3 months ago #7826

  • sozzled
  • sozzled's Avatar
  • Offline
  • Moderator
  • I'm just a user, mate!
  • Posts: 116
  • Thank you received: 20
I can confirm that this particular problem has been fixed
Read my blog and
The administrator has disabled public write access.
Time to create page: 0.060 seconds
Powered by Kunena Forum