Skip to Content Skip to Menu

Problem after Migrating from Joomla!1.5

  • mightec
  • mightec
  • OFFLINE
  • Posts: 80
  • Thanks: 0
  • Karma: 0
10 years 4 weeks ago #250131 by mightec
I am having another ERROR message, this time I have tried to edit/update my profile and get the following message:

1054 - Unknown column 'cb_cameras' in 'field list' SQL=UPDATE `photo_comprofiler` SET `user_id`=616,`firstname`='Michael',`lastname`='Martin',`hits`='0',`message_last_sent`='0000-00-00 00:00:00',`message_number_sent`='0',`avatarapproved`='1',`approved`=1,`confirmed`=1,`registeripaddr`='',`cbactivation`='regc2a805d3ff968e88768913005211380d048699aa',`banned`='0',`acceptedterms`='0',`lastupdatedate`='2014-10-11 09:34:37',`cb_pgenable`='',`cb_pgautopublish`='',`cb_pgshortgreeting`='',`cb_pgtotalitems`='0',`cb_pgtotalsize`='0',`cb_pgaccessmode`='',`cb_pgdisplayformat`='',`cb_address1`='',`cb_address2`='',`cb_towncity`='',`cb_postcode`='',`cb_homephone`='',`cb_mobilephone`='',`cb_interests`='',`cb_cameras`='',`cb_lenses`='',`cb_lighting`='',`cb_other`='',`cb_printers`='',`cb_software`='',`cb_computer`='' WHERE id='616'

I appreciate any help.
Regards
Mike

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

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
10 years 3 weeks ago #250143 by nant
Replied by nant on topic Problem after Migrating from Joomla!1.5

mightec wrote: I am having another ERROR message, this time I have tried to edit/update my profile and get the following message:

1054 - Unknown column 'cb_cameras' in 'field list' SQL=UPDATE `photo_comprofiler` SET `user_id`=616,`firstname`='Michael',`lastname`='Martin',`hits`='0',`message_last_sent`='0000-00-00 00:00:00',`message_number_sent`='0',`avatarapproved`='1',`approved`=1,`confirmed`=1,`registeripaddr`='',`cbactivation`='regc2a805d3ff968e88768913005211380d048699aa',`banned`='0',`acceptedterms`='0',`lastupdatedate`='2014-10-11 09:34:37',`cb_pgenable`='',`cb_pgautopublish`='',`cb_pgshortgreeting`='',`cb_pgtotalitems`='0',`cb_pgtotalsize`='0',`cb_pgaccessmode`='',`cb_pgdisplayformat`='',`cb_address1`='',`cb_address2`='',`cb_towncity`='',`cb_postcode`='',`cb_homephone`='',`cb_mobilephone`='',`cb_interests`='',`cb_cameras`='',`cb_lenses`='',`cb_lighting`='',`cb_other`='',`cb_printers`='',`cb_software`='',`cb_computer`='' WHERE id='616'

I appreciate any help.
Regards
Mike


Please use the Tools area to run the fields database test.

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

  • mightec
  • mightec
  • OFFLINE
  • Posts: 80
  • Thanks: 0
  • Karma: 0
10 years 3 weeks ago #250147 by mightec
Replied by mightec on topic Problem after Migrating from Joomla!1.5
Hi
I have run the test and this is what I get, it doesn't mean anything to me.

All CB plugin "Default language (English)" Database is up to date.
All CB plugin "CB Profile Gallery" Database is up to date.
Click here to Hide details
Table #__comprofiler_plug_profilegallery Column id structure is up-to-date.
Table #__comprofiler_plug_profilegallery Column userid structure is up-to-date.
Table #__comprofiler_plug_profilegallery Column pgitemorder structure is up-to-date.
Table #__comprofiler_plug_profilegallery Column pgitemtype structure is up-to-date.
Table #__comprofiler_plug_profilegallery Column pgitemfilename structure is up-to-date.
Table #__comprofiler_plug_profilegallery Column pgitemtitle structure is up-to-date.
Table #__comprofiler_plug_profilegallery Column pgitemdescription structure is up-to-date.
Table #__comprofiler_plug_profilegallery Column pgitemdate structure is up-to-date.
Table #__comprofiler_plug_profilegallery Column pgitemsize structure is up-to-date.
Table #__comprofiler_plug_profilegallery Column pgitempublished structure is up-to-date.
Table #__comprofiler_plug_profilegallery Column pgitemapproved structure is up-to-date.
Table #__comprofiler_plug_profilegallery has no unneeded columns.
Table #__comprofiler_plug_profilegallery Index PRIMARY is up-to-date.
Table #__comprofiler_plug_profilegallery Index userid_order_date is up-to-date.
Table #__comprofiler_plug_profilegallery Index pub_appr_userid_order_date is up-to-date.
Table #__comprofiler_plug_profilegallery has no unneeded indexes.
All CB plugin "Default" Database is up to date.
All CB plugin "CB Core" Database is up to date.
All CB plugin "WinClassic" Database is up to date.
All CB plugin "WebFX" Database is up to date.
All CB plugin "CB Menu" Database is up to date.
All CB plugin "OSX" Database is up to date.
All CB plugin "CB Connections" Database is up to date.
All CB plugin "Luna" Database is up to date.
All CB plugin "Content Author" Database is up to date.
All CB plugin "Dark" Database is up to date.
All CB plugin "Forum integration" Database is up to date.
All CB plugin "Mamblog Blog" Database is up to date.
All CB plugin "YaNC Newsletters" Database is up to date.
All CB plugin "Private Message System" Database is up to date.
All CB plugin "CB Captcha" Database is up to date.
CB plugin "CB JCal pro events": CB JCal pro events has no readable xml file /home/hhps/public_html/components/com_comprofiler/plugin/user/plug_cbjcalproevents/cbjcalproevents.xml
CB plugin "CB JCal pro mini-calendar": CB JCal pro mini-calendar has no readable xml file /home/hhps/public_html/components/com_comprofiler/plugin/user/plug_cbjcalprominical/cbjcalprominical.xml
CB plugin "CB Auto Actions": CB Auto Actions has no readable xml file /home/hhps/public_html/components/com_comprofiler/plugin/user/plug_cbautoactions/cbautoactions.xml
CB plugins database checks done. If all lines above are in green, test completed successfully. Otherwise, please take corrective measures proposed in red.

Can you help, thank you.

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

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
10 years 3 weeks ago #250163 by nant
Replied by nant on topic Problem after Migrating from Joomla!1.5
Please use the Tools area to run the fields database test.

Select the:

Check Community Builder User Fields Database

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

  • mightec
  • mightec
  • OFFLINE
  • Posts: 80
  • Thanks: 0
  • Karma: 0
10 years 3 weeks ago #250182 by mightec
Replied by mightec on topic Problem after Migrating from Joomla!1.5
I have done the test, this is what I get:

All CB fields data storage Database is up to date.
Click here to Hide details
Table #__comprofiler Column avatar structure is up-to-date.
Table #__comprofiler Column avatarapproved structure is up-to-date.
Table #__comprofiler Column hits structure is up-to-date.
Table #__users Column registerDate structure is up-to-date.
Table #__users Column lastvisitDate structure is up-to-date.
Table #__comprofiler Column lastupdatedate structure is up-to-date.
Table #__users Column username exists but is not of strict type, so not checked.
Table #__users Column name exists but is not of strict type, so not checked.
Table #__comprofiler Column firstname structure is up-to-date.
Table #__comprofiler Column middlename structure is up-to-date.
Table #__comprofiler Column lastname structure is up-to-date.
Table #__users Column username exists but is not of strict type, so not checked.
Table #__users Column name exists but is not of strict type, so not checked.
Table #__comprofiler Column firstname structure is up-to-date.
Table #__comprofiler Column middlename structure is up-to-date.
Table #__comprofiler Column lastname structure is up-to-date.
Table #__users Column username exists but is not of strict type, so not checked.
Table #__users Column name exists but is not of strict type, so not checked.
Table #__comprofiler Column firstname structure is up-to-date.
Table #__comprofiler Column middlename structure is up-to-date.
Table #__comprofiler Column lastname structure is up-to-date.
Table #__users Column username exists but is not of strict type, so not checked.
Table #__users Column name exists but is not of strict type, so not checked.
Table #__comprofiler Column firstname structure is up-to-date.
Table #__comprofiler Column middlename structure is up-to-date.
Table #__comprofiler Column lastname structure is up-to-date.
Table #__users Column email exists but is not of strict type, so not checked.
Table #__users Column username exists but is not of strict type, so not checked.
Table #__users Column name exists but is not of strict type, so not checked.
Table #__comprofiler Column firstname structure is up-to-date.
Table #__comprofiler Column middlename structure is up-to-date.
Table #__comprofiler Column lastname structure is up-to-date.
Table #__users Column password structure is up-to-date.
Table #__users Column params exists but is not of strict type, so not checked.
Table jos_comprofiler Column cb_address1 exists but is not of strict type, so not checked.
Table jos_comprofiler Column cb_address2 exists but is not of strict type, so not checked.
Table jos_comprofiler Column cb_towncity exists but is not of strict type, so not checked.
Table jos_comprofiler Column cb_postcode exists but is not of strict type, so not checked.
Table jos_comprofiler Column cb_homephone exists but is not of strict type, so not checked.
Table jos_comprofiler Column cb_mobilephone exists but is not of strict type, so not checked.
Table jos_comprofiler Column fbviewtype exists but is not of strict type, so not checked.
Table jos_comprofiler Column fbordering exists but is not of strict type, so not checked.
Table jos_comprofiler Column fbsignature exists but is not of strict type, so not checked.
Table #__comprofiler Column cb_hhpsmembershipnumber exists but is not of strict type, so not checked.
Table jos_comprofiler Column cb_committeemember exists but is not of strict type, so not checked.
Table #__comprofiler Column cb_committeeposition exists but is not of strict type, so not checked.
Table #__comprofiler Column cb_digitalgroup exists but is not of strict type, so not checked.
Table #__comprofiler Column cb_studiogroup exists but is not of strict type, so not checked.
Table #__comprofiler Column cb_cbsectionbw exists but is not of strict type, so not checked.
Table #__comprofiler Column cb_cbsectioncol exists but is not of strict type, so not checked.
Table #__comprofiler Column cb_cbsectionpi exists but is not of strict type, so not checked.
Table #__comprofiler Column cb_interests exists but is not of strict type, so not checked.
Table #__comprofiler Column cb_cameras exists but is not of strict type, so not checked.
Table #__comprofiler Column cb_lenses exists but is not of strict type, so not checked.
Table #__comprofiler Column cb_lighting exists but is not of strict type, so not checked.
Table #__comprofiler Column cb_other exists but is not of strict type, so not checked.
Table #__comprofiler Column cb_printers exists but is not of strict type, so not checked.
Table #__comprofiler Column cb_software exists but is not of strict type, so not checked.
Table #__comprofiler Column cb_computer structure is up-to-date.
CB fields data storage database checks done. If all lines above are in green, test completed successfully. Otherwise, please take corrective measures proposed in red

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48479
  • Thanks: 8283
  • Karma: 1443
10 years 3 weeks ago #250252 by krileon
Replied by krileon on topic Problem after Migrating from Joomla!1.5
A field exists called "cb_cameras", but its database table column is missing. You need to run the tool "Check Community Builder User Fields Database" as Nick instructed (click the big blue button) as it looks like you're running "Check Community Builder User Fields Database with strict column types" which just checks the column type and won't fix your issue.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

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

Moderators: beatnantkrileon
Powered by Kunena Forum