Transferring Showcase Data To New Forum

[Gary Gannon]

Is it possible to transfer showcase data to a new forum?

We are importing the users into the new forum and I would like to maintain all of the showcase, but it appears that might not be possible.

Any suggestions?

 

[Bob]

No worries The easiest way is to run them via phpMyAdmin via SQL tab.

 

[Travis]

When trying to reassign an item to another user, i am etting:

Server Error

Mysqli statement execute error : BIGINT UNSIGNED value is out of range in '(`ftvworld_newxf`.`xf_user`.`showcase_count` - 1)'

Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in NFLJ/Showcase/DataWriter/Item.php at line 577
NFLJ_Showcase_DataWriter_Item->_postSave() in XenForo/DataWriter.php at line 1409
XenForo_DataWriter->save() in NFLJ/Showcase/Model/InlineMod/Item.php at line 571
NFLJ_Showcase_Model_InlineMod_Item->reassignItems() in XenForo/ControllerPublic/InlineMod/Abstract.php at line 125
XenForo_ControllerPublic_InlineMod_Abstract->executeInlineModAction() in NFLJ/Showcase/ControllerPublic/InlineMod/Item.php at line 93
NFLJ_Showcase_ControllerPublic_InlineMod_Item->actionReassign() in XenForo/FrontController.php at line 347
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/ftvworld/public_html/new/index.php at line 13

 

[Bob]

ya, that is one of the MANY challenges when trying to manually merge. The user records that are linked to showcase will have mismatches Showcase Counts.

I THINK (not tested) that you should be able to run the "Rebuild User Showcase Counts" and then be able to reassign without error.