XF 1.2 double custom userprofile fields after import

[snoopy5]

Hi,

I just imported one XF forum into another one sucessfully (1.2.4). Now I have the problem, that in both original XF forums the same costum user profile fields existed.

How can I merge these without loosing the content?

So that new user who register i.e. tomorrow have only one custum user profile field to fill out. And old users shall see also only 1x the specific custom field in their user profile.

Thanks

 

[Paul B]

You can't merge custom user fields.

You may be able to construct SQL queries to move content from one to the other and then delete the duplicates.

 

[snoopy5]

You can't merge custom user fields.

You may be able to construct SQL queries to move content from one to the other and then delete the duplicates.

But how can I see then which field is from which forum?

And do you know by accident these sql queries?

 

[Jeremy]

The IDs should be unique.

 

[snoopy5]

...

And do you know by accident these sql queries?

 

[snoopy5]

Does anybody knows sql queries to move content from one custom user field to the other custom user field (as long as the target custom user field is empty)?

I really need this...

 

[Jake Bunce]

http://xenforo.com/community/threads/sql-query-to-transfer-info-between-fields.38648/#post-427064