Skip to Content Skip to Menu

Migration Issue: SP Transfer failing on "global" column (J3.10 to J5.4)

  • Oishiku
  • Oishiku
  • ONLINE
  • Posts: 9
  • Thanks: 1
  • Karma: 2
2 hours 51 minutes ago #343260 by Oishiku
Hello,I am currently migrating my site from Joomla 3.10 to 5.4.2 (Community Builder 2.9+) using the SP Transfer tool. I am working on a stage site subdomain.The Issue: During the transfer of the
Code:
#__comprofiler
and
Code:
#__comprofiler_fields
tables, the process stops with a 1054 Unknown column 'global' in 'field list' error.What I’ve tried so far:
  • I have successfully bypassed previous 1054 errors (like
    Code:
    cb_pb_enable
    ) by manually creating the missing columns in the destination
    Code:
    ltl25_comprofiler
    table via SQL.
  • However, even after adding a
    Code:
    global
    column to both
    Code:
    #__comprofiler
    and
    Code:
    #__comprofiler_fields
    , SP Transfer continues to fail with the same error.
  • I have excluded the
    Code:
    _comprofiler_plug_profilebook
    table from the transfer, but core user data is still being blocked from finishing (specifically group mappings and custom field data).
Questions:
  1. The "global" column: Is this a legacy column from an older CB version or a specific plugin (like CB Privacy)? Which specific table should it belong to so I can satisfy the transfer requirements?
  2. ProfileBook: My current J3 site uses ProfileBook. Does a version compatible with CB 2.9+ / Joomla 5.4.2 exist, or is there a recommended alternative for user guestbooks/entries?
Any guidance on getting the transfer to finish past the "global" field would be greatly appreciated.Environment:
  • Source: Joomla 3.10.x / CB 2.x
  • Destination: Joomla 5.4.2 / CB 2.9+
  • PHP: 8.x
  • Transfer Tool: SP Transfer

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 50137
  • Thanks: 8577
  • Karma: 1468
2 hours ago #343263 by krileon
We don't have a "global" column so I guess just delete that column. I'm guessing a 3rd party CB plugin added that.

ProfileBook: My current J3 site uses ProfileBook. Does a version compatible with CB 2.9+ / Joomla 5.4.2 exist, or is there a recommended alternative for user guestbooks/entries?

CB ProfileBook still works on latest CB and Joomla 3, 4, 5, and 6. Generally though you can replace it with something like CB Activity and a custom activity stream or comment stream if you don't need the ratings feature since CB Activity will provide substantially more modern features.


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