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
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
) by manually creating the missing columns in the destination
table via SQL.
- However, even after adding a
column to both
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:
- 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?
- 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