XF 1.2 Processing... Deleting... Threads (28/$s)

Live Free · Aug 17, 2013

I'm in the process of an import from vBulletin to Xenforo. Was almost completed. However, when updating counters/importing blogs/installing mods I get this:

Screen Shot 2013-08-17 at 3.04.14 PM.webp

The number 32 keeps changing... can anyone give some insight into this process? The Url says: /admin.php?tools/run-deferred

Live Free · Aug 19, 2013

Rigel Kentaurus said:
Now we are on to something

View attachment 54581

That retain_keys flag is explicitly deleting a Forum and Category

... When you import the blogs, do NOT select the "retain keys" option.
If you do, that is when the "Delete Forum" kicks in.

I am not sure if I can fix that and still reuse the import logic in vBulletin (I just added a new Importer, and that seems to be in the main controller). I wonder if that will also be a problem with people trying to import "2 forums into 1" (but then again, when doing that retain keys is a bad idea anyway)

I'm not quite sure I understand why this is causing a problem/where it's originating from.

I just tried again and didn't check "Retain imported content IDs" and it worked smoothly. I'm going to try one more time then do it for real.

Thanks so much for looking into this with me.

Rigel Kentaurus · Aug 19, 2013

Live Free said:
I'm not quite sure I understand why this is causing a problem/where it's originating from.

I just tried again and didn't check "Retain imported content IDs" and it worked smoothly. I'm going to try one more time then do it for real.

Thanks so much for looking into this with me.

The "retain keys" box causes a side-effect that deletes forums and threads ....

You don't notice when you import the original vBulletin forums and threads because there is nothing yet to delete. But you do when you import blogs because your data is already there.

I'll compensate for that in an update of the Blogs add-on, I should be able to override that behavior

Live Free · Aug 19, 2013

I see. Well thank you again.

I'm trying to do the upgrade on my live site but I'm getting this error:

Code:

Server Error
Mysqli prepare error: Table 'admin_db1.xfa_blog_category_global' doesn't exist

[LIST=1]
[*]Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
[*]Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
[*]Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
[*]Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
[*]Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1612
[*]XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1601
[*]XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1393
[*]XenForo_DataWriter->save() in XenForo/Model/Import.php at line 599
[*]XenForo_Model_Import->_importData() in XfAddOns/Blogs/ModelOverride/Import.php at line 26
[*]XfAddOns_Blogs_ModelOverride_Import->_importData() in XfAddOns/Blogs/Importer/BlogsVbulletin.php at line 193
[*]XfAddOns_Blogs_Importer_BlogsVbulletin->stepCategories() in XenForo/Importer/Abstract.php at line 77
[*]XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 180
[*]XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 232
[*]XenForo_ControllerAdmin_Import->_startStep() in XenForo/ControllerAdmin/Import.php at line 175
[*]XenForo_ControllerAdmin_Import->actionStartStep() in XenForo/FrontController.php at line 337
[*]XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
[*]XenForo_FrontController->run() in /home/admin/public_html/admin.php at line 13
[/LIST]

Thoughts? An unrelated error?

The table it's calling at the top is in the new live database, not the database it should be importing.

Actual error log:

Code:

Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Table 'admin_db1.xfa_blog_category_global' doesn't exist - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Daniel, 9 minutes ago
Stack Trace
#0 /home/admin/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
#1 /home/admin/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
#2 /home/admin/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
#3 /home/admin/public_html/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#4 /home/admin/public_html/library/XenForo/DataWriter.php(1612): Zend_Db_Adapter_Abstract->insert('xfa_blog_catego...', Array)
#5 /home/admin/public_html/library/XenForo/DataWriter.php(1601): XenForo_DataWriter->_insert()
#6 /home/admin/public_html/library/XenForo/DataWriter.php(1393): XenForo_DataWriter->_save()
#7 /home/admin/public_html/library/XenForo/Model/Import.php(599): XenForo_DataWriter->save()
#8 /home/admin/public_html/library/XfAddOns/Blogs/ModelOverride/Import.php(26): XenForo_Model_Import->_importData(284, 'XfAddOns_Blogs_...', 'blog_category_g...', 'category_id', Array, false, false)
#9 /home/admin/public_html/library/XfAddOns/Blogs/Importer/BlogsVbulletin.php(193): XfAddOns_Blogs_ModelOverride_Import->_importData(284, 'XfAddOns_Blogs_...', 'blog_category_g...', 'category_id', Array)
#10 /home/admin/public_html/library/XenForo/Importer/Abstract.php(77): XfAddOns_Blogs_Importer_BlogsVbulletin->stepCategories(0, Array)
#11 /home/admin/public_html/library/XenForo/ControllerAdmin/Import.php(180): XenForo_Importer_Abstract->runStep(Object(XfAddOns_Blogs_ControllerAdminOverride_Import), Object(XenForo_ImportSession), 'categories', 0, Array)
#12 /home/admin/public_html/library/XenForo/ControllerAdmin/Import.php(232): XenForo_ControllerAdmin_Import->_runStep(Object(XfAddOns_Blogs_Importer_BlogsVbulletin), Object(XenForo_ImportSession), 'categories', 0, Array)
#13 /home/admin/public_html/library/XenForo/ControllerAdmin/Import.php(175): XenForo_ControllerAdmin_Import->_startStep(Object(XfAddOns_Blogs_Importer_BlogsVbulletin), Object(XenForo_ImportSession), 'categories', Array)
#14 /home/admin/public_html/library/XenForo/FrontController.php(337): XenForo_ControllerAdmin_Import->actionStartStep()
#15 /home/admin/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#16 /home/admin/public_html/admin.php(13): XenForo_FrontController->run() #17 {main}
Request State
array(3) { ["url"] => string(52) "http://url.com/admin.php?import/start-step" ["_GET"] => array(1) { ["import/start-step"] => string(0) "" } ["_POST"] => array(2) { ["step_categories"] => string(17) "Import categories" ["_xfToken"] => string(8) "********" } }

Rigel Kentaurus · Aug 19, 2013

Live Free said:

I see. Well thank you again.

I'm trying to do the upgrade on my live site but I'm getting this error:

Code:

Server Error
Mysqli prepare error: Table 'admin_db1.xfa_blog_category_global' doesn't exist

[LIST=1]
[*]Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
[*]Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
[*]Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
[*]Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
[*]Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1612
[*]XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1601
[*]XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1393
[*]XenForo_DataWriter->save() in XenForo/Model/Import.php at line 599
[*]XenForo_Model_Import->_importData() in XfAddOns/Blogs/ModelOverride/Import.php at line 26
[*]XfAddOns_Blogs_ModelOverride_Import->_importData() in XfAddOns/Blogs/Importer/BlogsVbulletin.php at line 193
[*]XfAddOns_Blogs_Importer_BlogsVbulletin->stepCategories() in XenForo/Importer/Abstract.php at line 77
[*]XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 180
[*]XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 232
[*]XenForo_ControllerAdmin_Import->_startStep() in XenForo/ControllerAdmin/Import.php at line 175
[*]XenForo_ControllerAdmin_Import->actionStartStep() in XenForo/FrontController.php at line 337
[*]XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
[*]XenForo_FrontController->run() in /home/admin/public_html/admin.php at line 13
[/LIST]

Thoughts? An unrelated error?

The table it's calling at the top is in the new live database, not the database it should be importing.

Actual error log:

Code:

Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Table 'admin_db1.xfa_blog_category_global' doesn't exist - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Daniel, 9 minutes ago
Stack Trace
#0 /home/admin/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `xf...')
#1 /home/admin/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `xf...')
#2 /home/admin/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `xf...')
#3 /home/admin/public_html/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#4 /home/admin/public_html/library/XenForo/DataWriter.php(1612): Zend_Db_Adapter_Abstract->insert('xfa_blog_catego...', Array)
#5 /home/admin/public_html/library/XenForo/DataWriter.php(1601): XenForo_DataWriter->_insert()
#6 /home/admin/public_html/library/XenForo/DataWriter.php(1393): XenForo_DataWriter->_save()
#7 /home/admin/public_html/library/XenForo/Model/Import.php(599): XenForo_DataWriter->save()
#8 /home/admin/public_html/library/XfAddOns/Blogs/ModelOverride/Import.php(26): XenForo_Model_Import->_importData(284, 'XfAddOns_Blogs_...', 'blog_category_g...', 'category_id', Array, false, false)
#9 /home/admin/public_html/library/XfAddOns/Blogs/Importer/BlogsVbulletin.php(193): XfAddOns_Blogs_ModelOverride_Import->_importData(284, 'XfAddOns_Blogs_...', 'blog_category_g...', 'category_id', Array)
#10 /home/admin/public_html/library/XenForo/Importer/Abstract.php(77): XfAddOns_Blogs_Importer_BlogsVbulletin->stepCategories(0, Array)
#11 /home/admin/public_html/library/XenForo/ControllerAdmin/Import.php(180): XenForo_Importer_Abstract->runStep(Object(XfAddOns_Blogs_ControllerAdminOverride_Import), Object(XenForo_ImportSession), 'categories', 0, Array)
#12 /home/admin/public_html/library/XenForo/ControllerAdmin/Import.php(232): XenForo_ControllerAdmin_Import->_runStep(Object(XfAddOns_Blogs_Importer_BlogsVbulletin), Object(XenForo_ImportSession), 'categories', 0, Array)
#13 /home/admin/public_html/library/XenForo/ControllerAdmin/Import.php(175): XenForo_ControllerAdmin_Import->_startStep(Object(XfAddOns_Blogs_Importer_BlogsVbulletin), Object(XenForo_ImportSession), 'categories', Array)
#14 /home/admin/public_html/library/XenForo/FrontController.php(337): XenForo_ControllerAdmin_Import->actionStartStep()
#15 /home/admin/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#16 /home/admin/public_html/admin.php(13): XenForo_FrontController->run() #17 {main}
Request State
array(3) { ["url"] => string(52) "http://url.com/admin.php?import/start-step" ["_GET"] => array(1) { ["import/start-step"] => string(0) "" } ["_POST"] => array(2) { ["step_categories"] => string(17) "Import categories" ["_xfToken"] => string(8) "********" } }

I think this thread ran it's course, I'll answer you through a conversation

XF 1.2 Processing... Deleting... Threads (28/$s)

Live Free

Active member

Live Free

Active member

Rigel Kentaurus

Well-known member

Live Free

Active member

Rigel Kentaurus

Well-known member

Similar threads

We value your privacy