• Register
    • Help

    striker  0 Items
    Currently Supporting
    • Home
    • News
    • Forum
    • Wiki
    • Support
      • Manage Subscriptions
      • FAQ
      • Support For
        • VaultWiki 4.x Series
        • VaultWiki.org Site
    • What's New?
    • Buy Now
    • Manual
    • 
    • Support
    • VaultWiki 4.x Series
    • Bug
    • Error on Import VW from vb to xenforo

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

      VaultWiki allows your existing forum users to collaborate on creating and managing a site's content pages. VaultWiki is a fully-featured and fully-supported wiki solution for vBulletin and XenForo.

      The VaultWiki Team encourages you to join our community of forum administrators and check out VaultWiki for yourself.

    Issue: Error on Import VW from vb to xenforo

    • Issue Tools
      • View Changes
    1. issueid=4522 January 16, 2016 6:44 PM
      Lord Doys Lord Doys is offline
      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




    1. January 18, 2016 10:59 AM
      pegasus pegasus is offline
      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 Reply
    2. January 18, 2016 12:47 PM
      Lord Doys Lord Doys is offline
      Junior Member
      i did it but i have the same error
      Reply Reply
    3. January 20, 2016 1:15 PM
      Lord Doys Lord Doys is offline
      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
      Reply Reply
    4. January 20, 2016 4:57 PM
      pegasus pegasus is offline
      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 Reply
    5. January 21, 2016 11:04 AM
      pegasus pegasus is offline
      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 Reply
    6. January 30, 2016 1:46 PM
      pegasus pegasus is offline
      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 Reply
    7. January 31, 2016 3:31 PM
      Lord Doys Lord Doys is offline
      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 Reply
    8. January 31, 2016 3:59 PM
      Lord Doys Lord Doys is offline
      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
      Reply Reply
    9. March 3, 2016 5:27 PM
      pegasus pegasus is offline
      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 Reply
    10. March 9, 2016 3:29 AM
      Lord Doys Lord Doys is offline
      Junior Member
      Quote 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
    + Reply

    Assigned Users
    Loading Please Wait
    Tags
    Loading Please Wait
    • Contact Us
    • License Agreement
    • Privacy
    • Terms
    • Top
    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
  • striker
    Powered by vBulletin® Version 4.2.5 Beta 2
    Copyright © 2023 vBulletin Solutions Inc. All rights reserved.
    Search Engine Optimisation provided by DragonByte SEO (Pro) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
    Copyright © 2008 - 2013 VaultWiki Team, Cracked Egg Studios, LLC.