1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MG 1.1 Can't Install 1.1.6a

Discussion in 'Media Gallery Support' started by Steve F, Apr 22, 2016.

  1. Steve F

    Steve F Well-Known Member

    This might be related to xampp on my localhost but not certain. I get the below when trying to install on XF 1.5.7

    Server Error
    Mysqli prepare error: Table 'dev.xengallery_field' doesn't exist
    Zend_Db_Statement_Mysqli->_prepare() in C:\xampp\htdocs\dev\library\Zend\Db\Statement.php at line 115
    Zend_Db_Statement->__construct() in C:\xampp\htdocs\dev\library\Zend\Db\Adapter\Mysqli.php at line 381
    Zend_Db_Adapter_Mysqli->prepare() in C:\xampp\htdocs\dev\library\Zend\Db\Adapter\Abstract.php at line 478
    Zend_Db_Adapter_Abstract->query() in C:\xampp\htdocs\dev\library\Zend\Db\Adapter\Abstract.php at line 734
    Zend_Db_Adapter_Abstract->fetchAll() in C:\xampp\htdocs\dev\library\XenGallery\Model\Field.php at line 37
    XenGallery_Model_Field->getGalleryFieldsInCategories() in C:\xampp\htdocs\dev\library\XenGallery\Model\Field.php at line 552
    XenGallery_Model_Field->rebuildFieldCategoryAssociationCache() in C:\xampp\htdocs\dev\library\XenGallery\Install.php at line 62
    call_user_func() in C:\xampp\htdocs\dev\library\XenForo\Model\AddOn.php at line 215
    XenForo_Model_AddOn->installAddOnXml() in C:\xampp\htdocs\dev\library\XenForo\Model\AddOn.php at line 169
    XenForo_Model_AddOn->installAddOnXmlFromFile() in C:\xampp\htdocs\dev\library\XenForo\ControllerAdmin\AddOn.php at line 188
    XenForo_ControllerAdmin_AddOn->actionInstall() in C:\xampp\htdocs\dev\library\XenForo\FrontController.php at line 351
    XenForo_FrontController->dispatch() in C:\xampp\htdocs\dev\library\XenForo\FrontController.php at line 134
    XenForo_FrontController->run() in C:\xampp\htdocs\dev\admin.php at line 13
  2. Jake B.

    Jake B. Well-Known Member

    FWIW it's worked fine for me every time i've done it, though I haven't used xampp. Are you installing it fresh or trying to upgrade?
  3. Steve F

    Steve F Well-Known Member

    Fresh, just tried 1.1.5 as well same result. Probably missing something obvious though.
  4. wang

    wang Well-Known Member

    I do not use the Media Galley myself, but having a look at the error message, it appears that xengallery_field table, does not exist. Can you try to add it manually with a query and see if that will help.
  5. Jake B.

    Jake B. Well-Known Member

    Try deleting all of the xengallery tables manually through phpMyAdmin then reinstalling
  6. Steve F

    Steve F Well-Known Member

    No joy, there were 3 but none were xengallery_field.
  7. Chris D

    Chris D XenForo Developer Staff Member

    Hi Steve,

    I semi-periodically do clean installs of XFMG, especially when changes are made to the installer. All seems to be ok right now and we've had no other reports of this.

    A clean install worked fine, and the query in the code to create the xengallery_field table seems to be working fine.

    Just to be clear, what have you done so far?
    There were 3 what? There are three field related tables, but one of them is xengallery_field, and there are obviously considerable more than 3 tables in total. What were the 3 tables, specifically?

    This appears to be the code triggering the error:

    // Rebuilds the field cache after the default Example Category has been inserted.
    if (!self::$_version)
    This should be running after all of the install queries have completed, but if it only has 3 tables available at that time then something must be going wrong somewhere.
  8. Steve F

    Steve F Well-Known Member


    I haven't really tried anything aside from file health check , disabling other add-ons and trying to install XFMG 1.1.5. I just did another fresh 1.5.7 install and XFMG installed fine so I'm really at a lose now.
  9. Chris D

    Chris D XenForo Developer Staff Member

    That's rather random.

    The tables that have been created are not even in a sequential order.

    At this point all I can say is that this is unexpected and cannot be reproduced. It is almost certainly server related. I appreciate this is a bit of a non-solution. However, from here I would recommend inspecting PHP and MySQL error logs to see if anything is being logged that may explain this.

    I would also recommend deleting the version of 1.1.6a you have, and re-downloading it from scratch, even with a different browser if possible and uploading with a different FTP application. There's a possibility it could be a corrupted download or something but that would be presenting itself in a weird way (that kind of fault would normally be an all or nothing type thing).
  10. Steve F

    Steve F Well-Known Member

    I did try redownloading the package with the same result. I think you may have missed the part in the OP that this is XAMPP on my local machine.

    I created a new fresh XF install and it installed fine, same package. I also did a fresh install on our webserver which also went fine. Seems isolated to this specific local install.
  11. Chris D

    Chris D XenForo Developer Staff Member

    I didn't miss that. The advice still stands, really.

    Something must be going wrong, and that something must be being suppressed, so I'm expecting that the PHP or MySQL error logs might contain some hints. It's been a while since I used XAMPP so I'm not sure if these logs need enabling or what their default locations are.
  12. Brogan

    Brogan XenForo Moderator Staff Member

    For what it's worth, I've been using XAMPP for years and have never had any issues installing or upgrading XF, official add-ons, or third party add-ons.
    Steve F likes this.
  13. Steve F

    Steve F Well-Known Member

    Alright - it's installing now.

    In the 'C:\xampp\mysql\data\dev' (dev being the xf install) directory there were these files. If you notice the date being from last year it is these that caused the issue since I had copied XAMPP from my old HD to this SSD and still used 'dev' as the install. ;)

    See I knew it was something simple/obvious lol. Thanks for the help guys.
    Chris D likes this.

Share This Page