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

XF 1.5 Incorrect arguments to mysqld_stmt_execute

Discussion in 'Troubleshooting and Problems' started by Wicksy33, Dec 16, 2015.

  1. Wicksy33

    Wicksy33 Member

    Just went to my forum and now getting this, nothing has been changed for weeks it's just stopped working, any help will be greatful

    Xenforo 1.5.3
    Website: www.vgforums.co.uk/community

    An exception occurred: Mysqli statement execute error : Incorrect arguments to mysqld_stmt_execute in /homepages/1/d535499013/htdocs/vgforums/community/library/Zend/Db/Statement/Mysqli.php on line 214

    1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    3. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 808
    4. Zend_Db_Adapter_Abstract->fetchPairs() in XenForo/Template/Public.php at line130
    5. XenForo_Template_Public->_getTemplatesFromDataSource() inXenForo/Template/Abstract.php at line 572
    6. XenForo_Template_Abstract->_loadTemplates() inXenForo/Template/Abstract.php at line 556
    7. XenForo_Template_Abstract->_loadTemplate() in XenForo/Template/Abstract.phpat line 180
    8. XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
    9. XenForo_Template_Public->render() in NodesAsTabs/NavTabs.php at line 126
    10. NodesAsTabs_NavTabs::createNodeTabs()
    11. call_user_func_array() in XenForo/CodeEvent.php at line 90
    12. XenForo_CodeEvent::fire() in XenForo/Dependencies/Public.php at line 495
    13. XenForo_Dependencies_Public->_getNavigationContainerParams() inXenForo/Dependencies/Public.php at line 371
    14. XenForo_Dependencies_Public->getEffectiveContainerParams() inXenForo/FrontController.php at line 635
    15. XenForo_FrontController->renderView() in XenForo/FrontController.php at line158
    16. XenForo_FrontController->run() in/homepages/1/d535499013/htdocs/vgforums/community/index.php at line 13
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    I see references to the nodes as tabs add-on so it could be that.

    You can try disabling it to see if it resolves the error.
    If it does, you will need to post in the add-on thread for support.
     
  3. Wicksy33

    Wicksy33 Member

    How would be the best way to disable it as can't access the admin panel. Is that something I can do through the database?
     
  4. Wicksy33

    Wicksy33 Member

    would running the 1.5.4 security fix help at all?
     
  5. Wicksy33

    Wicksy33 Member

    ok i have set Nodes with Tabs to zero in database but still getting an error. see below

    My Hosting is with 1and1 would that have anything to do with it.

    An exception occurred: Mysqli statement execute error : Incorrect arguments to mysqld_stmt_execute in /homepages/1/d535499013/htdocs/vgforums/community/library/Zend/Db/Statement/Mysqli.php on line 214

    1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    3. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 808
    4. Zend_Db_Adapter_Abstract->fetchPairs() in XenForo/Template/Public.php at line 130
    5. XenForo_Template_Public->_getTemplatesFromDataSource() in XenForo/Template/Abstract.php at line 572
    6. XenForo_Template_Abstract->_loadTemplates() in XenForo/Template/Abstract.php at line 556
    7. XenForo_Template_Abstract->_loadTemplate() in XenForo/Template/Abstract.php at line 180
    8. XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
    9. XenForo_Template_Public->render() in XenForo/ViewRenderer/HtmlPublic.php at line 139
    10. XenForo_ViewRenderer_HtmlPublic->renderContainer() in XenForo/FrontController.php at line 637
    11. XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
    12. XenForo_FrontController->run() in /homepages/1/d535499013/htdocs/vgforums/community/index.php at line 13
     
  6. Mike

    Mike XenForo Developer Staff Member

    That won't actually disable it. Put this in config.php:
    Code:
    $config['enableListeners'] = false;
    Does that resolve it?
     
  7. Wicksy33

    Wicksy33 Member

    Nope, still get the same response as above
     
  8. Wicksy33

    Wicksy33 Member

    @Mike got it sorted, looks like a problem with 1and1. They have added a new option in the hosting control under Manage Webspace panel called PHP settings, you have to go in there and set the PHP version as all domains are set to "no version set", i set it to Version 5.6 and boom all started working as normal.

    thanks for you help tho and hopefully this may help any other people that may come across this problem with 1and1 hosting and Xenforo.
     
    snow2000 and foci like this.
  9. Chris D

    Chris D XenForo Developer Staff Member

    This does seem to be a change they made, but I can't see why the effect of it would be intentional. We suspect it may well be defaulting to using a much older version of PHP. Although your issue is now solved, it may well be worth reporting it to 1and1 so they can investigate and fix the issue for other customers.
     
  10. snow2000

    snow2000 Member

    Thank you so much! I had the same Problem with 1&1 today. Now everything is working!
     
    Wicksy33 likes this.

Share This Page