Error message in admin - Help!

16 years 8 months ago #44728 by skiguru
Error message in admin - Help! was created by skiguru
Hi, I get the following message when I try to confirm or edit a profile - "DB function failed with error number 1054
Unknown column 'sbviewtype' in 'field list' SQL=UPDATE jos_comprofiler SET `user_id`='5493',`approved`='1',`confirmed`='1',`website`='',`location`='',`occupation`='',`interests`='',`company`='',`city`='',`state`='',`zipcode`='',`country`='',`address`='',`phone`='',`fax`='',`sbviewtype`='',`sbordering`='',`sbsignature`='',`fbsignature`='',`fbordering`='_UE_FB_ORDERING_OLDEST',`fbviewtype`='_UE_FB_VIEWTYPE_FLAT',`firstname`='',`middlename`='',`lastname`='' WHERE id='5493'
SQL =

UPDATE jos_comprofiler SET `user_id`='5493',`approved`='1',`confirmed`='1',`website`='',`location`='',`occupation`='',`interest

Could anyone please decipher and let me know how to fix the problem

Thanks

Skiguru

site address www.skiguru.net

Please Log in to join the conversation.

16 years 8 months ago #44795 by beat
Replied by beat on topic Re:Error message in admin - Help!
Looks like you have JoomlaBoard not setup properly.

To fix the CB tables, do:

CB --> Tools --> Check DB

then follow the indications in results.

Beat - Community Builder Team Member

Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks :)
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info

Please Log in to join the conversation.

16 years 8 months ago #44856 by skiguru
Replied by skiguru on topic Re:Error message in admin - Help!
Hi Beat,

thanks for that - Yes, that fixed it.

Best wishes

Skiguru

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.205 seconds

Facebook Twitter LinkedIn