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

XF 1.2 Mysqli statement execute error : The table 'merc_ad_view' is full

Discussion in 'Troubleshooting and Problems' started by burkimo, Dec 9, 2014.

  1. burkimo

    burkimo Member

    Hi,

    Once 3 or 4 days, nginx server gives 500 internet server error, and then we restart mysql (percona), and for 3 days problem is being solved. Then same problem occurs agains.

    In config.php there is a row:
    ini_set('memory_limit', '-1');

    And our server is pretty strong which is a dedicated stand alone server with 16GB memory.
    I know this problem is occured because AdManager plugin but 3 weeks ago there were not any error about this plugin. Any advice please?

    ******

    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : The table 'merc_ad_view' is full - library/Zend/Db/Statement/Mysqli.php:214

    #0 /home/nginx/domains/bodyforumtr.com/public/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /home/nginx/domains/bodyforumtr.com/public/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /home/nginx/domains/bodyforumtr.com/public/library/Merc/AdManager/Model/Ad.php(203): Zend_Db_Adapter_Abstract->query('\n\t\t\tINSERT INTO...')
    #3 /home/nginx/domains/bodyforumtr.com/public/library/Merc/AdManager/Listener/TemplatePostRender.php(25): Merc_AdManager_Model_Ad->countAdView(Array)
    #4 /home/nginx/domains/bodyforumtr.com/public/library/Merc/AdManager/Listener/TemplatePostRender.php(33): Merc_AdManager_Listener_TemplatePostRender->execute('PAGE_CONTAINER', '<!DOCTYPE html>...', Array, Object(XenForo_Template_Public))
    #5 [internal function]: Merc_AdManager_Listener_TemplatePostRender::listen2('PAGE_CONTAINER', '<!DOCTYPE html>...', Array, Object(XenForo_Template_Public))
    #6 /home/nginx/domains/bodyforumtr.com/public/library/XenForo/CodeEvent.php(58): call_user_func_array(Array, Array)
    #7 /home/nginx/domains/bodyforumtr.com/public/library/XenForo/Template/Abstract.php(195): XenForo_CodeEvent::fire('template_post_r...', Array, 'PAGE_CONTAINER')
    #8 /home/nginx/domains/bodyforumtr.com/public/library/XenForo/Template/Public.php(110): XenForo_Template_Abstract->render()
    #9 /home/nginx/domains/bodyforumtr.com/public/library/XenForo/ViewRenderer/HtmlPublic.php(135): XenForo_Template_Public->render()
    #10 /home/nginx/domains/bodyforumtr.com/public/library/XenForo/FrontController.php(604): XenForo_ViewRenderer_HtmlPublic->renderContainer(Object(XenForo_Template_Public), Array)
    #11 /home/nginx/domains/bodyforumtr.com/public/library/XenForo/FrontController.php(158): XenForo_FrontController->renderView(Object(XenForo_ControllerResponse_View), Object(XenForo_ViewRenderer_HtmlPublic), Array)
    #12 /home/nginx/domains/bodyforumtr.com/public/index.php(13): XenForo_FrontController->run()
    #13 {main}


    array(3) {
    ["url"] => string(43) "http://www.bodyforumtr.com/members/xxxx/"
    ["_GET"] => array(1) {
    ["/members/xxxx/"] => string(0) ""
    }
    ["_POST"] => array(0) {
    }
    }
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    This is related to an add-on, something to do with Merc Ad Manager

    You will have to post in the add-on thread for support.
     
  3. burkimo

    burkimo Member

    Sorry I have posted a new thread in the add-on thread. We can close this thread.
     

Share This Page