1. Forums
  3. Support and Presales
  5. Developer Members Support
  7. SearchBot 2.0.1 with CB 2.0.1 sql error

SearchBot 2.0.1 with CB 2.0.1 sql error

9 years 5 months ago #252087 by activha
Replied by activha on topic SearchBot 2.0.1 with CB 2.0.1 sql error
When upgrading, [company] was replaced by [cb_company] and we lost all users data related to this field.

Please Log in to join the conversation.

9 years 5 months ago - 9 years 5 months ago #252099 by krileon
Replied by krileon on topic SearchBot 2.0.1 with CB 2.0.1 sql error
We don't replace any fields on install. I think the only conflict is sample data Fax field with the Terms and Conditions field as the Fax field in CB 1.x was using a reserved ID. The new sample data tool properly creates fields that are cb_ prefixed now so there's no reason for your company field to change to cb_ (the sample data tool won't change it).

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 to join the conversation.

9 years 5 months ago #252101 by activha
Replied by activha on topic SearchBot 2.0.1 with CB 2.0.1 sql error
The company field was replaced automatically when upgrading from 1.9 to 2.0 and fixing database with CB tools.

This is old story now as we have warned all of our users to upgrade their profiles, but it is part of all the glitches that we went through (including loss of auto actions, fields with \n\r and so on... )

:-)

Please Log in to join the conversation.

9 years 5 months ago - 9 years 5 months ago #252122 by krileon
Replied by krileon on topic SearchBot 2.0.1 with CB 2.0.1 sql error
So your field with the name "company" in CB > Field Management is completely gone and now replaced with "cb_company"? Do you have a backup of your install where you can check what the ID of that field is so I can see if it is using a reserved ID?

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 to join the conversation.

9 years 5 months ago #252124 by activha
Replied by activha on topic SearchBot 2.0.1 with CB 2.0.1 sql error
Yes it is gone and has been replaced by "cb_company", it was using field id 34 in CB 1.9

Please Log in to join the conversation.

9 years 5 months ago #252162 by krileon
Replied by krileon on topic SearchBot 2.0.1 with CB 2.0.1 sql error
Strange, 34 isn't a reserved id. I'm out of ideas as to what could cause that, sorry. Is the ID still 34 even after the upgrade to CB 2.0?

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 to join the conversation.

Moderators: beat, nant, krileon
  1. Forums
  3. Support and Presales
  5. Developer Members Support
  7. SearchBot 2.0.1 with CB 2.0.1 sql error
Time to create page: 0.255 seconds

Facebook Twitter LinkedIn

    You are here:  
  1. Home
  2. Forums
  3. Support and Presales
  4. Developer Members Support
  5. SearchBot 2.0.1 with CB 2.0.1 sql error

Search

Login / Logout

User Menu