1. How to renew my expired license?
    Dismiss Notice
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 Unknown Column 'user.user_id' In 'field List'

Discussion in 'Bug Reports' started by nrep, Jan 20, 2014.

  1. nrep

    nrep New Member

    I'm trying to import from IPB Gallery 5.0.4 to the latest XenGallery version. However, when I begin the import I get this error on the import albums step:

    Code:
    Mysqli prepare error: Unknown column 'user.user_id' in 'field list'
Zend_Db_Statement_Mysqli->_prepare() in \library\Zend\Db\Statement.php at line 115
Zend_Db_Statement->__construct() in \library\Zend\Db\Adapter\Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in \library\Zend\Db\Adapter\Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in \library\Zend\Db\Adapter\Abstract.php at line 734
Zend_Db_Adapter_Abstract->fetchAll() in \library\sonnb\XenGallery\Importer\ipb.php at line 327
sonnb_XenGallery_Importer_ipb->stepAlbums() in \library\XenForo\Importer\Abstract.php at line 77
XenForo_Importer_Abstract->runStep() in \library\XenForo\ControllerAdmin\Import.php at line 195
XenForo_ControllerAdmin_Import->_runStep() in \library\XenForo\ControllerAdmin\Import.php at line 143
XenForo_ControllerAdmin_Import->actionImport() in \library\XenForo\FrontController.php at line 347
XenForo_FrontController->dispatch() in \library\XenForo\FrontController.php at line 134
XenForo_FrontController->run() in \admin.php at line 13
     
    nrep, Jan 20, 2014
    #1
  2. sonnb

    sonnb Administrator Staff Member

    You found a bug. I have just fixed it and will be available in next release.
     
    sonnb, Jan 20, 2014
    #2
    nrep likes this.
  3. nrep

    nrep New Member

    Thanks, is there a quick workaround I can use for the time being so I can get the data imported?
     
    nrep, Jan 20, 2014
    #3
  4. sonnb

    sonnb Administrator Staff Member

    Sure. Please open library\sonnb\XenGallery\Importer\ipb.php line 321.

    Change
    Code:
    SELECT album.*, user.user_id, user.username
    To
    Code:
    SELECT album.*, user.member_id, user.username
     
    sonnb, Jan 20, 2014
    #4
    nrep likes this.
  5. nrep

    nrep New Member

    Thanks, I'm also getting this error now that I've fixed that:

    Code:
    Mysqli prepare error: Unknown column 'user.username' in 'field list'
    edit: I changed user.username to user.name and it seems to work
     
    nrep, Jan 20, 2014
    #5
  6. sonnb

    sonnb Administrator Staff Member

    You are right. Thanks so much.
     
    sonnb, Jan 20, 2014
    #6
    nrep likes this.

Share This Page