merging two Xenforo forums

[Olecoot]

Affected version

2.2.13

when merging two XF forums I am getting this error.



both are on the latest rev of XF.

 

[James]

Are you trying to merge via the standalone importer? It looks like the install is being interrupted and it's trying to write the same node ID twice. Are the nodes named the same? You might need to rename one.

Also doubly make sure you're using the most up to date importer.

 

[James]

Just done a quick search check this thread as a reference point:

XF 2.2 - Issue Using Importer to Merge Databases

XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry 'raw-Forum' for key 'node_name_unique' in src/XF/Db/AbstractStatement.php at line 228 XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196 XF\Db\Mysqli\Statement->getException() in...

xenforo.com

 

[Olecoot]

Just done a quick search check this thread as a reference point:

XF 2.2 - Issue Using Importer to Merge Databases

XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry 'raw-Forum' for key 'node_name_unique' in src/XF/Db/AbstractStatement.php at line 228 XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196 XF\Db\Mysqli\Statement->getException() in...

xenforo.com

Thanks, I've read that one already

Are you trying to merge via the standalone importer? It looks like the install is being interrupted and it's trying to write the same node ID twice. Are the nodes named the same? You might need to rename one.

Also doubly make sure you're using the most up to date importer.

No, I'm using the importer in the admin panel

 

[JordanH]

Are you selecting the "keep the ids the same" option? (I don't recall exactly what it's called)

 

[Olecoot]

Retain Content IDs. no, that is not checked.

 

[Olecoot]

Currently I've created another test DB and uploading the board I want to merge so I can compare the XF_node table where the unique node id is at. hoping I can find the duplicates there

 

[FTL]

Sounds like you could do with a script to find dupliate references that allows you to change them.

Perhaps @MattW can help you with this database merging.

 

[Olecoot]

I believe I found the issue. I'll know more later tonight when this merge I just kicked off runs its course.

 

[Olecoot]

So I fixered it Running the finalize commands now. in the screenshot from phpmyadmin you can see under "node name" the 1st two values are forum and hardware, everything else is Null. I set those to null and three others that were not null and restarted the merge. Thanks for the tips and hints given