Issue: Import from vw4 into vw4 throws an error

Issue Tools
- View Changes

November 5, 2017 4:24 PM

wolven

New Member

Import from vw4 into vw4 throws an error

Importscript runs into error while importing from test database to production

Hi,

whil importing I ran into the following error at Step 15:

Code:

An exception occurred: Call to undefined method vw_Import_Handle_VW4_Base_Controller::dependency() in [path]/vault/core/controller/import/handle/dependency/tagging/xf.php on line 29

    #0: vw_Import_Handle_Dependency_Tagging_Controller_XF->query() in [path]/vault/core/controller/import/handle/dependency/tagging/xf.php at line 21
    #1: vw_Import_Handle_Dependency_Tagging_Controller_XF->get_tags() in [path]/vault/core/controller/import/handle/vw4/tagging/vw.php at line 59
    #2: vw_Import_Handle_VW4_Tagging_Controller->do_tags() in [path]/vault/core/controller/import/handle/vw4/tagging/vw.php at line 21
    #3: vw_Import_Handle_VW4_Tagging_Controller->do_page_tags() in [path]/vault/core/controller/import/steps/vw4/vw.php at line 355
    #4: vw_Import_Steps_VW4_Controller->{closure}() in [path]/vault/core/controller/progress/steps/vw.php at line 83
    #5: vw_Progress_Steps_Controller->call() in [path]/vault/core/controller/progress/steps/vw.php at line 53
    #6: vw_Progress_Steps_Controller->execute() in [path]/vault/core/controller/progress/vw.php at line 92
    #7: vw_Progress_Controller->exec_script() in [path]/vault/core/controller/progress/vw.php at line 74
    #8: vw_Progress_Controller->execute() in [path]/vault/core/controller/cp/progress/vw.php at line 37
    #9: vw_CP_Progress_Controller->process() in [path]/vault/core/controller/cp/impex/vw.php at line 339
    #10: vw_CP_ImpEx_Controller->import() in [path]/vault/core/controller/cp/impex/vw.php at line 53
    #11: vw_CP_ImpEx_Controller->execute() in [path]/library/vw/XenForo/ControllerAdmin/Wiki.php at line 118
    #12: vw_XenForo_ControllerAdmin_Wiki->actionIndex() in [path]/library/XenForo/FrontController.php at line 351
    #13: XenForo_FrontController->dispatch() in [path]/library/XenForo/FrontController.php at line 134
    #14: XenForo_FrontController->run() in [path]/admin.php at line 13

Pls. help

Issue Details

Issue Number 5297

Issue Type Bug

Project VaultWiki 4.x Series

Category Importing

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.20

Fixed Version 4.0.21

Milestone (none)

Software DependencyXenForo 1.x

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags Import

November 6, 2017 11:08 AM
pegasus

VaultWiki Team
In vault/core/controller/import/handle/dependency/tagging/xf.php, find:

Code:

$base->dependency()

Replace with:

Code:

$base->get_dependency()
Reply
November 6, 2017 3:23 PM

wolven

New Member

and can I do the import again or do I have to clear everthing in the database. Please advice. Thnx

Reply
November 6, 2017 4:09 PM

pegasus

VaultWiki Team

You should just be able to continue the import from where you left off.

Reply
This petition for a change to Awaiting Feedback was rejected
November 9, 2017 1:35 PM

wolven

New Member

Ok, I've tried like you suggested.
Result?

mporting content tags
An exception occurred: Database Error: SELECT `i`.`itemid` AS `id`,`t`.`tag` AS `tag` FROM `xf_tag_content` `tt` INNER JOIN `vw_route` `i` ON (`tt`.`content_id` = `i`.`routeid`) LEFT JOIN `xf_tag` `t` ON (`t`.`tag_id` = `tt`.`tag_id`) WHERE `i`.`itemid` IN (1,2,3,4,5,6,7,8,9,11,12,13,14,15,16,17,18,19,20,21,22,23 ,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42 ,43,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62 ,63,64,65,66,67,68,69,70,73,74,75,76,77,78,80,81,82,83,84 ,85,86,87,88,89,90,91,94,95,96,102,103,104,105,106,107,10 8,109,110,111,113,114,115,116,117,118,119,120,121,122,123 ,124,125,126,127,128,129,130,131,132,133,134,135,136,137, 138,139,140,141,145,146,147,148,149,150,151,152,153,154,1 55,156,157,158,159,160,161,162,163,164,165,166,167,168,16 9,170,171,172,173,174,175,176,177,178,179,180,181,182,183 ,184,185,186,187,188,190,191,192,193,194,195,196,197,198, 199,200,201,202,203,204,205,206,207,208,209,210,211,212,2 13,214,215,216,217) AND `tt`.`content_type_id` = 'vwpage' AND `i`.`itemtypeid` = 1 Mysqli prepare error: Unknown column 'tt.content_type_id' in 'where clause' in [path]/vault/core/controller/db/xf.php on line 187
#0: vw_DB_Controller_XF->throw_error() in [path]/vault/core/controller/db/xf.php at line 203
#1: vw_DB_Controller_XF->query_read() in [path]/vault/core/model/db/mysql/vw.php at line 27
#2: vw_DB_MySQL_Model->select() in [path]/vault/core/controller/import/handle/dependency/tagging/xf.php at line 155
#3: vw_Import_Handle_Dependency_Tagging_Controller_XF->query() in [path]/vault/core/controller/import/handle/dependency/tagging/xf.php at line 21
#4: vw_Import_Handle_Dependency_Tagging_Controller_XF->get_tags() in [path]/vault/core/controller/import/handle/vw4/tagging/vw.php at line 59
#5: vw_Import_Handle_VW4_Tagging_Controller->do_tags() in [path]/vault/core/controller/import/handle/vw4/tagging/vw.php at line 21
#6: vw_Import_Handle_VW4_Tagging_Controller->do_page_tags() in [path]/vault/core/controller/import/steps/vw4/vw.php at line 355
#7: vw_Import_Steps_VW4_Controller->{closure}() in [path]/vault/core/controller/progress/steps/vw.php at line 83
#8: vw_Progress_Steps_Controller->call() in [path]/vault/core/controller/progress/steps/vw.php at line 53
#9: vw_Progress_Steps_Controller->execute() in [path]/vault/core/controller/progress/vw.php at line 92
#10: vw_Progress_Controller->exec_script() in [path]/vault/core/controller/progress/vw.php at line 74
#11: vw_Progress_Controller->execute() in [path]/vault/core/controller/cp/progress/vw.php at line 37
#12: vw_CP_Progress_Controller->process() in [path]/vault/core/controller/cp/impex/vw.php at line 339
#13: vw_CP_ImpEx_Controller->import() in [path]/vault/core/controller/cp/impex/vw.php at line 53
#14: vw_CP_ImpEx_Controller->execute() in [path]/library/vw/XenForo/ControllerAdmin/Wiki.php at line 118
#15: vw_XenForo_ControllerAdmin_Wiki->actionIndex() in [path]/library/XenForo/FrontController.php at line 351
#16: XenForo_FrontController->dispatch() in [path]/library/XenForo/FrontController.php at line 134
#17: XenForo_FrontController->run() in [path]/admin.php at line 13

I'm a bit puzzled yet.

Short question: Is it possible to start the import from scratch? What do I have to in case I run from one error to another?
November 9, 2017 1:44 PM
pegasus

VaultWiki Team
Same file, find all:

Code:

'content_type_id'

Replace all with:

Code:

'content_type'

A VW4+XenForo -> VW4+XenForo import is a rare migration, so I suspect there are a lot of bugs in the process. If you encounter any more errors, I encourage you to submit a private ticket for a free import service so that you don't have to deal with them personally.
Reply
November 9, 2017 1:49 PM

wolven

New Member

Thanx.

It comes from my testside, not open for public, we did all the preparation for go live, i.e. the transform of vbglossary to vault wiki and liked to import this from test to production.

Reply
November 9, 2017 2:28 PM

wolven

New Member

Ticket has been opened, cause next error occurred.
Thanx

Reply

+ Reply

All times are GMT -4. The time now is 5:58 PM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: Import from vw4 into vw4 throws an error

Issue Tools