Issue: Error on Import VW from vb to xenforo

Issue Tools
- View Changes

January 16, 2016 6:44 PM

Lord Doys

Junior Member

Error on Import VW from vb to xenforo

Error Import vaultWiki 3 under vb4 to vaultwiki 4.0.8b3 under xenforo 1.5.5

hi,
in xenforo 1.5.5 in admin backend, i use the wiki/import.
I choose as source format vw3 and i click in import button in the page after.
At step 1, i have notice error :
vault/core/view/cp/progress/vw.php on line 359 (i must put $error_type in place of error_type)
and i do again the import.

now (still step 1)
i meet this error. Could you help me to solve that ?

Code:

Step {1}

Importing wiki pages

An exception occurred: Database Error: SELECT `a`.`attachmentid` AS `attachmentid`,`a`.`filename` AS `filename`,`a`.`state` AS `state`,`a`.`settings` AS `settings`,`f`.`userid` AS `userid`,`f`.`filedataid` AS `filedataid`,`f`.`dateline` AS `dateline`,`f`.`extension` AS `extension`,`f`.`filehash` AS `filehash`,`u`.`username`,`u`.`ipaddress` FROM `vb3_attachment` `a` INNER JOIN `vb3_filedata` `f` ON (`a`.`filedataid` = `f`.`filedataid`) LEFT JOIN `vb3_user` `u` ON (`f`.`userid` = `u`.`userid`) WHERE `a`.`contenttypeid` = Post AND `a`.`contentid` = 55239 Mysqli prepare error: Unknown column 'Post' in 'where clause' in /var/www/html/testxenforo/vault/core/controller/db/xf.php on line 171

    vw_DB_Controller_XF->throw_error() in vault/core/controller/db/xf.php at line 185
    vw_DB_Controller_XF->query_read() in vault/core/model/db/mysql/vw.php at line 29
    vw_DB_MySQL_Model->select() in vault/core/controller/import/handle/vw3/attach/vw.php at line 405
    vw_Import_Handle_VW3_Attach_Controller->fetch_attachments_by() in vault/core/controller/import/handle/vw3/attach/vw.php at line 304
    vw_Import_Handle_VW3_Attach_Controller->fetch_attachments() in vault/core/controller/import/handle/vw3/page/vw.php at line 613
    vw_Import_Handle_VW3_Page_Controller->add_page() in vault/core/controller/import/handle/vw3/page/vw.php at line 439
    vw_Import_Handle_VW3_Page_Controller->do_page() in vault/core/controller/import/handle/vw3/page/vw.php at line 220
    vw_Import_Handle_VW3_Page_Controller->do_pages() in vault/core/controller/import/steps/vw3/vw.php at line 274
    vw_Import_Steps_VW3_Controller->{closure}() in vault/core/controller/progress/vw.php at line 100
    vw_Progress_Controller->call() in vault/core/controller/cp/impex/vw.php at line 114
    vw_CP_ImpEx_Controller->import() in vault/core/controller/cp/impex/vw.php at line 35
    vw_CP_ImpEx_Controller->execute() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 113
    vw_XenForo_ControllerAdmin_Wiki->actionIndex() in library/XenForo/FrontController.php at line 351
    XenForo_FrontController->dispatch() in library/XenForo/FrontController.php at line 134
    XenForo_FrontController->run() in admin.php at line 13

Issue Details

Issue Number 4522

Issue Type Bug

Project VaultWiki 4.x Series

Category Attachments

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.8

Fixed Version 4.0.9

Milestone (none)

Software DependencyAny

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags attachments, database, error, Import, mysql

January 18, 2016 10:59 AM
pegasus

VaultWiki Team
In vault/core/controller/import/config/vw.php, check the value of:

Code:

'dependency'

If it's empty, try using:

Code:

'vB4|vB3'
Reply
January 18, 2016 12:47 PM

Lord Doys

Junior Member

i did it but i have the same error

Reply

January 20, 2016 1:15 PM

Lord Doys

Junior Member

You need something else to investigate on this issue ?
As i said in my previous post, i did search 'dependency' and i put 'vB4|vB3'.
i try again the import wiki and i had the same error

Code:

An exception occurred: Database Error: SELECT `a`.`attachmentid` AS `attachmentid`,`a`.`filename` AS `filename`,`a`.`state` AS `state`,`a`.`settings` AS `settings`,`f`.`userid` AS `userid`,`f`.`filedataid` AS `filedataid`,`f`.`dateline` AS `dateline`,`f`.`extension` AS `extension`,`f`.`filehash` AS `filehash`,`u`.`username`,`u`.`ipaddress` FROM `vb3_attachment` `a` INNER JOIN `vb3_filedata` `f` ON (`a`.`filedataid` = `f`.`filedataid`) LEFT JOIN `vb3_user` `u` ON (`f`.`userid` = `u`.`userid`) WHERE `a`.`contenttypeid` = Post AND `a`.`contentid` = 55239 Mysqli prepare error: Unknown column 'Post' in 'where clause' in /var/www/html/testxenforo/vault/core/controller/db/xf.php on line 171

January 20, 2016 4:57 PM

pegasus

VaultWiki Team

I am reviewing. I am attempting not to use the ticket system today until we launch the new version, but if you are comfortable with it, you can submit one here: https://www.vaultwiki.org/members/?d...e&productid=20

What is happening is that for some reason during the Importing attachments step, the importer is suddenly considering the source database to also be a XenForo installation. I might be able to duplicate the behavior on my own and find a solution for you, but it's only a "might" and it could take some time, due to everything that has happened this week.

Reply
January 21, 2016 11:04 AM

pegasus

VaultWiki Team

Please PM me your vault/core/controller/import/config/vw.php (blank out your database user and password) and put it in CODE tags like this:
[code] ... contents of the file ... [/code]

Reply
January 30, 2016 1:46 PM

pegasus

VaultWiki Team

I was not able to reproduce this error using VW 4.0.8 Patch Level 1 on XenForo 1.5.5 to import VW 3.0.20 from vBulletin 4.2.2. I checked the bad value the error complains about, and my test gave me a correct value of int(1), whereas you are getting a string(4) "Post".

If you are still experiencing this error I would recommend submitting a new ticket: https://www.vaultwiki.org/members/?do=newticket
so that we can figure out why your installation is trying to use an invalid value for this database query.

Reply
January 31, 2016 3:31 PM

Lord Doys

Junior Member

i erase all, and i did all from scrash again :

i did a fresh install of xenforo 1.5.5a
i import data from my all vbulletin 4.x (take long time but the only problem i had is for merge user with the same email)
i did a fresh install of vaultwiki 4.0.8 b3
i imported data from vaultwiki 3.x

unfortunatly i had exactly the same problem

Reply

January 31, 2016 3:59 PM

Lord Doys

Junior Member

i had this before the error

Code:

Step {1}

Creating temporary import fields

Importing languages

Importing URL replacements

Importing rules for file uploads

Importing namespaces

Importing wiki forums

Importing wiki landing pages

Importing wiki landing pages

Creating empty landing pages

Importing wiki hierarchy

vw_importing_custom_paths

Importing wiki permissions

but when i try again it dissapear to display only the error like before.

NB :
i need to look before use the ticket because i use key to acces the server and i have only one ftp user with extend privilege

March 3, 2016 5:27 PM

pegasus

VaultWiki Team

I was able to duplicate this issue on another customer's site. It is fixed in 4.0.9 build 002. I think the behavior varied based on the PHP version.

Reply
March 9, 2016 3:29 AM

Lord Doys

Junior Member

Originally Posted by pegasus

I was able to duplicate this issue on another customer's site. It is fixed in 4.0.9 build 002. I think the behavior varied based on the PHP version.

Thanks,
i will try it this week, i will come back with the result

Reply

+ Reply

All times are GMT -4. The time now is 5:44 AM.

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: Error on Import VW from vb to xenforo

Issue Tools