• 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
    • Import step_X: Unknown column 'forum.node_id' in 'on clause'

    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: Import step_X: Unknown column 'forum.node_id' in 'on clause'

    • Issue Tools
      • View Changes
    1. issueid=3365 October 3, 2013 3:50 PM
      Alfa1 Alfa1 is offline
      Distinguished Member
      Import step_X: Unknown column 'forum.node_id' in 'on clause'

      step_x

      Importing languages

      Importing URL replacements

      Importing rules for file uploads

      step_x

      Error log:
      Code:
      Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown column 'forum.node_id' in 'on clause' - library/Zend/Db/Statement/Mysqli.php:77
      Generated By: Alfa1, 2 minutes ago
      Stack Trace
      
      #0 /library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('SELECT `ns`.*,`...')
      #1 /library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT `ns`.*,`...')
      #2 /library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('SELECT `ns`.*,`...')
      #3 /vault/core/controller/db/xf.php(115): Zend_Db_Adapter_Abstract->query('SELECT `ns`.*,`...')
      #4 /vault/core/model/db/mysql/vw.php(29): vw_DB_Controller_XF->query_read('SELECT `ns`.*,`...')
      #5 /vault/core/controller/import/handle/vw3/area/vw.php(75): vw_DB_MySQL_Model->select(Array)
      #6 /vault/core/controller/import/steps/vw3/vw.php(161): vw_Import_Handle_VW3_Area_Controller->do_namespaces(false, true)
      #7 /vault/core/controller/progress/vw.php(82): {closure}(Object(vw_Import_Controller), NULL)
      #8 /vault/core/controller/cp/impex/vw.php(75): vw_Progress_Controller->call(5, NULL)
      #9 /vault/core/controller/cp/impex/vw.php(31): vw_CP_ImpEx_Controller->import()
      #10 /library/vw/XenForo/ControllerAdmin/Wiki.php(94): vw_CP_ImpEx_Controller->execute('import', 'post')
      #11 /library/XenForo/FrontController.php(337): vw_XenForo_ControllerAdmin_Wiki->actionIndex()
      #12 /library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
      #13 /admin.php(13): XenForo_FrontController->run()
      #14 {main}
      
      Request State
      
      array(3) {
        ["url"] => string(88) "http://area51.myforum.eu/test4/admin.php?wiki/&panel=impex&do=import&step=5&nostyle=1"
        ["_GET"] => array(5) {
          ["wiki/"] => string(0) ""
          ["panel"] => string(5) "impex"
          ["do"] => string(6) "import"
          ["step"] => string(1) "5"
          ["nostyle"] => string(1) "1"
        }
        ["_POST"] => array(6) {
          ["wiki/"] => string(0) ""
          ["panel"] => string(5) "impex"
          ["do"] => string(6) "import"
          ["step"] => string(1) "5"
          ["nostyle"] => string(1) "1"
          ["_xfToken"] => string(8) "********"
        }
      }
      Delete... Close
    Issue Details
    Issue Number 3365
    Issue Type Bug
    Project VaultWiki 4.x Series
    Category Importing
    Status Fixed
    Priority 2 - Fatal / Database Errors
    Affected Version 4.0.0 Beta 6
    Fixed Version 4.0.0 Beta 7
    Milestone VaultWiki 4 Beta X
    Software DependencyXenForo 1.x
    License TypePaid
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags (none)


    Page 1 of 2 12 Next LastLast


    1. October 4, 2013 10:24 AM
      pegasus pegasus is offline
      VaultWiki Team
      If your 'dependency' field in the import config file is empty, try setting it to:
      Code:
      'vB4|vB3'
      In the next release, we will automatically assume a setting of 'vB4|vB3' for a VW3 import if nothing is set, but if the source is vB3 only you would still need to set it.

      A better fix would be to use form-based entry for the config settings but that probably won't be for a few versions.
      Reply Reply  
    2. October 4, 2013 2:45 PM
      Alfa1 Alfa1 is offline
      Distinguished Member
      Yes, an import page in the acp where the admin needs to fill out a form would be far better. Especially if there is verification of the details.
      Reply Reply  
    3. October 4, 2013 3:38 PM
      Alfa1 Alfa1 is offline
      Distinguished Member
      The fix does not work. Setting the dependency to 'vb4|vb3' leads to an instant freeze.
      Setting the dependency to 'vb3' leads to the same error as before.
      Reply Reply  
    4. October 5, 2013 11:34 AM
      pegasus pegasus is offline
      VaultWiki Team
      If the import dependency is set to an invalid value or blank the database connection will normalize table and fields names to the installation dependency.

      i.e. in vBulletin the unique ID on the "forum" table is "forumid"
      in XenForo the corresponding ID on the "xf_forum" table is "node_id"

      If it's looking for 'node_id' in the vB database that means it is using an XF dependency instead of the vB4|vB3 dependency. If your source database only runs vB3 then use the 'vB3' dependency (without the 'vB4|' part). If you are using an import config file that is several versions old, please copy your settings into a new config file and replace the old one. Some settings and methods have been moved around. Using an older file will probably not allow them to resolve properly, which might be why the correct dependency appears to make everything freeze up.

      Also make sure your vault/core/model/db/mysql/ directory contains a file named vb3.php. If it doesn't, that may be the problem.
      Reply Reply  
    5. October 5, 2013 6:50 PM
      Alfa1 Alfa1 is offline
      Distinguished Member
      You still have ftp access to my server. Please check the \config\vw.php file. I do not see what is going wrong.
      Maybe the issue is that I did not fill in the API path, as AFAIK there is none.
      Same with the imagepath. I never used a wiki image dir.
      Same with the namespaces. Its completely unclear to me what needs to be done with this.
      I also entered nothing into the charset value.
      The port number does not have apostrophes.
      In dependency I have 'vb3'

      The file is from Beta6.
      Reply Reply  
    6. October 5, 2013 9:47 PM
      Alfa1 Alfa1 is offline
      Distinguished Member
      BTW: I have just noticed that some data was imported, so its definitely accessing the database.
      I do hope that new import attempts will not cause duplicate content. I fear that this would create a mess beyond repair.
      Are threadID's retained or are there other methods to prevent duplicate data?
      Reply Reply  
    7. October 6, 2013 11:40 AM
      pegasus pegasus is offline
      VaultWiki Team
      Source IDs are maintained for the duration of an import to try to prevent duplicate data when hitting Continue. Source IDs are cleared once an import completely finishes so that you can import a different database without ID collisions. Even if the source IDs are lost, a coder can usually regenerate them as long as there is a copy of the source database around somewhere (as a backup, if the database is eliminated post-import).

      It is possible, and I have created a new task here, to change the handling of import IDs to central vw_import_map table, so that they don't have to be cleared after an import completes: https://www.vaultwiki.org/issues/3368/
      Reply Reply  
    8. October 9, 2013 12:15 PM
      Alfa1 Alfa1 is offline
      Distinguished Member
      Have you been able to access the server and find out whats going wrong? I'm not sure how to proceed from here.
      Reply Reply  
    9. October 9, 2013 2:11 PM
      pegasus pegasus is offline
      VaultWiki Team
      I have been able to access the server. I am trying to learn more about the issue you're facing today.
      Reply Reply  
    10. October 11, 2013 4:00 PM
      pegasus pegasus is offline
      VaultWiki Team
      I think it's all worked out. I encountered a few problems where it was accessing the wrong database (the cross-database VW3 importer wasn't choosing a unique database identifier for the source connection, while the other importers were already doing this as designed).

      However, I was not able to get all the way through the import process due to a 503 service unavailable error. I'm not sure if maybe I tried to run it while a database was backing up, or if there was some more verbose message I didn't have access to see. Please let me know. Otherwise, I'm leaving this marked resolved.
      Reply Reply  
    11. October 11, 2013 4:54 PM
      Alfa1 Alfa1 is offline
      Distinguished Member
      There was an active import which may have interfered with it.

      Did you review the 160 pages with a variety of database errors in the XF adminCP?

      My wiki does not work anymore. Whats next?
      Reply Reply  
    12. October 12, 2013 11:16 AM
      pegasus pegasus is offline
      VaultWiki Team
      I see, your site returns 503 Service Unavailabe when PHP enters an infinite loop. This is resolved now.
      Reply Reply  
    13. October 12, 2013 12:56 PM
      Alfa1 Alfa1 is offline
      Distinguished Member
      OK. So how do I proceed with the import?
      Reply Reply  
    14. October 13, 2013 1:14 PM
      pegasus pegasus is offline
      VaultWiki Team
      Simply return to the import page and reselect the same source type. It should continue where it left off.
      Reply Reply  
    15. October 13, 2013 1:56 PM
      Alfa1 Alfa1 is offline
      Distinguished Member
      I decided to do another clean xenforo install and import from there. If you changed anything in settings / database then its gone. Is there anything that I need to adjust before importing?
      Reply Reply  
    Page 1 of 2 12 Next LastLast
    + 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 11:15 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.