What Do You Need In The Xf2 Xengallery Version? Vote for your choices here: http://www.sonnb.com/threads/what-do-you-need-in-the-xf2-xengallery-version.1539/

Fixed Mysqli Prepare Error: Unknown Table 'album'

Discussion in 'Bug Reports' started by Live Free, Aug 19, 2013.

  1. Live Free

    Live Free Authorized Member Authorized

    Trying to import albums from vbulletin 4. Installed, configured, start the import and I get the following error, not sure how to proceed:


    Server Error

    Mysqli prepare error: Unknown table 'album'

    1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
    2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
    3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
    4. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 734
    5. Zend_Db_Adapter_Abstract->fetchAll() in sonnb/XenGallery/Importer/vbulletin4.php at line 251
    6. sonnb_XenGallery_Importer_vbulletin4->stepAlbums() in XenForo/Importer/Abstract.php at line 77
    7. XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 180
    8. XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 132
    9. XenForo_ControllerAdmin_Import->actionImport() in XenForo/FrontController.php at line 337
    10. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    11. XenForo_FrontController->run() in /home/spider7/public_html/admin.php at line 13
     
  2. sonnb

    sonnb Administrator Staff Member

    You want to import vB4 User Album to XenGallery? vB4 contains a table named "album". Please check if you are converting correct version.
     
  3. Live Free

    Live Free Authorized Member Authorized

    Yes, the stock vbulletin user albums to XenGallery.

    In the drop-down list on import data I've selected: vBB 4.x User Albums => sonnb - XenGallery
     
  4. sonnb

    sonnb Administrator Staff Member

    Have you correctly enter Database information about your vB in configuration step of importer?
     
  5. Live Free

    Live Free Authorized Member Authorized

    Code:
    Error Info
    Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Unknown table 'album' - library/Zend/Db/Statement/Mysqli.php:77
    Generated By: Daniel, A moment ago
    Stack Trace
    #0 /home/admin/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('?              ...')
    #1 /home/admin/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '?              ...')
    #2 /home/admin/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('?              ...')
    #3 /home/admin/public_html/library/Zend/Db/Adapter/Abstract.php(734): Zend_Db_Adapter_Abstract->query('?              ...', Array)
    #4 /home/admin/public_html/library/sonnb/XenGallery/Importer/vbulletin4.php(251): Zend_Db_Adapter_Abstract->fetchAll('?              ...')
    #5 /home/admin/public_html/library/XenForo/Importer/Abstract.php(77): sonnb_XenGallery_Importer_vbulletin4->stepAlbums(0, Array)
    #6 /home/admin/public_html/library/XenForo/ControllerAdmin/Import.php(180): XenForo_Importer_Abstract->runStep(Object(XfAddOns_Blogs_ControllerAdminOverride_Import), Object(XenForo_ImportSession), 'albums', 0, Array)
    #7 /home/admin/public_html/library/XenForo/ControllerAdmin/Import.php(132): XenForo_ControllerAdmin_Import->_runStep(Object(Tinhte_XenTag_XenForo_Importer_vBulletin), Object(XenForo_ImportSession), 'albums', 0, Array)
    #8 /home/admin/public_html/library/XenForo/FrontController.php(337): XenForo_ControllerAdmin_Import->actionImport()
    #9 /home/admin/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #10 /home/admin/public_html/admin.php(13): XenForo_FrontController->run()
    #11 {main}
    Request State
    array(3) {
      ["url"] => string(48) "http://site.com/admin.php?import/import"
      ["_GET"] => array(1) {
        ["import/import"] => string(0) ""
      }
      ["_POST"] => array(1) {
        ["_xfToken"] => string(8) "********"
      }
    }
    
    
     
  6. Live Free

    Live Free Authorized Member Authorized

    Yep.
     
  7. sonnb

    sonnb Administrator Staff Member

    Could you show me the structure (screenshot is ok) of your vB's database? What is exactly version of your vB?
     
  8. Live Free

    Live Free Authorized Member Authorized

    Sent you a PM.
     
  9. sonnb

    sonnb Administrator Staff Member

    Did you used "wf" as your database prefix?
     
  10. Live Free

    Live Free Authorized Member Authorized

    Yes, in the original database and in the database configuration settings.
     
  11. sonnb

    sonnb Administrator Staff Member

    Do you know what is this addon: XfAddOns_Blogs_ControllerAdminOverride_Import?
     
  12. sonnb

    sonnb Administrator Staff Member

    Seem that we have an issue here. I would fix it for the next update.
     
  13. Live Free

    Live Free Authorized Member Authorized

    That would have to be from BetterBlogs. I imported vbulletin blogs to that add-on earlier today.

    If I remove that file and try again, might that work?
     
  14. sonnb

    sonnb Administrator Staff Member

    It is our addon's issue. I have fixed it and would available in next update. Please retry again when new update comes (estimated would be end of today).
     
    Live Free likes this.
  15. Live Free

    Live Free Authorized Member Authorized

    Great, will do. Thank you.
     
  16. sonnb

    sonnb Administrator Staff Member

    Could you try with new update?
     
  17. sonnb

    sonnb Administrator Staff Member

    There is one issue in the new update and I have sent you a quick fix to address that. Please try the latest file I have sent to you. Please remember if you are not on latest version then XML import is required.
     
  18. Live Free

    Live Free Authorized Member Authorized

    Confirmed, this fixed it. Thanks!!!
     
    sonnb likes this.
  19. STASHlFY

    STASHlFY New Member

    i get a different error :(
     
  20. sonnb

    sonnb Administrator Staff Member

    What is your error?
     

Share This Page